Database support for SQLite3

[LiveFreeAndRoam]

SQLite3 is extremely popular in embedded systems, handheld devices, and applications that have 'simple' database requirements.

At the moment, I have to manually massage the DDL statements that EA creates so it is useable by an SQLite3 database.

Similarly, using ODBC to reverse engineer a SQLite3 database resulted in several pieces of information missing from the diagram.  Especially table relationships.

Any chance we can get full SQLite3 support?  See http://www.sqlite.org/ for more information.

LFaR.

[fwoolz]

LFaR,

Your monicker sure beats New Hampshire's motto here in the States - "Live free or DIE!"

[LiveFreeAndRoam]

Hehe.  Yes, I much prefer my version  .  I used to be LiveFreeAndSurf, but now I'm doing much more roamin'  8-)

... Live Free Or Die ...

I wonder... is that an "inclusive or" or an "exclusive or".  Just kiddin', no disrespect intended.

Cheers,
LFaR.

[fwoolz]

LFaR,

No worries, no offense taken! If you browse the forum you'll no doubt find many threads discussing inclusive vs. exclusive or and a host of other semantic topics.

In the particular case of New Hampshire, however, I think General John Stark meant it as an {XOR} constraint when he used the phrase in the following toast before the Battle of Bennington in 1777: "Live Free Or Die; Death Is Not The Worst of Evils." Of course he wasn't going to be in the battle, so it was easy for him to say!

[benoit.gygax]

+1

[songofruth]

Converting from MS Access to SQLite 3.  Would love to see EA have support for it.