Do you know any SQLite visual develoment tool?
Do you know about any visual development tool such as Microsoft Access or FileMaker but that uses SQlite as database engine?
I'm looking for a Windows desktop software (or easy programming language) with which I can build a database application that uses SQLite.
At last I found dBExForm. It's a GUI form editor for a number on SQL databases such as: Access, MsSql, MySql, Oracle, SQLite.
From the developer web site:
Connect designer to database and get tables and fields direct from database. User or designer can drag and drop components fields and tables to the form. Simple edit form for single table will be ready in couple minutes. DBEXform helps to build small or large applications by creating forms, grids, reports, search, sorts and etc. features with couple clicks. More sophisticated solutions can be made with free hand designer powered with full programming capabilities in .NET Framework environment.
I tested it a little and it seems a good product. Unfortunately it is not cheap: 265USD.
I find sqlitebrowser in first of google search result.
You can download it from here: http://sqlitebrowser.org/
Some important features:
- Open source
- Many platform support (windows, mac, linux)
- Recently updated
Take a look at DBeaver, based on Eclipse.
It is described as a free multi-platform database tool for developers, SQL programmers, database administrators and analysts.
An Enterprise Edition version also supports non-JDBC datasources (WMI, MongoDB, Cassandra, Redis).
A PPA for Ubuntu exists:
sudo add-apt-repository ppa:serge-rider/dbeaver-ce sudo apt-get update sudo apt-get install dbeaver-ce
Take a look at SQLite Studio.
Full history is available if you feel like curious.
So after a WHOLE lot of searching and trying things, I seem to be coming down to an old standard... Delphi.
Delphi + SQLite + a visual manager seem to make a good substitute to Access that is cross platform and doesn't require me to write VBA code.
I don't know of anything that will be as easy to use as FileMaker for creating a database front end. Therefore I have two suggestions.
- Use FileMaker and forget about SQLite. If you're using SQLite, you are probably not building a shared database system, and FileMaker would probably work for this. Is there a specific reason you're deciding on SQLite for your database storage?
- Use Real Studio. It isn't as easy to build reports with Real Studio as with FileMaker, but it can create a front-end to a SQLite system.