AW: [sqlite] Problems with Multi-Threaded Application.

I would suggest using a queue approach. Its not as bad as it sounds. Have that queue processed by a single thread, which controls the database writes. That way you can save the time for other operations, such as database open/close etc. You can't avoid the "can't read while writing" though.

AW: [sqlite] Binary compatibility

How does sqlite recognize a boolean value ? Does sqlite know that bool , Bool , boolean ... are booleans ? Thank's Henri -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 31. Mai 2006 15:04 An: sqlite-users@sqlite.org Betreff: Re: [sqlite]

AW: [sqlite] Re: ACID for attached databases

thank you, that is exactly what I searched for. Best Martin - Ursprüngliche Mail Von: Igor Tandetnik <[EMAIL PROTECTED]> An: SQLite Gesendet: Montag, den 22. Mai 2006, 15:03:03 Uhr Betreff: [sqlite] Re: ACID for attached databases Martin Pfeifle <[EMAIL

Re: AW: AW: [sqlite] Re: spatial sqlite anyone ?

tag, den 19. Mai 2006, 09:38:13 Uhr Betreff: Re: AW: [sqlite] Re: spatial sqlite anyone ? Martin Pfeifle wrote: Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index d

Re: AW: [sqlite] Re: spatial sqlite anyone ?

Martin Pfeifle wrote: Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index data in relations and index these relations by B-trees. In this case, you do not have to change

Re: AW: AW: [sqlite] Re: spatial sqlite anyone ?

use to avoid one by one select ? Do you have any pointer for that ? Then again you can use ordinary SQL. - Ursprüngliche Mail Von: Noel Frankinet <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Gesendet: Donnerstag, den 18. Mai 2006, 09:50:56 Uhr Betreff: Re: AW: [sqlite] Re: s

AW: AW: [sqlite] Re: spatial sqlite anyone ?

etreff: Re: AW: [sqlite] Re: spatial sqlite anyone ? Martin Pfeifle wrote: >Hi, >I think the simplest solution would be to put a spatial index on top of the >B-tree, that's what e.g. Oracle does in their Spatial Cartridge. >Basically you store the index data in relations and ind

Re: AW: [sqlite] Re: spatial sqlite anyone ?

Martin Pfeifle wrote: Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index data in relations and index these relations by B-trees. In this case, you do not have to change

AW: [sqlite] Re: spatial sqlite anyone ?

Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index data in relations and index these relations by B-trees. In this case, you do not have to change the core code of SQLite.

Re: AW: [sqlite] spatial sqlite anyone ?

Martin Pfeifle wrote: I am very interested. We are working on spatial sqlite for almost one year. We plan to include sqlite into an embedded spatial application. You mention that there are open-source code for library 3 and 4. Can you give me a hint where to find it? I will contact you at the

AW: [sqlite] spatial sqlite anyone ?

I am very interested. We are working on spatial sqlite for almost one year. We plan to include sqlite into an embedded spatial application. You mention that there are open-source code for library 3 and 4. Can you give me a hint where to find it? I will contact you at the end of the week providing

Re: AW: [sqlite] Direct use of SQLite btree functions / performan ce

Chris Werner <[EMAIL PROTECTED]> wrote: > OK, I'll bite: How do we get SQLite ver 4? > > Is there a CVS Tag I am missing? > You misunderstand. There is no SQLite v4. What I was saying is that the requested change (pagable blobs) would require an incompatable file format change, which would

RE: AW: [sqlite] Direct use of SQLite btree functions / performan ce

OK, I'll bite: How do we get SQLite ver 4? Is there a CVS Tag I am missing? Good work by the way! Christian Werner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:33 AM To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] Direct

Re: AW: [sqlite] Direct use of SQLite btree functions / performance

[EMAIL PROTECTED] wrote: > Maybe I'm missing something here, but there should be an interface to page a > blob into memory. Especially for large blobs, this would make sense to me to > not load them into memory at once. > > If sqlite doesn't provide this already, it would probably make a lot of

Re: AW: [sqlite] primary key and physical data organization

Martin Pfeifle wrote: Thanks, If we look at a B+-tree, all records are stored at the leaf level and form at least a logical list. But what happens, if we insert new records which do not fit on the corresponding leaf page any more. Assume this page has to be split. Where is the newly created

Re: AW: [sqlite] primary key and physical data organization

Martin Pfeifle <[EMAIL PROTECTED]> wrote: > Our goal is that all records are physically clustered according to their RO= > WID. > In order to achieve this goal, does it make sense to reorganize a table by = > for instance a command like > "insert into reorganized_table > select * from

AW: [sqlite] primary key and physical data organization

Thanks, If we look at a B+-tree, all records are stored at the leaf level and form at least a logical list. But what happens, if we insert new records which do not fit on the corresponding leaf page any more. Assume this page has to be split. Where is the newly created physical page stored?

AW: [sqlite] primary key and physical data organization

That's great thank you very much. - Ursprüngliche Mail Von: [EMAIL PROTECTED] An: sqlite-users@sqlite.org; Martin Pfeifle <[EMAIL PROTECTED]> Gesendet: Mittwoch, den 5. April 2006, 23:09:25 Uhr Betreff: Re: [sqlite] primary key and physical data organization Martin Pfeifle <[EMAIL

Re: AW: [sqlite] [ANN] SQLite ODBC driver version 0.67

[EMAIL PROTECTED] wrote: > > Hi, > > I just would like to point out that: > > - a zip-archive for the drivers ("no-install") is not provided That was my intention; is the ZIP version really necessary ? > - the documentation for sqliteodbc.c / sqliteodbc.h is missing Ditto, since SQLite

AW: [sqlite] [ANN] SQLite ODBC driver version 0.67

Hi, I just would like to point out that: - a zip-archive for the drivers ("no-install") is not provided - the documentation for sqliteodbc.c / sqliteodbc.h is missing Regards, Michael -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von

Re: AW: [sqlite] Bad performance with large joins?

Jim Dodgen <[EMAIL PROTECTED]> wrote: > > 2. get the optimizer to ignore indexes that I know cannot help > >I do this in the where clause, by adding a zero or concatenating a "" > depending upon the data type > > examples: > > where sex = "M" > changed to > where sex||"" = "M"

Re: AW: [sqlite] Bad performance with large joins?

As has been stated in the past SQLite is a small foot print RDBMS, one of the things keeping it small is that it does not have a large query optimizer. One of the things that can happen is if you have lots of indexes the optimizer may pick something non optimum My tricks are as follows: 1.

Re: AW: [sqlite] Bad performance with large joins?

"Christian Schwarz" <[EMAIL PROTECTED]> writes: >> Practically one such line for each table and each column. > > Why on each column? I just took the existing DB-import-script from that project. But ... > For example, when your where-clause contains columns A, B and C (in > this order) you

AW: [sqlite] Bad performance with large joins?

> >> > Have you tried creating indexes on your rows. > >> > [..] > >> > I suggest you add indexes on text_val > >> > >> Yes. I use > >> > >> create index text_val_idx on geodb_textdata(text_val); > >> > > > > This index seems pretty useless. You're querying against > > geodb_textdata.loc_id and

Re: AW: [sqlite] Bad performance with large joins?

"Christian Schwarz" <[EMAIL PROTECTED]> writes: >> > Have you tried creating indexes on your rows. >> > [..] >> > I suggest you add indexes on text_val >> >> Yes. I use >> >> create index text_val_idx on geodb_textdata(text_val); >> > > This index seems pretty useless. You're querying against >

AW: [sqlite] Bad performance with large joins?

> > Have you tried creating indexes on your rows. > > [..] > > I suggest you add indexes on text_val > > Yes. I use > > create index text_val_idx on geodb_textdata(text_val); > This index seems pretty useless. You're querying against geodb_textdata.loc_id and geodb_textdata.text_type. So you

AW: [sqlite] Vacuum slow

-Ursprüngliche Nachricht- Von: Jay Sprenkle [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. März 2006 17:21 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Vacuum slow > But I wonder : > > if I have a db ~ 1gb and I delete all the data in the tables ( db is > than nearly empty )

AW: [sqlite] sqlite and index

hi dennis now it works. thanks as lot for your help. klaus -Ursprüngliche Nachricht- Von: Dennis Cote [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 25. Januar 2006 20:50 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] sqlite and index Klaus Schären wrote: >Hi > >i have the

Re: AW: [sqlite] DELETE Statements

Hello Daniel, So, sqlite3_exec() returns no error status or message? How are you generating the SQL query? What happens if you type the exact same command in Sqlite3.exe? Your method should work, I use Exec to create and drop tables without any callback functions. My guess is the query is just

AW: [sqlite] DELETE Statements

Hello, Thanks for your answer. > sqlite3_prepare() > sqlite3_step() > sqlite3_finalize() I tried to do this, but nothing happend. I passed the SQL Statement to the prepare function and sqlite3_stmt to the step and the finalize function. The prepare function returns SQLITE_DONE and the prepare

AW: [sqlite] Looking for source sqlite-3.0.7.tar.gz

Thanks. I also downloaded a 3.0.8 but that didn't work. I did receive a 3.0.7 version today. Ciao Sami > -Ursprüngliche Nachricht- > Von: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 21. November 2005 19:32 > An: sqlite-users@sqlite.org; [EMAIL PROTECTED] > Betreff: Re:

Re: AW: [sqlite] and , or

Martin Engelschalk wrote: The problem seems to be that sqlite makes a difference between an empty string and a null value. s/sqlite/SQL/ The SQL standards all say that nulls never compare equal to anything, not even other nulls. SQLite's behavior here is the correct one.

Re: AW: [sqlite] and , or

Martin Engelschalk wrote: Hi all, The problem seems to be that sqlite makes a difference between an empty string and a null value. Therefore, your query has to check both. In Oracle (and problaby others) the datatype "Varchar2" can be used to treat an empty string as a null value. Does

Re: AW: [sqlite] and , or

Hi all, The problem seems to be that sqlite makes a difference between an empty string and a null value. Therefore, your query has to check both. In Oracle (and problaby others) the datatype "Varchar2" can be used to treat an empty string as a null value. Does anyone know if there is a way

Re: AW: [sqlite] and , or

On Wed, 19 Oct 2005 09:59:49 +0200, "Eggert, Henri" <[EMAIL PROTECTED]> wrote: > What I need is a select statement which returns both. try select Id from Data where (coalesce(text,'') = '') and (coalesce(comming,'') = ''); klint. +---+-+ :

AW: [sqlite] and , or

Sorry , I was not clear enough. Considere the following : create table t1 ( a integer , b text , c text ) ; insert into t1 ( a , b , c ) values ( 1 , 'a' , 'b' ) ; insert into t1 ( a , b , c ) values ( 2 , 'c' , '' ) ; insert into t1 ( a , b , c ) values ( 3 , '' , 'd' ) ; insert into t1 ( a ,

Re: AW: [sqlite] and , or

> Hi Henri, > > On 18.10.2005, at 14:56, Eggert, Henri wrote: > > > I have found that the problem is the column name "Text". > > If I replace the column name "Text" by another all works fine. > > So I wonder : is "Text" a keyword for sqlite ? > > > > It indeed is [1]. :) > > > -Markus > > [1]

Re: AW: [sqlite] and , or

Hi Henri, On 18.10.2005, at 14:56, Eggert, Henri wrote: I have found that the problem is the column name "Text". If I replace the column name "Text" by another all works fine. So I wonder : is "Text" a keyword for sqlite ? It indeed is [1]. :) -Markus [1]

Re: AW: [sqlite] and , or

> Hi, > > I want to select the records which have both columns Text and Comming > empty. > > I have found that the problem is the column name "Text". > If I replace the column name "Text" by another all works fine. > So I wonder : is "Text" a keyword for sqlite ? Why do you wonder? You used it

AW: [sqlite] and , or

Hi, I want to select the records which have both columns Text and Comming empty. I have found that the problem is the column name "Text". If I replace the column name "Text" by another all works fine. So I wonder : is "Text" a keyword for sqlite ? Thank's Henri -Ursprüngliche

AW: [sqlite] Views over multiple tables and conditional selection (ticket #1134)

> Us an "AS" clause on each result column of the view in order to > assign the specific name you want to that column. That works. Many thanks! Regards, Christian

AW: [sqlite] Case-sensitive table names

Sorry, I was a little bit unclear. My problem is that I have the need to treat "table1" and "TABLE1" as two single entities. ivo -Ursprüngliche Nachricht- Von: Austin Ziegler [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 28. September 2005 16:21 An: sqlite-users@sqlite.org; [EMAIL

RE: AW: [sqlite] VB6 question

05:22 To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] VB6 question I am using SQLite Plus sucessfully Ray Borror Gregory Letellier wrote: all the wrapper ar for 2.8 and i wan't use the 3.0 anyone known 3.0 wrapper ? Steve O'Hara a écrit : >Don't want to dampen your enthusiasm for t

RE: AW: [sqlite] VB6 question

How does a C++ wrapper help someone using VB6? Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of RAY BORROR Sent: 29 July 2005 05:22 To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] VB6 question I am using SQLite Plus sucessfully Ray

Re: AW: [sqlite] VB6 question

to resort to some OS calls to unravel that). > >Use one of the wrappers. > >Steve > > > > > > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] >rg]On Behalf Of Gregory Letellier >Sent: 27 July 2005 11:17 >To: sqlite-users@

RE: AW: [sqlite] VB6 question

for the DLL I'll send it anyone that's interested. Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Gregory Letellier Sent: 28 July 2005 13:02 To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] VB6 question all the wrapper ar for 2.8 and i wan't use

Re: AW: [sqlite] VB6 question

PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Gregory Letellier Sent: 27 July 2005 11:17 To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] VB6 question Ok Thank's for your help i will trying this !!! [EMAIL PROTECTED] a écrit : Hi, unfortunately this has to do with the C calling

RE: AW: [sqlite] VB6 question

-users@sqlite.org Subject: Re: AW: [sqlite] VB6 question Ok Thank's for your help i will trying this !!! [EMAIL PROTECTED] a écrit : >Hi, > >unfortunately this has to do with the C calling convention used by sqlite3.dll. By default DLLs compiled with C have the cdecl calling conventio

Re: AW: [sqlite] VB6 question

Ok Thank's for your help i will trying this !!! [EMAIL PROTECTED] a écrit : Hi, unfortunately this has to do with the C calling convention used by sqlite3.dll. By default DLLs compiled with C have the cdecl calling convention, but VB only supports the stdcall calling convention. You must

AW: [sqlite] VB6 question

Hi, unfortunately this has to do with the C calling convention used by sqlite3.dll. By default DLLs compiled with C have the cdecl calling convention, but VB only supports the stdcall calling convention. You must recompile sqlite using MS Visual C++ or other compiler and switch the default

Re: AW: [sqlite] time zone?

On Friday 01 July 2005 08:58 am, [EMAIL PROTECTED] wrote: > Try select time('now', 'localtime'); > Michael that did it! come to think of it .. I don't remember date saying CDT before. Where can I find all of these functions documented? I searched the sqlite docs but didn't find anything. unless

AW: [sqlite] time zone?

Try select time('now', 'localtime'); Michael -Ursprüngliche Nachricht- Von: Stephen Leaf [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 1. Juli 2005 15:47 An: sqlite-users@sqlite.org Betreff: [sqlite] time zone? sqlite> select time('now'); 13:45:20 $ date Fri Jul 1 08:45:37 CDT 2005

AW: [sqlite] Problem with "installing"

Hello :) Thanks for your answer. I'm unsing for my first tests under Windows the Visual C++ Compiler .NET (because this first testprogram should run previously only under windows). Thanks in advance :) Daniel -Ursprüngliche Nachricht- Von: Eugene Wee [mailto:[EMAIL PROTECTED]

AW: [sqlite] bug in ORDER BY ?

Does "select * from mactor order by id desc limit 1" and "select * from mactor order by id limit 1" not work? Greetings, Christian

AW: [sqlite] Plans for SQLite version 3.2

How about adding support to obtain the column type information, when querying views? (I'm refering to the question I posted a couple of days ago.) -Ursprüngliche Nachricht- Von: D. Richard Hipp [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 18. Februar 2005 16:54 An:

AW: [sqlite] How to unite query results from two databases

I didn't even think of the simplest solution... Thanks, Michael -Ursprüngliche Nachricht- Von: Bob Dankert [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 9. Februar 2005 19:53 An: sqlite-users@sqlite.org Betreff: RE: [sqlite] How to unite query results from two databases I havent

RE: AW: [sqlite] sqlite3_column_tablename

What do you want if the user types "SELECT (t0.x || t1.x) FROM table0, table1 ."? I would like to second that request. Ok, sure, there are cases where the info is meaningless (like above), and should be blank. But in most cases, it IS meaningful, and extremely useful for tools (not so much

Re: AW: [sqlite] sqlite3_column_tablename

--- "Plenert, Joerg" <[EMAIL PROTECTED]> wrote: > Yes that function points into the right direction ! > But I need something like that: > > SELECT t0.x as col0, t1.x as col1 from table0 as t0, table1 as t1 where t0.y > = t1.y; > > Now I want the following information about the colums: > >

AW: [sqlite] sqlite3_column_tablename

Yes that function points into the right direction ! But I need something like that: SELECT t0.x as col0, t1.x as col1 from table0 as t0, table1 as t1 where t0.y = t1.y; Now I want the following information about the colums: 1: column name = col0 original column name = x table name =

Re: AW: [sqlite] sqlite3_column_tablename

Hi Joerg, Plenert, Joerg wrote: Hi Ulrik, picture this: A user types a query with output of fields from two ore more tables. Now, before you output the data, you'll check if the user has the right to see the data in the fields. So I check if the columns name is in my "allowed" list. Because two

AW: [sqlite] sqlite3_column_tablename

Hi Ulrik, picture this: A user types a query with output of fields from two ore more tables. Now, before you output the data, you'll check if the user has the right to see the data in the fields. So I check if the columns name is in my "allowed" list. Because two tables may have a column with

Re: AW: [sqlite] Version 3.1.0

Hello, wchar_t is not a 2 byte unicode character. For example, in Mac OS X, wchar_t is 4 bytes. It would be better to define UniChar as 2 byte type. In OS X it is defined as: typedef UInt16 UniChar; where UInt16 is defined (on most, if not all platforms) as: typedef unsigned short UInt16; Tom

AW: [sqlite] Version 3.1.0

You could replace the const void* with wchar_t on conforming compilers (such as MCVC 6+) to simplify unicode development: #if defined(wchar_t) typedef const wchar_t* strw; #else // #if defined(wchar_t) typedef const void* strw; #endif // #if defined(wchar_t) I think this would allow easier usage

Re: AW: AW: [sqlite] SQLite website hacked

Matthias Zirngibl wrote: Arg! "cvs -v" tells me 1.11.5, which is ancient. I've been doing apt-get update apt-get upgrade which I thought was suppose to keep me up to date with all security patches. But I guess not Anonymous CVS access has been disabled until I can get this fixed.

Re: AW: AW: [sqlite] SQLite website hacked

Matthias Zirngibl wrote: Arg! "cvs -v" tells me 1.11.5, which is ancient. I've been doing apt-get update apt-get upgrade which I thought was suppose to keep me up to date with all security patches. But I guess not Anonymous CVS access has been disabled until I can get this fixed.

AW: AW: AW: [sqlite] SQLite website hacked

> apt-upgrade is giving me the following error. Can anyone explain? > > > Setting up util-linux (2.11n-7) ... > dpkg: error processing util-linux (--configure): > subprocess post-installation script returned error exit > status 2 Errors were encountered while processing: > util-linux > E:

Re: AW: [sqlite] SQLite website hacked

D. Richard Hipp wrote: Arg! "cvs -v" tells me 1.11.5, which is ancient. I've been doing apt-get update apt-get upgrade which I thought was suppose to keep me up to date with all security patches. But I guess not For Debian 'woody' the latest cvs is 1.11.1p1, for Debian 'sarge' the

Re: AW: [sqlite] SQLite website hacked

"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > Somebody please instruct me on the proper way to get security > updates for debian Be sure you have the following line in /etc/apt/sources.list and prior to doing "apt-get update ; apt-get upgrade" deb http://security.debian.org/

AW: AW: [sqlite] SQLite website hacked

> Arg! "cvs -v" tells me 1.11.5, which is ancient. I've been doing > > apt-get update > apt-get upgrade > > which I thought was suppose to keep me up to date with all > security patches. But I guess not > > Anonymous CVS access has been disabled until I can get this fixed. > >

AW: [sqlite] SQLite website hacked

> On 25/giu/04, at 17:34, D. Richard Hipp wrote: > > > 3 days ago, somebody broke into the SQLite website and defaced the > > CVSTrac homepage. (www.cvstrac.org and www.sqlite.org > share the same > > machine.) > > You are not alone: >

AW: [sqlite] SQLite 2.8.13. Issues found with SQLite.exe

Hi all, my tests found: Using a file test.sql and decommenting the .commands as required -- + .databases -- + .dump -- + .echo ON -- + .exit -- + .explain -- + .header ON -- + .help -- + .indices table -- + .mode list -- +

<    1   2