OverView

Query Lite is a sqlite front-end. To create, manage and test sqlite databases. It opens, saves and run SQL scripts

Query Lite consists of three parts:
1. On the top; a simpe Text Editor with syntax highlighting where you write your SQL scripts/SQL queries.
2. in the middle; the Query Result View to view the result from the query and on the bottom.
3. An Info View to view info and error messages etc.






Getting started:

First you need to choose a database, go to File, New/Choose Database. A Filepanel opens, and choose an existing sqlite database, or enter a name for your new database in the filepanel textfield. Type in the name "test.db" or whatever you want to call the database file. Then press Save.

Now you can start typing sql queries in the text editor, or you can open a sqlscript.
Type/Copy this into the text editor:

CREATE TABLE Person (firstName VARCHAR(25),lastName VARCHAR(25) NOT NULL);
insert into Person (firstName,lastName) VALUES ('Query','Guye');
select * from Person;


To run the sql query, press the Run button, or go to the Action menu, and chose Run SQL Script.


To save the sql script, go to the File menu, and Save SQL Script, choose the name to save the sql script as, then press Save.