TOKYO (MacHouse) – For the past three weeks, we’ve been working on data management applications. Last month, we released OrganizeX Essential and OrganizeX Mobile. Developing this type of applications requires that we closely watch the database content. If an application encrypts data not as a whole but on the basis of individual records, you will run into a small problem. Our existing software title called ViewSQL Pro lets us view the table content. But it won’t let us view actual text values if records are encrypted individually. There is another problem. If you have a field with the blob data type, you can probably tell that some information fills a cell. But you can’t really tell if those bits of data will actually turn into an image. So what can we do about that? As usual, we develop a new software title. In fact, we submitted a new software title to Mac App Store several hours ago. This new submission is called LiteReader.
The main objective of Lite Reader is to let the user view the table content of an SQLite database file. SQLite is a widely-used data management system supported by Mac OS X, iOS, Android software developers. LiteReader supports two community-maintained AES wrappers called AESCrypt-ObjC and RNCryptor for Objective-C in decrypting data on the basis of individual records. LiteReader also lets you decode blob data into a viewable image.
- Read SQLite database file and return numbers of records (rows) and fields (columns) for each table.
- Decode blob data into a viewable image.
- Decrypt AES text data.
- Save encryption keys.
- Get quick access to recently-opened data files.
- Search encrypted or non-encrypted data.
- Save entire encrypted or decrypted data for the selected table as XML.
- Save encrypted or decrypted text data for the selected record as text.
- The application supports the retina display.
- The application supports the fullscreen mode.
- Languages: English only.
- Application file size: 12.7 MB.
- The application comes with a complete user’s guide written in English. (Choose Help > User’s Guide.)
- The application comes with a 9-page introduction window, giving the user a quick tour over how it works.
- 10.7 (tested with 10.7.5), 10.8 (untested), 10.9 (tested with 10.9.4)
- 64-bit system
- Decrypting text values depends on AES wrappers. Currently, LiteReader supports two community-maintained ones (AESCrypt-ObjC & RNCryptor).
1.0.4 (Released on March 1, 2016)
- Fix: The application could crash when the user selects a table containing one or more fields returning NULL.
- Fix: When the height of the inspector window is small, the controls will no longer stick to the bottom under the Text tab.
1.0.2 (Released on October 22, 2014)
- After the user selected and opened a database file with the open dialog window, some commands were made inaccessible.
- A custom font was not working properly.
Application user’s guide is available (only in English). Click here to access it online.
Click here to download a trial version. This trial version will remain fully functional for 7 days, starting from the very moment you first launch it. It will delete all application files upon expiration. Click here to download resource package.
A video tutorial with text commentary is available in the form of a QuickTime movie. Click here. The data size is 130.0 MB, and the movie duration is 13 minutes and 48 seconds. The video dimensions are 1,440 x 900 pts.
LiteReader is a product of MacHouse.
Apple and the Apple logo are trademarks of Apple Inc., registered in the U.S. and other countries. Mac App Store is a service mark of Apple Inc.