SQLite?

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
parry60
Registered User
Posts: 5
Joined: Fri May 09, 2003 9:00 pm

SQLite?

Post by parry60 »

Since PHP5 is going to include SQLite by default, are there any plans to incorporate an SQLite extension to the phpBB 2.1 DBAL?
-----BEGIN GEEK CODE BLOCK-----
GCS d- s:- a---- C++++ UL++++ P+ L+++ E- W+++ N+ o K+ w---
O- M+ V-- PS+++ PE-- Y+ PGP t 5 X R tv-- b++ DI+ D+
G e-- h! r-- y
------END GEEK CODE BLOCK------
User avatar
dhn
Registered User
Posts: 1518
Joined: Wed Jul 04, 2001 8:10 am
Location: Around the corner
Contact:

Re: SQLite?

Post by dhn »

Yes, and it is already implented. ;)
Image
User avatar
dhn
Registered User
Posts: 1518
Joined: Wed Jul 04, 2001 8:10 am
Location: Around the corner
Contact:

Re: SQLite?

Post by dhn »

psoTFX in a recent CVS checkin wrote:SQLite support ... Probably helps if the installer supports it I guess ... I'm having one of those lifes, please excuse me.
Image
User avatar
Lord Illicious
Registered User
Posts: 19
Joined: Mon Nov 26, 2001 8:52 am
Contact:

Re: SQLite?

Post by Lord Illicious »

Hope there will be a mysql to sqlite converter or importer of some sort.

BTW, great looking beta! Looks really improved and i like the new subforums plus the redirect to URLs forums.
smiley
Registered User
Posts: 14
Joined: Thu Jun 19, 2003 11:50 pm

Re: SQLite?

Post by smiley »

Lord Illicious wrote:BTW, great looking beta!
Alpha :wink:
eXplosive
Registered User
Posts: 45
Joined: Mon Mar 04, 2002 4:03 am

Re: SQLite?

Post by eXplosive »

Lord Illicious wrote:Hope there will be a mysql to sqlite converter or importer of some sort.
There really is no need for one. Just simply backup your database data. Install phpBB v2.2 then restore your data.
cgranade
Registered User
Posts: 86
Joined: Thu Jul 03, 2003 8:35 pm

Re: SQLite?

Post by cgranade »

What advantages come of using SQLite in this case, v. MySQL? Can SQLite handle the same stresses, or more? I've just not heard of SQLite until now, and have no idea as to how capable it is.
User avatar
A_Jelly_Doughnut
Registered User
Posts: 1780
Joined: Wed Jun 04, 2003 4:23 pm

Re: SQLite?

Post by A_Jelly_Doughnut »

SQLite is well, Lite. It lacks several features. I haven't seen any benchmarks, so I can't comment on that, though.
A_Jelly_Doughnut
User avatar
psoTFX
Registered User
Posts: 1984
Joined: Tue Jul 03, 2001 8:50 pm
Contact:

Re: SQLite?

Post by psoTFX »

Actually it lacks very very little ... in many ways it's standard SQL feature set is superior to MySQL. It's called "lite" because it is a self-contained "server/client".

As I've noted before for boards where there are few simultaneous users it will likely provide a fairly robust solution. However, for busier boards the file I/O will probably "wreck" performance ... this is where a dedicated server daemon comes into its own.
User avatar
A_Jelly_Doughnut
Registered User
Posts: 1780
Joined: Wed Jun 04, 2003 4:23 pm

Re: SQLite?

Post by A_Jelly_Doughnut »

I'm thinking that it would be a pain to MOD, due to lack of ALTAR TABLE commands, but I won't try to MOD it until it is done :P
A_Jelly_Doughnut
Post Reply