SQLitening Support Forum

Support Forums => You've got Questions? We've got Answers! => Topic started by: Mark Strickland on August 11, 2008, 08:42:27 PM

Title: A "Must Have"
Post by: Mark Strickland on August 11, 2008, 08:42:27 PM
As I have been working with SQLiteing my SQLite query tool has proved to be very valuable.

There are TWO SEPARATE problems for folks trying to use SQLitening and learn SQL at the same time.

If you get a query tool that can connect directly to a SQLite DB you can figure out the SQL code THEN put it in your PB program using SQLiteing with almost a cut and paste.  At that point you will know your SQL code is working.

You can also do the opposite by doing things in your PB program to output the generated SQL statements by displaying them to cut and paste back into your SQL query tool or even have the PB program simply stuff them directly into the clipboard for a direct paste.

I use SQLMaestro but below is a link to a large number of options and many are free.

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools (http://www.sqlite.org/cvstrac/wiki?p=ManagementTools)

These will let you play with SQL statements and even use the EXPLAIN QUERY PLAN (mentioned in a previous post) to help you figure out how SQLite will approach finding and returning your data.