SEO

I need a design tool to design my database.

Back in past I used DBDesigner (free) but it is best suited to MySQL
and i now use PostGreSQL and SQLite.

The tool should have most of the following:

Ability to create a rather complex and arbitrarily big scheme and
produce automatically the SQL code for PostGreSQL and for SQLite.

Some degree of automation with "logical to physical" procedures
(automake entity for n:n relationship, foreign key automatically added
and other time saving stuff).

Ability to produce documentation in XML/HTML using the schema and
designer's comments on tables and properties (best would be an html
documentation or an xml schema easily convertible in an html
documentation with some other tool i don't know).

A few tools of pure graphical purpose (colored boxes/panels, labels)
and an easy way to arrange tables, show or hide additional
information, organize relationship (move his names, eventually hide
them), and the ability to export the whole thing as an image.

"Free" or "not so costly" license. If i use postgresql is also to save
money, as you might expect. A one hundred dollars software might be my
solution, a one thousand dollars is probably not.

Ability to generate CRUD stored procedure automatically may be
appreciated, but i belienve it's more than i need.

On 03.07.2007 21:43, Gabriele wrote:
> "Free" or "not so costly" license. If i use postgresql is also to save
> money, as you might expect. A one hundred dollars software might be my
> solution, a one thousand dollars is probably not.

Casestudio.. or Toad Data Modeler, as it is named these days, is about
the only one.


--
Regards,
Hannes Dorbath

It really seem powerful and useful, even in its free version. I will
evaluate it and eventually buy it.

Anyway it doesn't support SQLite. My app use SQLite to handle single
installation (no client/server) and offline work (sycronization with
the server beforehand) to simplify the installation of a more
lightweight client part.
Is there an easy way to convert a PostGreSQL database designed with
Toad in a SQLite database?
Actually, just the create commands are needed, the rest is optional.

Or in case, is there a better way to allow persistent data to be
stored and syncronized from and to a PostGreSQL server without
installing a PostGreSQL server on every client?

On 04.07.2007 10:44, Gabriele wrote:
> Anyway it doesn't support SQLite.

Casestudio is a script based framework, there is lot of user contributed
stuff. I remember having seen SQLite support somewhere, if not it's not
so hard to add support yourself.

--
Regards,
Hannes Dorbath

On 4 Lug, 16:59, Hannes Dorbath <l...@theendofthetunnel.de> wrote:
> On 04.07.2007 10:44, Gabriele wrote:
>
> > Anyway it doesn't support SQLite.
>
> Casestudio is a script based framework, there is lot of user contributed
> stuff. I remember having seen SQLite support somewhere, if not it's not
> so hard to add support yourself.
>
> --
> Regards,
> Hannes Dorbath

Thank you again!
I will study this tool closer.