[sqlite] secure_delete versus journal_mode persist.

Given a 3.7.15.2 OSX binary fresh from the website, the following scenario seems suspect: > ./sqlite3 trial.db sqlite> pragma secure_delete = 1; 1 sqlite> pragma journal_mode = persist; persist sqlite> pragma journal_size_limit = 4096; 4096 sqlite> pragma page_size; 1024 sqlite> create table x

Re: [sqlite] secure_delete versus journal_mode persist.

On 29 Jan 2013, at 8:19am, Scott Hess wrote: > insert into x values ('SQLite is a software library that implements > a self-contained, serverless, zero-configuration, transactional SQL > database engine. SQLite is the most widely deployed SQL database engine in > the world.

Re: [sqlite] bug report: out of memory error for most operations on a large database

As per your questions: 1. I do not use sqlite from C or some other language. The calls are from the command line using sqlite3 command line utility. Hence no sqlite3_memory_used calls. Memory used by sqlite3 process was obtained by eyeballing the sqlite3 process in Windows task manager.

[sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hello dear (System.Data.)SQLite users, I am using System.Data.SQLite in combination with Spatialite which works very well. One problem I currently have is that when I'm trying to insert several milions of records (namely road segments with just two columns: Id INTEGER, Geometry LINESTRING) it

Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

On Tue, 29 Jan 2013 14:22:07 +0100, Markus Dibo wrote: Hello dear (System.Data.)SQLite users, I am using System.Data.SQLite in combination with Spatialite which works very well. One problem I currently have ... Hi Markus, I suppose that posting such questions into the SpatiaLite own

Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hi Sandro, thanks for your answer - I will post the question (possibly including the solution) on the appropriate mailing list. Actually, my columns are defined the way you suggested - I will make it more clear in my post to the spatialite mailing-list. But your answer sounds interesting -

Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hi Mark, Currently I am converting my C# polygons to a string of the form "LINESTRING(x1 y1, ..., xN yN)" which would be the WKT (Well-Known Text) format. If I understand your answer correct I could simply convert my C# polygons to the WKB (Well-Known Binary) format and use BLOB as the DbType

Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hi, thanks for your answer again (again I was unclear in my question, sorry for that - I am using "ST_GeomFromText('LINESTRING(APPROPRIATE_VALUES)', APPROPRIATE_SRID)" ). I think I found the problem: My parametrized command text looks like: "INSERT INTO RoadSegments (Id, Geometry) VALUES

Re: [sqlite] secure_delete versus journal_mode persist.

Simon Slavin wrote: > On 29 Jan 2013, at 8:19am, Scott Hess wrote: > >> insert into x values ('SQLite is a software library that implements >> a self-contained, serverless, zero-configuration, transactional SQL >> database engine. SQLite is the most widely deployed SQL database

Re: [sqlite] secure_delete versus journal_mode persist.

On Tue, Jan 29, 2013 at 7:52 AM, Yuriy Kaminskiy wrote: > User-space database encryption and all "safe data erase" tools only > provide you > with warm feeling of safety without any real security. I agree. I am merely pointing out that I think that this result may be

[sqlite] FTS problem with 'NOT term' queries

Hello! From http://www.sqlite.org/fts3.html#section_3_1 we can see the query SELECT * FROM docs WHERE docs MATCH 'database NOT sqlite'; But the equal query doesn't works: SELECT * FROM docs WHERE docs MATCH 'NOT sqlite AND database'; Error: malformed MATCH expression: [NOT sqlite AND database]

Re: [sqlite] FTS problem with 'NOT term' queries

On 1/29/2013 11:30 PM, Alexey Pechnikov wrote: From http://www.sqlite.org/fts3.html#section_3_1 we can see the query SELECT * FROM docs WHERE docs MATCH 'database NOT sqlite'; But the equal query doesn't works: SELECT * FROM docs WHERE docs MATCH 'NOT sqlite AND database'; Error: malformed

Re: [sqlite] FTS problem with 'NOT term' queries

The explanation right above that table of examples contains these important (I believe) phrases: ...BINARY SET operators... ...TWO operands to an operator... (emphasis mine) On Tue, Jan 29, 2013 at 11:30 PM, Alexey Pechnikov wrote: > SELECT * FROM docs WHERE docs MATCH