[sqlite] UTF support

I saw a few things go by about unicode... and understand that it should just work to store the data as characters... I'm getting a unrecognized token... and think this page isn't right... I was playing with greek translation of 'mary had a little lamb' http://www.sqlite.org/tokenreq.html

Re: [sqlite] Behavior change: INTEGER PRIMARY KEY and PRAGMA index_list

You were totally correct, read data after done. Thanks for your reply. -Paul -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch Sent: Sunday, October 05, 2014 3:05 AM To: sqlite-users@sqlite.org Subject: Re:

Re: [sqlite] Sqlite giving error on unique constraint

The table schema and insert statement might be useful ... On Monday, 6 October, 2014 14:42, Jeffrey Parker said: >I am working with sqlite3 in python 2.7.8 and I am running into a strange >error where I get the below exception when running an insert into >statement >on an

[sqlite] Sqlite giving error on unique constraint

Hello, I am working with sqlite3 in python 2.7.8 and I am running into a strange error where I get the below exception when running an insert into statement on an empty table. I know this is probably more to do with the python libraries but I thought that I would ask the question here in case

Re: [sqlite] why does gperftools shows sqlite3_memory_used as using the largest amount of memory

Mayank Kumar (mayankum) wrote: > will the memory used by sqlite keep on increasing, if we don't > finalize at all during the life time of the db, as we do more insert/ > delete/replace operations ? Every prepared statement needs some memory (but only a small amount). As long as you are using

Re: [sqlite] why does gperftools shows sqlite3_memory_used as using the largest amount of memory

Thanks Clemens. Gperftool a malloc replacement, profiler and leak checker, reports that the largest amount of memory was being used by sqlite3_memory_used api which sounds weird, as it just reports the value of some counters. So it might be an error in gperftools itself. Not sure. I found

Re: [sqlite] Filling struct Select in sqlite

On Mon, 6 Oct 2014 10:28:59 +0530, Prakash Premkumar wrote: >Instead of generating an sql query for a select statement, I would like to >bypass the parser and fill in struct Select by myself based on the data I >have and Pass it to sqlite3Select() function. Can you

Re: [sqlite] Memory Usage

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/02/2014 03:12 PM, David Muchene wrote: > I was wondering what options I can tune to make sqlite use more > memory. Have you tried using memory mapping (there is a pragma). https://sqlite.org/mmap.html Roger -BEGIN PGP SIGNATURE-

Re: [sqlite] struct SrcList

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/06/2014 04:41 AM, Prakash Premkumar wrote: > Can you please show me where in sqlite code the struct SrcList is > filled up ? You keep asking people to do lots of work on your behalf without showing you have made any effort yourself. You have

Re: [sqlite] Long lived prepared statements

Thanks Mark, That confirms what I have been observing. I have been running a test for about 12 hours doing the reused prepare and I detect no leakage. A question about your reply about the automatic finish at the last fetchrow. I assume this is the same finish of the handle obtained from my

Re: [sqlite] passing error messages to pysqlite

Is anyone able to tell me why I'm having this commit problem in python? Mark On Saturday, October 04, 2014 11:43:41 AM Mark Halegua wrote: > Just tried the same code on a different system, using sqlite3 3.8.2 > > Same result. > > Mark > > On Saturday, October 04, 2014 10:44:20 AM Mark

[sqlite] Best page size and cache size in high memory environment

Hi All, My application uses temporary tables that can become quite big (>300MB), so it makes sense to me to change the page size and cache size with pragma statements. The docs say "The default suggested cache size is 2000 pages" and "The normal configuration for SQLite running on workstations

[sqlite] share data across connections

Dear all, I'd like to ask for your advice. My goal is to perform some kind of different math computations (whatever) over a _subset_ of items (records) stored in my sqlite DB. Each record has a number of properties stored in the same DB. Each calculation needs only _one_ parameter of a certain

[sqlite] SQL logic error or missing database no such table: config

Hello, Using SQLite for C# (package from NuGet). In some cases...I get this exception but database and table are present. Why I get this exception? Corruption? What? Thanks Best Regards ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Comiple time warning: possible array index out of bound within assert() in an error path

On Sun, Oct 5, 2014 at 1:54 PM, ISHIKAWA,chiaki wrote: > > I am reporting a suspicious compile-time error warning and > a fix to avoid a negative array index access during run time within > an assert(). > This harmless compiler warning should now be fixed. But as an

Re: [sqlite] Performance gain in SQLite

I recall there is or once was a way to compile sqlite so that you could embed in your program the pre-generated sql. This was for embedded programs, not to speed things up, but to remove the parser and save memory in very small embedded systems. For it to work, the sql and the database schema

[sqlite] Comiple time warning: possible array index out of bound within assert() in an error path

Hi, Thank you for the great package. I am reporting a suspicious compile-time error warning and a fix to avoid a negative array index access during run time within an assert(). Background: I was compiling mozilla thunderbird, and ever since I switched to GCC 4.9.1 with its improved

Re: [sqlite] Performance gain in SQLite

Hello PP> Will I get any performance benefits if I directly generate the Vdbe PP> program instead of generating the sql string ? I think any (tiny) performance gains will be offset by the extra work required to create the VDBE program and to keep your code up to date with SQLite. SQL (the

[sqlite] Performance gain in SQLite

Will I get any performance benefits if I directly generate the Vdbe program instead of generating the sql string ? My application emits out sql strings for execution. Instead if I generate the Vdbe program myself , will I get performance benefits since, I am bypassing the parser. Thanks Prakash

Re: [sqlite] struct SrcList

Thanks for your reply Hick. Can you please show me where in sqlite code the struct SrcList is filled up ? Thanks Prakash On Mon, Oct 6, 2014 at 5:01 PM, Hick Gunter wrote: > I estimate that you have about a 1 : 2^^32 chance of assigning the > correct value. I guess it is an

Re: [sqlite] struct SrcList

I estimate that you have about a 1 : 2^^32 chance of assigning the correct value. I guess it is an index into a table of cursors required for processing the statement and there will be assertions to satisfy. -Ursprüngliche Nachricht- Von: Prakash Premkumar

[sqlite] struct SrcList

Hi, struct SrcList has a field int iCursor, if I'm manually filling up this struct ,can I assign any integral value to iCursor,so that this value can be used by OpenRead or OpenReadWrite opcode when it accesses this particular table ? Thanks Prakash

Re: [sqlite] Curious datetime/strftime BUG?

John wrote: > On 5/10/2014 19:59, Clemens Ladisch wrote: >> The documentation says: >> | These functions only work for dates between -01-01 00:00:00 and >> | -12-31 23:59:59. For dates outside that range, the results of >> | these functions are

Re: [sqlite] Filling struct Select in sqlite

Prakash Premkumar wrote: > Instead of generating an sql query for a select statement, I would like to > bypass the parser and fill in struct Select by myself based on the data I > have and Pass it to sqlite3Select() function. Can you please give me some > pointers in this direction ? Just do the

Re: [sqlite] Long lived prepared statements

> I think I know the answer to this so I'm looking for some > conformation. What I do is to prepare a relatively large and complex > query. Then I run the same query forever never doing a finalize. My > assumption is I will have no memory leakage. In principle this should be fine, and if it