Re: [sqlite] Multiple *processes* accessing one database

On 6/13/07, Andrew Roark <[EMAIL PROTECTED]> wrote: My question: how well does sqlite handle one database file being accessed by multiple processes? Very well, so far. You'll want to make sure you use an appropriate locking (transaction) strategy, and accomodate SQLITE_BUSY even when you

Re: [sqlite] Is it a bug?

--- [EMAIL PROTECTED] wrote: > I have a user-defined function named DECRYPT, which decrypts column data > encrypted by my other UDF named ENCRYPT. > > The UDF callback function (which does the decrypting) calls > sqlite3_result_blob > after decrypting the data. Sqlite does return the data

[sqlite] Is it a bug?

I have a user-defined function named DECRYPT, which decrypts column data encrypted by my other UDF named ENCRYPT. The UDF callback function (which does the decrypting) calls sqlite3_result_blob after decrypting the data. Sqlite does return the data OK...BUT! It doesn't provide the data type

Re: [sqlite] index with NULL values

Good stuff! Is this in the wiki somewhere? On 6/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Adler, Eliedaat" <[EMAIL PROTECTED]> wrote: > Hi, > > I want to add an index on a sparsely populated column - > i.e. for most rows the column is null. > > 1. Would this index be very compact?

RE: [sqlite] How can I convert from Julian time to a tm structure?

Dr. Hipp, Thank you very much for the link to the source for the Julian date calculations. I did pull the code out of date.c, and I'm using it. But the code seems to rely on implicit conversions between floating-point numbers and integers that I assume must be intentional, but it looks

[sqlite] MMap On Solaris

John, You seem pretty knowledgable regarding MMAP. I was wondering if you could help me with this MMAP scenario: I'm curious as to how the OS and multple processes interact regarding file i/o and mmap. Process A --- Writes to a file sequentially using either pwrite or kaio.

RE: [sqlite] How can I convert from Julian time to a tm structure?

Hi Rob, Regarding: One thing I want to do is to move the conversion of the timestamp from a Julian time to a human-readable time from the query to my application. I may not understand your request fully, but are you asking for more information than is provided in the source files for the

Re: [sqlite] "Make" with VisualStudio/Windows

Yes I tried using the amalgamation, but I still don't get as good result as I did before with 3.3.13... Also, when I defined SQLITE_OMIT_ALTERTABLE I got this error: error LNK2019: unresolved external symbol _sqlite3AlterBeginAddColumn referenced in function _yy_reduce error LNK2019: unresolved

RE: [sqlite] How can I convert from Julian time to a tm structure?

All right. Smack me upside the head again. I deserve it. SQLite is open source, so I just had to look in the source code. RobR - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] How can I convert from Julian time to a tm structure?

Rob Richardson wrote: ... One thing I want to do is to move the conversion of the timestamp from a Julian time to a human-readable time from the query to my application I didn't see any little utility function in the SQLite library that just exposes whatever routine SQLite uses to do the

Re: [sqlite] "Make" with VisualStudio/Windows

On 6/13/07, Jonas Sandman <[EMAIL PROTECTED]> wrote: Hello, Is it possible to get the latest SQLite somehow which doesn't require you to actually run "make"? With the amalgamation (?) you can just compile the whole thing in Visual Studio but it seems that the compiler isn't very successful in

[sqlite] How can I convert from Julian time to a tm structure?

Greetings! I am trying to speed up an application that queries a table with three columns and around a million records, and one of the fields is a timestamp. One thing I want to do is to move the conversion of the timestamp from a Julian time to a human-readable time from the query to my

[sqlite] "Make" with VisualStudio/Windows

Hello, Is it possible to get the latest SQLite somehow which doesn't require you to actually run "make"? With the amalgamation (?) you can just compile the whole thing in Visual Studio but it seems that the compiler isn't very successful in optimizing when it's run like that since my

[sqlite] reserved chars in insert

Hi, I would like to know the reserved characters which cannot be used in inserting a string.. (like ",',...). Thanks in advance, Lloyd __ Scanned and protected by Email scanner -

Re: [sqlite] Database designer for SQLite

Thanks but i forgot to specify that i'm on Mac :( Something else for me ?? Le 13 juin 07 à 16:44, Jim Dodgen a écrit : www.datanamic.com

Re: [sqlite] Database designer for SQLite

I use dezign from www.datanamic.com They don't have a template for sqlite but it is easy make one. Quoting Paul KOENIG <[EMAIL PROTECTED]>: > > > Début du message réexpédié : > > > De : Paul KOENIG <[EMAIL PROTECTED]> > > Date : 13 juin 2007 16:26:56 HAEC > > À : sqlite-users@sqlite.org > >

[sqlite] Database designer for SQLite

Début du message réexpédié : De : Paul KOENIG <[EMAIL PROTECTED]> Date : 13 juin 2007 16:26:56 HAEC À : sqlite-users@sqlite.org Hi, I'm new with SQLite. Do someone know a database designer like DBDesigner for SQLite? I want to create a graphic Entity-RelationShip schema. Thanks

[sqlite] How SQLite may work on AVR or similar mcu?

I do not need it actually, but i am so inquisitive. I have heard that sqlite has been ported to AVR too. How may be solved the main storage solved on it? So for example, i have system with ATmega64 with 128KB of external SRAM. The whole ram is organized as static 60KB and 18 pages of 4KB (the

Re: [sqlite] MMap On Solaris

MMAP just lets you avoid one or two layers of buffering and APIs. If you were to use fopen/fread you go to function calls then open/read plus buffering and function calls then to to the VM to actually access the data. Going direct to the VM and getting a pointer to the VM pages is more