It’s been a while since I last posted anything, but I’ve nonetheless been busy that time: now Libgda has support for creating and modifying database structures (that is queries like CREATE TABLE, etc).
The pictures below show the database creation dialogs from Mergeant for PostgreSQL and MySQL (notice the small differences in the information required to create a database):
This code is not yet in CVS but will soon be.
I suppose most of these fields are optional? When you create a database using the command line (mysql for example) you need almost no information:
mysql -u root -p
create database
At least for localhost, which is the common case, I’d think.
I hope this doesn’t encourage people to specify an encoding when creating Postgres databases. The default should be correct, and the default should be what they want.
The dialog needs some padding around the edges. See, e.g. http://developer.gnome.org/projects/gup/hig/2.0/design-window.html#layout-dialogs
What’s the deal with the OK/Cancel button’s being flipped, too?