[sqlite] BerkleyDB pager?

I'm investigating embedded databases for an upcoming project, and I came upon this thought: Wouldn't an SQLite pager that uses Sleepycat/BerkleyDB be quite interesting? Andrew

Re: [sqlite] using sqlite as a temporary database to process lots of data

Patrick Dunnigan wrote: > I am currently using SQLite to process @ 400 million records (and climbing) > a day by reading files, importing them into SQLite, and summarizing. The Wow! How much memory those 400 milion of records is using ? Do you use Sqlite 2 or 3 version ? I was told that SQlite

Re: [sqlite] php 5 / sqlite 3 - is it possible ??

Philip Butler wrote: Hi all, I have been trying to use the latest sqlite 3 with PHP 5. I have sqlite 3 compiled OK, but cannot seem to figure out how to get PHP 5 to "link it in". I have tried options like --with-sqlite=/path (where path is the path to the sqlite library). I have also

Re: [sqlite] how to use the LIMIT and OFFSET?

You should use SQL to get the data you want, then use your host language to display the data. Those are 2 separate operations, and you'll be better off not mixing them. If you're going to let your users go backward, you're going to have to cache the data anyway. Regards

[sqlite] how to use the LIMIT and OFFSET?

i am trying to run some web search like query. the one that returns a total number of results and only presents the first 20, then allows user to click on next to go to the next 20 etc. has anyone done this before? i suppose i would use LIMIT or OFFSET in the select statement, but the offset

[sqlite] php 5 / sqlite 3 - is it possible ??

Hi all, I have been trying to use the latest sqlite 3 with PHP 5. I have sqlite 3 compiled OK, but cannot seem to figure out how to get PHP 5 to "link it in". I have tried options like --with-sqlite=/path (where path is the path to the sqlite library). I have also tried: