Re: [sqlite] Do people think of SQLite as a file or as a database

On Wed, Jul 15, 2009 at 07:11:51PM -0700, CadMapper wrote: > > This is not a technical question about SQLite. I want to you how people in > general think about SQLite. Is that a file or a database? When you talk > about it, do you refer to it as file or database? It's a database. It happens

Re: [sqlite] Do people think of SQLite as a file or as a database

It's possible that the question was referring to this statement in the About page on sqlite.org: "SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL

Re: [sqlite] Do people think of SQLite as a file or as a database

On Wed, 15 Jul 2009, CadMapper wrote: > This is not a technical question about SQLite. I want to you how people > in general think about SQLite. Is that a file or a database? When you > talk about it, do you refer to it as file or database? Neither. It is a database management system used to

[sqlite] Do people think of SQLite as a file or as a database

This is not a technical question about SQLite. I want to you how people in general think about SQLite. Is that a file or a database? When you talk about it, do you refer to it as file or database? Thanks for your input in advance! -- View this message in context:

[sqlite] Load a database stored into memory?

Hi, I'm using http://www.wischik.com/lu/programmer/zip_utils.html this class to unzip a database, but there is an option to store it directly into memory (Example 3). Can I access it using the function "sqlite3_open"? -- View this message in context:

[sqlite] FTS3 *_content tables (do I really need them?)

Dear all,   a few weeks ago, I asked the question below but did not get any response on it. A few minutes ago,  I found a remark (cf.  http://osdir.com/ml/freedesktop.tracker/2008-07/msg00085.html)  that it might be possible to avoid the "redundant" storage of document information in the fts

Re: [sqlite] Database corrupt.

On Wed, 15 Jul 2009 08:29:15 +0200, Denis Gottardello wrote: >I have many cases of database corruption. >May depend on what? It shouldn't happen if you use it correctly. This page is worth reading: http://www.sqlite.org/atomiccommit.html Please tell us the

Re: [sqlite] Optimizing insert or replace speed

Also, very good. No index on Delta File: 3 seconds. Index on SN: 4 seconds. Index on MasterList (write_out_ok, MFGID, TypeID, SN); 4 seconds. Time is to the nearest second in my test program, so I can't distinguish between the two. In summary: /*FAST */ insert or replace into

Re: [sqlite] Optimizing insert or replace speed

Adam DeVita wrote: > I've identified the following query as a bottle neck in a utility I've > written. > > insert or replace into main.masterlist select * from delta.masterlist > d where d.write_out_ok=0 and > d.sn not in(select M.sn from main.masterlist M where > M.record_updatetime >

[sqlite] Feature request: GiST index

Hello! There are a lot of tasks where GiST index is needed. Does exists any plans to implement this? Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How to create a table that has a field that can hold a 64-bit interger

2009/7/15 Dieter Dasberg : > Hello, > . . . > > This > > create table test (Afield INTEGER) > > leads always to a data-size of 4 byte, What makes you think this? See http://www.sqlite.org/datatype3.html > what I need is a data-size of 8 byte. > > What can I do? > > Best

Re: [sqlite] Announce of the new "Versioning" extension

Hello! On Wednesday 15 July 2009 09:56:28 Neville Franks wrote: > Hi Alexey, > Thank you for this extension which could be quite interesting to many > SQLite users. Is there any documentation on this available, possibly > in your new book? I couldn't find any with the source at >

[sqlite] How to create a table that has a field that can hold a 64-bit interger

Hello, I am using the SQLite3.dll with Delphi 2007 for development. I try to create a table with an integer field, that can hold 64-bit integer values. I read and searched a lot of the archives, also googled around a good time, but I did not find a hint. This create table test

Re: [sqlite] Announce of the new "Versioning" extension

Hi Alexey, Thank you for this extension which could be quite interesting to many SQLite users. Is there any documentation on this available, possibly in your new book? I couldn't find any with the source at http://mobigroup.ru/files/sqlite-ext/ Also you have used the GNU License which means we

[sqlite] Database corrupt.

I have many cases of database corruption. May depend on what? Someone using sqlite in multi thread environment? -- Denis Gottardello Sintesi S.r.l. ___ sqlite-users mailing list sqlite-users@sqlite.org