SqlBrowserFX
SqlBrowserFX is a feature rich cross platform sql client for SQLite , MySQL, MariaDB for both windows and linux
Features
- Manage data (insert, update, delete) via gui.
- Execute raw sql queries.
- Editor for sql with syntax highlighting, autocomplete features.
- Adjustable responsive ui.
- Graphical representation of database as tree.
- Exposure of database to the web as RESTful service with one click.
- Import, export csv files.
- Queries History.
- Savable queries.
- Support for SQLite.
- Support for MySQL, MariaDB.
- Cross Platform.
Prerequisites
- Java 11 +
- MySQL server for usage with mysql.
Installing
Copy sqlbrowser-for-build.db to sqlbrowser.db. Import the project to your favorite ide as maven project and run SQlBrowserFXApp class. You can also run install.sh script , if you are using linux in order to install sqlbrowserfx as cli command 'sqlfx'.
Build standalone app
Run build.sh script, this will generate all files needed in 'dist' folder. Run SqlBrowserFX.exe for Windows, or run sqlbrowserfx.sh for Linux.
Awesome projects used
- DockFX - The docking framework used (a moded version actually).
- RichTextFΧ - Library which provides editor with syntax highlighting feature.
- ControlsFX - Library which provides many useful custom gui components.
- Spark Java - The web framework used. (Until version 1.5.0)
- Javalin - The NEW web framework used.
Other Notes
SqlBrowserFX is now java 11 compatible (without using the module system) and will not support java 8 from now on. If you want to run it with java 8 check tag 1.5.0 (last for java 8).