Re: [Phpsqliteadmin-devel] SQLite2 & SQLite3 compatible

[Firman W. <fi...@gm...>]

On 8/26/05, Felipe Lopes <ff...@gm...> wrote:
> Ok! I will read a bit about sqlite3 on php...Just to check what is new
>=20

OK, and create the wrapper too Felipe while you read it ;-)

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

Sure, I will download it first.

> Felipe Lopes
>=20
> 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...
> >
> > php 5.1 will be able to use sqlite v2 (through the php-sqlite extension=
)
> > and v3 through the pdo_sqlite driver.
> >
> > So we should also support both.
> >
> > > 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?
> >
> > I think I like that idea
> >
> > > > And does anyone has create the sqlite2pdo or
> > > > pdo2sqlite?
> >
> > no...
> >
> > > > Other problem is, how to know a database is SQLite2 or SQLite3
> > > > format?
> >
> > 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...
> >
> > 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.
> >
> > DBs that are created through phpsla will have this version parameter se=
t
> > correctly.
> >
> >
> > regards,
> > Yves
> >
> >
> > 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
> > ;-)
> >
> > > > Regards,
> > > > --
> > > > Firman Wandayandi
> > > > Never Dreamt Before (http://php.hm/~firman/)
> > > >

--=20
Firman Wandayandi
Never Dreamt Before (http://php.hm/~firman/)