Posted by Toby Inkster on 01/25/07 10:25

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

• Next in forum: Re: DB -> Flat file, did I waste my time?
• Prev in forum: Re: [ot] listing foreign keys in mySQL on InnoDB
• Thread view: Re: Just PHP will give you nothing unless you upgrade yourself

[Reply to this message]