Re: [sqlite] Database File Structure

On Sun, 2005-02-27 at 22:54 -0500, Robert L Cochran wrote: > Is there a published file > structure for the database? > The header comment to the btree.c source file. http://www.sqlite.org/cvstrac/getfile/sqlite/src/btree.c -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Any Plan for Supporting sqlite3_exec16 in near future

On Sun, 2005-02-27 at 22:37 -0400, [EMAIL PROTECTED] wrote: > Hi All, > > Anyone have idea when sqlite will support sqlite3_exec16. Since > sqlite3_exec return important error information for the execution error. > Supporting exec16 is urgent for unicode application. > The implementation of

[sqlite] Database File Structure

I've been fooling with 3.1.3 tonight and hex dumped one of my database files: [EMAIL PROTECTED] itemlist]$ hexdump -C -n 16 wishlist 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 |SQLite format 3.| 0010 Only the first 16 bytes are shown here. Is there a published file

RE: [sqlite] Version 3.1.3 is a headache

> The last one is really annoying and I can't believe the > auto-tests could have missed it ... > >create table a (id, x); >create table b (id, y); >insert into a values (1,1); >insert into b values (1,2); >select * from a inner join b; > > column names returned:

[sqlite] Any Plan for Supporting sqlite3_exec16 in near future

Hi All, Anyone have idea when sqlite will support sqlite3_exec16. Since sqlite3_exec return important error information for the execution error. Supporting exec16 is urgent for unicode application. Ming

Re: [sqlite] numbering ?

http://www.sqlite.org/faq.html#q1

Re: [sqlite] sqlite performance variationin linux and windows

On Sun, 2005-02-27 at 15:31 -0500, Clay Dowling wrote: > > > >Anyone using other compiler to build sqlite on Windows ? Maybe Borland ? > >I seems there is a lot o room for faster sqlite.dll by using other > >compiers than VC++ 6. We can run some tests to see which is faster ... > > > I thought I

[sqlite] in-memory database and threads

Hello sqlite-users, If using an in-memory database, do the possible db corruption problems when using multiple threads go away and can the same db handle returned from the sqlite3_open call in the main thread be used by the worker threads? If not would it help to use mutexes to syncronize

[sqlite] in-memory database and threads

Hello sqlite-users, If using an in-memory database, do the possible db corruption problems when using multiple threads go away and can the same db handle returned from the sqlite3_open call in the main thread be used by the worker threads? If not would it help to use mutexes to syncronize

Re: [sqlite] database encryption

Olivier Singla wrote: This said, I was wondering if anybody would like to share with me his/her experience with this extension. Also, any other solution available ? You might want to read the SQLite web site pages about support. Dr. Hipp offers an encrypted version of the database in exchange for

Re: [sqlite] sqlite performance variationin linux and windows

Ionut Filip wrote: Hi, So the VC++ 7.1 dll is much faster than the VC++ 6, up to 20% in some operations, and the "MS mixed dll load bug" is not a problem, assuming sqlite doesn't mix native code with managed .net code :). Anyone using other compiler to build sqlite on Windows ? Maybe Borland ? I

Re: [sqlite] Version 3.1.3 is a headache

Jakub Adamek wrote: select * from a inner join b; Just as a general guide with any database system, this type of query isn't particularly recommended because of the namespace issue. Here's what I do to get around the problem (again, not just with SQLite): 1. Specify the criteria for the join

[sqlite] in memory database threads

Hello sqlite-users, If using an in-memory database, do the possible db corruption problems when using multiple threads go away and can the same db handle returned from a sqlite3_open call in the main thread to the worker threads? If not would it help to use mutexes to syncronize access to the db

Re: [sqlite] lobjc

Ulrik Petersen wrote: I have a copy of libobjc.a in cygwin/lib/mingw and copied it to c:/dev-cpp/lib/gcc/mingw32/3.4.2 as lobjc.a but this is not working Unless your Cygwin version of libobjc.a is exactly the same as the one that comes with dev-c++, I suspect this may not be a good idea.

[sqlite] numbering ?

Q. Lets say: I have a Field called: CoID (AKA: company id) and when I create a new Table called Company want to have the following: CoID ( But when creating this field ) WHAT statement would define it, to auto number by one and lock that number ) don't want any to change the CoID # that has been

Re: [sqlite] database encryption

Hi, Olivier Singla wrote: Hi, I am planning to use sqlite in a PowerPC embedded device (using of course Linux). So far I am extremely happy (and impressed!) by sqlite. The only thing I think I am missing is a way to protect the database (not only the data by themself, but also the database

RE: [sqlite] Version 3.1.3 is a headache

The fact is, the pragmas regarding column names now seem completely broken, as they do absolutely nothing. Was this by design, or a new bug ? -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 1:08 AM To: sqlite-users@sqlite.org Subject:

[sqlite] database encryption

Hi, I am planning to use sqlite in a PowerPC embedded device (using of course Linux). So far I am extremely happy (and impressed!) by sqlite. The only thing I think I am missing is a way to protect the database (not only the data by themself, but also the database schema). There is a project

RE: [sqlite] sqlite performance variationin linux and windows

Hi, So the VC++ 7.1 dll is much faster than the VC++ 6, up to 20% in some operations, and the "MS mixed dll load bug" is not a problem, assuming sqlite doesn't mix native code with managed .net code :). Anyone using other compiler to build sqlite on Windows ? Maybe Borland ? I seems there is a