mORMot Open Source

BrentG

Member

Registered: 2012-04-05

Posts: 31

Newbie Question: Best way to create Sqlite tables?

I just stumbled on mORMot and since I'm a Delphi fan, I'm eager to put it to work.

My question is, what is the best way to construct the table structures?

1) Is the table structure always hand coded in a Delphi TSqlRecord class as per the first couple of examples I've seen, or
2) Can I use something like SqliteStudio and then import the table structure into Delphi? If so, is there a utility for that?

TIA
Brent

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Newbie Question: Best way to create Sqlite tables?

1) You can use existing DB structure, if they match the TSQLRecord layout.

2) There is no reverse engineer feature yet.
But it is planned and already prepared in SynDBExplorer tool.