[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 (Af

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 > http://mobigroup.

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 regards, > > Dieter SQLi

[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 http://sqlite.org:8080/cgi-bin/mailman/listi

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 > d.record_upd

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 main.masterlist

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 sqlite version, operation system, wr

[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 *_con

[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: http://www.nabble.com/Load-a-database-store

[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: http://www.nabble.com/Do-peo

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

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 datab

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 t