Has anyone ever worked with SQLite at all?
PHP5 is apparently going to come with SQLite embedded, ostensibly eliminating the need for a separate database engine for most basic purposes. Seems like SQLite promises to be lightning fast and easy to use, and it also has some surprising "advanced" features (like transactions). There's some unusual stuff as well, like the almost complete absense of data types for columns (which they say is a feature not a bug).
Personally I'm inclined to be hesitant to make the switch for anything but the simplest applications, but perhaps that nervousness is unfounded. Any thoughts?
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
PHP5 is apparently going to come with SQLite embedded, ostensibly eliminating the need for a separate database engine for most basic purposes. Seems like SQLite promises to be lightning fast and easy to use, and it also has some surprising "advanced" features (like transactions). There's some unusual stuff as well, like the almost complete absense of data types for columns (which they say is a feature not a bug).
Personally I'm inclined to be hesitant to make the switch for anything but the simplest applications, but perhaps that nervousness is unfounded. Any thoughts?
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
SQLite