SQLiteManager is intended to administrate SQLite databases. The particularity of this type of database is that it is stored in a single file on your hard drive without the need of any server to host it. So, its main advantage is that it does not require any network protocol to access the stored data, and it can also be moved and copied more easily. Luckily, this program is quite simple and intuitive.
The main users of this tool are software developers, who are most likely to take advantage of its features. The application supports opening various type of database extensions, including db, sqlite and sqlite3. Similarly, it allows connecting to cubeSQL, a powerful online database server based on SQLite. Fortunately, the program allows encrypting a database using strong algorithms such as AES 128/256/RC4 and SQLCypher, which can prevent data theft.
In case you decide to open an existing database, the tool lets you visualize not only its data but also its internal structure. Moreover, you can run your own SQL queries and even save them. Likewise, the application provides such functions as creating views, tables, indexes, triggers and scripts in a wizard-like way, which spares you the efforts of writing all the code. It is good to know that the tool’s features can be expanded by adding SQLite extensions, too.
All in all, I must say that I am not too impressed by any of its multiple features, as other similar products provide the same benefits and some of them are even freeware or open-source. Sadly, it cannot create its own local sqlite server, something that is very convenient in case you need to share data over a network. The program is shareware. Still, you can always try its unregistered version with the limitation that it can process up to 20 rows only.
- Very easy to use
- Allows creating encrypted databases with many algorithms
- Many database operations available
- Opens existing database files
- Connects to online sqlite’s database servers
- Cannot create its own sqlite server
- Too expensive