Anyone use SQLite?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
OneSeventeen
Forum Newbie
Posts: 2
Joined: Fri Jul 23, 2004 3:42 pm
Location: Albuquerque, NM

Anyone use SQLite?

Post by OneSeventeen »

With SQLite being bundles with PHP5, I just can't help myself! I have been playing around with it a little bit, and so far I'm loving it!

You must understand that right now I've got about 45 Access Databases on a windows-based webserver that I am relying on day in and day out. I still haven't decided if I want to switch over to SQLite, but when you are constantly using over 1 GB of data through MS Access, you get pretty tired of lag times and slow responses.

I was just hoping to find someone who is using SQLite in a production environment, so I could convince everyone else here to switch. (I've already imported a few access databases into SQLite, which took forever, but worked nicely :) )
redmonkey
Forum Regular
Posts: 836
Joined: Thu Dec 18, 2003 3:58 pm

Post by redmonkey »

I'm using it within an internal production environment for some of our less demanding database requirements. I've only recently (over the last month or so) deployed it so can't really comment on the long term stability or usefulness.

I do find the error reporting returned is extremly vague and rather unhelpful. And the lack of 'alter table' command may give some grief if you need to alter an existing database table structure.

I have deployed SQLite for less demanding (low traffic) databases, although I haven't done any testing I'm not too sure how it would cope with heavy usage as it employes database level locking for insert/update/delete etc...
Post Reply