On Tue, 21 Dec 2004 14:48:33 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > wiseguy wrote: > > > > I've been used sqlite a bit since php5 beta version. Now I am making a > > website and at this point I must decide which database I should use. My wish > > is to use sqlite, but friends of mine say that I might have problem down the > > road if I need to add a column on database or something since ALTER TABLE is > > not available. > > > > Tell your friends that they need to read the FAQ. > http://www.sqlite.org/faq.html#q13
I would also add that last time I worked with MySQL it does this under the hood, which is why ALTER TABLE can be very expensive compared to PostgreSQL or Oracle. It's a trade off in simplicity. -- | Christopher Petrilli | [EMAIL PROTECTED]