RE: [sqlite] Appropriate uses for SQLite

2007-02-15 Thread Eduardo Morras
I'm late too, but here you have my opinion At 02:03 05/02/2007, you wrote: FWIW I don't interpret any posts on this thread as an attempt to change SQLite, either. But there seems to be some who see value in more clearly defining *when* SQLite *does* work. I guess that there is a lot of enthusias

Re: [sqlite] Embedded Database Functions

2006-12-24 Thread Eduardo Morras
At 17:00 24/12/2006, you wrote: On Sun, Dec 24, 2006 at 09:35:01AM -0600, John Stanton wrote: > >There is even a starting grammar for you: > > http://www.antlr.org/grammar/1107752678378/PLSQLGrammar.g > A compiler for a subset of PL/SQL would not be too arduous a project, If what you want is

Re: [sqlite] Embedded Database Functions

2006-12-23 Thread Eduardo Morras
At 03:41 22/12/2006, you wrote: There has been discussion about extending Sqlite to have more functions, but the risk is creating Sqlite-Bloat and losing the most endearing feature of the product, its light weight and simplicity. Here is an interesting and thought provoking discussion on the

Re: [sqlite] Re: File Syste

2006-12-14 Thread Eduardo Morras
At 22:03 13/12/2006, you wrote: I am developing a File System, and I'd like to use B+ Tree and not lost time and CPU understanding SQL... Check HFS(16/32 bits) and HFS+(64 bits) filesystems from Apple, they use B+ trees. The code is open source and you can find it on Darwin repository. ---

Re: AW: [sqlite] for what reason :memory: is much slower than /dev/sh m/dummy.db

2006-12-05 Thread Eduardo Morras
Hello Eduardo, thank you for the hints given. Please can you tell me how to disable journaling? In our project it is not important to have the database persistent. We create the database, work with it, and destroy it within one batch run. So we dont have to save it to disk ;-). thank you so f

Re: [sqlite] for what reason :memory: is much slower than /dev/shm/dummy.db

2006-12-01 Thread Eduardo Morras
At 09:34 01/12/2006, you wrote: Hi there, we are on an challanging project with very high requirements on performance. When doing some debugging we discover, that the sqlite method for creating an memory-based database is much slower than using e.g /dev/shm on linux or /tempfs on solaris. (We ha

<    1   2   3