[sqlite] Compiling sqlite using chars unsigned by default

2009-05-08 Thread Axel Mammes
Great! Thanks. On May 8, 2009, at 3:34 PM, Axel Mammes wrote: > Hi, I am using the ARM RVDS 2.0.1 compiler to try to get SQLite on a > VeriFone Vx570 point of sale terminal running VerixV operating > system. I am > still working on getting it to work, but before I continue I ne

[sqlite] Compiling sqlite using chars unsigned by default

2009-05-08 Thread Axel Mammes
Hi, I am using the ARM RVDS 2.0.1 compiler to try to get SQLite on a VeriFone Vx570 point of sale terminal running VerixV operating system. I am still working on getting it to work, but before I continue I need to know if the fact that chars are unsigned by default will break sqlite build. Thanks

Re: [sqlite] Porting SQL to run on a proprietary operating system

2006-01-11 Thread Axel Mammes
ly > to save a snapshot, and load it when booting up. It's fast but if your > hardware > can't detect a power failure and write the data with what power > remains in the power supply > capacitors you risk losing some data in case of power failure between > snapshots. > &

Re: [sqlite] proposal for improving concurrency in SQLite

2006-01-10 Thread Axel Mammes
How about using a hard-link to store the log file somewhere else? That should work transparently... On 1/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > > On Mon, Jan 09, 2006 at 09:08:10PM -0800, Dan Kennedy wrote: > > > > > > The short version:

Re: [sqlite] Porting SQL to run on a proprietary operating system

2005-12-30 Thread Axel Mammes
ill keep the tables in > RAM. > The only drawback there is I believe you can't share data between threads. > Since > you only have one thread that might be just what you need. > > On 12/29/05, Axel Mammes (gmail) <[EMAIL PROTECTED]> wrote: > > Flash will only be us

RE: [sqlite] Porting SQL to run on a proprietary operating system

2005-12-29 Thread Axel Mammes \(gmail\)
against flash drives. I believe several people use in ram databases and occasionally flush them to flash storage to prevent 'wearing out' the flash prematurely. On 12/29/05, Axel Mammes (gmail) <[EMAIL PROTECTED]> wrote: > I write software for electronic funds transfer terminals. For thi

[sqlite] Porting SQL to run on a proprietary operating system

2005-12-29 Thread Axel Mammes \(gmail\)
I write software for electronic funds transfer terminals. For this project in particular I am using a Verifone Vx570 terminal (www.verifone.com). The platform consists in a 32 bit ARM9 processor with 4-32 MB battery backed up RAM and 4-32 flash. The operating system is called Verix. It supports

RE: [sqlite] Locking

2005-12-23 Thread Axel Mammes \(gmail\)
Does your flat file support ACID transactions? That´s the killer feature fo my app. I want to store financial transactions and I don´t trust normal flat files. -Original Message- From: Dan Petitt [mailto:[EMAIL PROTECTED] Sent: Viernes, 23 de Diciembre de 2005 08:00 p.m. To:

RE: [sqlite] ring buffer table

2005-12-23 Thread Axel Mammes \(gmail\)
Wouldn´t a SELECT COUNT(*) just read the table header and get the amount of records from there? That should be faster and simpler than maintaning a separate table for the counters. -Original Message- From: Paul Bohme [mailto:[EMAIL PROTECTED] Sent: Viernes, 23 de Diciembre de 2005 02:52