gnome-db

[rbirdman]

I came across an interesting project while trialling Novell's Linux Desktop. In amongst the menus was a program call mergeant which I haven't noticed before. It's part of the gnome-db (http://www.gnome-db.org/) project which consist of three separate parts.

1.libgda ( database abstraction)
2.libgnomedb ( gtk widgets)
3.mergeant ( database client)

There are providers (drivers) for a variety of databases but it is still early days and there is a lot of functionality to be added in. From what I can gather PostgreSQL and mySQL have the best support at the moment.

I compiled them in Fedora Core 2 after dealing with the dependencies and was able to connect to one of my databases and create a select query. See the link below for some screen dumps.

http://home.swiftdsl.com.au/~rbirdman/mergeant/

In six months to a years time I think I will be saying I wasted my time trying to learn a bit of PostgreSQL :(

[PT_Ryan]

Nah PostgreSQL knowledge does come in handy sometimes.


Regards,
Ryan.

[axcairns]

Looks interesting. Much as I despise it Access is a great tool for quick & dirty work. Looks like this might fit the bill for a Linux equivalent.

Does the query builder support 'visual' development (ie. display the tables and relationships on screen then drag the columns you want into the query then fill in the criteria...)?

Allan

[rbirdman]

Looks interesting. Much as I despise it Access is a great tool for quick & dirty work. Looks like this might fit the bill for a Linux equivalent.

Does the query builder support 'visual' development (ie. display the tables and relationships on screen then drag the columns you want into the query then fill in the criteria...)?

Allan

Its not really aiming to be an access replacement, more of an admin tool for a variety of database (eventually). At the moment the query is a choice of type the SQL yourself or use a wizard. When libgnomedb gets more developed who knows.

One chap on the mailing list is working on some sort of forms section so you may well get some access like features. It would depend on someone with the skill thinking thats worthwhile I guess.

Its very early for this project though. Someone is still working on the code to create the actual postgres tables. At the moment clicking that button just gives a message "function not supported yet".