Today I built and ran my first successful SQLite queries. It’s really easy, but the damn phpsqlitetadmin tool I was using never worked right. Finally I tried a new program and it worked like a charm. I didn’t realize SQLite supported views, triggers, and custom functions. That’s kinda cool.
Of course, what will I actually use SQLite for? I use MySQL and that seems to work everywhere. The onyl place SQLite seems to be useful is for installations that don’t support databases, and in that case, you have to hope they have SQLite installed or are using PHP5. Perhaps I’ll write the next version of tihs weblog for SQLite and just say you need PHP5 for it to work.