Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Hi Andrew, Yup, I think my mind is made up...I will use SQLite with WAL with "fairly frequent" commits to force the update of the database from the WAL file. How often do you run the commits between the two files? Or do you just use the default? Chat later Lynton -Original Message-

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

I've used SQLite for exactly this. I have no gripes with it at all. I ended up using just one table in one DB as indexing makes things simple and fast and I support arbitrary queues with multiple readers. WAL i've been trying these last few days and seems trouble-free. On 30/09/2010 6:11 PM,

Re: [sqlite] Pivot Sequential Data into Dynamic Groups

On Sep 30, 2010, at 11:44 PM, Jordan Dahlke wrote: > Is there a good way to do this with Select and Group By statement? For a given definition of "good" :P create temporary table range as select 0 as start, 24 as end union all select 25 as start, 49 as end union all select 50 as start, 74

Re: [sqlite] appropriate Uses For SQLite

Thanks for the info. it has helped clarify some things for me. I think I will stick with MySQL with this application as it is going to be a networked app. If I do one that does not need to be on a network i will dive into SQLlite. thanks again. Pavel Ivanov-2 wrote: > > There's no

Re: [sqlite] Pivot Sequential Data into Dynamic Groups

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/30/2010 02:44 PM, Jordan Dahlke wrote: > Is there a good way to do this with Select and Group By statement? Look in the archives for this mailing list. There was exactly that discussion yesterday with a subject of "Vertical -> Horizontal

[sqlite] Pivot Sequential Data into Dynamic Groups

I am recording data received over a serial bus into a sqlite database. The data is received at roughly 40hz, though some variables are in less frequent multiples of that, 10hz and 4hz. Variable, Value, Time Speed, 60, 0.1ms Direction, 90, 0.4ms Temp, 22, 0.7ms Speed, 60, 25ms Speed, 60.21, 50ms

Re: [sqlite] Tips on connecting to remote SQLite servers?

On Sep 30, 2010, at 11:40 PM, Mike wrote: > I am new to SQLite and I want to connect to a remote older SQLite server > from a modern iPhone app. > > I am using the C API to connect. Can someone tell me the syntax for > connecting to a remote SQLite server using the C API?

[sqlite] Tips on connecting to remote SQLite servers?

I am new to SQLite and I want to connect to a remote older SQLite server from a modern iPhone app. I am using the C API to connect. Can someone tell me the syntax for connecting to a remote SQLite server using the C API? Thanks, -m ___ sqlite-users

Re: [sqlite] appropriate Uses For SQLite

There's no contradiction in those citations. First talks about website with some 100K hits/day. Website means application running on some dedicated server, clients send HTTP requests to your application and application processes it working with locally stored database. Second citation is talking

[sqlite] appropriate Uses For SQLite

I am looking into the best method for implementing a database for a small application that I will most likely be building it in Adobe Air. I looked at "Appropriate Uses For SQLite" on the the SQLite.org website and I got some conflicting info. for Example I saw the following: "SQLite usually

Re: [sqlite] data consistency issues in WAL

On Thu, Sep 30, 2010 at 3:02 PM, Erik Fears wrote: > Each thread has its own handle (implemented using boost's thread local > storage). > > I had a bug a few days ago I fixed where I was leaking sqlite3_stmt objects > in the reader thread. If I don't finalize a sqlite3_stmt,

Re: [sqlite] data consistency issues in WAL

Each thread has its own handle (implemented using boost's thread local storage). I had a bug a few days ago I fixed where I was leaking sqlite3_stmt objects in the reader thread. If I don't finalize a sqlite3_stmt, would it leave a transaction uncommitted? --erik On Wed, Sep 29, 2010 at 2:35

Re: [sqlite] how to know the primary key of a table?

Jay A. Kreibich wrote: > The sixth column of the output of "PRAGMA table_info( )". > Each column of will return one row. The last column of the > output will have a value of 1 (true) if that row's column is part of > the PK, or 0 (false) if that row's column is not part of the PK. > >

Re: [sqlite] how to know the primary key of a table?

On Thu, Sep 30, 2010 at 05:47:49PM +0200, TP scratched on the wall: > Hi everybody, > > Apart from parsing the SQL definition of a table obtained with > sqlite_master, is there any means to obtain directly the primary key of a > table? I have not found any PRAGMA allowing that. The sixth

Re: [sqlite] Disambiguation of Latin accent characters for FTS3

On Thu, Sep 30, 2010 at 8:36 AM, Travis Orr wrote: > I know it is possible but can't figure out what needs to be done to be able > to make FTS3 see E as being equal to É. And other similar cases. Despite the orthographic similarity, those sounds are as different to French speakers

Re: [sqlite] Disambiguation of Latin accent characters for FTS3

Hi Travis, You need to define a "tokenizer" to be used by FTS3; something somehow similar to user-defined collating sequences. See http://www.sqlite.org/fts3.html#section_5_1 The ICU library has language-specific library functions for ignoring accents while tokenizing. The Perl binding

Re: [sqlite] how to know the primary key of a table?

On 30 Sep 2010, at 4:47pm, TP wrote: > Apart from parsing the SQL definition of a table obtained with > sqlite_master, is there any means to obtain directly the primary key of a > table? I have not found any PRAGMA allowing that. If your primary key is a unique autoincrement integer, then

[sqlite] how to know the primary key of a table?

Hi everybody, Apart from parsing the SQL definition of a table obtained with sqlite_master, is there any means to obtain directly the primary key of a table? I have not found any PRAGMA allowing that. Thanks in advance, Julien -- python -c "print ''.join([chr(154 - ord(c)) for c in

[sqlite] Disambiguation of Latin accent characters for FTS3

I know it is possible but can't figure out what needs to be done to be able to make FTS3 see E as being equal to É. And other similar cases. I have a custom collation sequence that does this disambiguation for sorting query results, but it doesn't appear to be functioning when performing

Re: [sqlite] Referential integrity based on a view.

On Sep 30, 2010, at 3:30 PM, Muthuveerappan Alagappan wrote: > Hi > > I am a newbie to sqlite, I am having difficulty in trying to > build > referential integrity based on a view. > > sqlite allows me to create referential integrity based on a >

Re: [sqlite] [C-API] Query returns only 0

Hello Gerald, i think you should tell us more about what you are trying to do and add some C code. what do you mead by "return value"? What functions do you call? Do you know that you have to get the selected value by calling a function like sqlite3_column_text ? Martin Am 30.09.2010

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Hi Drake, Thanks for your comments below, I really appreciate your insight on this ;-) Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Drake Wilson Sent: 30 September 2010 12:29 PM To: General Discussion of SQLite

Re: [sqlite] Referential integrity based on a view.

Thanks a lot!! Is there any proposal to build this feature (referential integrity on a view)? On Sep 30, 2010, at 19:58, "Igor Tandetnik" wrote: > Muthuveerappan Alagappan wrote: >> sqlite allows me to create referential integrity based on a

Re: [sqlite] Referential integrity based on a view.

Muthuveerappan Alagappan wrote: > sqlite allows me to create referential integrity based on a view ( vu_cars ) This looks like a bug. I'm pretty sure referencing a view in a foreigh key is not supposed to work. -- Igor Tandetnik

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Quoth Lynton Grice , on 2010-09-30 12:05:18 +0200: > BTW: What is WAL WAL mode uses a write-ahead log instead of a rollback journal, which can help reduce write activity but requires the use of shared memory to keep things consistent between database handles. If I

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Hi Drake, Thanks for your comments, much appreciated. I will look into your concerns below, thanks. To me it seems like a perfect match, one could even break it up into "one .db file per message queue"...very nice and easy to use. I already have a message queue implementation in Python that

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Quoth Lynton Grice , on 2010-09-30 10:11:54 +0200: > Bottomline: We have one writer and multiple readers per queuefine. > > Then I scratch my head and wonder why SQLite is not the PERFECT persistence > layer for building an awesome "file based queue" on? It is

[sqlite] [C-API] Query returns only 0

Hello Gyus, ive got problems with my qeuries. After loading a table, i create a statement for every column to prepare the querys. A sample for such a prepared query is.. SELECT "F_SIZE_M0200_m0_VALUE" FROM fileInfos WHERE FILEINFO_FULLNAME = ?1 ...for that query i bind TEXT values

[sqlite] Referential integrity based on a view.

Hi I am a newbie to sqlite, I am having difficulty in trying to build referential integrity based on a view. sqlite allows me to create referential integrity based on a view ( vu_cars ), however it doesn't allow me to insert any records into the

[sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Hi there, I am a HUGE SQLite fan and have an interesting question I have been scratching my head about for a couple days now. First off my daily job is very much around "messaging" and I am very familiar with message queue products like Websphere MQ and Fiorano MQ. When you install