VSTO & .NET & Excel

May 30, 2013

SQLabs SQLite Tools

Filed under: .NET & Excel, Apps for Office, COM Add-ins, Database, Excel, LiveCode, Real Basic Developing, SQLite — Dennis M Wallentin @ 5:42 pm

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:

SQLiteManager

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:

SQLiteConverter

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:

cubeSQL

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/

Enjoy!

Kind regards,
Dennis

About these ads

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 39 other followers

%d bloggers like this: