Re: [Phpsqliteadmin-devel] SQLite2 & SQLite3 compatible

[Yves G. <yg...@mi...>]

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)=20
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=20
> > 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=20
the first dozen of bytes, they have an id of the version of the db=20
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=20
it's not set, we can always fall back to opening the file and read the=20
version there.

DBs that are created through phpsla will have this version parameter set=20
correctly.


regards,
Yves


p.s.
Firman:
Fatal error: Only variables can be passed by reference=20
in /home/firman/public_html/blog/nucleus/libs/BLOG.php on line 187
;-)

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