Re: [sqlite] "Database is locked" error in PHP via PDO despite setting timeout

If you want to use a lightweight DB like Sqlite and you are setting up your own daemon and server situation then you can place the DB synchronization function in the daemon around the Sqlite so that its action is single streamed. In a similar situation we have installations which manage many

[sqlite] SQLITE3.DLL fails to load if address 0x60900000 occupied and DLL recompilation

Hallo. After I changed my development machine, I was not able any more to load the SQLITE3.DLL in my .Net application. Looking around, I found this article that describes the problem. http://www.sqlite.org/cvstrac/tktview?tn=1474 The solution is to recompile the DLL with visual

[sqlite] forcing primary key range

Hello, Is there a way to force the range value taken by a primary key? Suppose I have a table that will never contain more than 2**20 rows. On some occasion, I want new inserted rows to have a pkey in [0, 2**32), on another occasion they would take their value in [2**32, 2*33), etc. In my

Re: [sqlite] SQLITE3.DLL fails to load if address 0x60900000 occupied and DLL recompilation

Hi, According to that ticket it is fixed in the latest download on the website. So there should be no need to recompile yourself unless it is an older version? Cheers, Rob - Original Message - From: "Clinco, Michele" <[EMAIL PROTECTED]> To: Sent: Tuesday,

[sqlite] R: [sqlite] SQLITE3.DLL fails to load if address 0x60900000 occupied and DLL recompilation

It is not. I tried, but does not work. Bye, Michele -Messaggio originale- Da: Rob Lohman [mailto:[EMAIL PROTECTED] Inviato: martedì, 21. marzo 2006 10:11 A: sqlite-users@sqlite.org Oggetto: Re: [sqlite] SQLITE3.DLL fails to load if address 0x6090 occupied and DLL recompilation Hi,

[sqlite] SQLITE_ENABLE_MEMORY_MANAGEMENT: AV when Open / Close DB in different threads

Hello, I am using SQLite compiled with SQLITE_ENABLE_MEMORY_MANAGEMENT on Win32. I execute the following psydocode, all with same DB handle: * In application's main thread: sqlite3_open * Create a new thread * In new thread: sqlite3_close This creates an access violation in pager.c, lines 2065

Re: [sqlite] SQLITE_ENABLE_MEMORY_MANAGEMENT: AV when Open / Close DB in different threads

You have to call open & close in the same thread, and in each thread if needed. " The returned sqlite3* can only be used in the same thread in which it was created. It is an error to call sqlite3_open() in one thread then pass the resulting

Re: [sqlite] SQLITE_ENABLE_MEMORY_MANAGEMENT: AV when Open / Close DB in different threads

Hi Ralf, If I remember correctly you cannot use a SQLite database handle across threads. Each thread will need to open (and close) the database itself. Cheers, Rob - Original Message - From: "Ralf Junker" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 21,

Re: [sqlite] SQLITE_ENABLE_MEMORY_MANAGEMENT: AV when Open / Close DB in different threads

Hello Ludovic Ferrandis, thanks, but this is not quite true for the latest version: http://www.sqlite.org/faq.html#q8 reads: "The restriction on moving database connections across threads was relaxed somewhat in version 3.3.1. With that and subsequent versions, it is safe to move a connection

Re: [sqlite] SQLITE_ENABLE_MEMORY_MANAGEMENT: AV when Open / Close DB in different threads

Ralf Junker <[EMAIL PROTECTED]> wrote: > Hello, > > I am using SQLite compiled with SQLITE_ENABLE_MEMORY_MANAGEMENT on Win32. > Why? What do you hope to accomplish by using MEMORY_MANAGEMENT on Win32? MM is designed for use on embedded devices with very tight memory restrictions. It is not

[sqlite] Performance & database design

Hallo list, I'm relatively inexperienced when it comes to databases and SQL (but to programming). I'm using sqlite's (recent version) C API called from a C++ application. I'm confronted with the following situation: Ca. 2500-3000 objects (called 'entity') everyone with 3 properties (REAL in

Re: [sqlite] SQLITE_ENABLE_MEMORY_MANAGEMENT: AV when Open / Close DB in different threads

Hello Rob Lohman, SQLite is multithreaded since 3.3.1. Still, threre are restrictions: "When shared-cache mode is enabled, a database connection may only be used by the thread that called sqlite3_open() to create it. If another thread attempts to use the database connection, in most cases an

Re: [sqlite] Performance of VIEW with UNION

Joe Wilson <[EMAIL PROTECTED]> wrote: > > Does SQLite have a debug function to dump its parse tree > in readable ASCII form? > Nope. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] forcing primary key range

jt <[EMAIL PROTECTED]> wrote: > Hello, > > Is there a way to force the range value taken by a primary key? When you insert a NULL into an INTEGER PRIMARY KEY, it always converts the NULL to be one larger than the largest existing value. But you can specify a specific key and skip SQLite's

Re: [sqlite] Performance & database design

Micha Bieber <[EMAIL PROTECTED]> wrote: > Appending all 25*10^6 rows takes 40 > minutes on a PC with 3 GHz, 1GB memory and sufficient large harddisk. > Inserting 25-million rows in a table should be quick. Building an index (or indices) on a 25-million row table takes much longer. You did not

Re: [sqlite] SQLITE_ENABLE_MEMORY_MANAGEMENT: AV when Open / Close DB in different threads

Hello Richard, in case of stating the obvious: Thanks for your answer! It is always my pleasure reading your explanations on SQLite: Quick, precise, and right up to the point! Ralf >> While I understand from the FAQ that it might be problematic to use more >> than one thread with

[sqlite] support for table partitioning?

Hi drh and others, Regarding the issues they appear on ML with very large tables and knowing that sqlite now enforces constraint checks on tables, is there any chances of suporting table partitoning? Regards, Miha

Re: [sqlite] support for table partitioning?

On 3/21/2006, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: >"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: >> Hi drh and others, >> >> Regarding the issues they appear on ML with very large tables and knowing >> that sqlite now enforces constraint checks on tables, is there any >> chances of

[sqlite] R: [sqlite] support for table partitioning?

> The database already knows exactly where to look for each table when all the tables are in the same file. > All it has to do is "lseek()" to the appropriate spot. How does moving tables into separate files help this or make it any faster? > "Table partitioning" is a technique used to improve

Re: [sqlite] support for table partitioning?

"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: > Hi drh and others, > > Regarding the issues they appear on ML with very large tables and knowing > that sqlite now enforces constraint checks on tables, is there any > chances of suporting table partitoning? > Put each table in a separate database

Re: [sqlite] support for table partitioning?

"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: > On 3/21/2006, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > >"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: > >> Hi drh and others, > >> > >> Regarding the issues they appear on ML with very large tables and knowing > >> that sqlite now enforces

[sqlite] help: there is some error

hello everyone, I just want to test the connection between C and sqlite3, When I cross compile my program there is an error baffled me? There are my steps and the error: $arm-linux-gcc -o sqltest sqltest.c libsqlite.a usr/local/arm-linux/lib/libc.so.6: could not read

Re: [sqlite] help: there is some error

You should try with an ARM library. I think the ARM linker should not appreciate an X86 library. On 3/21/06, 杰 张 <[EMAIL PROTECTED]> wrote: > > hello everyone, > I just want to test the connection between C and sqlite3, When I > cross compile my program there is an error baffled me? > >

Re: [sqlite] Multithread access to DB

Sqlite has 3 types of locks, which is weird for me. Could You explain what is a "reserved lock"? Read and read/write (exclusive) locks are apparent. http://www.sqlite.org/capi3ref.html#sqlite3_busy_handler Best Regards, Rafal Rusin TouK Company (www.touk.pl)

RE: [sqlite] Multithread access to DB

http://www.sqlite.org/lockingv3.html RESERVED A RESERVED lock means that the process is planning on writing to the database file at some point in the future but that it is currently just reading from the file. Only a single RESERVED lock may be active at one time, though multiple SHARED locks

Re: [sqlite] Re: Select with left outer join - Am I going mad or just having a bad day?

On 21 Mar 2006, at 18:11, Ed Porter wrote: Hi Ian, You nee to use a Full Outer Join. I don't know if SQLite has this function. Nah, definitely only wanted a left outer, didn't want the results multiplied up or anything, just wanted every Category and any Cases if matching the

[sqlite] Scrolling thru an index

In a previous message: The way indices work in SQLite is that there is one row in the index for each row in the table but the index rows are in index order. ... D. Richard Hipp <[EMAIL PROTECTED]> Is there a way I can scroll thru a particular index? For example: 1. Scroll

[sqlite] Different column names in callback function on Linux vs. Windows

Hello, I'm doing a port of our application from Windows to Linux and one of the problems I'm facing is when executing the following statement through a call to sqlite3_exec(): SELECT mytable.'mycolumn' FROM table The registered callback function 4th argument (a char**) denoting the

[sqlite] Re: - [sqlite] Incrementing the value of a column

Try: UPDATE table SET aColumn = someNewValue, numTouched = numTouched + 1 WHERE ; Regards. rayB |-+> | | Tito Ciuro | | | <[EMAIL PROTECTED]> | | || | |

Re: [sqlite] Performance & database design

Some people on the list have noted that inserting pre-sorted rows in sub-batches into SQLite is faster than inserting unsorted rows. Granted, you could only do this for one index per table, but might this be the basis of an optimization? (I have not looked at the insert code. Perhaps SQLite is

[sqlite] How do I install sqlite-odbc at ARM9 target board?

Hi,all I just want to connect ASP and SQLite at ARM9 target board,but I don't known how to do it . Please help me! Thank you so much! __ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com

Re: [sqlite] Performance & database design

On Wed, Mar 22, 2006 at 10:41:23AM +1100, John Stanton wrote: > The mmap'd index was about three times faster than when it > used a LRU paged cache. I looked fairly closely into the possibility of using mmap for the SQLite btree backend, and realized that it would be quite difficult. Because

Re: [sqlite] Performance & database design

Our approach to byte order independence was fairly simple, and worked well with a mmap'd index. It involved keeping the just word pointers in a local byte ordered block if the machine were a different Endian. The overhead was next to insignificant. Our indices were all byte order

[sqlite] Has anyone used sqlite for Pocket PC development?

Hi, I am planning to use sqlite with VS .Net 2003 Smart device C# application. Just wondering if anyone has blazed down this path before and has any insights to share. Thanks! ~CodeMonkey8