Database Modeller

dbmodel2Several times I needed a tool to play with database models on Linux and I haven’t found anything decent, so I’ve decided to write one myself. I’ve been using Visio’s entity-relational diagram features a lot and I like it, so this is where I got ideas for the diagram look and editing UI design from. It’s far from complete, but it already does most of the things I needed it to do.

Release 0.3 (2010-01-24)

Download

Changes

  • PDF export
  • Support for printing
  • Opening of files passed through the command line arguments (Bug #401595)
  • The recently used files list now always uses absolute paths
  • Implemented auto-scrolling in the diagram view (Bug #420324)
  • The “Close” menu item will now only close the document, not the window (Bug #420322)
  • Use the selected file format in the export dialog, instead of relying only on the extension (Bug #396056)

Development

You can get the development version of the source code using Bazaar:

bzr branch http://bzr.oxygene.sk/dbmodel/trunk dbmodel

You need to have Qt4 installed, then you can run qmake followed by make to build it.

Roadmap

As I mentioned, this is a personal tool and not a very high-priority project, but there are a few things I’d like to implement in near feature:

  • Extend the model to be able to fully represent a physical database schema (at least for PostgreSQL).
  • Use QtScript to allow users to export the schema into SQL scripts, ORM mapping classes, etc.
  • Allow users to manually edit connections in the diagram. Doing this automatically is a very complex problem (even the simplest approximation I could think of), for which I don’t have enough time.

Links

Comments

4 responses to “Database Modeller”

Leave your response
  1. Lukáš Lalinský | Database Modeller 0.3 says:
    January 24, 2010 at 4:47 am

    [...] Database Modeller [...]

  2. Palo says:
    January 24, 2010 at 10:58 am

    Hi Lukas, what about writing module for SQuirreL SQL. Just kind of view. Anyway nice tool and looking forward to use it – specially with PostgreSQL.

  3. Vaclav Hajek says:
    February 28, 2010 at 6:19 am

    Hi Lukas,

    can I bring the feature request? When I’m doing some relations, two thing are missing to me. Firts, relation arrow may start and finish on the accurate positions of the table columns which are in relationship. Second, can you add cardinality “value” above the arrow (maybe just only during mouseover event)?

    Thank you, greeting from the neighbourhood :) Vaclav.

  4. Bernardo Arancibia says:
    April 18, 2010 at 3:02 am

    I need an arrow like this

    >

    Can you add it? please!

Your response