[sqlite] Bug in retrieving last rowid?

I have created Tables A & AS_FTS "create table A (id integer primary key, string Text);" "create virtual table AS_FTS (Name);" and a trigger "insert into A_FTS (rowid,Name) values (New.%@,New.%@);" (and a not shown delete trigger). Now, I enter two strings into tue table: one and two. I

Re: [sqlite] rtree performance problems?

Am 18.08.2008 um 21:32 schrieb Dennis Cote: > Thomas Sailer wrote: >> >> Interestingly, the original query is extremely compute-bound, there >> is >> almost no disk activity! >> >> Looking at the output opcodes from the queries, I can't see any >> significant difference. Though I have to admit

[sqlite] RTree query

I have two tables with about 100 000 rows. One is the main data table and the other an RTree table. I started a query like described at http://www.sqlite.org/rtree.html: SELECT data.location_name FROM data, rtree WHERE data.id=rtree.id AND rtree.x >= 0 AND rtree.x <= 10; This runs for about

Re: [sqlite] Severe documentation bug in sqlite3_close leading to crash

Am 26.07.2008 um 17:21 schrieb Stephen Woodbridge: > Hartwig Wiesmann wrote: >> The latest sqlite3_close(sqlite3*) documentation states: >> >> Applications should finalize all prepared statements and close all >> BLOB handles associated with the sqlite3

[sqlite] Severe documentation bug in sqlite3_close leading to crash

The latest sqlite3_close(sqlite3*) documentation states: Applications should finalize all prepared statements and close all BLOB handles associated with the sqlite3 object prior to attempting to close the object. The sqlite3_next_stmt() interface can be used to locate all prepared

Re: [sqlite] rtree module crashes

Hi Dan, sorry, but I do not have any access to the page, I think. Hartwig Am 04.07.2008 um 17:00 schrieb Dan: > > On Jul 4, 2008, at 9:24 PM, Hartwig Wiesmann wrote: > >> Hi, >> >> I posted a while ago the mail attached below but did not receive any >> ans

[sqlite] rtree module crashes

Hi, I posted a while ago the mail attached below but did not receive any answer. If there is any better place to discuss it please let me know. When I compile SQLite using SQLITE_ENABLE_RTREE set to 1 SQLite will crash when opening a database (Mac OSX). The reason seems to be that in

[sqlite] rtree module crashes

When I compile SQLite using SQLITE_ENABLE_RTREE set to 1 SQLite will crash when opening a database (Mac OSX). The reason seems to be that in rtree.c sqlite3ext.h is included instead of sqlite3.h. This can be prevented by setting SQLITE_CORE to 1 but then the types i64, u8 etc. are

Re: [sqlite] Comparison of SQLite applications for Mac

Hi Tom, SQLite Database Browser (sqlitebrowser.sourceforge.net) seems to be missing. Hartwig Am 07.05.2008 um 06:20 schrieb BareFeet: > Dennis Cote wrote: > >>> 2. Know of another application that should be included. >>> > >> You may want to include the free SQLite Manager add on for

[sqlite] [OT] Program to document database l ayout

Hello, this is a bit off topic: I am looking for a program that is suitable for documenting the structure of a SQLite database. I am looking for a program that can visualize the relations between different tables, their connections and indices. Furthermore, comments should be attached to

[sqlite] sqlite3_column_blob and memory allocation

Hi, I have got two questions concerning the function "sqlite3_column_blob". As sqlite3_column_blob returns "void const*": 1) I assume that the returned pointer will be released by sqlite3, right? So, I do not have to call free() on this pointer. 2) How long is this pointer valid? Till the

[sqlite] SQLiteSpy - new topic

Hello, is there a similar program as SQLiteSpy for other platforms available? I am especially interested in programs running on MacOS X. Hartwig

Re: [sqlite] sqlite3 on MacOSX

Thanks! Using the latest sqlite3 command tool helped! Hartwig