PHP - SQLite vs SQLite3

Question

I've made a web application using SQLite (2.8.17), I've only now discovered that there's an SQLite3. It somehow eluded my attention when making the web application, probably due to the lack of documentation for the php functions.

I'm wondering, what are the benefits of using SQLite3 over SQLite? Is it considerably faster?

Bogdev · Accepted Answer · 2010-12-07 16:37:01Z

30

SQLite2 internally stores every value as a string, regardless of its type.
Upgrading to SQLite3 will certainly shrink the database size since numbers and BLOBS get stored in their native formats, which could make things run faster.
Another big advantage in my opinion is that recent versions of sqlite, (starting from 3.6.23) support foreign keys.

Since you were using PHP, I would suggest that you look into PDO. It could prove helpful in case you need to change the DBMS for the application

edited Dec 7, 2010 at 16:37

answered Dec 7, 2010 at 16:29

Bogdev

3262 silver badges3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex LE · Accepted Answer · 2010-12-07 05:14:59Z

5

This documents from the sqlite.org website: http://www.sqlite.org/version3.html it doesn't talk about performance, but differences. anyway there are not update to sqlite2 I personally recommend using latest and greatest version 3 (see Improved Concurrency, always good for web applications).

answered Dec 7, 2010 at 5:14

Alex LE

20.8k4 gold badges32 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP - SQLite vs SQLite3

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related