Re: [sqlite] What is sqlite3_stmt_readonly for?

On Thursday, December 09, 2010 4:25 AM, Roger Binns wrote: > You are indeed correct. It was added and is called by Fossil after using > an > authorizer. I did (twice) raise these issues with the team before release > with no response. It looks like our calls did not go unheeded: it seems now

Re: [sqlite] enums

2010/12/8 Dagdamor > john darnell писал(а) в своём письме Wed, 08 > Dec 2010 02:23:53 +0600: > > > I cannot find a reference to "enum" in any SQLite documentation. Hmm. > > I suppose I could write a quick little function and use it as the > >

Re: [sqlite] What is sqlite3_stmt_readonly for?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/07/2010 11:57 PM, Andy Gibbs wrote: > But what I wonder is, for what purpose it can be used? On the face of it, > it seems very useful, but then as you read through the description you find > a whole load of statement types that return an

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Wed, Dec 8, 2010 at 2:44 PM, Richard Hipp wrote: > On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille > wrote: > >> Hello, >> >> The pragma foreign_key_list appears to be deprecated in 3.7.4: >> >>

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On 8 Dec 2010, at 8:03pm, Bogdan Ureche wrote: > Now that foreign key constraints are enforced natively, why would you want > >> to have a list of them? Why should the foreign_key_list pragma continue to >> consume code space and developer maintenance time? > > It would make life easier for

Re: [sqlite] SQLite-3.7.4 Amalgamation?

On Wed, 8 Dec 2010 06:35:06 -0500, Richard Hipp wrote: >The version is still 3.7.4. It is merely encoded as 3070400 in the >filename, since names like 3070400, 3070403, 3070420, 3070500, 3071200 >sort into correct order when you do "ls", but the corresponding real >version

Re: [sqlite] Selecting a group of entries based on RowID.

On Tue, 7 Dec 2010 10:44:31 -0800, Kirk Clemons wrote: >I would like to select each row in order from a table without getting the >table information as well. >This way I can insert them into another database with the same tables. >How would I do this? $ sqlite3

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On 8 December 2010 20:44, Richard Hipp wrote: > On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille > wrote: > >> Hello, >> >> The pragma foreign_key_list appears to be deprecated in 3.7.4: >> >> http://www.sqlite.org/pragma.html#pragma_foreign_key_list >>

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

That is very bad news ... My application uses this information e.g. to automatically populate comboboxes (FKs) etc. Am 08.12.2010 20:35, schrieb Petite Abeille: > Hello, > > The pragma foreign_key_list appears to be deprecated in 3.7.4: > >

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Dec 8, 2010, at 8:44 PM, Richard Hipp wrote: > Now that foreign key constraints are enforced natively, why would you want > to have a list of them? To know what they are. In the same way as there are pragma that list database, table, column, index, etc... To paraphrase: "Now that tables

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

Now that foreign key constraints are enforced natively, why would you want > to have a list of them? Why should the foreign_key_list pragma continue to > consume code space and developer maintenance time? > > > It would make life easier for developers of administration tools for SQLite, for

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Dec 8, 2010, at 2:44 PM, Richard Hipp wrote: > On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille >wrote: > >> Hello, >> >> The pragma foreign_key_list appears to be deprecated in 3.7.4: >> >> http://www.sqlite.org/pragma.html#pragma_foreign_key_list >> >> Any reason

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille wrote: > Hello, > > The pragma foreign_key_list appears to be deprecated in 3.7.4: > > http://www.sqlite.org/pragma.html#pragma_foreign_key_list > > Any reason for such deprecation? > Now that foreign key constraints are

[sqlite] pragma foreign_key_list deprecated in 3.7.4?

Hello, The pragma foreign_key_list appears to be deprecated in 3.7.4: http://www.sqlite.org/pragma.html#pragma_foreign_key_list Any reason for such deprecation? What's the alternative to that pragma to achieve the same effect? Thanks in advance.

Re: [sqlite] enums

john darnell писал(а) в своём письме Wed, 08 Dec 2010 02:23:53 +0600: > I cannot find a reference to "enum" in any SQLite documentation. Hmm. > I suppose I could write a quick little function and use it as the > Default... Hmm, there is a useful function

Re: [sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

I just tried it on my Mac and this new build works pretty well. Thanks a lot for your assistance. -- Marco Bambini http://www.sqlabs.com On Dec 8, 2010, at 1:54 AM, Richard Hipp wrote: > In Tue, Dec 7, 2010 at 7:15 PM, Richard Hipp wrote: >> On Tue, Dec 7, 2010 at 6:22 PM,

Re: [sqlite] Runtime memory growth concerns

Hi all, After a day of debugging and code changes I realised that SQLite rocks, it was some of my C code not getting cleaned up (basically structures returned from the Queue where not FREE'd properly). C coding is not my day job ...;-) So lesson learnt: Do not blame SQLite for dodgy C code that

[sqlite] How to optimize this simple select query ?

Hello, on the table : CREATE TABLE HASH( ID INTEGER PRIMARY KEY ASC, x1_y1 INTEGER, x1_y2 INTEGER, x1_y3 INTEGER, x1_y4 INTEGER, x1_y5 INTEGER, x2_y1 INTEGER, x2_y2 INTEGER, x2_y3 INTEGER, x2_y4 INTEGER, x2_y5 INTEGER, x3_y1 INTEGER, x3_y2 INTEGER, x3_y3

Re: [sqlite] FTS3 bug?

Dan Kennedy wrote: > On 12/08/2010 04:18 AM, Iker Arizmendi wrote: >> The function that opens a cursor for the simple tokenizer, >> simpleOpen, does not set the "pTokenizer" member of the >> returned cursor. Ie, it appears the following line is >> missing: >> >> c->base.pTokenizer =

Re: [sqlite] SQLite in WinCE Emulator - Disk I/O Err or and change of pragma don´t work

Thank you Shane Thanks also to Jay A. Kreibich and Simon Slavin Happy new year Horacio Pereira -Mensagem Original- From: Shane Harrelson Sent: Wednesday, December 08, 2010 11:32 AM To: General Discussion of SQLite Database Subject: Re: [sqlite]SQLite in WinCE Emulator - Disk I/O Error

Re: [sqlite] SQLite in WinCE Emulator - Disk I/O Error and change of pragma don´t work

According to the MSDN support sites, there are a couple of known issues with the Windows Mobile Emulator, when using emulated storage cards. With an emulated storage card, SetEndOfFile() (which we use for truncating a file) and FlushFileBuffers() (which we use for syncing) will fail. They do not

Re: [sqlite] Runtime memory growth concerns

Hi there, I am playing with the PRAGMA cache_size and it seems to help lots. I will keep you posted ;-) Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Lynton Grice Sent: 07 December 2010 10:31 PM To:

Re: [sqlite] SQLite-3.7.4 Amalgamation?

On Tue, Dec 7, 2010 at 9:23 PM, Ladislav Bodnar wrote: > On Wednesday 08 December 2010, Richard Hipp wrote: >> I changed to a more consistent naming scheme for all of the build >> products: >> >>      sqlite-PRODUCT-OS-ARCH-VERSION.zip >> >> with the OS and ARCH being

Re: [sqlite] occasional SQLITE_PROTOCOL on synchronous=normal with WAL

On Tue, Dec 7, 2010 at 6:51 PM, Richard Hipp wrote: > You have to have multiple processes really hammering away at the > database in order to get this to happen, which is apparently what you > are doing, huh.  And we've only seen this on variations of unix, not > on windows.  

Re: [sqlite] SQLite-3.7.4 Amalgamation?

On Wednesday 08 December 2010, Richard Hipp wrote: > I changed to a more consistent naming scheme for all of the build > products: > > sqlite-PRODUCT-OS-ARCH-VERSION.zip > > with the OS and ARCH being omitted for source-code products. In your > case, you probably are looking for > >

Re: [sqlite] Runtime memory growth concerns

Interesting, seems that for my queue implementation using SQLite in WAL mode if I keep a "global" connection handle open while the client is using the queue then the memory grows quickly..but if I open and close the handle on each SEND, RECEIVE etc then all is fine... Does this sound right?

Re: [sqlite] Runtime memory growth concerns

Hi there, Regarding the message I sent earlier...Just a quick update from my side, it seems when I run the following sqlite3_step(stmt); The memory grows and does not get released in my specific case even though I set sqlite3_finalize(stmt); after it. The moment I comment

[sqlite] SQLite in WinCE Emulator - Disk I/O Er ror and change of pragma don´t work

Hi, all I'm using SQLite version 3.7.2 ported to Windows CE, in a application developed using Lazarus I got the compiled SQLITE3.DLL for Windows CE in the site www.parmaja.com For now, I am using one emulator to run the native Windows CE application in a desktop computer running Windows

[sqlite] Selecting a group of entries based on RowID.

I would like to select each row in order from a table without getting the table information as well. This way I can insert them into another database with the same tables. How would I do this? Thank you, Kirk. ___ sqlite-users mailing list

[sqlite] Runtime memory growth concerns

Hi there, I am a huge SQLite fan and am very curious as to why the following would happen. Essentially I have a "queue implementation" using SQLIte in WAL mode and it is working really well. However, at runtime if I watch the Task Manager in windows as thousands of messages are sent to

Re: [sqlite] WAL file size

On Tue, Dec 7, 2010 at 9:49 AM, Yoni Londner wrote: > Hi, > > Yes, in this scheme the checksum is based on salt values and own frame > content.a > > Note that the current design solve a potential DB corruption bug in > sqlite. current WAL design is base on the fact that once

[sqlite] tarball and directory name

Hi, Just noticed that the format of the version in the tarball name changed, as in "sqlite-autoconf-3070400.tar.gz". However, this unpacks to a directory called "sqlite-3.7.4". This makes it difficult for automated build systems that want to have a predictable directory name. Would it be