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
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.
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
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
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
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
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
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
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
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
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
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
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
13 matches
Mail list logo