D. Richard Hipp 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
Sorry, Richard, but I think that it isn't so simple.... you must also store triggers and indexes... and maybe you don't know what's the table structure is, so you must parse youd table structure and modify it...
Anyway, accepting some limitations, it is an easy work...
Also at the page http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers you can find some wrappers that support the ALTER statement
Paolo
