SQLite?
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!
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!
SQLite?
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------
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------
-
dhn
- Registered User
- Posts: 1518
- Joined: Wed Jul 04, 2001 8:10 am
- Location: Around the corner
- Contact:
Re: SQLite?
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.
-
Lord Illicious
- Registered User
- Posts: 19
- Joined: Mon Nov 26, 2001 8:52 am
- Contact:
Re: SQLite?
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.
BTW, great looking beta! Looks really improved and i like the new subforums plus the redirect to URLs forums.
Re: SQLite?
Alpha :wink:Lord Illicious wrote:BTW, great looking beta!
Re: SQLite?
There really is no need for one. Just simply backup your database data. Install phpBB v2.2 then restore your data.Lord Illicious wrote:Hope there will be a mysql to sqlite converter or importer of some sort.
Re: SQLite?
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.
-
A_Jelly_Doughnut
- Registered User
- Posts: 1780
- Joined: Wed Jun 04, 2003 4:23 pm
Re: SQLite?
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
Re: SQLite?
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.
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.
-
A_Jelly_Doughnut
- Registered User
- Posts: 1780
- Joined: Wed Jun 04, 2003 4:23 pm
Re: SQLite?
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 
A_Jelly_Doughnut