Search the web
Sign In
New User? Sign Up
metabase-dev · Metabase Development discussions list
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Re: PHP Extension SQLite Driver latest   Message List  
Reply | Forward Message #1135 of 1151 |
Re: [metabase-dev] PHP Extension SQLite Driver latest

Hello,

on 11/01/2005 01:01 AM jonbouyw said the following:
> OK this latest revision is running 14 out of the 16 tests!!!
>
> I had to turn of PRIMARY key support in order to stop it duplicating
> the PRIMARY key when setting the autoincrement field to type INTEGER
> PRIMARY KEY.

I think an hack of the base manager driver class may be needed. I'll
take a look at that.


> Because the SQLite API is binary unsafe it's still falling over on
> LOB's. I should be able to use the PHP sqlite_udf_encode_binary() and
> sqlite_udf_decode_binary() functions to counter this but I'm not sure
> how best to include those functions in the driver.
>
> Being as using LOB storage for files isn't an issue for me I'm not
> that bothered, but it would be nice to to have it complete now the
> autoincrement is working!!!

I am not sure yet if relying on UDF is a good idea. I need to check what
is the matter.

--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html



Wed Nov 2, 2005 6:03 am

mallemos
Offline Offline
Send Email Send Email

Forward
Message #1135 of 1151 |
Expand Messages Author Sort by Date

OK the last update, for now, until someone who knows what they are doing can verify what I've done. This one is completing all 16 conformance tests. And now...
jonbouyw
Offline Send Email
Nov 1, 2005
7:43 pm

Hello, ... I think an hack of the base manager driver class may be needed. I'll take a look at that. ... I am not sure yet if relying on UDF is a good idea. I...
Manuel Lemos
mallemos
Offline Send Email
Nov 2, 2005
6:03 am

Hello, ... Ok, can you please upload all your files here? http://groups.yahoo.com/group/metabase-dev/files/beta/ ... Great. The survey shows there is a...
Manuel Lemos
mallemos
Offline Send Email
Nov 2, 2005
6:35 am

Hello, ... I am finally integrating your update of the SQLite driver under PHP 4.3.11 using the extension from PECL. I am experiencing a few glitches with the...
Manuel Lemos
mallemos
Offline Send Email
Nov 17, 2005
6:32 am

... script it ... No I have no idea why that happens. I'm am aware of it though, strangely it runs right through the test script, first time, when using a...
jonbouyw
Offline Send Email
Nov 18, 2005
5:41 pm

Hello, ... I figured that the problem is that when you change the schema of an SQLite database, existing database connections are not made aware. The driver...
Manuel Lemos
mallemos
Offline Send Email
Nov 18, 2005
10:24 pm

... Yes, the alternative as I understand it would be to insert a 'VACUUM' on the database in between, but I think it is far more efficient to close and...
jonbouyw
Offline Send Email
Nov 18, 2005
11:14 pm

Hello, ... I am not sure if a VACUUM would notify the other connections. Anyway, that is documented now in the driver notes. ... No problem. I also implemented...
Manuel Lemos
mallemos
Offline Send Email
Nov 20, 2005
3:55 am

... Hi Manuel I've just tested the latest CVS version and it's working great apart from when running for the first time with a persistent connection. PHP...
jonbouyw
Offline Send Email
Nov 20, 2005
2:15 pm

Hello, ... Maybe that is because closing persistent connections should not make any effect. I changed the driver class to not call sqlite_close when closing a...
Manuel Lemos
mallemos
Offline Send Email
Nov 21, 2005
4:00 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help