Re: [sqlite] parallelizing an update

Hello, it is not aesthetic, it groups all update in a single transaction that speed up the processing. Using multi thread or multi-process is not efficient, it is at the end a single process that can write to the database (a single file). Grouping all the update in a single transaction is the

[sqlite] negative numbers

I am writing an open source program. I am having trouble getting any results using this query. This returns none select * from signs where lon-121 and lon-119; onCreate(SQLiteDatabase db) { db.execSQL(CREATE TABLE + TABLE_NAME + ( + _ID + INTEGER PRIMARY KEY

Re: [sqlite] negative numbers

On Jan 31, 2010, at 9:19 AM, james pruett wrote: I am writing an open source program. I am having trouble getting any results using this query. This returns none select * from signs where lon-121 and lon-119; onCreate(SQLiteDatabase db) { db.execSQL(CREATE TABLE + TABLE_NAME

Re: [sqlite] negative numbers

On 31 Jan 2010, at 2:19pm, james pruett wrote: I am having trouble getting any results using this query. This returns none select * from signs where lon-121 and lon-119; onCreate(SQLiteDatabase db) { db.execSQL(CREATE TABLE + TABLE_NAME + ( + _ID + INTEGER

Re: [sqlite] negative numbers

On Sun, Jan 31, 2010 at 8:19 AM, james pruett gpscru...@gmail.com wrote: I am writing an open source program. I am having trouble getting any results using this query. This returns none select * from signs where lon-121 and lon-119; onCreate(SQLiteDatabase db) {      

Re: [sqlite] negative numbers

On Sun, Jan 31, 2010 at 09:11:21AM -0600, P Kishor scratched on the wall: On Sun, Jan 31, 2010 at 8:19 AM, james pruett gpscru...@gmail.com wrote: I am writing an open source program. I am having trouble getting any results using this query. This returns none select * from signs

Re: [sqlite] negative numbers

On Sun, Jan 31, 2010 at 9:42 AM, Jay A. Kreibich j...@kreibi.ch wrote: On Sun, Jan 31, 2010 at 09:11:21AM -0600, P Kishor scratched on the wall: On Sun, Jan 31, 2010 at 8:19 AM, james pruett gpscru...@gmail.com wrote: I am writing an open source program. I am having trouble getting any

[sqlite] system.data.sqlite encryption

Hi all, I am using System.data.sqlite from my .NET project, but I am planning to access my db from C/C++ and C# / C++/CI The point is that I want an encryted database, and I plan to use the extension from http://www.hwaci.com/sw/sqlite/prosupport.html#crypto how to use / implement this exension

[sqlite] UTF-8 and UTF-16

I am planning to store text in a database which has to accommodate a few international languages. In this case I have to use UTF-16LE encoding for my TEXT fields. I know that once an encoding has been set for a database, it cannot be changed. Do BLOBS are effected? I guess I cannot mix

Re: [sqlite] UTF-8 and UTF-16

a1rex wrote: I am planning to store text in a database which has to accommodate a few international languages. In this case I have to use UTF-16LE encoding for my TEXT fields. Perhaps there are some external reasons, but there's nothing in SQLite that would force this. For example, UTF-8 is

Re: [sqlite] UTF-8 and UTF-16

On Sun, 31 Jan 2010 18:12:27 -0500, Igor Tandetnik itandet...@mvps.org wrote: It's PRAGMA encoding = UTF-16. The parameter needs to be quoted. This is indeed the syntax description. Peculiarly, anywhere else, string literals have to be single quoted. Is this something to iron out in v4 ? --

Re: [sqlite] UTF-8 and UTF-16

Thank you for your help! This call: sqlite3_exec(handle,PRAGMA encoding = \UTF-16\,NULL,NULL,zErr); works. Samuel - Original Message From: Igor Tandetnik itandet...@mvps.org To: sqlite-users@sqlite.org Sent: Sun, January 31, 2010 6:12:27 PM Subject: Re: [sqlite] UTF-8 and UTF-16