Glom 1.0 is out. It’s reasonably stable, and it does many useful things, in a simple way:
- Define fields in tables: number, text, boolean, date, time, and image.
- Define relationships between tables.
- Define field calculations with python.
- Define field lookups.
- Define default field formatting which can be overriden later.
- List and details views, with automatic layout when resizing.
- Related records portals on the details view.
- Related Fields on list and details views.
- Dropdown lists of choices for field entry.
- Open and Find buttons next to ID fields (used by relationships).
- Find mode: Using the existing list and details layouts, with a built-in full text search.
- Reports: Simple reports with group-by and summary parts.
- Per-table user/groups access rights.
- Scripting: Add a button to the details view to run a python script.
- Internationalization: Translate titles of tables, fields, layout items, relationships, reports, etc.
All without SQL. This is enough for regular people to create usable database systems, though the current version would probably be challenged by tables that have millions of records.
Glom will now voluntarily follow the GNOME release schedule, so new features will be implemented and stabilized every six months. I’m looking forward to implementing all the new features, but I will take a break to do some paying work. I recommend Ubuntu Dapper for trying out Glom – wait for the Ubuntu release on
April 20th June 1st 2006 if you want a stable system.
Many thanks to the beta testers who helped me to reproduce and fix some annoying bugs, particularly Peter Williams, Ryan Paul, Phill Gillespie, Halászvári Gábor, and Daniel Holbach.