Glom 1.0

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.

6 thoughts on “Glom 1.0

  1. Hi Murray,

    just a quick note: Ubuntu Dapper Drake (aka 6.06) will be released on June 1st 2006; there will be a rather stable pre-release on April 20th, maybe you meant that.

  2. Great work! The 1.0 feature list looks awesome. I’m looking forward to the day when I can completely replace all my crufty old Python database management scripts with an elegant Glom solution. That day seems to be getting closer all the time. The post-1.0 feature list is very exciting. I’m particularly looking forward to seeing things like evolution data server integration and support for a web UI. Keep up the good work!

    I do have a feature request… if it is at all possible, I’d like to be able to sort rows by specific columns in the table view. I couldn’t figure out how to do that. I have a field in one of my tables that uses a date type, and I want to be able to sort my rows by date. Is this possible? If not, is it possible to implement that in a future version?

    Thanks!

    — Ryan

Leave a Reply to Dave Cancel reply

Your email address will not be published. Required fields are marked *