GcDBBuilder version 1.0beta (release date: 2009-03-23)
About
This is Database table and relation design tool, created for web development puprose. Main reason I started developing this tool, was the lack of free DB design tools available. Main goal of this software is FREE PostgreSQL designer, but in the future MySQL support will also be implemented
Brief history
I started with Microsoft Visio which was very expensive piece of software and ER diagramm drawing was for Microsoft SQL and Access databases only. Next I tried FabForce DBDesigner4 - which was developed for MySQL, I love this software, but "MySQL only" drives me crazy, because 99% of my work I do with PostgreSQL. Then I switched to Dia (software build on GTK+) - it was usefull for UML diagramm drawing, but to get SQL out of UML it was real pain, and I must add that this software was ugly. So I searched Google a bit and found DBDesigner Fork (which is a fork of FabForce DBDesigner 4), this software had support for PostgreSQL *.sql file export, but it also had some nasty bugs (like crashing on table deletion). So then I realized - either you pay for good software like SQLManager or you develop it yourself. So here it is, I'm making my own :)
What's ready and what's not
SQL import and export - partialy. You can import tables, foreign keys and indexes, and you can export tables (CREATE TABLE), relations and indexes.
Drawing and editing - you can draw and edit tables and relations, but yet there is no algorythm for table and relation positioning (same goes for SQL import) - all the tables and relations appear on the upper left corner - all in one stack. Don't worry - there is Drag&Drop implemented, so you can reorder them as you wish, but position saving has yet to come.
Own file format - maybe, or maybe I could use DBDesigner Fork XML file format - i seems pretty good.
Database connections and reverse engineering - yes, I have thought of that, but first I must rewrite (a couple of times) my SQL parser.
MySQL support - unfortunately I'll have to leave it for version 2.0, because PostgreSQL support is still prety unfinished
Download
- Windows binaries (.NET Framework not included)
- Source code (Visual C# 2005 Express Edition)
Previous releases
- v0.4alpha
- Windows Intaller
- Windows binaries (.NET Framework not included)
- Source code (Visual C# 2005 Express Edition) - not yet released (will be released at the time of version 1.0)
- SQL Reader source (C#) - if anybody is interested in helping to make it perfect, please contact me.
Requirements
Microsoft .NET Framework 3.0
Change Log
- 2009-03-23 (v1.0) - SQL parser completely rewriten. New UI.
- 2007-11-09 (v0.4) - SQL parser completely rewriten, but still not perfect. Few design updates.
- 2007-10-27 (v0.3) - Initial public release.
ToDo
- Algorythm for "new table" or "new other object" positioning on the plot.
- Own or DBDesigner Fork XML file support for workspace data storage
- Implement objects: Triggers, Functions, Indexes, Sequences. Anyting else?
- Draw cute icons
