SQLibri - the lightweight sqlite GUI client
SQLibry is a platform independent SQLite GUI client. Which allows to work with this database easily and effectively.
Build and run
Navigate to project parent folder and run ./gradlew build on Unix-based OS or gradle.bat build on Windows to build the project, then java -jar build/libs/sqlibri-[version].jar to run it.
Note: To run this application you need Java SE 1.8.0_40+ Download Java
Getting started
It this section we collect all information which is essential to figure out how to use the application. You can find this tutorial inside the application by pressing CTRL/COMMAND+SHIFT+H or find it in HELP -> USER GUIDE menu.
Working with database
Creating database
First of all we need to figure out how to create a database. And it's simple as pie. Just click on DATABASE menu -> then on CREATE menu item / or press CTRL/COMMAND+N, enter database path and name and click OK.
Opening database
To open database click on DATABASE menu -> OPEN menu item / or press CTRL/COMMAND+O, enter database path and name and click ok.
Droping database
TO drop database click on DATABASE menu -> DROP menu item -> and press ok. It will drop currently opened database.
Copying database
To copy database click on DATABASE menu -> COPY menu item / or press CTRL/COMMAND+SHIFT+C, enter file path and name and press ok. It will copy currently opened database to new one(which is located by entered filepath).
Working with SQL editor
Writing and executing SQL queries
You can write SQL queries in the SQL Editor, which provides some advanced code editor features like syntax highlighting, intellisence and snippets. To run the query click on EXECUTE button or press F9. Query execution info will be displayed in the status bar. If query returns any data it will be displayed in the table view.
Navigating through previously executed queries
When query has been executed, it saves to history. You can search and select previously executed queries using history combobox.
Working with query files
Saving Queries
To save written before query you need to click on FILE menu -> SAVE QUERY menu item / or pres CTRL/COMMAND+S and enter file path and name.
Opening Queries
To open saved before query you need to click on FILE -> LOAD QUERY menu item / or press CTRL/COMMAND+SHIFT+O and enter file path and name.
Exporting as CSV
Exporting data to CSV file
to Export data from table view to CSV file you need to click on FILE menu -> EXPORT AS CSV menu item / or press CTRL/COMMAND+E, enter file name and press ok.
Shortcuts
| Key | Command |
|---|---|
| CTRL/COMMAND+S | Save Query |
| CTRL/COMMAND+Shift+O | Open Query |
| CTRL/COMMAND+E | Export As CSV |
| CTRL/COMMAND+X | Exit |
| CTRL/COMMAND+N | Create Database |
| CTRL/COMMAND+O | Open Database |
| CTRL/COMMAND+Shift+C | Copy Database |
| CTRL/COMMAND+Shift+H | Open User Guide |
Snippets
| keyword | expanded |
|---|---|
| tbl | Create table |
| col | Create column |
| ccol | Create column (varchar type) |
| ncol | Create column (number type) |
| dcol | Create column (date type) |
| ind | Create index on column |
| uind | Create unique index on column |
| s* | Select all from table |
| addcol | Add column to the table |
| seq | Create sequence |
| tblcom | Create comment on table |
| colcom | Create comment on column |
| ins | Insert row(s) to table |
| upt | Update row(s) |
| dt | Drop table |
| dl | Delete row(s) from table |
License
SQLibri is released under the MIT License.