SQLiteStudio is a SQLite database manager with the following features:
- Portable - no need to install or uninstall. Just download, unpack and run.
- Intuitive interface,
- Powerful, yet light and fast,
- All SQLite3 and SQLite2 features wrapped within simple GUI,
- Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X and should work
on other Unixes (not tested yet).
- Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON),
- Importing data from various formats (CSV, custom text files [regular expressions]),
- Numerous small additions, like formatting code, history of queries executed in editor windows,
on-the-fly syntax checking, and more,
- Unicode support,
- Skinnable (interface can look native for Windows 9x/XP, KDE, GTK, Mac OS X, or draw widgets to fit for other
environments, WindowMaker, etc),
- Configurable colors, fonts and shortcuts.
- Open source and free - Released under GPLv3 license.
How can you help?
Accessing Android databases directly from your computer! Now it's possible with SQLiteStudio and DbAndroid plugin -
No more pulling and pushing database files. Browsing and editing databases directly on the device using SQLiteStudio - the handy and powerful way.
The plugin is available at the store (click).
If you want to just try it, you can get a trial license.
More details on the plugin - click here.
This version brings a long-awaited UI lifting which increases space for all data views. Less frame borders and margins, more data visibility! Database list now takes bottom-left corner (instead of bottom panel), making the list longer. This layout if configurable in settings. The SQL editor now saves contents (when using 'Save' action) to the previously saved/opened file, without asking for the file each time. There's also a new option when inserting new data rows to make it inserted above/below current row, or at the end of grid view. Finally, there are lots of bug fixes. More details as always in the Changelog. Enjoy!
Yet another bugfix release. This one is a crucial update, as it fixes bug #2838. It also fixes several other, less important bugs.
The 3.0.4 has been released!
The new version provides lots of bugfixes, new layout of database dialog and "ignore errors" option in import dialog. NOTE FOR LINUX USERS: the update engine for Linux doesn't handle update packages correctly. This is a bug that must be fixed. For now you will have to download the fresh package from here. Auto-updated package won't work for you.
This version comes with French and Russian translations! More translations are yet to come. There's also a lot of bugs fixed. See full changelog for details.