Samsung had created ripples when it first launched the galaxy s8 in 2017. It was stunning smartphone with infinity edge to edge display, packing large display in small body. It was received well by enthusiasts around the world. There were leaks all over the internet, going on from couple of month’s altogether. Nevertheless, just when this entire news surrounding the comeback from tech giant was going on, the Chinese smartphone vendors had already come up with various Samsung galaxy s8 clone, which are based of accurately on the leaks. [Read more…]
Sqlite is one of the popular database formats is used by many mobile systems including Android devices for structured data storage. Sqlite application is an open source application and resembles SQL server but is lite implementation of it. Android supports Sqlite application through dedicated APIs and it happens to be a crucial source of evidence from forensics prospect. Sqlite files used by the apps are usually stored at the location: /data/data/<ApplicationPackageName>/databases. Forensically, these files are highly important, as these files will store valuable data handled by respective application. Many apps are used for making fund transfers, booking tickets, bank transactions, and personal chats. These details can be found in apps Sqlite files, which can be interrogated for evidence.
Important Sources for Forensics Investigation
- Browser Memory
- Application storage
- External Card & System Storage
- Sqlite Database files
- SMS/Call Records
- GPS Records
- Social Sites (Facebook, Twitter)
- Messenger (MSN, Yahoo)
- Email associated data
Sqlite database analysis of Android device can be done either using an image of the device data or by accessing the files through a rooted device. Once the device is rooted, investigators can acquire all the Sqlite files of apps. These files can belong to many applications and its analysis can lead to multiple pieces of evidence. For instance, database file of a YouTube app of an android device comprises of several tables showing details like _id (for each entry made in YouTube app), display1, display2, query (text typed for searching video) and date (epoch date and time stamp).
Explore Sqlite File for Investigation
Sqlite forensic explorer is adept application software, which is capable to perform complete examination of a Sqlite file. Android application data is saved in different versions of Sqlite file. This application program is capable to explore the Sqlite files and the tables embedded. For this, install the application and launch it.
Learn More about the Product
Product Name: Sqlite Forensic Explorer
Size: 13.3 MB
Supported Operating system: Windows 8, 7, Vista, and XP
Free Demo: Available
Product Website Link: http://www.acquireforensics.com/products/sqlite-forensic-explorer/
Step by step guide to perform Sqlite data analysis with SqLite Forensics Explorer:
- Click on Add File which will pop-up another window for adding the file. Click on the Browsing icon to add the Sqlite file saved on the system.
- Left-pane will show up all the tables present in the Sqlite file. Different tables store different data like “urls”, “visits”, “keyword search”, “downloads”, Users can view any of the table and integrated data in it. Here, different rows of the tables can be viewed like title, url, visit_cont, types_count, last_visit_time hidden, favicon_id, etc.
- Users can view the details in Hex tab. Hex view helps in interrogating the data unaltered. Users can perform the analysis on the data here and can check for the manipulation done here.
- This software can also show Deleted tab where deleted data from the Sqlite file can be viewed.
- This application has this Query feature which help to examine the Sqlite database using commands. SQL Editor Functionality helps to add multiple queries for performing execution on the database added. These queries can also be saved for future analysis.
This software also allows recovery of corrupted data from Sqlite database. Its support towards damaged Sqlite files provides an exceptional functionality for forensics investigation. It is a comprehensive application program, which allows users to export the carved details to CSV, PDF or HTML file for further analysis or reporting purpose. It supports varied formats of Sqlite like .db or .sqlite and this allows variant of Sqlite databases to be examined. Investigators can dig into details by viewing the data in Hex format and the deleted data. It also supports BLOB data type for analyzing multimedia components.
There are many media streaming devices which are gaining popularity, like Chrome cast but still there has to be fully functional Android box that can be connected to your TV. An android box can perform every function that conventional Android Smartphone’s and tablets can do, apart from just streaming music and videos. One of these smart Android boxes called as Minix Neo X8-H plus does this job for you. It is extremely small device that converts your television set into full fledged Android TV. [Read more…]
Smartphones have become our lifelines today. With new features and hardware coming along in new smartphones, our dependency have increased a lot on them. Apart from just using it to send out important mails and updating social media profiles, we even use it for storing precious information like official presentations, documents and other stuff. There is always risk of losing data, so it is always recommended to take backups. Unfortunately, in our busy lives today, it is impossible to take complete backups due to the amount of time it takes. However, you do not need to worry about it anymore now! I am going to introduce you to a tool, called Vibosoft Dr. Mobile for Android which helps you to take one click backups and restore if needed. [Read more…]
Sony had announced its budget 4G offering at the IFA 2014. This came out as a surprise, since Sony doesn’t come up with budget devices off late. We have reviewed Sony Xperia E3 device, which turns out to be one the best in its category. Earlier, Sony had said that M in Xperia M stands for mid ranged device whereas E stands for entry level. However, in the press release, it was described as the mid-range device. Check out our complete hands on review to know whether it is worth buying or no. [Read more…]
We are happy to announce first giveaway on our blog, Grudgets. Christmas and New Year is around the corner, so we thought it’s the best time to reward our visitors. 😉 From time to time, we will also be posting various deals you can grab this New Year.
No1 has been known for creating some Samsung rip-offs in the past. We had already seen No.1’s Note 3 and S5 which had been huge hit among Samsung lovers. This time, they have come up with Samsung galaxy note 4 clone, which is available for just fraction of the price of the genuine one. To remind you, Note 4 was launched alongside with Note Edge at the IFA 2014 which was held at Berlin this year. Does it stand out like other devices? Check out our review to know more.
If you follow this blog, than you might know that THL is one of the emerging Chinese brands that offers high quality smartphones. We had recently seen THL 5000 which had octa core processor and priced under $200. The new one, THL 4000 packs a punch under $100 which you must consider if you are planning to get a new device. [Read more…]
With the entry of many Chinese devices into smartphone, consumers have many choices while buying new devices. In these days of mobile computing, people usually prefer to buy phablets which act like smartphone as well as tablets. Following this trend, iNew has launched its new phablet, iNew Android 4.4.4 which is available at great discount on Gearbest. [Read more…]
Back in September 2014, when iPhone 6 was launched officially, many Apple fans had praised the new iPhone. It was probably because of the larger display that dominated Apple’s new iPhone series. Just ahead of the official launch. Goo phone had come up with I6, which was basically an iPhone 6 clone. At that time, there was no official wording about iPhone. It was based off on rumors that were widespread around the internet. [Read more…]
DBX to PST Converter is a conversion application from a prestigious company. The main functionality of the utility is to convert the Outlook Express (a desktop based mail program) DBX files into various forms like EML, PST and MSG too. It has been developed with many enhanced characteristics and this makes it a highly proficient tool for the conversion. [Read more…]