Re: [Phpsqliteadmin-devel] SQLite2 & SQLite3 compatible

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

On 8/26/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.
> >

Yeah, SQLite2 still our focus, but I see peoples started to use
SQLite3. So we need to do something for this issue, we don't want
phpsla throwed out just because they use SQLite3.

> > 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

OK, clear.

> > 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

So, we need to work on that. Anyone want to create it first? Felipe? Yves?

> > > 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

Nice idea. And also we need to think about "phpsla" system db, should
we use SQLite2 or SQLite3 or both (2 databases)?

>=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

Hah, What's that? ;-S I think this problem with PHP 5.1 at dotgeek
server. BTW, thanks for info Yves. ;-)

> > > Regards,
> > > --
> > > Firman Wandayandi
> > > Never Dreamt Before (http://php.hm/~firman/)
> > >
> > >


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