On 11/2/06, Rob Richardson <[EMAIL PROTECTED]> wrote:
I have a small database in which tables have columns that were created
as integer primary key, but not autoincrement. I would like to make
sure keys are never reused, so I want to add autoincrement to the column
definition. Is that
viking2 <[EMAIL PROTECTED]> wrote:
I have a database (*.db3) with 3 tables:
CREATE TABLE TB_Signature (Filename TEXT, FileSignature TEXT, FileSize
INTEGER, FileDate INTEGER, PRIMARY KEY (FileSignature,FileSize));
CREATE TABLE TB_FileRecords (pszFilename TEXT PRIMARY KEY, nFileSize
INTEGER,
I have a database (*.db3) with 3 tables:
CREATE TABLE TB_Signature (Filename TEXT, FileSignature TEXT, FileSize
INTEGER, FileDate INTEGER, PRIMARY KEY (FileSignature,FileSize));
CREATE TABLE TB_FileRecords (pszFilename TEXT PRIMARY KEY, nFileSize
INTEGER, nFileSignature TEXT);
CREATE TABLE
You can enforce a column's TYPE using CHECK() and/or TRIGGER.
It might be expensive if used on all columns for large inserts
or updates; depends on what the priorities are.
INTEGER, REAL and BLOB are easy to enforce with triggers.
typeof( NEW.cEnforceReal ) <> 'real'
typeof( NEW.cEnforceInteger
David Gewirtz wrote:
John Stanton wrote:
Perhaps a thread per open database sync'd on an event and driven by a
queue would give you contention-free operation and avoid the need to
ever have the DB locked.
A thread would post its request to the queue then wait on an event
signifying
On Fri, Nov 03, 2006 at 11:39:47AM -0600, Gabriel Cook wrote:
> So, is there any way to of thing with a BLOB?
>
> > WHERE substr(data, 1, 1) == x'bc'
This works:
WHERE substr(data, 1, 1) == CAST(X'...' AS TEXT);
but only as long as X'...' has no NULs. And probably only as lon as
data contains
Peter De Rijk uttered:
--On Friday 27 October 2006 15:31, [EMAIL PROTECTED] wrote:
When a table is indexed, INSERT performance is logorithmic in the
number of rows in the table and linear in the number of indices.
This is because entries have to be inserted into the index in
sorted
Thanks for your reply.
However, I can't normalize the data in the blob, basically, its an arbitrary
frame of data. I don't know what's in it or how its formatted at design
time.
I'm ok with the table scan, IF I there is any way I can get the query to
work. I'll have to scan the data even if I
John Stanton wrote:
> Perhaps a thread per open database sync'd on an event and driven by a
> queue would give you contention-free operation and avoid the need to
> ever have the DB locked.
>
> A thread would post its request to the queue then wait on an event
> signifying completion.
That's
Christian Smith <[EMAIL PROTECTED]> wrote:
>>
> Version 2 used a Red/Black balanced tree in :memory:, whereas version 3
> appears to have done away with this optimisation. I'm curious as to why?
>
It is simpler to support a single algorithm (b-trees) rather than
two (b-tree + red/black trees).
Manzoor Ilahi Tamimy uttered:
I found that Version 2.8 was much Faster than 3.6 using ":memory:", 30
Seconds and 60 seconds in case of 2.8 and 3.6 respectively.
can I use 2.8 in my project when i have a huge amount of data to handle.
Version 2 used a Red/Black balanced tree in :memory:,
On 11/3/06, John Stanton <[EMAIL PROTECTED]> wrote:
As was pointed out, an Sqlite DB is just va file. Copy it to make a
backup. If you cannot create a file from your O/S then you will never
be able to make a backup. Fix that problem first.
There is, however, one issue to be aware of. If you
If you can get this to work it will be very slow. I suggest when writing to
this table that you extract the relevant parts of the data blob and store
them in separate fields with an appropriate index on each each . This will
avoid the a table scan for every query, which is what you'd get if your
As was pointed out, an Sqlite DB is just va file. Copy it to make a
backup. If you cannot create a file from your O/S then you will never
be able to make a backup. Fix that problem first.
[EMAIL PROTECTED] wrote:
No,
We are working on RTOS. There is some problem with mounting the
Hello all,
I'm trying to figure out if there is a way use portions of a BLOB field in a
select query.
Here is an example of the table:
CREATE TABLE fcdata (
timestamp INTEGER NOT NULL,
portINTEGER NOT NULL,
dataelementtype
No,
We are working on RTOS. There is some problem with mounting the
file system. Therefore all the filesystem APIs are returning failure.The
open() system call used inside the sqlite3_open() was not able to create
the file.
We are trying to find out a solution for it.
In the mean time if
Whether your database creation error solved? what was the problem?
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Friday, November 03, 2006 2:18 PM
Subject: [sqlite] sqlite backup from the program.
Hi All,
How to take a backup of the
SQLite database is stored as a normal file in the disk. Why dont you use
Operating System calls to back up the file?
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Friday, November 03, 2006 2:18 PM
Subject: [sqlite] sqlite backup from the program.
18 matches
Mail list logo