We all get some favorite tools, tools that we use on a regular basis. They usually do the work fast and effective. I still use SQLite databases and have done it more then eight years or so. The SQLite database is great for a various tasks, especially as an embedded database. It’s easy to work with in all the environments I move between, VB6 / VB.NET / LiveCode / Real Studio (Xojo) / PowerBasic & EZ GUI / NSB AppStudio.
The key to successfully use SQLite in different solutions is the tools I administrate SQLite databases with. For some years ago I stumbled over a site that caught my interest, http://www.sqlabs.net/.
When looking into it I read about some tools that could help me manage SQLite databases. The first tool was the SQLite Manager which turned out to be a powerful database management tool. The following picture is a screen shot of it:
Next, I needed to port two databases, i e so called Access database and then I tried the SQLite Converter. Success! Since then I always use SQLabs’s Converter. Yes, the below screen shot shows the SQLite Converter in action:
For a year ago or so SQLabs published an excellent offer for their relational database management system (DBMS) named to cubeSQL:
- A Developer key : Unlimited connections key but requires you to restart the server every 4 hours or
- A Freeware key: Max 3 concurrent connections key without any time limitation.
Some months later, after the publish, I needed a server for my SQLite databases. I then remembered this kind offer. Now I nearly cannot live without it.
The following screen shot shows the cubeSQL in action:
In my personal opinion these tools are highly recommended and the price of each SQLite tool should not scare anyone away.
They, SQLabs, also offer some more tools that may be is of interest.
For more information, please visit their site: http://www.sqlabs.net/