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
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
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
Quoth Lynton Grice lynton.gr...@logosworld.com, 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 lightening
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 uses
Quoth Lynton Grice lynton.gr...@logosworld.com, 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 were
Muthuveerappan Alagappan muthuveerappan...@gmail.com 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
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 itandet...@mvps.org wrote:
Muthuveerappan Alagappan muthuveerappan...@gmail.com wrote:
sqlite allows me to create referential integrity based on a view (
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
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 11:41,
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
view
(
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
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
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 (bit
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 for
On Thu, Sep 30, 2010 at 8:36 AM, Travis Orr t...@ivl.com 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 as
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 column
Jay A. Kreibich wrote:
The sixth column of the output of PRAGMA table_info( table ).
Each column of table 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.
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
On Thu, Sep 30, 2010 at 3:02 PM, Erik Fears str...@strtok.net 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, would it
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 will
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
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
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?
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
-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
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
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 as
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,
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-
30 matches
Mail list logo