[sqlite] problem to link with cross compiler gcc, ...

2014-08-15 Thread olivier BOURQUARD
BQD Process le temps d'avance www.bqd.process hi. I had trouble finding the parameters of the cross compiling, but I managed to achieve the "hello world" program, and execute it in the raspberry. I have problems to link the simple program that opens a database. I use Eclipse LUNA on Windows

[sqlite] Using SQLite with WP8.1

2014-08-15 Thread venkata bhaskar kakaraparthy
Hi SQLite Users, I am new to SQLite and tried using SQLite to my Windows phone 8.1 App. I couldn't find any useful samples online which can be used with Windows phone 8.1. Requesting to share any useful samples that can help my application. Here are the sample requests I am looking for:

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

2014-08-15 Thread Jan Nijtmans
2014-08-12 10:35 GMT+02:00 Jan Nijtmans : > > $ i686-w64-mingw32-gcc -c -DSQLITE_WIN32_NO_ANSI sqlite3.c > sqlite3.c: In function ‘sqlite3_win32_is_nt’: > sqlite3.c:33312:10: error: ‘sInfo’ undeclared (first use in this function) > > (sInfo.dwPlatformId ==

Re: [sqlite] Docs: ON CONFLICT clause versus CHECK constraints

2014-08-15 Thread Zsbán Ambrus
On 8/15/14, Richard Hipp wrote: > http://www.sqlite.org/draft/lang_conflict.html Thanks for fixing it. -- Ambrus ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQlite on flash filesystem

2014-08-15 Thread Levente
I am thinking about putting an SQLite database on a flash drive (SD card). I would like to know what kind of file system is the optimal. I want to query a lot, and insert or update a few times per minute. The goal is to minimize disk writes, which leads the FLASH to wear out. After some googling