|
|
Posted by Hasin Hayder on 01/25/07 11:21
If thats the issue with SQLite, let me share some info. The FK is
available in MySQL also , but unfortunately If the table type is
MyISAM, it doesnt maintain the FK forcefully. The FK is somewhat
actually working if and only if ur table type is InnoDB
I am not biased by PGSQL or SQLite, I just recently moved to PG.
Regards
Hasin Hayder
http://hasin.wordpress.com
On Jan 25, 4:25 pm, Toby Inkster <usenet200...@tobyinkster.co.uk>
wrote:
> Hasin Hayder wrote:
> > And it is also necessary to learn atleast one of the embedded database
> > like SQLite. Dont ever think that SQLite is less powerull.SQLite still has a long way to go before it can be considered a contender
> for anything more than very basic projects. I imagine that the lack of
> foreign key constraints alone is enough to put it out of the running for
> many projects.
>
> My current project is being built on PostgreSQL, and I plan to also
> support MySQL for the 1.0 release, and then Firebird for shortly later.
> (PDO helps!) I've considered supporting SQLite in the first release, but
> with its current feature set, it just won't cut it. Perhaps if a future
> release includes foreign keys and, triggers, I'll reassess the situation.
>
> BTW, nice rant.
>
> --
> Toby A Inkster BSc (Hons) ARCS
> Contact Me ~http://tobyinkster.co.uk/contact
Navigation:
[Reply to this message]
|