ith :
>
> On 2018/06/13 6:35 PM, skywind mailing lists wrote:
>> Hi Ryan,
>>
>> my problem is that I use the "most safest" mode that exists for SQLite and
>> it still fails… Therefore, I need to know why it fails.
>
> Alright, but this implies a ver
Hi Ryan,
my problem is that I use the "most safest" mode that exists for SQLite and it
still fails… Therefore, I need to know why it fails.
Regards,
Hartwig
> Am 2018-06-13 um 01:23 schrieb R Smith :
>
>
> On 2018/06/13 12:21 AM, skywind mailing lists wrote:
>
rs [mailto:sqlite-users-
>> boun...@mailinglists.sqlite.org] On Behalf Of skywind mailing lists
>> Sent: Tuesday, 12 June, 2018 16:06
>> To: SQLite mailing list
>> Subject: [sqlite] How to convert SQL file into database when a column
>> value is Inf?
>>
>>
Hi,
the original database is malformed. So, I cannot access it anymore besides
doing a dump.
Regards,
Hartwig
> Am 2018-06-13 um 00:17 schrieb Bob Friesenhahn :
>
> On Wed, 13 Jun 2018, skywind mailing lists wrote:
>>
>> A workaround is of course to use a text edito
Hi,
when I load my database into sqlite3 and run an integrity check I only get the
error message: Error: database disk image is malformed
I do not get any further information. What causes this simple error message? I
expected to get some more information what is actually the reason why SQLite3
Hi,
I issued the following commands:
echo .dump | sqlite3 Database.sldb > D.sldb
sqlite3 -init D.sldb NewDatabase.sldb
Unfortunately, reading the SQL file produced the following error:
Error: near line 56721: no such column: Inf
The corresponding SQL command is:
INSERT INTO "Flights"
VALUES(36
Hi,
but to which directory should I set it? There is no general tmp directory
accessible.
Regards,
Hartwig
> Am 2018-06-10 um 02:30 schrieb Bob Friesenhahn :
>
> On Sat, 9 Jun 2018, skywind mailing lists wrote:
>
>> Hi,
>>
>> currently I am not creating
edy :
>
> On 06/10/2018 12:00 AM, skywind mailing lists wrote:
>> Hi,
>>
>> what is your experience with temporary files requested by SQLite3 on
>> Android? I am using SQLite3 natively on Android - I compiled SQLite3 by
>> myself - and get an error when
Hi,
what is your experience with temporary files requested by SQLite3 on Android? I
am using SQLite3 natively on Android - I compiled SQLite3 by myself - and get
an error when SQLite3 tries to create temporary files because:
- the directories
/var/tmp
/usr/tmp
/tmp
> by default.
>
> <https://sqlite.org/lang_conflict.html>
> <https://sqlite.org/pragma.html#pragma_recursive_triggers>
>
> On December 23, 2017 7:05:59 AM EST, R Smith wrote:
>>
>>
>> On 2017/12/23 1:57 PM, skywind mailing lists wrote:
>>>
Hello,
I have checked the documentation but did not find an explicit answer concerning
my case. Of course I can test it but this does not mean that the functionality
is guaranteed also for future versions. Assume I have an insertion statement
like
INSERT OR REPLACE INTO TestTable VALUES(1,2);
Hi,
just my few cents: if you are using the RTree module I made very bad
experiences running SQLite in parallel, even when running only two or three
threads in parallel. In this case I use a single thread-safe queue that is
handling all SQLite access.
Regards,
Hartwig
> Am 2017-03-04 um 16:54
Assume I have got a zPath like abc.def passed to mkFullPathname. Inside
mkFullPathname zPath[0] != '/' will evaluate to true. Assume further that
osGetcwd(..) will return '/' (which can actually be the case under Android and
theoretically under other systems as well but probably less likely). In
Thanks!
In the meantime I found out that version 3.8.8.3 is still working while 3.9.0.0
fails.
Regards,
Hartwig
> Am 2016-08-02 um 18:47 schrieb Dan Kennedy :
>
> On 08/02/2016 01:01 PM, skywind mailing lists wrote:
>> HI,
>>
>> it seems to be that I am not allowe
Hi,
I have seen that the branch Apple-OSX is still active. Is there any reason why
the contents of this branch are not merged into trunk? Or is the trunk always
merged into Apple-OSX? What is the best branch to use for OS X / iOS?
Regards,
Hartwig
_
27;Record B1');");
#endif
ExecuteStatement(databaseHandle,"DELETE FROM A WHERE
AnotherID=1;");
ExecuteStatement(databaseHandle,"DELETE FROM B WHERE ID=1;");
ExecuteStatement(databaseHandle,"COMMIT;");
Hi,
I have added a database but it seems to be that the zip file got lost.
Regards,
Hartwig
> Am 2016-08-02 um 01:13 schrieb Richard Hipp :
>
> Do you have a database schema to go with your sample program?
>
> On 8/1/16, skywind mailing lists <mailto:mailingli...@skywind
Hi,
I have got a database that works using SQLite 3.7.7 but not with version SQLite
3.13.0. I get the assertion
Assertion failed: (((Fts3Table *)pVtab)->mxSavepoint < iSavepoint), function
fts3SavepointMethod, file /.../sqlite/sqlite3.c, line 144649.
I have compiled the SQLite amalgamation wit
Hi,
I checked SQLite’s documentation and a bit the internet but it seems to be that
nobody has a definite answer which preprocessor directives have to be used to
compile SQLite for Universal Windows. Without any preprocessor directives the
compilation badly fails (system calls are the problem).
:36 +0200
> skywind mailing lists wrote:
>
>> At the moment I have to run something like:
>>
>> UPDATE A SET item1=(SELECT B.item FROM B WHERE B.ID=A.ID),...
>> itemN=... WHERE EXISTS (SELECT 1 FROM B WHERE B.ID=A.ID);
>>
>> Using a FROM clause I just need on
> Am 2016-06-04 um 15:33 schrieb Gerry Snyder :
>
> If SQLite implemented the FROM it would just be a translation into the
> complex and slow statements you want to avoid.
>
> Gerry Snyder
> On Jun 4, 2016 9:19 AM, "skywind mailing lists"
> wrote:
>
>
Hi,
I am using quite often SQL statements that update the data of one table with
data from another table. This leads to some quite complex (and slow) statements
because SQLite3 is not supporting a FROM clause in update statements. I am just
wondering why the FROM clause is not supported by SQLi
Hi,
according to the documentation this is a slow query for FTS tables:
SELECT * FROM mail WHERE rowid BETWEEN 15 AND 20;
while
SELECT * FROM mail WHERE rowid=15;
is fast.
As far as I know both queries are fast on normal tables. Where is the
difference / what is the reason for the performanc
vin :
>
>
> On 14 Aug 2015, at 4:10pm, skywind mailing lists
> wrote:
>
>> I do not get any error message from SQLite. And the database only gets
>> corrupted when the iDevice has to shut down due to battery issues. I have
>> never had a customer complaining ab
the same application".
>
> Just sayin'.
>
> --
> E
>
>
> On Thu, Aug 13, 2015 at 2:04 PM, Simon Slavin wrote:
>
>>
>> On 13 Aug 2015, at 6:32pm, skywind mailing lists
>> wrote:
>>
>>> Before my app closes I close the database
mon Slavin :
>
>
> On 13 Aug 2015, at 6:32pm, skywind mailing lists
> wrote:
>
>> Before my app closes I close the database explicitly. Though I do not know
>> if this happens always when the iDevice shuts down due to battery issues.
>
> iDevices shut down quite a
Hi,
does anybody have any similar experience that an SQLite database becomes
corrupt on iOS? It seems to be that when the iDevice is running out of battery
it can happen that the SQLite becomes corrupt. I have currently not found a
possibility to reproduce it but once a while my customers exper
Am 07.09.2014 um 21:52 schrieb Simon Slavin :
>
> On 7 Sep 2014, at 7:19pm, Richard Hipp wrote:
>
>> mailingli...@skywind.eu> wrote:
>>
>>> Is it possible to change the fourth parameter in sqlite3_bind_XXX (and
>>> probably other locations) because this seems to be for me the appropriate
>>>
Hello,
I have seen that SQLite uses normally parameters of type "int" to pass the size
of a variable (see sqlite3_bind_blob, fourth parameter). When compiling SQLite3
with Clang and some warnings enabled I get warnings when passing sizeof(...) as
the fourth parameter. The reason is that sizeof(
Hi Clemens,
thanks for the link!
Regards,
Hartwig
Am 22.08.2014 um 22:26 schrieb Clemens Ladisch :
> skywind mailing lists wrote:
>> I hoped that somebody already tried to implement a nearest neighbor
>> algorithm.
>
> Typically, objects are not axis-aligned rectangl
Hello,
I hoped that somebody already tried to implement a nearest neighbor algorithm.
Is the format of the shadow tables somewhere documented or do I have to analyze
the source code?
Regards,
Hartwig
Am 22.08.2014 um 02:58 schrieb Richard Hipp :
> On Thu, Aug 21, 2014 at 8:54 PM, Peter Aronso
Hello,
does anybody have any experience with implementing a nearest neighbor search
using SQLite's RTree functionality? Is a nearest neighbor search possible?
Regards,
Hartwig
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
In
afpUnlock(sqlite3_file *, int)
the sharedLockByte is defined as an int (int sharedLockByte =
SHARED_FIRST+pInode->sharedByte;) although all other related variables and the
following function parameters are defined as unsigned long longs. At least
theoretically this can lead to information
Am 10.12.2013 um 10:59 schrieb Dan Kennedy :
> On 12/10/2013 02:44 PM, skywind mailing lists wrote:
>> This is an example that the ANALYZE command leads to a wrong query plan for
>> RTrees:
>>
>> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude)
This is an example that the ANALYZE command leads to a wrong query plan for
RTrees:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
FromLongitude,TillLongitude);
INSERT INTO A VALUES(1,0,0,0);
INSERT INTO
Am 09.12.2013 um 10:06 schrieb Clemens Ladisch :
> skywind mailing lists wrote:
>> Assume I have the following tables:
>>
>> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
>> CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, Till
Assume I have the following tables:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
FromLongitude,TillLongitude);
and there is an index on A for Latitude,Longitude. B is filled using
INSERT INTO B SELECT
my SQLite code
> and it seems to be working correctly.
>
> Peter
>
> - Original Message
>> From: skywind mailing lists
>> To: General Discussion of SQLite Database
>> Sent: Tue, May 7, 2013 10:46:42 AM
>> Subject: Re: [sqlite] Update statement
>>
>&g
Hi,
my question is: is it guaranteed that it works?
Regards,
Hartwig
Am 07.05.2013 um 03:24 schrieb James K. Lowden:
> On Mon, 6 May 2013 23:53:40 +0100
> Simon Slavin wrote:
>
>>> How do I create this kind of update statement?
>>>
>>> UPDATE T SET a=0.5*(a+b), b=0.5*(b-a);
>>>
>>> The RHS
Hi,
How do I create this kind of update statement?
UPDATE T SET a=0.5*(a+b), b=0.5*(b-a);
The RHS should always be used with the values of a and b before the assignment.
I think that the result of this kind of statement is undefined, or?
Regards,
Hartwig
_
Hi,
why is the above mentioned still open? It seems to be that the bug does not
exist anymore under 3.7.7.
Best regards,
Hartwig
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
11, at 9:19pm, skywind mailing lists wrote:
>
>> A few user have reported that when the iPhone/iPad runs out of batteries the
>> SQLite3 database may become corrupted. I have received one database back and
>> it is indeed defect and unrecoverable. Does anybody have an idea
is running out of batteries
(perhaps during a write operation?).
BTW: I assume that the rollback journal is in the same folder as the database
file, right?
Best regards,
Hartwig
Am 07.08.2011 um 22:25 schrieb Richard Hipp:
> On Sun, Aug 7, 2011 at 4:19 PM, skywind mailing lists <
>
I am using SQLite 3.6.x and higher for two apps for the iPhone/iPad. I do not
use the built-in SQLite library because I need Rtree and FTS support.
Therefore, I compile it by myself with the following preprocessor directives:
SQLITE_THREADSAFE=1 SQLITE_ENABLE_RTREE=1 SQLITE_ENABLE_FTS3=1
SQLITE
There seem to be a couple of variables in the sqlite3 amalgamation that get
assigned a value but actually their value is not used. If there is an intention
to get rid of these statements I will submit samples like
h = pFile->h;
(sqlite3.c in line 26039 version 3.7.7)
But perhaps these lines
Hi,
FTS and sqlite3_last_insert_rowid do not work together. This is a known
shortcoming. Basically this also means that you can't use any triggers
involving FTS.
Regards,
Hartwig
Am 13.05.2011 um 17:38 schrieb Steven Parkes:
> I gather sqlite3_last_insert_rowid doesn't play well with FTS? I
Hi Rolf,
I am using FMDB and SQLite for more than 2 years now and have not experienced
any problems so far. Therefore, I expect that the bug is somewhere else but not
inside SQLite (3.7.2) nor FMDB (2009-10-18).
Greetings,
Hartwig
Am 04.05.2011 um 23:22 schrieb Rolf Marsh:
>
>
> Prior to ge
table
In both cases you will get an error message.
Hartwig
Am 22.02.2011 um 00:16 schrieb BareFeetWare:
> On 22/02/2011, at 4:31 AM, skywind mailing lists wrote:
>
>> "Supports SQLite extension" would be an accurate feature description. And in
>> the cell (value) I s
y you may have a row for each type of extension but I find this a
bit too much.
Hartwig
Am 20.02.2011 um 21:48 schrieb BareFeetWare:
> On 21/02/2011, at 3:20 AM, skywind mailing lists wrote:
>
>> in your comparison chart it would also be nice to see which software is able
>> to
Hi Tom,
in your comparison chart it would also be nice to see which software is able to
support SQLite extension. A couple of them do not support the FTS nor RTree
capabilities of SQLite.
Hartwig
Am 20.02.2011 um 07:19 schrieb BareFeetWare:
> Hi Ben,
>
> In reply to your announcement of Base
I have created an RTree table with the command
CREATE VIRTUAL TABLE AirspaceRTree USING rtree
(ID,MinLatitude,MaxLatitude,MinLongitude,MaxLongitude,MinAltitude,MaxAltitude);
Furthermore, I have a table Airspace. The contents besides the ID (primary key)
are irrelevant for this context.
When us
51 matches
Mail list logo