SQLight
SQLight is an SQLite database manager tool. With this tool, you can browse, edit, delete data from local SQLite file with easy to use UI and controls. If you want to perform SQL query operation on database, there is a query box. Type your query and click the button to execute and get results. You can also export data as a file and save it on your drive.
System Requirements
● Mac computer with an Intel Core processor
● OS X version 10.7 (Lion) or later
● 1.6 MB or more of available disk space
Download Latest Version - 3.0.0.0
Documentation
Share
Future Plans
Next major release will be version 4.0.0.0. Following are the updates planned for the same.
● Bug fixing will always continue for every release and we will make sure that the application will run without errors, efficiently and smoothly.
● SQL query history will be supported in this version.
● Preferences to set custom colors for sql query syntax highlighting will be supported in this version.
Please follow us to know exact date of the release and other new features those will be added.
Free
SQLight is totally free. No trial version with limited timespan to use. No demo version with many of the features disabled. You will get a fully functional application.
Regular Updates
We already have planned and started working on features for next releases. Also there will be bug fixing as reported by our QA people and app users.
Beautiful looks and carefully designed, clean and neat layout
While designing SQLight we took due care to make it easy to understand and use. We kept it simple, neat and of course beautiful.
You can see list of tables, views, indexes on left panel and right panel provides you controls to manage them.
Use tabs to open multiple databases at the same time
SQLight provides tab feature (similar to what we have in web browsers). You can open another database in a new tab and can work on different databases at the same time.
Save any data including BLOB from SQLite database
SQLight provides a feature that allows you to save any data e.g. CHAR, VARCHAR, TEXT, INT, BLOB etc. from SQLite database. Just right click on any of the cell to save contents as file.
Quick look table data
SQLight provides a feature that allows you to take a quick look at table data like image, plain text, html etc. Just right click on any of the cell and select Quick Look option.
SQL query with syntax coloring
You can perform SQL query operation on database. There is a query box with syntax coloring support, to help you with use of SQL keywords and function names.
Features to make your task easy
SQLight provides you various keyboard shortcuts, right click menus to ease your task.
● You can navigate between tabs with (Command + 1), (Command + 2) etc.
● You can navigate between segments with (Ctrl + 1) for Table Structure, (Ctrl + 2) for Table Data and (Ctrl + 3) for SQL Query.
● You can rename a table just by selecting right click menu.
● Simply double click on data row to edit it.