Re: [sqlite] In memory SQLite

use ":memory:" as the path of sqlite file when invoke sqlite3_open. 2009/1/22 Ionut > Hi, > > I am trying to use SQLite in a new operating system. > Right now we don't support a large functionality > Is there a way to make SQLite to work entirely into memory? > (meaning that everything should be

[sqlite] How to read whole table with a BLOB cloumn as quickly as possible?

Hello, I want to store image data into sqlite by spliting image to many blocks(256*256pixels). In my table, each row contain one block and some other information, about 4~7column totally. The table has the 32K page size, and I make these pragma: journal_mode = OFF, synchronous = OFF, locking_mode =