Re: [sqlite] Re: SQLite and nested transactions

2007-04-14 Thread Raymond Hurst
I followed every one of these threads and it is really good stuff. I've done some research to realize I need to do more. I see that most of you are in the client/server world where you can ask the client various questions about the query. In my case, I am a standalone server embedded in a

Re: [sqlite] Looking for a cryptographic library

2007-08-24 Thread Raymond Hurst
Search for the following on the web: BeeCrypt, CryptoPP, OpenSSL Ray Hurst [EMAIL PROTECTED] wrote: Hi all: I'm writing an application that uses SQLite to store user's data, and need a library to crypt some stuff, including passwords and data. The goal is to crypt before insert and

Re: [sqlite] Database file analysis

2007-11-02 Thread Raymond Hurst
Yes. this is all possible Babu, Lokesh wrote: Hi all, Does anyone analysed the sqlite3 database output file by opening the file in some hex editor. Is it possible to create one such database file without using sqlite.i.e., is it possible to write the contents without using sqlite and later

Re: [sqlite] Memory Usage

2007-11-17 Thread Raymond Hurst
Hi Scott, My initial evaluation of this database was that it allocates memory for each operation on the database. It returns the memory only when the database is committed. So the behavior you see is normal. Ray Hurst ScottDerrick wrote: I am using sqlite3 in a DAQ device. Data can be

Re: [sqlite] Memory Usage

2007-11-17 Thread Raymond Hurst
Hi Scott, Ooops..meant to say the following. My initial evaluation of this database was that it allocates memory for each operation on the database. It returns the memory only when the database is CLOSED. So the behavior you see is normal. Ray Hurst ScottDerrick wrote: I am using sqlite3

Re: [sqlite] Using the Sqlite Btree Backend directly

2007-04-03 Thread Raymond Hurst
I am an extreme newbie at this and I am open to suggestions: My requirements are: Smallest footprint possible ACID requirements (transactional rollback a must) Be able to create tables with fields that have name/value pairs. Not sure what else! If a dBase derivative meets these

Re: [sqlite] SQLite and nested transactions

2007-04-09 Thread Raymond Hurst
This is all good stuff but I'm getting a little lost. The gist of it all is that SQLite needs to be modified to support nested transactions with a journal per transaction scheme. Correct? The counter idea was good but it didn't support Igor's example. Hope I am correct here. Ray [EMAIL