[sqlite] Help for a newbie

Hello all, I have been attempting to figure out how to build the sqlite2 plugin for QT4. I need to use V2 as I am working with files written by another program. Here is a synopsis of where I am at: I am a relitive newbie to QT et al (but not programming in general). I managed to

RE: [sqlite] Fix for sqlite3.h in version 3.3.10

--- James Dennett <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Joe Wilson [mailto:[EMAIL PROTECTED] > > Subject: Re: [sqlite] Fix for sqlite3.h in version 3.3.10 > [snip] > > > > I don't know if this is the right place to post suggestions to the > > > SQLite developers,

Re: [sqlite] SQLite last inserted id

My issue with that is I need the rowid of the existing row back. Insert or ignore doesn't seem to update the database's last_insert_rowid in the ignore case, from what I've seen. Insert or Replace almost does it, but it re-allocates the rowid, which breaks my referential integrity. Should the

Re: [sqlite] SQLite last inserted id

If you'd have a unique index on that column then you could just use "INSERT OR IGNORE ..." Nico -- - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] SQLite last inserted id

I would like to solicit ideas on this as well. An operation similar to insert or replace, but that doesn't allocate a new row ID on replace (just returns the old one through the last insert row ID.) Having to do the search operation, and if it fails do an insert (or vice versa) doesn't seem

RE: [sqlite] SQLite last inserted id

Can you use the API call sqlite3_last_insert_rowid ? -Original Message- From: Weston Weems [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 3:58 PM To: sqlite-users@sqlite.org Subject: [sqlite] SQLite last inserted id What I'd ultimately like to do, and what I used to do with a

Re: [sqlite] Pager Question... Open Source Project

On Mon, Jan 22, 2007 at 06:06:53PM -0600, John Stanton wrote: > Alternately use a 64 bit machine and a 64 bit OS. Did you not read what I wrote? That was one of the solutions I offered. The issue is that memory mapping runs into the 32-bit VM space wall and you have three options: too bad, go

[sqlite] Sqlite3.3.11 - No differences except for sqlite3.h and os_win.c

I got sqlite-source-3.3.11.zip from sqlite.org/download.html and found this issue. Seems incomplete to me going by http://sqlite.org/changes.html Thanks, - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] SQLite last inserted id

What I'd ultimately like to do, and what I used to do with a sproc, is the following Pass a string to a sproc, it'll select from table where field = string value, and if no records insert it and grab last inserted id. That way with one call, I can ensure one string in db, and always get the an

Re: [sqlite] Pager Question... Open Source Project

On Mon, Jan 22, 2007 at 05:13:44PM -0600, John Stanton wrote: > >Of course. The point is that 32-bit memory models will impact the > >design of the this pager. Either only support 64-bit memory models, > >window your memory mappings, or only support small databases. > > > Or be adaptive and

Re: [sqlite] Pager Question... Open Source Project

Nicolas Williams wrote: On Mon, Jan 22, 2007 at 03:05:12PM -0600, John Stanton wrote: Certainly, but the requirement here is for an in-memory fs, as I read the email. Of course. The point is that 32-bit memory models will impact the design of the this pager. Either only support 64-bit

Re: [sqlite] Pager Question... Open Source Project

On Mon, Jan 22, 2007 at 09:59:56AM -0600, John Stanton wrote: > A neat way to implement a pager is to memory map a file to make it > shared virtual memory. Then you need some form of mutex to synchronize > access to it. If you are sharing it between processes or threads you > need a lock flag

Re: [sqlite] sqlite3 lib do not open old sqlite databases

thanks man 2007/1/22, Trey Mack <[EMAIL PROTECTED]>: From http://www.sqlite.org/formatchng.html "Version 3.0.0 is a major upgrade for SQLite that incorporates support for UTF-16, BLOBs, and a more compact encoding that results in database files that are typically 25% to 50% smaller. The new

Re: [sqlite] sqlite3 lib do not open old sqlite databases

From http://www.sqlite.org/formatchng.html "Version 3.0.0 is a major upgrade for SQLite that incorporates support for UTF-16, BLOBs, and a more compact encoding that results in database files that are typically 25% to 50% smaller. The new file format is very different and is completely

[sqlite] php sqlite compliance

Can you please tell me what version of sqlite is supported by php5? Thanks in advance

[sqlite] sqlite3 lib do not open old sqlite databases

Hello everybody I'm moving from sqlite 2.8.17 to sqlite3.3.11 but when i'm trying to open my databases created with sqlite 2.8.X i have this error message: file is encrypted or is not a database Is that normal or did i have a mistake somewhere? Thank you for your help in advance

Re: [sqlite] Pager Question... Open Source Project

A neat way to implement a pager is to memory map a file to make it shared virtual memory. Then you need some form of mutex to synchronize access to it. If you are sharing it between processes or threads you need a lock flag on each page. If you make your shared area a named file rather than

Re: [sqlite] One DB fed from many DBs

- Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Monday, January 22, 2007 10:19 AM Subject: Re: [sqlite] One DB fed from many DBs jose isaias cabrera wrote: can unique id numbers have numbers missing? Jose, Yes, of course. The

[sqlite] Need for new pragma directives

Hi! My project (Libgda/Libgnomedb) needs to be able to get more information about a database structure, and I've made a patch which defines 3 new pragma directives: * "table_info_long()" which adds a column to the "table_info" pragma to tell if a column is auto incremented (see ticket #1464) *