I’m looking for a graphical tool that allows me to create, populate and browse/search databases.
Primary use case: Curate a personal collection (e.g., for movies, postage stamps, quotes, …). There are often specialized databases (e.g., Griffith for media) for such cases, but I’m looking for a general-purpose one that makes no assumptions.
It should, of course, support several tables (otherwise, LibreOffice Calc could probably be used). So in case of a movie database, the user might also want to record directors (and their metadata).
The form (for populating) should be created automatically according to the database setup.
It should offer fields like: text, date, select lists (with pre-defined values), relations (to other records in same or other tables), file upload, image (displayed), etc.
- Fields should support: validation criteria (i.e., "must contain only numbers", …), multiple values (i.e., "can have 1 or more values", "must have exactly 1 value", "none or 1 value", …)
There needs to be some kind of export in well-known format.
It needs to support searching in specific as well as in all fields, only in specific or also in all tables.
- It MUST be FLOSS (Free/Libre Open Source Software).
- It MUST run natively on GNU/Linux, no web-apps.
What I know
I’m not experienced with this tool, but I guess that OpenOffice/LibreOffice Base could probably solve most of my requirements, but as far as I can see, I’d have to create the forms manually (i.e., first create the database, then create the form). Also, the (default?) "design" (look and feel) of the forms is not really user friendly, it gets complicated when there are several tables involved.
I often use the CMS Drupal when I need such a database. It offers everything I need (content types, fields, relations), creates the forms automatically, and allows me to export the data (with custom modules). However, I’m looking for a native/local client (nothing that requires a server).
I also found Glom and Kexi, but I have no experience with them.