On 3/29/07, Xavier RAYNAUD <[EMAIL PROTECTED]> wrote:
I currently use this one:
http://www.zentus.com/sqlitejdbc/
o The nestedVM will work for both windows and linux, but you will loose
performance.
o The native JNI libraries are faster, but do not work for both windows
and linux.
I have
Thank you both... I'll be looking at those...
Joel
On 3/29/07, Griggs, Donald <[EMAIL PROTECTED]> wrote:
Hi Joel,
Have you already looked at:
http://www.sqlite.org/pragma.html#schema
(as well as sqlite_master as mentioned earlier)
-Original Message-
From: Joel Cochran
Hi Joel,
Have you already looked at:
http://www.sqlite.org/pragma.html#schema
(as well as sqlite_master as mentioned earlier)
-Original Message-
From: Joel Cochran [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 29, 2007 1:55 PM
To: sqlite-users@sqlite.org
Subject: [sqlite]
Ahh, sorry about that stack. It's not actually a trashed call stack. The
variables are not accurate here because it is an optimized build's call stack.
The reason I included it was merely to show the function-call-stack, which is
accurate.
From: Dave Gierok
On 3/29/07, Joel Cochran <[EMAIL PROTECTED]> wrote:
Hi all,
Is there a way (through SQL) to retrieve metadata about an SQLite database?
Specifically I would like to find lists of tables, indexes, views, and table
schema.
http://www.sqlite.org/faq.html#q9
--
Puneet Kishor
Hi all,
Is there a way (through SQL) to retrieve metadata about an SQLite database?
Specifically I would like to find lists of tables, indexes, views, and table
schema.
Thanks,
--
Joel Cochran
Dave Gierok <[EMAIL PROTECTED]> wrote:
> I'm getting a very occational crash in prepSelectStmt when
> trying to run the following statement:
>
> CREATE TABLE tmpdb.[Profile0_Career_UnlockedCars] AS SELECT * FROM
> [Profile0_Career_UnlockedCars];
>
> My call stack is:
>
> *
I'm getting a very occational crash in prepSelectStmt when trying to run the
following statement:
CREATE TABLE tmpdb.[Profile0_Career_UnlockedCars] AS SELECT * FROM
[Profile0_Career_UnlockedCars];
Where another tmpdb has been attached to the main db via ATTACH.
My call stack is:
*
On 3/29/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
On Thu, 29 Mar 2007, Jonas Sandman wrote:
> I guess I could split it into more tables, but would that really make
> anything faster?
It would make upgrades, changes, and searching faster.
> The whole key is the filename, I query for
On Thu, 29 Mar 2007, Jonas Sandman wrote:
I guess I could split it into more tables, but would that really make
anything faster?
It would make upgrades, changes, and searching faster.
The whole key is the filename, I query for files in specific filepaths, so
it doesn't matter if something
Xavier RAYNAUD <[EMAIL PROTECTED]> writes:
> I use native JNI libraries, and choose at runtime the native library
> to open. (on eclipse, with OS-dependant fragments, it's easy to do)
Can you elaborate on how you make this selection, and how you package
the fragment?
--
Steven E. Harris
Igor Tandetnik wrote:
Kostas5904 wrote:
But...
When I ask a value from the user and I try to store it into the same
table,
I run the following code
item=dialog.GetValue()
table="names1"
cols="id,descr,type"
values=("null",item,3)
a="insert into %s
I should add that I am scanning a folder-tree for the files and are storing
the metadata in the database like that so I don't have to read the actual
files. That's why I used the path as primary key to begin with. No duplicate
entries.
On 3/29/07, Jonas Sandman <[EMAIL PROTECTED]> wrote:
On
On Thu, 29 Mar 2007, Jonas Sandman wrote:
I am quite new at database and how to set them up properly so keep in mind
that the obvious might stare into your face but just point it out to me
Jonas,
I strongly recommend that you read a book on database design. You have a
single, flat-file
Kostas5904 wrote:
But...
When I ask a value from the user and I try to store it into the same
table,
I run the following code
item=dialog.GetValue()
table="names1"
cols="id,descr,type"
values=("null",item,3)
a="insert into %s (%s) values %s" %
Hello again,
I am quite new at database and how to set them up properly so keep in mind
that the obvious might stare into your face but just point it out to me :-)
I am having this database with mediafiles (even anyone recall my previous
mails) and I create it like this:
CREATE TABLE Files
At 16:20 29/03/2007, you wrote:
>Eduardo Morras <[EMAIL PROTECTED]> wrote:
>> Hello:
>>
>> I'm trying to use altivec simd code to SQLite. Has read hash.c
>> but it looks like hashing is done one by one when insert data.
>> Is it true? When is called rehash function? If i insert data with
>>
sorry hit send by accident this should be:
CREATE TRIGGER sync_child_with_parent_update
BEFORE UPDATE ON parent
FOR EACH ROW BEGIN
UPDATE child
SET
field_name_a = NEW.field_name_a,
field_name_b = NEW.field_name_b,
field_name_c = NEW.field_name_c,
Hi, everybody. I am new in Python and Sqlite and I have a problem when I'm
using unicode strings. Actually I'm working with WxPython and pysqlite (to
connect to sqlite).
The problem is as follows:
When I execute this:
cursor.execute('INSERT INTO names1 (id,decr,type)
CREATE TRIGGER sync_child_with_parent_update
BEFORE UPDATE ON parent
FOR EACH ROW BEGIN
UPDATE child
SET
field_name_a = NEW.field_name_a,
field_name_b,
field_name_c)
VALUES
(NEW.field_name_a,
NEW.field_name_b,
NEW.field_name_c);
I think using triggers would be a good solution:
You good just trigger on inserts and updates to parent
and do whatever you like to child.
Example:
CREATE TRIGGER sync_child_with_parent_insert
BEFORE INSERT ON parent
FOR EACH ROW BEGIN
INSERT INTO child
(field_name_a,
Eduardo Morras <[EMAIL PROTECTED]> wrote:
> Hello:
>
> I'm trying to use altivec simd code to SQLite. Has read hash.c
> but it looks like hashing is done one by one when insert data.
> Is it true? When is called rehash function? If i insert data with
> index i think hashing happens one by one,
At 11:27 29/03/2007, you wrote:
>Hello:
>
> I'm trying to use altivec simd code to SQLite. Has read hash.c but it looks
> like hashing is done one by one when insert data. Is it true? When is called
> rehash function? If i insert data with index i think hashing happens one by
> one, but if i
fangles wrote:
When I have text pasted into an sqlite string field, it is stored okay but
when I retrieve a string, it is truncated at the first CR (0D).
Hi fangles,
Did you get this sorted?
Martin
-
To unsubscribe,
On 3/29/07, Ludvig Strigeus <[EMAIL PROTECTED]> wrote:
Hi,
I'm looking at using Sqlite as a storage backend for a program. Using SQL is
a little bit overkill and much more than we need. How complicated would it
be to interface to the btree subsystem directly? Sqlite seems very modular
from the
On 3/29/07, Arora, Ajay <[EMAIL PROTECTED]> wrote:
Thanks for your reply.
I'm writing my application in Perl using SQLite as file based database.
Multiple users would be accessing the database simultaneously.But I'll
lock the file prior to any updations to the database. I'm planning to
use a
[EMAIL PROTECTED] wrote:
Martin Jenkins <[EMAIL PROTECTED]> wrote:
Very true. Furthermore, the B-Tree interface layer is not a part
of the published API and as such it is subject to change without
notice and between point releases.
I nearly said that the B-Tree interface was unpublished
Martin Jenkins <[EMAIL PROTECTED]> wrote:
> Ludvig Strigeus wrote:
> > Hi,
> >
> > I'm looking at using Sqlite as a storage backend for a program. Using
> > SQL is a little bit overkill...
>
> ... I reckon learning that SQL would be a lot easier than
> learning to use and/or coding against the
John,
Thanks for the useful info. Unfortunately it sounds as if this is more
than I have time for right now.
Stephen
On Wed, 2007-03-28 at 16:29 -0600, John Stanton wrote:
> Perl would not do a good job. You need to use the Sqlite page
> structures and they are defined in C terms.
>
> If
Arora, Ajay wrote:
Can anyone please look into my query,
I've tables
Master ( id integer primary key,
field1 text)
And
Child (id integer, name text)
Might be worth looking for Celko's "Hierarchies in SQL". I've not read
it but I've seen good reviews and Celko seems well
John Stanton wrote:
Perl would not do a good job. You need to use the Sqlite page
structures and they are defined in C terms.
But Tcl might. The test suite pokes about with SQLite internals.
Martin
-
To unsubscribe,
Hello:
I'm trying to use altivec simd code to SQLite. Has read hash.c but it looks
like hashing is done one by one when insert data. Is it true? When is called
rehash function? If i insert data with index i think hashing happens one by
one, but if i insert all data and after that make an
Hi,
I'm looking at using Sqlite as a storage backend for a program. Using SQL is
a little bit overkill and much more than we need. How complicated would it
be to interface to the btree subsystem directly? Sqlite seems very modular
from the looks of it, but has anyone attempted anything like this
Hi Jim,
Jim Dodgen a écrit :
Hello,
first off I am not a java guy. I'm a perl C guy.
I am getting involved in a upcoming project that needs a java wrapper that will
work for both windows and linux.
Any preferences?
I currently use this one:
http://www.zentus.com/sqlitejdbc/
o The
34 matches
Mail list logo