[libdbi-users] pydbi - Python bindings for libdbi

2011-01-23 Thread Vikram Ambrose
Hello List, Is there any interest in writing python bindings for libDBI? I've been pondering over the idea of a pyDBI for a while now. The advantages of a scriptable interface to libDBI should be obvious. But it goes without saying that having such a binding could make for some very versatile

[libdbi-users] Hello

2011-01-17 Thread Vikram Ambrose
I've been emailing the list for about a month now with my patches and I have got no responses. Can someone please confirm that these messages are going through? -- Protect Your Site and Customers from Malware Attacks Lea

Re: [libdbi-users] PATCH: sqlite3 parser bugs

2010-12-28 Thread Vikram Ambrose
On 12/25/2010 08:34 PM, Vikram Ambrose wrote: The first issue I had was that the parser was unable to find Tables in the SQL statement. This was because the parser assumed that the only possible white space around keywords was ' ' or 0x20; [...] The second bug was that the pa

[libdbi-users] PATCH: sqlite3 parser bugs

2010-12-25 Thread Vikram Ambrose
I'm working on a patch for the sqlite3 driver to resolve some of the issues I've been having. The first issue I had was that the parser was unable to find Tables in the SQL statement. This was because the parser assumed that the only possible white space around keywords was ' ' or 0x20; eg.

[libdbi-users] sqlite3 multiple tables

2010-12-24 Thread Vikram Ambrose
Seem to be having a small problem with the sqlite3 driver. Scenario is 3 tables. 1. Artist (id,name) 2. Album (id,VA,name) 3. Album_Artist (artist_id,album_id) (VA = is a flag to denote Various Artists type Albums) Trying to select a particular Artist from a list VA=0 Albums. SELECT Artist.id

Re: [libdbi-users] sqlite and binary

2010-12-23 Thread Vikram Ambrose
On 12/23/2010 02:35 PM, markus.hoeni...@mhoenicka.de wrote: > Vikram Ambrose writes: > > I can't seem to get BLOBs to work with SQLite. > > > > Here is some test code. > > http://en.pastebin.ca/2026862 > > > > Output on my machi

[libdbi-users] sqlite and binary

2010-12-22 Thread Vikram Ambrose
I can't seem to get BLOBs to work with SQLite. Here is some test code. http://en.pastebin.ca/2026862 Output on my machine is; dbi_conn_connect: rv = 0: data = ERROR What am I doing wrong? Vikram. -- Learn how Oracl

Re: [libdbi-users] Timeout / Reconnect

2010-07-24 Thread Vikram Ambrose
On 07/15/2010 04:11 PM, Markus Hoenicka wrote: > I assume that the server going away is a problem of all database engines, > except maybe the > embedded ones. Adding some code to the MySQL driver to fix your > original problem thus might be the wrong solution. Don't you > experience the same pro

Re: [libdbi-users] Timeout / Reconnect

2010-07-01 Thread Vikram Ambrose
On 07/01/2010 03:12 AM, Markus Hoenicka wrote: > Vikram Ambrose was heard to say: > >> Is there a way of having the mysql driver, reconnect and then complete >> the query without erroring out, in the case of driver/server timeout? >> This way I do not lose my query to a

[libdbi-users] Timeout / Reconnect

2010-06-30 Thread Vikram Ambrose
I make use of the mysql driver and I find that when I come back to my PC the next day, the first query I issue always results in an error. I need to reconnect to the server for it to work again. I've setup a callback to do the reconnect, but the original query is lost. Is there a way of having