Re: [sqlite] performance statistics

[EMAIL PROTECTED] wrote: I am currently investigating porting my project from postgres to SQLite due to anticipated performance issues (we will have to start handling lots more data). My initial speed testing of handling the expanded amount data has suggested that the postgres performance

[sqlite] Dates in sqlite3 databases and GUI tools

Hello All, From: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions "The julian day number is the preferred internal representation of dates." Unfortunately floating point values are not very readable when used with existing GUI tools. The only problem is visualization, GUI tools need to

[sqlite] Sqlite3 BLOB support

Hello all, I'm sorry for a probably lame question, I'm new to sqlite and database programming. Is it possible to store very large files in sqlite3 database? Are there any limitations?

Re: [sqlite] [sqlite-lemon] Lemon Parser Generator Tutorial

[EMAIL PROTECTED] wrote: Freshmeat has a tutorial on the Lemon Parser Generator. http://freshmeat.net/articles/view/1270/ This tutorial walks you through a simple calculator. It would be also interesting to have an example of using Lemon + RE2C (http://re2c.sf.net). I think RE2C lexer works