Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary
but also with a libsqlite3.a static lib. Could anyone suggest how I
could alter this Makefile to support these requirements please?
For x86_64 and i686, kernel 2.6.29.4, glibc 2.10.1.
TOP = ../sqlite3
BCC = gcc -O2
USLEEP = -DHAV
I established re-try logic to get this to work. :(
On Jun 5, 2009, at 7:08 PM, Rosemary Alles wrote:
>
> I have several (identical processors) accessing a sqlite3 database
> over NFS. I have a busy handler (see below) and use "begin exclusive"
>
> Periodically I get the following error from f
I have several (identical processors) accessing a sqlite3 database
over NFS. I have a busy handler (see below) and use "begin exclusive"
Periodically I get the following error from from sqlite3:
Function:artd_sql_exec_stmt error in stmt:begin exclusive against
database:/wise/fops/ref/artid/l
Last try...
On Sat, Jun 6, 2009 at 1:30 AM, Nikolaus Rath wrote:
> John Machin writes:
>> On 6/06/2009 8:19 AM, Nikolaus Rath wrote:
>>> John Machin writes:
> Now I'm confused. I want to know if it will be sufficient to wrap my
> last_insert_rowid() call between BEGIN .. and END in order
John Machin writes:
> On 6/06/2009 8:19 AM, Nikolaus Rath wrote:
>> John Machin writes:
Now I'm confused. I want to know if it will be sufficient to wrap my
last_insert_rowid() call between BEGIN .. and END in order to make it
return the rowid that was last inserted by the same thr
Nikolaus Rath wrote:
>>> Is BEGIN ... COMMIT sufficient for that?
>>
>> No. Transaction is also maintained per connection. Starting a
>> transaction would prevent other connections from making concurrent
>> changes, but wouldn't block other threads using the same connection.
>
> Actually it seems
"Igor Tandetnik" writes:
> Nikolaus Rath wrote:
>> "Igor Tandetnik" writes:
>>> Nikolaus Rath wrote:
How can I determine the rowid of the last insert if I am accessing
the db from different threads? If I understand correctly,
last_insert_rowid() won't work reliably in this case.
>
On 6/06/2009 8:19 AM, Nikolaus Rath wrote:
> John Machin writes:
>>> Now I'm confused. I want to know if it will be sufficient to wrap my
>>> last_insert_rowid() call between BEGIN .. and END in order to make it
>>> return the rowid that was last inserted by the same thread even if
>>> multiple th
John Machin writes:
>> Now I'm confused. I want to know if it will be sufficient to wrap my
>> last_insert_rowid() call between BEGIN .. and END in order to make it
>> return the rowid that was last inserted by the same thread even if
>> multiple threads are using the same connection (but differen
Hi!
I have a few questions/observations about the caching model. Any help
clarifying these issues would be greatly appreciated. (I'm working on a
Windows Server class OS).
1) Setting the SQLITE_CONFIG_PAGECACHE keyword within sqlite3_config()
seems to define a single cache for the instance of
On Fri, Jun 05, 2009 at 10:53:58AM -0400, German Escallon scratched on the wall:
> Say I have the following record in my DB:
>
> Path: /home/media/mymusic
> filename: rock_my_world
> extension: mp3
>
> I want to be able to find this file by typing any of the following in
> the user interface tha
I am not familiar with breeding business.
My suggestion comes from a very different problem that i solved recently.
The challenge was to describe a tree and to find the path to the root
starting from any leaf or intermediate node.
How to do?
1) The entity supported by the node shall support at l
Hi,
Not sure if that answers your question, but I think you seriously want
to use FTS3. It will be both a trillion times faster than your current
query - you may have trouble with your last example though. Maybe you
can still go through by escaping the search terms.
http://www.sqlite.org/cvstrac/
Hello all,
I have a table with file information (path, filename, extension, size,
etc), and I would like to enable search on this table based on different
fields with a single input, and/or concatenation of the same. For example..
Say I have the following record in my DB:
Path: /home/media/mymus
I tried the scripts with the command line sqlite3 application. The row
inserted in the data_view. But I received “SQL error: unknown error.”
Pavel Ivanov-2 wrote:
>
> "Not an error" is SQLITE_OK. Are you sure that you don't do anything
> between getting error code from SQLite and obtaining erro
Here is a relational model that I use for my genealogy. It is in
postgresql, but it should work fine in SQLite:
All people are stored in the indi table:
CREATE TABLE woodbridge.indi
(
indi character varying(10) NOT NULL,
lname character varying(30),
fname character varying(60),
title
On Fri, Jun 05, 2009 at 11:50:02AM +0400, Vladimir Kharitonov scratched on the
wall:
> I have a problem inserting data through a view.
> INSERT INTO data_view (id, created, content)
> VALUES (randomblob(16), datetime('now'), 'data');
>
> I receive strange SQLite Error: ???not an error???.
> I us
"Not an error" is SQLITE_OK. Are you sure that you don't do anything
between getting error code from SQLite and obtaining error message?
Maybe in another thread?
Pavel
On Fri, Jun 5, 2009 at 3:50 AM, Vladimir Kharitonov
wrote:
> I have a problem inserting data through a view.
>
> This is my DB:
robinsmathew wrote:
> hey i hve created a table
> CREATE TABLE video_tab (video_id INTEGER, project_id INTEGER,
> video_path VARCHAR(100), video_length INTEGER, video_type
> VARCHAR(10), video_size VARCHAR(10), CONSTRAINT video_pk PRIMARY
> KEY(video_id, project_id), CONSTRAINT fk_project_id FOREI
hey i hve created a table
CREATE TABLE video_tab (video_id INTEGER, project_id INTEGER, video_path
VARCHAR(100), video_length INTEGER, video_type VARCHAR(10), video_size
VARCHAR(10), CONSTRAINT video_pk PRIMARY KEY(video_id, project_id),
CONSTRAINT fk_project_id FOREIGN KEY (project_id) REFERENC
On 5/06/2009 5:27 PM, Francis GAYREL wrote:
> To build a consistent oriented tree we need to associate to the nodes a
> ranking property such as the birthdate (or any precedence criterion).
> Therefore the ancestor of someone is to be selected among older ones.
"Ancestor" is a *derived* relati
Hello Martin,
it's a db than an user sent me... so I really don't know...
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Jun 5, 2009, at 11:31 AM, Martin Engelschalk wrote:
> Hi Marco,
>
> How do you insert this data into your database?
> I opened your databas
Hi Marco,
How do you insert this data into your database?
I opened your database with an old version of SQLiteSpy, which uses an
even older version of sqlite. It showed the value as a blob.
Martin
Marco Bambini wrote:
> I understand that the issue could be caused by the wrong datatype...
> but
I understand that the issue could be caused by the wrong datatype...
but what is strange is that the same db and the same query worked fine
with sqlite 3.4.2 and the behavior changed with sqlite 3.6.x
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Jun 5, 200
Your field value is a blob, so you have to use a cast like you did to
find the row, or use a blob literal:
SELECT * FROM lo_user WHERE lo_name=X'61646d696e';
Marco Bambini wrote:
> I just posted the db on my website... there is one row and there
> aren't invisible characters.
>
> Please note
Maybe don't use varchar, but text instead when creating the table.
RBS
> I just posted the db on my website... there is one row and there
> aren't invisible characters.
>
> Please note that the following query returns the exact row:
> SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin';
>
I just posted the db on my website... there is one row and there
aren't invisible characters.
Please note that the following query returns the exact row:
SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin';
but I really don't have an explanation...
--
Marco Bambini
http://www.sqlabs.com
h
Hi,
attachments do not make it through the list.
There is no row with the value 'admin' in the field 'lo_name' in your
table. Did you check that there are no blank spaces or other invisible
characters?
Martin
Marco Bambini wrote:
> Anyone can please explain me why this query:
> SELECT * FROM l
You can download the db from:
http://www.sqlabs.com/download/test.sqlite
It's only 4KB.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Jun 5, 2009, at 11:04 AM, Marco Bambini wrote:
> Anyone can please explain me why this query:
> SELECT * FROM lo_user WHERE lo
Anyone can please explain me why this query:
SELECT * FROM lo_user WHERE lo_name='admin';
returns 0 rows in this db?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
___
sqlite-users mailing list
sqlite-users@sq
Thank you very much!
you told me how to do. but I missed the "... defined as UNIQUE ...".
Actually my question is just solved by two step:
First - CREATE UNIQUE INDEX i_recdata ON rec_data (num, di, time1);
Second - INSERT OR REPLACE INTO rec_data (num, di, data, time1, time2,
format) VALUES
I have a problem inserting data through a view.
This is my DB:
CREATE TABLE data (
id BLOB PRIMARY KEY,
created REAL NOT NULL
);
CREATE VIRTUAL TABLE text USING FTS3();
CREATE VIEW data_view AS
SELECT d.id, d.rowid, d.created, t.content
FROM data d INNER JOIN text t ON d.row
To build a consistent oriented tree we need to associate to the nodes a
ranking property such as the birthdate (or any precedence criterion).
Therefore the ancestor of someone is to be selected among older ones.
To make the ancestor allocation more easy the ancestor's list may be
filtered on
33 matches
Mail list logo
