Re: [sqlite] Small enhancement: BEGIN SHARED

2006-04-08 Thread Paul Bohme
[EMAIL PROTECTED] wrote: > Paul Bohme <[EMAIL PROTECTED]> wrote: > >> I have a small patch that adds "BEGIN SHARED" syntax in addition to >> IMMEDIATE and EXCLUSIVE. I have an application that requires a >> consistent view of the data

[sqlite] Small enhancement: BEGIN SHARED

2006-04-08 Thread Paul Bohme
I have a small patch that adds "BEGIN SHARED" syntax in addition to IMMEDIATE and EXCLUSIVE. I have an application that requires a consistent view of the data across a number of individual statements. What is ideal is a way to simply lock the database with a SHARED lock for the duration, but

Re: [sqlite] Persistent user-defined functions

2006-04-08 Thread Paul Bohme
Daniel Franke wrote: > Layering. Wrap sqlite3_* into your own set of functions. Create another > library, say libyourapp. Most functions will just forward the arguments to > sqlite, but others, e.g. yourapp_open_db() will not only open the database, > but also attach a couple of functions,

Re: [sqlite] SQLite and Flash memory

2006-01-12 Thread Paul Bohme
[EMAIL PROTECTED] wrote: Has anyone experimented with putting SQLite directly on the Linux MTD flash interface? I.e. by-passing JFSS2. Would this offer any kind of significant efficiency benefit? JFFS2 is designed to wear the flash evenly, preventing you from 'drilling holes' by

Re: [sqlite] ring buffer table

2006-01-09 Thread Paul Bohme
Julien LEFORT wrote: Hi, I would like to implement a log table with a finite dimension, for exemple a table with 500 records, and when the last record is set in the table I would like to come back at the first tuplet and write over the previous value recorded. I think it's the way SQLite

Re: [sqlite] ring buffer table

2005-12-23 Thread Paul Bohme
tities, thus I didn't really expect SQLite to have it. -Original Message- From: Paul Bohme [mailto:[EMAIL PROTECTED] Sent: Viernes, 23 de Diciembre de 2005 02:52 p.m. To: sqlite-users@sqlite.org Subject: Re: [sqlite] ring buffer table Julien LEFORT wrote: Hi, I would like to imp

Re: [sqlite] ring buffer table

2005-12-23 Thread Paul Bohme
Julien LEFORT wrote: Hi, I would like to implement a log table with a finite dimension, for exemple a table with 500 records, and when the last record is set in the table I would like to come back at the first tuplet and write over the previous value recorded. I think it's the way SQLite

Re: [sqlite] SQlite for Linux on the ARM processor.

2005-12-22 Thread Paul Bohme
Ben Clewett wrote: Dear SQLite I wish to compile SQLite for the ARM processor running Linux (ARM720T). The compilation will have to use the cross-compiler arm-linux-gcc version 2.95.2 running on Intel Linux, since the devise it's self has no compiler. Does any person have an image for

Re: [sqlite] Using time and date values

2005-12-15 Thread Paul Bohme
Brad wrote: I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a way to easily transform the date from one

[sqlite] Odd query optimization

2005-12-02 Thread Paul Bohme
OK, little puzzled by this one, wondering if my expectations of behavior are off. (Apologies for the longish post..) This is with 3.2.7. I have a reasonably simple 'users' table, with a single compound index (at first) on user last/first name: create table users ( id integer primary key,

Re: [sqlite]cross compiling with powerpc

2005-12-02 Thread Paul Bohme
Julien LEFORT wrote: Hi, I've been struggling for few hours trying to run the configure script the right way so I can cross compile sqlite3 for a powerpc target. I guess it is only a problem of options I pass into the configure script. here is the command I pass: CC=powerpc-linux-gcc