You understand it correctly, meaning that you can not do structural
changes with sql commands. But since sqlite is very fast and easy
you can easily get away with it with some workarounds.
One is to make the new database in memory with the new structure,
import all records into it, drop the old tables, and connect the
database file to the in memory database, and our laughing.
Not as good as structure changes, but works. Also, don't forget that
sqlite doesn't care what type the fields are. So you could in theory
name them all varchar and then still be able to read integers or
whatever from them.
During my dev cycles, I just toss the database file, create a new
one, and continue. But I create my database with code, makes it so
much easier to do everything.
And one but not least, do a good design to start with.
Trausti
On Apr 27, 2006, at 8:23 PM, Long Huynh wrote:
I like the idea of SQLite's easy setup and lite
Maintainant, however I need to change my data
structures often through out the development cycle,
due to requirement changes. There is no easy way to
make modification like MySQL, so I've been still
waiting for new MySQL driver.
Do I not understand SQLite to make this kind of
comment?
Thanks
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|