Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: LiveFreeAndRoam on September 14, 2010, 04:30:50 pm

Title: Database support for SQLite3
Post by: LiveFreeAndRoam on September 14, 2010, 04:30:50 pm
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.
Title: Re: Database support for SQLite3
Post by: fwoolz on September 15, 2010, 02:13:07 am
LFaR,

Your monicker sure beats New Hampshire's motto here in the States - "Live free or DIE!"
Title: Re: Database support for SQLite3
Post by: LiveFreeAndRoam on September 15, 2010, 10:13:41 am
Hehe.  Yes, I much prefer my version  ;).  I used to be LiveFreeAndSurf, but now I'm doing much more roamin'  8-)

Quote
... Live Free Or Die ...

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

Cheers,
LFaR.
Title: Re: Database support for SQLite3
Post by: fwoolz on September 16, 2010, 12:34:55 am
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!
Title: Re: Database support for SQLite3
Post by: benoit.gygax on September 28, 2010, 06:18:12 pm
+1
Title: Re: Database support for SQLite3
Post by: songofruth on August 17, 2016, 02:02:11 am
Converting from MS Access to SQLite 3.  Would love to see EA have support for it.