Re: [sqlite] SELECTing calls < last two weeks?

On Tue, 25 Mar 2008 11:09:55 -0400, "Derrell Lipman" <[EMAIL PROTECTED]> wrote: >http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Thanks guys. For those interested, here's a way to do it: $sql = "SELECT * FROM calls "; $sql .= "WHERE (julianday('now') - julianday(calls_date)) < 15"; ___

[sqlite] SELECTing calls < last two weeks?

Hello In MySQL, I used the following to only get calls received in the last two weeks: WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY) Is there an equivalent in SQLite, or should I perform this test in PHP? Thank you. ___ sqlite-us

Re: [sqlite] [FreeBSD] Can read but can't write?

On Mon, 24 Mar 2008 21:57:52 +0100, Gilles Ganault <[EMAIL PROTECTED]> wrote: > I'm having the following issue trying to access an SQLite 3.3.17 >database from PHP+PDO under FreeBSD 6.3: I can read, but can't write, >with no error reported by PHP or /var/log/mes

[sqlite] [FreeBSD] Can read but can't write?

Hello I'm having the following issue trying to access an SQLite 3.3.17 database from PHP+PDO under FreeBSD 6.3: I can read, but can't write, with no error reported by PHP or /var/log/messages. I've tried both Apache and Lighttpd as web server, to no avail. Here's some information: 1. ec

Re: [sqlite] Where is the database file created?

On Sat, 22 Mar 2008 22:06:12 +0900, "Fred Janon" <[EMAIL PROTECTED]> wrote: >Thanks, I did already read that page and all the other ones. I was asking a >question about SQLLite3.exe very precisely, I thought. The command line is >in my email and its result. I don't think there is any mention of in-

[sqlite] Formating SUM?

Hello I searched on the web site and "The definitive guide to SQLite", but didn't find if it's possible to format the output from the SUM() function: SELECT SUM(invoice_amount) AS Amount FROM invoice"; => With invoice_amount defined as TEXT, I'd like this number to be formatted as "100.000,00',

Re: [sqlite] [3.5.4] Why doesn't filesize change?

On Wed, 12 Mar 2008 03:32:06 -0700, "Cory Nelson" <[EMAIL PROTECTED]> wrote: >SQLite allocates space in pages. If an insert doesn't require >allocating a new page, the file size won't grow. Good to know. Thanks. ___ sqlite-users mailing list sqlite-use

[sqlite] [3.5.4] Why doesn't filesize change?

Hello Out of curiosity, is it normal that the size of an SQLite file doesn't change even when adding stuff to it, as reported by "ls" in Linux? Does SQLite use some kind of clusters, ie. pre-reserved space, which would explain this? Thank you. ___ sql

[sqlite] [TSV) mode vs. separator?

Hello I'd like to save the output of SELECT into a tab-delimited text file, and noticed that there are two commands that seem to do the same thing: sqlite> .mode tabs sqlite> .separator \t sqlite> .output myfile.tsv sqlite> select * from mytable; sqlite> .exit What's the difference betwe

Re: [sqlite] Newbie question re using SQLite in basic client/server situation

On Fri, 7 Mar 2008 21:06:21 +1100 (EST), Jeff Brown <[EMAIL PROTECTED]> wrote: >"so, the file locking logic of many network >filesystems implementation contains bugs (on both Unix >and windows). If file locking does not work like it >should, it might be possible for two or more client >programs to

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Wed, 05 Mar 2008 09:44:21 +0100, Marco Wobben <[EMAIL PROTECTED]> wrote: >A brief history: Thanks much for the information. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 14:33:06 -0800 (PST), Rael Bauer <[EMAIL PROTECTED]> wrote: > This type of question may better be answered on borland forums. I doubt it. Few Delphi developpers seem to work with SQLite :-/ > Maybe this will work. all events point to this published method: Thanks for the cod

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 23:07:15 -0600, "Fred Williams" <[EMAIL PROTECTED]> wrote: >You might want to test a little further with Aducom's stuff. I'm using >Aducom and have the following working code in at least one app: > >begin > AList.Fields.FieldByName(FldName[j+1]).Value := >Trim(E

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 13:43:46 -0800 (PST), Rael Bauer <[EMAIL PROTECTED]> wrote: > 3. Add code in this event like the following: >Text := qryContacts.FieldByName('MyField').AsString; Thanks for the tip, but Aducom's Table component doesn't have a FieldByName property. procedure TForm1.ASQLite3

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 14:09:51 -0500, John Elrick <[EMAIL PROTECTED]> wrote: >You can't. You lose the db aware aspect, but what I'm saying is it >isn't as "bad" as I used to think. OK, I don't mind not using DB-aware widgets if you say it's not much more work. So how do you 1) access an SQLite da

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 11:39:40 -0600, "P Kishor" <[EMAIL PROTECTED]> wrote: >I think you really need to read I did. The problem is not SQLite, it's the connector (Delphi, in this case). If I knew how and I could still use DB-aware grids, I would gladly get rid o

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 12:43:30 -0500, John Elrick <[EMAIL PROTECTED]> wrote: >The component. We used Aducom for a while and found that TEXT is >internally converted to a TMemo field. If you examine the source, you >can see the conversions. OK, so Aducom is out. I'll give DISQLite a deeper look,

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 11:03:44 -0600, "P Kishor" <[EMAIL PROTECTED]> wrote: >I think that was the point of my saying, "Anything using SQLite is >free to do what it wants." I routinely write Perl code that checks >what I am inserting into SQLite and croaks if something is not as I >expected. So, even

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 09:27:14 -0500, John Elrick <[EMAIL PROTECTED]> wrote: >FYI, we rolled our own adapters for a Delphi project. We had no use for >the TDataset capabilities and removed the overhead. I would be happy to >share them if they would help. I haven't found a good guide/tutorial on

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 09:00:31 -0500, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >There's no difference as far as SQLite is concerned. Length >specification, if present, is parsed but not enforced. Yes, that's what I read too, but obviously, like Apple, some component in Delphi think different :-)

Re: [sqlite] [newbie] SQLite and VB.Net?

On Mon, 3 Mar 2008 11:48:00 -0500, "Samuel Neff" <[EMAIL PROTECTED]> wrote: >The performance impact of using ADO.NET vs direct is miniscule and greatly >outweighed by the improved efficiency in development. Good news. Thanks much for the input. ___ sqli

[sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

Hello I thought that SQLite treated any numeric data the same, but some Delphi components seem to handle TEXT data as BLOB/MEMO, and handle VARCHAR as regular text: http://img404.imageshack.us/img404/8614/nextdbgridparentzt9.jpg http://img246.imageshack.us/img246/6615/delphismdbgrid1hw8.j

Re: [sqlite] Checking that a row exists?

On Thu, 21 Feb 2008 11:40:45 -0700, Dennis Cote <[EMAIL PROTECTED]> wrote: >select exists (SELECT * FROM sqlite_master WHERE type='table' AND >lower(name)=?) > >This will always return one row with one column with a value that is >either 0 or 1. Thanks guys for the help. ___

Re: [sqlite] [newbie] SQLite and VB.Net?

On Sun, 2 Mar 2008 21:07:03 -0500, "Samuel Neff" <[EMAIL PROTECTED]> wrote: > I would go the ADO.NET route 'cause it'll fit into your .NET application much >better. The overhead is minimal compared to the normal cost of running >database queries (in any database). The reason I'm concerned about u

Re: [sqlite] [newbie] SQLite and VB.Net?

On Sun, 2 Mar 2008 08:13:18 -0800 (PST), Jalil Vaidya <[EMAIL PROTECTED]> wrote: >There are ADO.NET providers available for SQLite. Thanks guys for the input. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/l

[sqlite] [newbie] SQLite and VB.Net?

Hello I don't know anything about .Net, and I'd like to build a quick app with Visual Studio 2005 or 2008 to check how well it performs with SQLite. If performance and deployment prove to be good enough, we'll use VB.Net for new projects and finally dump VB6. AFAIK, the default option is

Re: [sqlite] Alternative to * to SELECT most columns?

On Sat, 01 Mar 2008 18:50:56 +0100, Gilles Ganault <[EMAIL PROTECTED]> wrote: >This doesn't work as intended, because it returns all the rows, >effectively ignoring the WHERE part: Thanks everyone for the help. Problem solved: $dbh = new PDO("sqlite:test.sqlite"

Re: [sqlite] Alternative to * to SELECT most columns?

On Sat, 1 Mar 2008 18:23:43 -0500, "Stephen Oberholtzer" <[EMAIL PROTECTED]> wrote: >I have to ask: Why is it that you expected a condition applying to one >column on one table, to also apply to a differently named column in a >differently named table? Because I'm not clear about how joins work :-

Re: [sqlite] Alternative to * to SELECT most columns?

On Sat, 1 Mar 2008 18:04:12 -0500, "Stephen Oberholtzer" <[EMAIL PROTECTED]> wrote: >> INSERT INTO Table2 VALUES (NULL,"Some text in Table2"); >> INSERT INTO Table2 VALUES (NULL,"Some other text in Table2"); >> = >> INSERT INTO Table1 VALUES (NULL,"John Doe",1); >> INSERT INTO Table1 VALUE

Re: [sqlite] Alternative to * to SELECT most columns?

On Sat, 1 Mar 2008 15:35:01 -0500, "P Kishor" <[EMAIL PROTECTED]> wrote: >SELECT table1.*, table2.col1 >FROM table1 JOIN table2 ON table1.field10 = table2.field1 Thanks for the tip, but... 1. I want to SELECT all the columns from Table1 and one column from Table2, but only rows WHERE table1.field

Re: [sqlite] Alternative to * to SELECT most columns?

On Sat, 1 Mar 2008 15:27:19 -0500, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >What do you mean, all the rows? Are you saying the resultset contains >some rows where table1_field10 is not equal to table2_field1? With all >due respect, I find it very hard to believe. That's what happens, though.

[sqlite] Alternative to * to SELECT most columns?

Hello I have two tables: Table1 has about 10 columns, Table2 has 2. I need to get all the columns of Table1 and only one column in Table2 where some field in Table1 is equal to field1 in Table2. This doesn't work as intended, because it returns all the rows, effectively ignoring the WHERE

[sqlite] Good tutorial/book on SQLite in French?

Hi I'm looking for a tutorial in French for my... 70-year-old father, who's also not quite at ease with relational databases and SQL. SQLite did the trick to get him to stop using flat-files with home made performance improvements, and move on to SQL. The few books on SQLite haven't been translat

Re: [sqlite] How long time to index this table

On Mon, 25 Feb 2008 13:34:04 +0100 (CET), Lars Aronsson <[EMAIL PROTECTED]> wrote: >You might say that it's my fault if I specify an insufficient >cache_size, but I think that (1) I shouldn't really need to >specify this in a "zero configuration" database engine, and (2) >the behaviour is except

[sqlite] Checking that a row exists?

Hello Is this the standard way to check that a row exists in PHP/SQLite, or is there a better syntax? $query = "SELECT count(*) FROM contacts WHERE contacts_phones_tel GLOB '%s*'; $query = sprintf($query,$row['calls_phones_tel']); $query = $dbh->query($sql)->fetch(); if(!$query[0]) {

Re: [sqlite] Outer join between two tables?

On Mon, 18 Feb 2008 15:03:27 -0500, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >where phones_contact_tel not in (select tel from contacts) Thanks, it worked: SELECT * FROM phones WHERE phones_tel NOT IN (SELECT contacts_phones_tel FROM contacts); Out of curiosity, isn't the standard solution to

Re: [sqlite] PRIMARY KEY? Date and time datatypes?

On Mon, 18 Feb 2008 12:32:55 +, [EMAIL PROTECTED] wrote: >The AUTOINCREMENT keyword prevents an primary key from being >reused even after it is deleted. Thanks for the clarification. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

Re: [sqlite] PRIMARY KEY? Date and time datatypes?

On Mon, 18 Feb 2008 23:31:32 +1100, BareFeet <[EMAIL PROTECTED]> wrote: >I can create a view to display the date in my localtime: Thanks much for the example. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/l

[sqlite] Outer join between two tables?

Hello I have two tables: - Phones, which has two columns: Tel and Name. A customer may have more than one number - Contacts, which has the expected colums (address, e-mail, etc.), and, since phone numbers are unique, uses the main (or only) number in Phones as primary key. IOW, to find a contac

Re: [sqlite] PRIMARY KEY? Date and time datatypes?

On Sat, 16 Feb 2008 11:29:29 +1100, BareFeet <[EMAIL PROTECTED]> wrote: > If you designate an integer column as also being the primary key, > then SQLite will auto assign its value incrementally each time > you insert a new row, unless you assign a value explicitly. In this case, why do we need

[sqlite] PRIMARY KEY? Date and time datatypes?

Hello I have a couple of questions on using SQLite3: 1. what happens if I leave out "PRIMARY KEY" and just use INTEGER? 2. I prefer to use text to save dates and times because they're easier to handle between SQLite and PHP than Julian, but does SQLite handle text dates/times OK, or should I exp

Re: [sqlite] [Linux/Python 2.4.2] Forking Python doesn't work

On Wed, 13 Feb 2008 13:42:20 +0100, Gilles Ganault <[EMAIL PROTECTED]> wrote: (snip) Oops, wrong forum at Gmane :-) Sorry for the wrong posting. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/li

[sqlite] [Linux/Python 2.4.2] Forking Python doesn't work

Hello When a call comes in, I'd like to fork a Python script that broadcasts a message so that users see the CID name + number pop up on their computer screen, and simultaneously ring their phones. The following script doesn't work as planned: It waits until the script ends before moving

[sqlite] Re: [Linux + PHP] Recommended way to access SQLite?

On Mon, 10 Dec 2007 16:35:48 +0100, Kees Nuyt <[EMAIL PROTECTED]> wrote: >So I activated php_pdo_sqlite_external instead and copied >sqlite3.dll v3.5.3 to %serverroot%/bin . Thanks for the infos. So the options are: 1. use the old SQLite2 sqlite_() functions (or some class that turns this into

Re: [sqlite] [Linux + PHP] Recommended way to access SQLite?

At 23:34 09/12/2007 +0100, DJ Anubis wrote: I would recommend using PDO interface, as this is the standard PHP5 API. Don't worry about PHP4, as this old version will no more be supported soon... Thanks for the tip. -

[sqlite] [Linux + PHP] Recommended way to access SQLite?

Hello I'm not a PHP expert, and need to work with SQLite from PHP scripts on a CentOS 5.1 server (from the command line, and web apps in FastCGI). It seems like I have two options: - calling the SQLite library - going through the PDO interface, and its SQLite module. Which of the two would yo

RE: [sqlite] [Visual Basic] How do you work with SQLite?

At 23:25 09/08/2007 +0100, RB Smissaert wrote: One, via an ADO recordset after connecting to Interbase with ODBC. [...] Two, via a custom Delphi dll that moves data directly from Interbase to SQLite. This is maybe slightly faster than the first method, but not that much difference. So, no ODBC

[sqlite] [Visual Basic] How do you work with SQLite?

Hello I was wondering: how do you VB developpers work with SQLite? Currently, I use a variant array that I fill with data from SQLite, and use ComponentOne's grid object to display the data through its LoadArray() method; If/once the data is updated by the user, I write the array back to SQLi

Re: [sqlite] sqlite as server queries

At 14:08 06/08/2007 +0100, "Edwin Eyan Moragas" wrote: 2) anybody ever implemented something like a single process of sqlite doing queries for a lot of networked clients? Am working on this, in Classic VB5: Winsock control on the server, Inet control on the client, the client thinks it's talki

Re: [sqlite] Re: [2.8.x] Incrementing a column automatically with INSERT/UPDATE?

At 02:21 06/08/2007 +0200, you wrote: I'm sorry to bother you again, but I can't figure out how to write a trigger that will set a column to 1 when a user creates a new record :-/ Found it in "Sam's Sqlite (2004)": CREATE TRIGGER insert_mytable_timestamp AFTER INSERT ON mytable BEGIN U

Re: [sqlite] Re: [2.8.x] Incrementing a column automatically with INSERT/UPDATE?

Hello At 15:28 04/08/2007 -0400, you wrote: UPDATE mytable SET timestamp = old.timestamp + 1 WHERE rowid=new.rowid; I'm sorry to bother you again, but I can't figure out how to write a trigger that will set a column to 1 when a user creates a new record :-/ I tried the following but neither

Re: [sqlite] Re: [2.8.x] Incrementing a column automatically with INSERT/UPDATE?

At 15:28 04/08/2007 -0400, Igor Tandetnik wrote: UPDATE mytable SET timestamp = old.timestamp + 1 WHERE rowid=new.rowid; Great :-) Thanks a lot. For those interested in doing the same thing: = create table mytable (id INTEGER AUTO PRIMARY KEY, name VARCHAR(50), timestamp INTEGER);

Re: [sqlite] [2.8.x] Incrementing a column automatically with INSERT/UPDATE?

At 13:05 04/08/2007 +, [EMAIL PROTECTED] wrote: 2.8.x support triggers. Good to know :-) So I don't have to upgrade everyone to 3.x then. I did try to create a self-incrementing timestamp column with 2.8.x but it doesn't seem to be handle more than one such column: C:\sqli

[sqlite] [2.8.x] Incrementing a column automatically with INSERT/UPDATE?

Hello I was wondering if SQLite 2.8.x was able to update a column automatically when performing either INSERT or UPDATE, or if this can only be done with triggers in 3.x? For instance, when adding a record, I need to have a counter in the third column be incremented by one: insert

RE: [sqlite] [VC++ 6] Error compiling VBified source

At 11:23 03/08/2007 -0700, Robert Simpson wrote: Download the System.Data.SQLite.DLL I maintain from http://sqlite.phxsoftware.com Thanks, I'll check it out :-) G. - To unsubscribe, send email to [EMAIL PROTECTED] --

Re: [sqlite] [VC++ 6] Error compiling VBified source

At 09:53 03/08/2007 -0700, Joe Wilson wrote: This has come up before on the list. The instructions are wrong: Sorry, should have thought someone had already tried.. and failed :-/ Browsing through the archives, it looks like the code might not be 100% reliable, so I'll probably look for anoth

[sqlite] [VC++ 6] Error compiling VBified source

Hello As I'd like to be able to build my own SQLite DLL for use with Visual Basic Classic, I followed Todd Tanner's instructions at www.tannertech.net/sqlite3vb/ to make the (few) required changes and compile with Visual C++ 6.0. As a test, after just making those changes in the amalgamated

Re: [sqlite] Re: [3.3.13] UPDATE OR ROLLBACK?

At 23:20 30/07/2007 -0400, Igor Tandetnik wrote: http://sqlite.org/capi3ref.html#sqlite3_changes Makes sense. Thanks! - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] [3.3.13] UPDATE OR ROLLBACK?

Hello I'd like to use a timestamp column in each table to keep track of when a column was last updated, so that a user can be notified of a problem when trying to updated a record that has already been updated by another user while the first user was still working on the original data. In w

[sqlite] [2.8.13] Implementing concurrency through timestamp

Hello I need to implement concurrency in an app that was written with 2.8.13. If possible, I'd like to avoid upgrading to 3.x. As an easy way to handle concurrency, someone mentionned the following idea: In each table, add a column which will contain a monotonically increasing counter so tha

Re: [sqlite] Re: How to know which rows are affected by UPDATE/DELETE?

At 14:06 29/07/2007 -0400, you wrote: select rowid from suppliers where name='IBM'; Simple enough :-) Thanks. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] How to know which rows are affected by UPDATE/DELETE?

Hello To write a front-end server to SQLite. To avoid locking the whole database, I'd like to implement optimistic locking, but for this to work, I need to use a timestamp and know which tables + records are affected when a user sends a query that changes the database (UPDATE, DELETE). I gue

[sqlite] Compiling for Classic VB?

Hello I read the following pages to compile the SQLite C source into a VisualBasic-friendly DLL (ideally, VisualBasic 5 instead of 6): http://www.tannertech.net/sqlite3vb/ http://www.persistentrealities.com/index.php?p=18 but I don't have MS' VisualStudio compiler. 1. Is it possible to use a

[sqlite] [Delphi] Escaping quote?

Hello I'm having a problem saving strings into a colum from a Delphi application because they might contain the ( ' ) single quote character: = // Input := 'Let's meet at the pub tonight!'; MyFormat := 'insert into stuff (title) values ('''%s')'; SQL := Format(MyFormat, Input); try

[sqlite] Converting from 2.8.x to 3.x?

Hello As we move from a 2.8.x file-based solution to a 3.x c/s solution, we'll have to convert databases from one format to the other. What's the easiest way to do this? Thank you G. - To unsubscribe, send email to

Re: [sqlite] Recommend server for Windows?

At 20:47 19/06/2007 -0500, John Stanton wrote: Such a server can be made simpler then mine by making it single threaded. Is it publicly available from http://www.viacognis.com? Thanks G. - To unsubscribe, send email

RE: [sqlite] Recommend server for Windows?

At 16:49 19/06/2007 -0700, Medi Montaseri wrote: While its difficult to tell what the problem statement (or context) is, but the ingrediants like HTTP and POST spells SOAP. The context is that, until now, our apps were almost used on stand-alone hosts with only a few customers hosting the (sma

Re: [sqlite] Recommend server for Windows?

At 11:20 19/06/2007 -0400, Clay Dowling wrote: I'm going to recommend PostgreSQL. Thanks for the idea, but if possible, we'd rather something really basic, typically a single EXE. Besides, using eg. PostgreSQL would require rewriting our application. I went through the list of servers on t

[sqlite] Recommend server for Windows?

Hello Until now, our users were mostly single-hosts, and the few who did share an SQLite database through a shared drive had a small database and very low concurrency. But a couple of new ones have a DB that's about 50MB, running on a 10Mbps LAN... and an INSERT takes about 10 seconds :-/ S

[sqlite] [Wiki] How to register, and actually add a page?

Hello I'd like to contribute to the wiki, but I didn't find... 1. How to register: There's no Register link in the Login page 2. How to actually add a page once I added a Camel-formatted word in a page. Thank you Gilles. -

Re: [sqlite] Recommended wrapper for Python?

At 21:14 23/04/2007 +0100, Martin Jenkins wrote: pysqlite implements Python's DBAPI and was integrated into Python. There is another wrapper, APSW, which is thinner and closer to SQLite's C API. Choose whichever you feel most comfortable with. If you choose pysqlite be aware that it will start

Re: [sqlite] Recommended wrapper for Python?

At 14:40 23/04/2007 +0200, Stef Mientki wrote: I've no experience whatsover, but if I see the list, the top one is the best choice, because it'll be integrated in the standard Python. Thanks. I didn't know SQLite was part of Python 2.5.

[sqlite] Recommended wrapper for Python?

Hello I browsed through the archives at Gname, but most threads regarding wrappers for Python date back to 2005. There are several wrappers listed in the wiki (http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers), so I'd like some feedback about which you would recommend to use SQLite from P

<    1   2   3