Glom

Glom is an open source and totally free graphical software implemented in GTK+ for the GNOME desktop environment and engineered to allow users to design database table definitions and to manipulate the relationships between them.

The program also allows users to edit and search the data in those tables, it features relationships, related fields, lookups, related records, drop-down choices, calculated fields, searching, users and groups, as well as reports.

The Glom application also includes Numeric, Date, Text, Time, Image and Boolean field types, and allows users to translate each Glom system in multiple languages, making it available for numerous countries.

Getting started with Glom

After installation, you will be able to easily open the application from the main menu of your desktop environment. A ‘Welcome to Glom’ dialog will open, allowing you to open an existing document from a local file, a session found on the local network or recently opened projects.

The same dialog will also allow you to create a new empty document or to create a new document from predefined templates, such as small business example, lesson planner, music collection, openismus film manager and project manager example.

All documents can be exported to a custom location, imported from previous sessions or shared on the network. From the Tables menu you can easily access contacts, invoices, products and stuff, as well as to edit selected tables.

The Developer menu is the most important one, as it allows users to quickly switch between operator and developer, as well as to modify fields, relationships, relationships overview, layout, print layouts, reports, database preferences, users, script library, and translations. It also allows you to export or restore backups, test translations, enable drag and drop of layouts, and change the active platform from normal to Maemo.

Designed for GNOME

The software has been designed for the GNOME desktop environment and it is distributed along with the GNOME Project. It is fully compatible with any other open source desktop environment and operating system, supporting 32-bit and 64-bit hardware platforms.

What is new in this release:

• Layout: Custom fonts: Fix regressoin in 1.31.5. (Murray Cumming)

What is new in version 1.31.5:

• Build: Convert the source code to C++11.
• Build: Remove unused source code.
• Build: Use libxml++-3.0 instead of libxml++-2.6.
• Build: Improvements to how we find and use boost libraries. (Murray Cumming)

What is new in version 1.29.3:

• Details: Let entry widgets expand to fill space, fixing a regression from 1.27.2.
• Details: Make text alignment work again, fixing a regression from 1.27.2
• Use the LC_TIME to get translated date formats, even when LANGUAGE is set.

What is new in version 1.28.3:

• Use the LC_TIME environment variable to get translated date formats. (Murray Cumming) Bug #742968
• Avoid a crash during shutdown. (Murray Cumming) Bug #741851
• Fix remaining warnings from the Coverity scan. (Murray Cumming)

What is new in version 1.28.0:

• Glade UI files:
• Remove deprecated GtkContainer:resize-mode property.
• FlowTableWithFields: Replace use of deprecated xalign and valign.
• Replace stock properties with icon-name properties.

What is new in version 1.25.6:

• Backup/Restore: Use libarchive instead of calling the tar shell command. This should be slightly more robust and safe, though we were already correctly escaping and quoting the shell commands.
• Avoid an infinite loop when document loading fails.

What is new in version 1.25.5:

• Check that we have the pg_config utility.
• Add some tests.
• Slight improvements to the libglom API.

What is new in version 1.24.3:

• Build:
• Check that we have the pg_config utility.
• Find libpython* on Ubuntu Trusty 64-bit.

What is new in version 1.25.4:

• Fix a crash when switching between Data and Find mode.
• Fix some widget expansion in the UI.
• Formatting: Do not allow a 0 line-height for multiline text.
• Added some more tests.
• Some code cleanup.

What is new in version 1.24.2:

• Avoid some crashes when switching between Data or Find mode, or when navigating around generally.
• Fixes for clang compiler and scan-build analyzer warnings. (This should make sharing over the network work again.)
• Small Business examples: Correct a Relationship title.

What is new in version 1.22.4:

• Avoid some crashes when switching between Data or Find mode, or when navigating around generally. (Murray Cumming)
• Fixes for clang compiler and scan-build analyzer warnings. (This should make sharing over the network work again.) (Murray Cumming)
• Small Business examples: Correct a Relationship title. (Murray Cumming)

What is new in version 1.25.3:

• Make menu item accelerators work again. (Murray Cumming)
• Field Definition: Move Default formatting into a separate window. (Murray Cumming)
• Find (broken after the port to GAction): - Really stop when cancelling after none found. - Show only the found records. - Update the menu item state. (Murray Cumming)
• Adjust dialog widget spacing to be more GNOME HIG-compliant. (Murray Cumming)
• Rearrange some dialogs to make them less tall, to (almost) fit in small screens. (Murray Cumming)
• Replace (deprecated) GtkTable with GtkGrid. (Murray Cumming)
• Replace our custom GtkNotebook with GtkStack. (Murray Cumming)
• Build:
• Bundle .glade files, (most) icons, and example files into the Glom executable using GResource, instead of installing them. (Murray Cumming)
• Bundle the XSLT file into the libglom library instead of installing (Murray Cumming)
• Port from gnome-doc-utils to yelp-tool. (Murray Cumming)
• Fixes for clang compiler and scan-build analyzer warnings. (Murray Cumming)
• AppData file: Actually use translations. (Murray Cumming)

What is new in version 1.25.2:

• Build:
• Fix the build with --enable-warnings=fatal, by replacing all uses of GtkUIManager and GtkAction with GtkBuilder, GAction and GMenu. (Accelerators, such as Ctrl-Q are currently not working.) (Murray Cumming)
• Replace depreacted GtkHBox and GtkVBox with GtkBox in Glade files. (This can cause strange layout issues, but I think I caught them all.) (Murray Cumming)

What is new in version 1.24.0:

• Document format: table node: Remove superfluous parent_table attribute.
• libglom: Various minor code cleanups.

What is new in version 1.23.4:

• Fix the build with --enable-warnings=fatal. Do not use ev_view_set_loading() because it is deprecated.
• Fix the build on Ubuntu Raring. It puts libpython2.7 in /usr/lib/i386-linux-gnu/ .
• Reduce the libgda dependency version again.

What is new in version 1.23.3:

• Added an --enable-mysql configure option. When enabled, this adds a PostgreSQL/MySQL choice in the UI, as with the existing --enable-sqlite configure option. The MySQL support is very experimental and unsupported. It might be removed later if nobody chooses to work on it.
• libglom: Added a dependency on libgda-mysql-5.0, because libglom always supports all backends regardless of the build option.
• Tests:
• Simplify the code a litte.
• Test the use of a relationship to get data.
• Add a test that uses an example with text primary keys.

What is new in version 1.21.5:

• Depend on libgda 5.0.3 because we need the GdaNumeric corrections. This avoids errors when creating from examples, when using a non-English locale. This fixes bug #668346 (Janne)

What is new in version 1.23:

• libglom: TranslatableItem: Require the caller to provide the locale to get_title() instead of calling the static set_current_locale() method (now removed). This allows Online Glom to use translations, and it is generally good to avoid the static data.

What is new in version 1.21:

• Make libglom 1.22 parallel installable with glom 1.20.
• Document: Added get_translation_available_locales().
• Field: Remove unused get_gda_holder_string().
• Remove unused get_sql_format() methods.
• DbUtils:: Added get_fields_for_table(),
• get_fields_for_table_one_field(), get_lookup_fields(), and
• get_lookup_value()
• Add a remove_field(parent_table_name, table_name, field_name) method overload, deprecating the existing method overloads.
• Deprecate the old has_field() method and do not use it.
• Remove unused parameternamegenerator.[h|cc] source files.
• Avoid deprecated glibmm API (Murray Cumming)

What is new in version 1.20.2:

• Correct parsing of quotes in example data.
• ComboBoxes: Work around GtkComboBoxText bug #612396. This fixes the Users/Groups dialogs and the Script Library dialog.
• libglom: DbUtils::recreate_database_from_document(): Create groups and set table privileges too.
• More tests.

What is new in version 1.20.1:

• Avoid some unnecessary stdout warnings.
• Tests:
• Added several more tests and improved existing tests.
• Added gcov/lcov to generate test code coverage reports in HTML.(make gcov)
• libglom:
• LayoutGroup: Added a remove_field(parent_table_name, table_name, field_name) method overload.
• LayoutGroup: Added a has_field(parent_table_name, table_name, field_name) method overload.
• Added DbUtils::set_fake_connection().

What is new in version 1.19.12:

• Added the glom_create_from_example command-line utility. This has no UI dependencies and might be useful when using Online Glom.
• Details:
• Print: Use a standard print layout instead of HTML.
• ID choosing dialog: Work around a crash in GTK+. Bug #660347
• Related Records: Fix bug with a blank row when there is only one row.
• Related Records: Do not try to navigate to an empty record.
• Find:
• Get criteria even when a field is on the layout twice.
• Do not show data in related records.
• Developer mode:
• Fields: Adapt choices fields when changing field names. Bug #661075
• Simplify the default layout structure for details.
• Details: Do not enable drag-and-drop by default.
• Field Formatting window: Make it slightly less tall. See https://bugs.launchpad.net/ubuntu/+source/glom/+bug/863016
• Layout window: Correct the vertical order of Add buttons.
• Print Layout:
• Allow multiple pages.
• Add experimental Create Standard feature.
• Add an Align menu.
• Show contents of System Preferences in Fields.
• Document:
• Avoid writing some unnecessary XML nodes.
• Use CSS3 formatting for colors, via Gdk::RGBA. (Murray Cumming)
• Build: Remove glibc-specific function call. (Jasper Lievisse Adriaanse) Bug #660496
• libglom:
• LayoutItem_Portal: Added get_suitable_table_to_view_details().
• Added layout_field_should_have_navigation(). (Murray Cumming)

What is new in version 1.19.4:

• Calculated fields and button scripts:
• Properly return boolean results.
• Initialize pygobject, to fix the use of the PyRecord API.
• libglom: Added utils::build_sql_select_count_rows().
• Fix crashes when using choices with fixed lists.
• Do not crash if PyDateTime_IMPORT fails.
• Remove some unnecessary padding/borders around the main window.
• Main window: Use a custom Notebook-like widget instead of Gtk::Notebook.
• CSV Import: Fix quoted-newline detection, so we don't drop rows.
• Use the new Gtk::ComboBox CellArea API to align columns properly.
• Build:
• Depend on libgdamm-5.0 instead of libgdamm-4.0.
• Remove the dependency on pygda, though we now check for gi.repository.Gda at startup instead.It is provided by libgda-5.0 (currently 4.99.x).
• Require the latest mm-common and dist the mm-common scripts.
• Require the latest gtksourceviewmm

What is new in version 1.18.1:

• CSV Import: Fix quoted-newline detection, so we don't drop rows. (Murray Cumming) Bug #637529 (Darmon Xavier),
• libglom:
• Avoid the PyDateTime_Check() crash in strange situations such as under JNI. and provide a clue on stderr.
• Added utils::build_sql_select_count_rows().
• ComboEntry: Really have an entry.
• Build:
• Require the latest libgdamm, because we use its latest API.
• Avoid a tarball-build dependency on mm-common or the mm-common scripts installed by the older version of glibmm.
• Make glom-1.18 parallel-installable with glom-1.16 (Murray Cumming)

What is new in version 1.19.3:

• Build with the latest gtkmm, goocanvasmm, libgdamm and gtksourceviewmm.
• Fix the tests builds with changed linker behaviour on Ubuntu Natty.
• Allow libglom to be built without building the Glom UI code too.
• Handle changed setlocale() behaviour on Ubuntu Natty.

What is new in version 1.14.7:

• CSV Import: Actually preview and import the field values. Murray Cumming) Bug #625693 (maximiliano).
• Build:
• Remove the gconfmm dependency, because we don't use it. (Murray Cumming)

What is new in version 1.16.2:

• CSV Import: Actually preview and import the field values. Bug #625693 (maximiliano).
• List view: Make the retry option actually work afer entering invalid data. Bug #167818
• Build: Remove the gconfmm dependency, because we don't use it. (Murray Cumming)

What is new in version 1.19.2:

• CSV Import: Actually preview and import the field values. (Murray Cumming) Bug #625693 (maximiliano).
• List view: Make the retry option actually work afer entering invalid data.(Murray Cumming)
• Details view: Solve some widget layout problems, by using Use EggSpreadTable from libegg instead of Glom's own FlowTable widget.
• Build:
• Remove the gconfmm dependency, because we don't use it.(Murray Cumming)
• Use upstream gettext instead Glib one.(Javier Jardon) Bug #631367
• (Hopefully) solve the timing problems in the import tests, which are now active again.
• Call xmlCleanupParser() because libxml++ does not anywmore.(Murray Cumming)

What is new in version 1.14.6:

• Import dialog, Text formatting:
• SpinButtons: Don't have 0 to 0 ranges with only 0 increments possible.
• Document loading: Show an error dialog even for unexpected errors.
• Startup: Catch exceptions from std::locale::global() because it is throwing in at least one system under apparently normal circumstances. This should fix bug #619445 (teidooricaerak) or at least give us another clue. (Murray Cumming)
• Build: Linker flags improvements (David King)

What is new in version 1.15.2:

• Field Formatting: Related Choices: Add a Show All checkbox, so that the list of choices can be restricted according to the relationship, instead of just showing all values in the related table. This allows the Choices to be used to narrow down a choice based on a choice in another field. (Murray Cumming) Bug #625536 (fmyhr)
• Allow unique fields with same name in multiple tables. (Murray Cumming) Bug #625192 (fmyhr).
• Developer menu: Added Export Backup and Restore Backup menu items. These use PostgreSQL's pg_dump and pg_restore utilities, wrapping the dump and .glom file up in a .tar.gz.
• As well as allowing backups of data, this should make it easier to upgrade the PostgreSQL version, which some distros do automatically when upgrading to new major versions of Glom. This is possible because pg_restore can work with the pg_dump output of an older PostgreSQL version.
• See also: http://www.glom.org/wiki/index.php?title=Pg_dump_when_upgrading_PostgreSQL (Murray Cumming)
• Build:
• Explicitly link with libdl for Python module loading test. (David King)
• Rename the library to libglom-1-16 to be parallel-installable with libglom-1-14.
• Adapt to the latest libgdamm API. (Murray Cumming)

What is new in version 1.14.4:

• Developer menu: Added Export Backup and Restore Backup menu items. These use PostgreSQL's pg_dump and pg_restore utilities, wrapping the dump and .glom file up in a .tar.gz. As well as allowing backups of data, this should make it easier to upgrade the PostgreSQL version, which some distros do automatically when upgrading to new major versions of Glom. This is possible because pg_restore can work with the pg_dump output of an older PostgreSQL version. See also: http://www.glom.org/wiki/index.php?title=Pg_dump_when_upgrading_PostgreSQL (Murray Cumming)
• Build: Explicitly link with libdl for Python module loading test. (David King)

What is new in version 1.14.3:

• Fix position of "Records / Found" labels. (Daniel Borgmann)
• List: Don't allow deleting placeholder rows. (Daniel Borgmann)
• Build: Don't require avahi-ui.

What is new in version 1.14.1:

• Python field calculation: Fix a crash when using some date types.
• Documentation:
• Build and install libglom (C++) API reference documentation (for use by applications) and pyglom (Python) API reference documentation (for use by Glom calculated fields and button scripts). (Murray Cumming, Daniel Elstner, David King)
• Added unit tests. (Murray Cumming)

What is new in version 1.12.7:

• Initial Dialog: Do not crash sometimes if cancelling the file chooser.(Murray Cumming) Bug #612303 (David King)
• Details: Do not make field widgets too wide, so this fits on a laptop screen.(Murray Cumming)
• Build:
• Fix the build with exceptions disabled. (Peter Penz)
• Fix the buidl with autoconf 2.65(Fryderyk Dziarmagowski) Bug #613179
• Check for the correct libxml++ dependency (David King)

What is new in version 1.13.9:

• Field Formatting: Allow choices to be shown as radio buttons instead of a
• drop-down combo box. Requested by Frederik Vande Rieviere.(Murray Cumming)
• Python scripts: Added a startup script feature, in Database Preferences.
• Initial Dialog: Do not crash sometimes if cancelling the file chooser.(Murray Cumming) Bug #612303 (David King)
• Build:
• Don't use deprecated gtkmm API. This requires the latest gtkmm.(Murray Cumming)
• Require the correct gtkmm and libsigc++ versions.(David King)
• Fix the Glade file so it can be opened with the latest glade-3 (when the
• gtksourceview glade catalog is installed).(David King)

What is new in version 1.13.8:

• Align widgts in neighbouring groups, making things look generally neater. - Do not make field widgets too wide, so this fits on a laptop screen. (Murray Cumming)
• Python scripts: Added ui.print_layout(), ui.print_report(report_name), and ui.start_new_record() methods. (Murray Cumming)
• Fix the build with exceptions disabled. (Peter Penz )

What is new in version 1.13.6:

• Python scripts:
• Fields value may now be changed like so: record["fieldname"] = 123
• Simple navigation is posible via, for instance: ui.show_table_list("artists") ui.show_table_details("artists", 10) where 10 is the value of the primary key in the table. (Murray Cumming)
• Avoid showing in the window title. Noticed by Daniel Borgmann. (Murray Cumming)

What is new in version 1.12.2:

• Details: Choices: Actually show choices drop-down lists again, fixing a regression in Glom 1.12.
• Export, Import: Better handling of binary image data.

Requirements:

• Bakery
• libgdamm
• Python
• PyGTK
• iso-codes