Posts Tagged SQLite

PHP SQLite3 support

Jul 4th, 2009 Posted in PHP, SQL | no comment »

I never before noticed the SQLite3 class in PHP. Until now.

OK … so what can you use sqlite for? Let’s assume you are developing a database driven app. Wouldn’t it be nice to not have to set up a mysql server on your laptop to be able to code on localhost whereever you are?

With SQLite you only need one *.db file and your ready to run!

$database = new SQLite3('test.db');

That’s all it takes to make a new SQLite object in PHP.

The SQLite code is actually verry similar to MySQLi object code. I like it. Hopefully you do to ;)