Re: [Phpsqliteadmin-devel] SQLite2 & SQLite3 compatible

[Felipe L. <ff...@gm...>]

Ok! I will read a bit about sqlite3 on php...Just to check what is new

OFF: install google talk guys!! Its awesome....and then add me ;-)

Felipe Lopes

On 8/25/05, Yves Glodt <yg...@mi...> wrote:
> On Thursday 25 August 2005 20:15, Felipe Lopes wrote:
> > IMHO we should focus on SQLite2 until php5 upgrades its sqlite
> > extension to SQLite3 officially. In fact, I=B4m not too sure how we
> > should deal w/ this issue, but I imagine that php devel team have
> > good reasons to remain on SQLite2.
> >
> > I would like to hear some words from Yves too...
>=20
> php 5.1 will be able to use sqlite v2 (through the php-sqlite extension)
> and v3 through the pdo_sqlite driver.
>=20
> So we should also support both.
>=20
> > Felipe Lopes
> >
> > On 8/25/05, Firman Wandayandi <fi...@gm...> wrote:
> > > Last night I read about pdo_sqlite extension, it's support SQLite3.
> > > I wondering why the SQLite extension is very slow to upgrade the
> > > engine into version 3. And this morning I asked to SQLite
> > > mailing-list about SQLite3 backward compatibility, then I got
> > > SQLite3 isn't support SQLite2 databases.
> > >
> > > Now, the problem is, If we want phpsla support SQLite3 too, we need
> > > use pdo_sqlite extension for it, but then when we support both of
> > > SQLite2 and SQLite3 we use 2 extensions with very different
> > > behaviour.
> > >
> > > My solution is create the pdo2sqlite or sqlite2pdo wrapper, so we
> > > just only need to call the same function for same operations. What
> > > do you think guys?
>=20
> I think I like that idea
>=20
> > > And does anyone has create the sqlite2pdo or
> > > pdo2sqlite?
>=20
> no...
>=20
> > > Other problem is, how to know a database is SQLite2 or SQLite3
> > > format?
>=20
> To detect whether a file is v2 or v2 IIRC you have to open it and read
> the first dozen of bytes, they have an id of the version of the db
> file. This is not efficient as we would to it on each pageload...
>=20
> We should add a version parameter in the alias definition, and in case
> it's not set, we can always fall back to opening the file and read the
> version there.
>=20
> DBs that are created through phpsla will have this version parameter set
> correctly.
>=20
>=20
> regards,
> Yves
>=20
>=20
> p.s.
> Firman:
> Fatal error: Only variables can be passed by reference
> in /home/firman/public_html/blog/nucleus/libs/BLOG.php on line 187
> ;-)
>=20
> > > Regards,
> > > --
> > > Firman Wandayandi
> > > Never Dreamt Before (http://php.hm/~firman/)
> > >
> > >
> > > -------------------------------------------------------
> > > SF.Net email is Sponsored by the Better Software Conference & EXPO
> > > September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> > > Practices Agile & Plan-Driven Development * Managing Projects &
> > > Teams * Testing & QA Security * Process Improvement & Measurement *
> > > http://www.sqe.com/bsce5sf
> > > _______________________________________________
> > > Phpsqliteadmin-devel mailing list
> > > Php...@li...
> > > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel
> >
> > -------------------------------------------------------
> > SF.Net email is Sponsored by the Better Software Conference & EXPO
> > September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> > Practices Agile & Plan-Driven Development * Managing Projects & Teams
> > * Testing & QA Security * Process Improvement & Measurement *
> > http://www.sqe.com/bsce5sf
> > _______________________________________________
> > Phpsqliteadmin-devel mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel
>=20
> --
> Linux 2.6.12 #1 Sat Jul 9 23:28:04 CEST 2005 i686
>  20:29:18 up  1:43,  0 users,  load average: 0.07, 0.52, 0.56
>=20
>=20
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practic=
es
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & Q=
A
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Phpsqliteadmin-devel mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel
>