[sqlite] What is sqlite3_stmt_readonly for?

Hi, I notice a new API function in sqlite 3.7.4, namely sqlite3_stmt_readonly. 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 "undefined"

Re: [sqlite] Concern over runtime memory growth?

Hi Max, I'm testing on 2 systems, on Solaris 10 and Windows XP. I am using SQLIte version sqlite 3_6_23 Any ideas? Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Max Vlasov Sent: 08 December 2010 08:07 AM To:

Re: [sqlite] Concern over runtime memory growth?

Hi, Actually I am in the problem. I have some SQLite used in main application and 1500-2000 lines of code in SQLite Extension, which is pretty much one big trigger. I free all the memory I allocate, I destroy all prepared statements, but I still leaking very badly. My application does not

Re: [sqlite] Concern over runtime memory growth?

On 8 Dec 2010, at 5:58am, Lynton Grice wrote: > But memory just grows and grows with this call. > > I have tried to open the queue and close the queue after each call and that > seems to help, but surely that is not the answer? Try it without these: PRAGMA journal_mode=wal PRAGMA

Re: [sqlite] Concern over runtime memory growth?

On Wed, Dec 8, 2010 at 8:58 AM, Lynton Grice wrote: > Hi there, > > > I have implemented a queue using SQLIte in WAL mode and it seems to be > working well.. > > > Now that I am testing and send thousands of messages to the queue I am > watching the memory growth

[sqlite] Concern over runtime memory growth?

Hi there, I have implemented a queue using SQLIte in WAL mode and it seems to be working well.. Now that I am testing and send thousands of messages to the queue I am watching the memory growth of the application grow and grow. I have make a "queue shared lib / dll" and have seen

Re: [sqlite] Problem with disableTerm() and virtual tables

> > When I attempt to perform a certain join (shown below), the disableTerm > function fails in the ALWAYS assertion, because the wtFlags field already has > the TERM_CODED bit set. As far as I can tell, it is looking at the first > constraint in the ON clause of the LEFT JOIN, possibly for

Re: [sqlite] SQLite-3.7.4 Amalgamation?

Roger Binns wrote: > On 12/07/2010 08:45 PM, Darren Duncan wrote: >> I am also working with automated scripts, which now have to be updated to >> use >> either the new style or old style depending on the user-requested SQLite >> version. (DBD::SQLite bundles a SQLite version, and includes a

Re: [sqlite] SQLite-3.7.4 Amalgamation?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/07/2010 08:45 PM, Darren Duncan wrote: > I am also working with automated scripts, which now have to be updated to use > either the new style or old style depending on the user-requested SQLite > version. (DBD::SQLite bundles a SQLite

Re: [sqlite] SQLite-3.7.4 Amalgamation?

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] FTS3 bug?

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 = pTokenizer; > > which causes

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] SQLite-3.7.4 Amalgamation?

On Tue, 7 Dec 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 Richard, That's how

Re: [sqlite] SQLite-3.7.4 Amalgamation?

On Tue, Dec 7, 2010 at 8:17 PM, Rich Shepard wrote: >   What happened to the souce tarball of the amalgamation? I'm wondering if > the change to the autoconf version will break the Slackbuild script I use. > >   Was there something wrong with the tarballs of previous

[sqlite] SQLite-3.7.4 Amalgamation?

What happened to the souce tarball of the amalgamation? I'm wondering if the change to the autoconf version will break the Slackbuild script I use. Was there something wrong with the tarballs of previous versions? Rich ___ sqlite-users mailing

Re: [sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

In Tue, Dec 7, 2010 at 7:15 PM, Richard Hipp wrote: > On Tue, Dec 7, 2010 at 6:22 PM, Marco Bambini wrote: >> Running sqlite3_analyzer on a MacOS X 10.6.5 results in the following issue: >> >> dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib >>  

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

On Tue, Dec 7, 2010 at 7:30 PM, Michael Barton wrote: > We've been testing switching our app to use WAL journaling mode. > We're using a snapshot of trunk from last week sometime. > > We have a sort of weird occasional problem where we get > SQLITE_PROTOCOL when setting

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

On Tue, Dec 7, 2010 at 7:30 PM, Michael Barton wrote: > We've been testing switching our app to use WAL journaling mode. > We're using a snapshot of trunk from last week sometime. > > We have a sort of weird occasional problem where we get > SQLITE_PROTOCOL when setting

[sqlite] occasional SQLITE_PROTOCOL on synchronous=normal with WAL

We've been testing switching our app to use WAL journaling mode. We're using a snapshot of trunk from last week sometime. We have a sort of weird occasional problem where we get SQLITE_PROTOCOL when setting "pragma synchronous=normal". Our app has a lot of concurrent connections to the database

Re: [sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

On 8 Dec 2010, at 12:15am, Richard Hipp wrote: > I don't know how to statically link the TCL libraries on a Mac. I > tried every combination of options I could think of and none of them > seem to work. > > I think you just have to install TCL on your Mac in order to use > sqlite3_analyzer

Re: [sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

On Tue, Dec 7, 2010 at 6:22 PM, Marco Bambini wrote: > Running sqlite3_analyzer on a MacOS X 10.6.5 results in the following issue: > > dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib >  Referenced from: /Users/marco/Desktop/sqlite3_analyzer >  Reason: image not found >

[sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

Running sqlite3_analyzer on a MacOS X 10.6.5 results in the following issue: dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib Referenced from: /Users/marco/Desktop/sqlite3_analyzer Reason: image not found Trace/BPT trap Seems like a broken binary to me. Any idea? -- Marco Bambini

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

On 7 Dec 2010, at 8:08pm, Horacio Rabelo Pereira wrote: > During the execution, the journal file for database is created, and after the > crash it is removed and the database file remains without any modifications. it is important that the journal file is /not/ removed by anything except

[sqlite] FTS3 bug?

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 = pTokenizer; which causes problems in simpleNext . Possible bug? Regards, Iker -- Iker

Re: [sqlite] enums

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Dagdamor > Sent: Tuesday, December 07, 2010 12:46 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] enums > > john darnell

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

On Tue, Dec 07, 2010 at 06:08:28PM -0200, Horacio Rabelo Pereira scratched on the wall: > Searching in the Web, I found a note describing a workaround, that > consist in change the pragma ???jornal_mode??? to value ???truncate???. > > For my surprise, all my tries to change the value of pragma

[sqlite] SQLite in WinCE Emulator - Disk I/O Error 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] Lemon behavior

I'm using Lemon for a non-sqlite related project and it is exiting with an assertion failure that I would like to understand. I have extracted the following small set of productions from a larger grammar. The "list" production happens to be the start symbol in the larger grammar. list::=

Re: [sqlite] enums

john darnell писал(а) в своём письме Wed, 08 Dec 2010 00:22:54 +0600: > I have no better reason than that I'm used to it in my dealings with > MySQL and C++. > > It could save developer time and disk space, however, if it were > efficiently implemented. > > From

Re: [sqlite] enums

I have no better reason than that I'm used to it in my dealings with MySQL and C++. It could save developer time and disk space, however, if it were efficiently implemented. >From the sense of your comment, I get that the answer is no...Oh well. At >least I learned something today. Thanks

Re: [sqlite] enums

On Tue, Dec 7, 2010 at 8:38 PM, john darnell wrote: > Is there any way to build an SQLite table that recognizes enums? > Hmm, I always thought that this is better to be implemented by a separate table and lookup join. Can you name a reason to do this internally by

Re: [sqlite] Backup-restore behaviour

On 7 Dec 2010, at 5:49pm, Csom Gyula wrote: > I was just wondering how portable is the backup format... (well according to > the backup API - as far as I see the backup format is nothing but the > database file format). Yes, it's just a copy of the source file. No changes. Simon.

Re: [sqlite] Backup-restore behaviour

Thanks for your response! We are currently running our app on a 64 bit machine (btw OS is Debian GNU/Linux). I was just wondering how portable is the backup format... (well according to the backup API - as far as I see the backup format is nothing but the database file format). Gyula

Re: [sqlite] database size (again)

On Tue, Dec 7, 2010 at 6:57 PM, Laszlo Nemeth wrote: > Hi, > > Question: is it possible to recompile sqlite to force the > representation of integers to be 4 bytes, and that of floats to be > also 4 bytes. I would like to have no observable change in the > behaviour of

[sqlite] enums

Is there any way to build an SQLite table that recognizes enums? It's a lot easier to understand at data that looks like this: kHard kSoft kAlt kSoft kSoft kHard than this: 1 2 3 2 2 1 R, John A.M. Darnell Senior Programmer Walsworth Publishing Company Brookfield, MO John may also be reached

Re: [sqlite] Backup-restore behaviour

On Dec 7, 2010, at 10:49 AM, Csom Gyula wrote: > It clarified the situation, that is backup-restore seems to be the best > choice:) Just one more question. As you put backup-restore is based upon data > pages (that could be binary a format I guess) not on plain SQL/data records. > After all:

Re: [sqlite] Backup-restore behaviour

Again, thanks for your response:) Cheers, Gyula Feladó: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] ; meghatalmaz: Simon Slavin [slav...@bigfraud.org] Küldve: 2010. december 7. 17:00 Címzett: General Discussion of SQLite Database

Re: [sqlite] WAL file size

Hi, It's clear that for the WAL to be a general purpose solution, which can be used in systems which have constant stream of reads/writes from sqlite, it should not grow limitlessly under all circumstances (assuming the user run a checkpoint every once in a while). I think my design can work

Re: [sqlite] database size (again)

A lot of the SQLite overhead is going to be in the stuff surrounding your actual data; I'd be surprised if you saved much space by using fixed-size ints vs the varints used by SQLite. You didn't mention about indexes; if you have any, they will take a lot of space because your row size is so

Re: [sqlite] Backup-restore behaviour

On 7 Dec 2010, at 3:49pm, Csom Gyula wrote: > Just one more question. As you put backup-restore is based upon data pages > (that could be binary a format I guess) not on plain SQL/data records. After > all: Is the data page/backup format platform indenpendent? For instance can I > restore a

[sqlite] database size (again)

Hi, I have a database (6 in fact) of high-frequency data create table eurusd (tick integer not null, bid float not null, ask float not null); with 80M records currently and growing, freshly inserted, no deletions will ever take place, the schema will never change, and neither of the

Re: [sqlite] Accessing multiple rows at once via a select statement

> This isn't an SQLite problem; it's a C problem. You need to make a > C-style closure: function plus pointer to structure of persistent > data. Define: > >struct write_closure { >mystructure *next; >}; > > or whatever, then put a struct write_closure on the stack and pass a >

Re: [sqlite] Backup-restore behaviour

Thanks for your reply! It clarified the situation, that is backup-restore seems to be the best choice:) Just one more question. As you put backup-restore is based upon data pages (that could be binary a format I guess) not on plain SQL/data records. After all: Is the data page/backup format

Re: [sqlite] How Execute Joint Queries In Sqlite?

A union of a left and right joins should do it. On 12/7/2010 4:50 AM, Simon Slavin wrote: > On 7 Dec 2010, at 12:37pm, Pavel Ivanov wrote: > >>> I Writed A FULL OUTER JOIN Query In Sqlite But I Got A Message Like Not >>> Supported. What Should I Do To Do This >> You should re-think once more: do

Re: [sqlite] SQLite Introspection

On 07/12/2010, at 11:25 AM, Tom Krehbiel wrote: > I haven't been able to find anything in the documentation that indicates how > to get at the trigger definition. You can, of course, get the definition of any entity from the SQLite_Master table, such as: select Name, SQL from SQLite_Master

Re: [sqlite] WAL file size

On 12/07/2010 09:49 PM, 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 writes > pages

Re: [sqlite] SQLite Introspection

On Mon, Dec 06, 2010 at 05:25:43PM -0700, Tom Krehbiel scratched on the wall: > The documentation for the analyze > command says they can do a *select *on table *sqlite_stat1 *but when I do a > select I get an error with 'no such table: sqlite_stat1'. Like the table sqlite_sequence (used for

Re: [sqlite] WAL file size

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 writes pages successfully to the WAL, they will never get corrupted. but

Re: [sqlite] Date/Time query help

Marco Bambini wrote: > CREATE TABLE foo (id integer PRIMARY KEY AUTOINCREMENT,connection_date text); > > and I insert data into this table using the syntax: > INSERT INTO foo (connection_date) VALUES (datetime('now','localtime')); > INSERT INTO foo (connection_date) VALUES

Re: [sqlite] how to know the list of pragma that are database related or connection related

Vander Clock Stephane wrote: >>> Some pragma are set be connection, >>> some by database (and all the connection to this database) and >>> some by the engine (all database and all connections) >> Could you give an example of this last category? I don't see by what >>

[sqlite] Date/Time query help

I have a table like: CREATE TABLE foo (id integer PRIMARY KEY AUTOINCREMENT,connection_date text); and I insert data into this table using the syntax: INSERT INTO foo (connection_date) VALUES (datetime('now','localtime')); INSERT INTO foo (connection_date) VALUES (datetime('now','localtime')); I

Re: [sqlite] Backup-restore behaviour

On 7 Dec 2010, at 1:03pm, Csom Gyula wrote: > Based on the documentation available we've already decided to use > the CLI either .backup-.restore or .dump. Possibly simplest to answer some of it here. The dump/read pair use standard SQL commands like SELECT and INSERT. The normal SQL

Re: [sqlite] how to know the list of pragma that are database related or connection related

>> Some pragma are set be connection, >> some by database (and all the connection to this database) and >> some by the engine (all database and all connections) > Could you give an example of this last category? I don't see by what possible > mechanism could a PRAGMA issued in one process

[sqlite] Backup-restore behaviour

Hi, we are using SQLite3 as an embeded database in our application and we'd like to select the proper backup-restore mechanism. Based on the documentation available we've already decided to use the CLI either .backup-.restore or .dump. However we have some questions we couldn't find in the

Re: [sqlite] how to know the list of pragma that are database related or connection related

Vander Clock Stephane wrote: > Some pragma are set be connection, > some by database (and all the connection to this database) and > some by the engine (all database and all connections) Could you give an example of this last category? I don't see by what possible

Re: [sqlite] How Execute Joint Queries In Sqlite?

On 7 Dec 2010, at 12:37pm, Pavel Ivanov wrote: >> I Writed A FULL OUTER JOIN Query In Sqlite But I Got A Message Like Not >> Supported. What Should I Do To Do This > > You should re-think once more: do you really need a full outer join? > Maybe you can change your schema so that it was more

Re: [sqlite] How Execute Joint Queries In Sqlite?

Arunkumar T wrote: > I Writed A FULL OUTER JOIN Query In Sqlite But I Got A Message Like Not > Supported. What Should I Do To Do This You should rewrite your query in a way that doesn't require full outer joins (I personally don't recall ever having the need to use

Re: [sqlite] How Execute Joint Queries In Sqlite?

> I Writed A FULL OUTER JOIN Query In Sqlite But I Got A Message Like Not > Supported. What Should I Do To Do This You should re-think once more: do you really need a full outer join? Maybe you can change your schema so that it was more clear and didn't require full outer join for querying.

Re: [sqlite] SQLITE_CORRUPT when PRAGMA max_page_count is reached

On Tue, Dec 7, 2010 at 12:10 AM, uncle.f wrote: > Could Anybody please help? > > We are running SQLite 3.7.3 on an embedded device and using C API to > interact with the DB. One of our goals is to ensure that the database > never grows past certain size (which is very small for

[sqlite] How Execute Joint Queries In Sqlite?

I Writed A FULL OUTER JOIN Query In Sqlite But I Got A Message Like Not Supported. What Should I Do To Do This Can You Help Me? Regards Arunkumar ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Problem with disableTerm() and virtual tables

I am running SQLite 3.6.22 (debugging code enabled) with extensive use of virtual tables that behave as if their structures were as follows (unused fields have been omitted): CREATE TABLE one ( aunsigned, bunsigned, cunsigned, dunsigned, stext); CREATE

[sqlite] SQLITE_CORRUPT when PRAGMA max_page_count is reached

Could Anybody please help? We are running SQLite 3.7.3 on an embedded device and using C API to interact with the DB. One of our goals is to ensure that the database never grows past certain size (which is very small for this embedded box). We open DB connection once and would like to keep it

Re: [sqlite] SQLite 3 and FK

On 6 Dic, 14:43, "Jay A. Kreibich" wrote: > On Mon, Dec 06, 2010 at 06:20:13PM +0600, Dagdamor scratched on the wall: >zac Yes ...my error...i want translate name from italian I resolve error! Table models is auto generate from csv import file...and...not have a PK !!! i

[sqlite] SQLite - sorting and case-insensitive comparison of Unicode characters

Hi Guys, SQLite has problems related to the sorting and case-insensitive comparison of Unicode characters. It solved this problem by enabling ICU extension. But, I couldn't find detailed information about its enabling within "ADO.NET 2.0 Provider for SQLite" (http://sqlite.phxsoftware.com/). I

Re: [sqlite] need help on escaping the ']' character in the identifier

On Tue, Dec 7, 2010 at 3:49 AM, 곽현미 wrote: > Anyone please give me an advise, > > when i try the query below, > > CREATE TABLE "Test]" (no INTEGER), > > sqlite gives me the 'unrecognized token: "]" ' result. > It works when I try it. What version of SQLite are you using?

Re: [sqlite] database question

On 7 Dec 2010, at 10:31am, CDN Mark wrote: > newbie question, what I'd like to do is improve/add columns for a sadly > lacking database for a commercial proramme. What I'd like to know is it > possible to add columns to an existing database without causing problems, add > extra info into

Re: [sqlite] need help on escaping the ']' character in the identifier

Quoth Philip Graham Willoughby , on 2010-12-07 10:57:45 +: > Use the right quotes, single not double; this works for me: > > create table 'test]' (no integer); Yagh! Please don't call those the 'right' quotes in this case. Quoth

Re: [sqlite] database question

Hi Mark, I am not an expert on SQLite. But I have programming experience, so I can make a suggestion. You did not say what application you are talking and if you did, I might not know about it. What I would do is yes create a simple application that accesses the SQLite database and the table

Re: [sqlite] need help on escaping the ']' character in the identifier

On 7 Dec 2010, at 08:49, 곽현미 wrote: > Anyone please give me an advise, > > when i try the query below, > > CREATE TABLE "Test]" (no INTEGER), > > sqlite gives me the 'unrecognized token: "]" ' result. > > Is there a way to escape the ']' character in the identifier? Use the right quotes,

[sqlite] database question

Hi, newbie question, what I'd like to do is improve/add columns for a sadly lacking database for a commercial proramme. What I'd like to know is it possible to add columns to an existing database without causing problems, add extra info into these columns, and then somehow create a viewer of

[sqlite] need help on escaping the ']' character in the identifier

Anyone please give me an advise, when i try the query below, CREATE TABLE "Test]" (no INTEGER), sqlite gives me the 'unrecognized token: "]" ' result. Is there a way to escape the ']' character in the identifier? Thanks, hyunmi. ___ sqlite-users