Re: [sqlite] Method to load Sqlite DB (disk) directly into memory

On Mon, Sep 6, 2010 at 7:25 PM, Simon Slavin wrote: > > On 7 Sep 2010, at 12:21am, Richard wrote: > > > I was wondering if there's a method to directly load a disk DB into > memory. I'm aware of 2 indirect methods, namely: > > > > > > - create a .dump and .read the created

Re: [sqlite] Method to load Sqlite DB (disk) directly into memory

On Mon, Sep 6, 2010 at 7:21 PM, Richard wrote: > Hi, > > > I was wondering if there's a method to directly load a disk DB into memory. > I'm aware of 2 indirect methods, namely: > > > - create a .dump and .read the created file > > > - attach the disk DB and insert the disk tables

Re: [sqlite] Method to load Sqlite DB (disk) directly into memory

On 7 Sep 2010, at 12:21am, Richard wrote: > I was wondering if there's a method to directly load a disk DB into memory. > I'm aware of 2 indirect methods, namely: > > > - create a .dump and .read the created file > > > - attach the disk DB and insert the disk tables into memory tables

[sqlite] Method to load Sqlite DB (disk) directly into memory

Hi, I was wondering if there's a method to directly load a disk DB into memory. I'm aware of 2 indirect methods, namely: - create a .dump and .read the created file - attach the disk DB and insert the disk tables into memory tables I'm using the command line tool. Is there a direct method

[sqlite] sqlite3 -has_codec in test suite

Given: > ./testfixture % sqlite3 -has_codec Error: wrong # args: should be "sqlite3 HANDLE FILENAME ?-vfs VFSNAME? ?-readonly BOOLEAN? ?-create BOOLEAN? ?-nomutex BOOLEAN? ?-fullmutex BOOLEAN?" % sqlite3 -has-codec 0 and: src/tclsqlite.c:if( strcmp(zArg,"-has-codec")==0 ){ are the

Re: [sqlite] Altering primary key in trigger produces incorrect last_insert_rowid() value

Quoth Sergey Shishmintzev , on 2010-09-05 21:57:24 +0300: > Hi, > I'm trying to simulate primitive table inheritance. > > There is my SQL code: > > -- when inserting row into table child1 > -- new child1.id must be obtained from base table > CREATE TRIGGER

Re: [sqlite] Altering primary key in trigger produces incorrect last_insert_rowid() value

On Sun, Sep 5, 2010 at 2:57 PM, Sergey Shishmintzev < sergey.shishmint...@gmail.com> wrote: > > Is it possible to tracking updates of primary key in triggers and > returning expected last_insert_rowid() value in future releases? > No. The name is the function is last_insert_rowid(), not

Re: [sqlite] Create a GUI for interacting with a test questions sqlite db

On 05-09-2010 10:47, Arthur Avramiea wrote: > I would like to use sqlite to create a question db for test generation. It > will be organized in a couple of questions cathegories. A random function > will generate a test by selecting a couple of questions from each section. > The sqlite db will be

Re: [sqlite] Create a GUI for interacting with a test questions sqlite db

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/06/2010 12:21 PM, Arthur Avramiea wrote: > The pass doesn't have to be in plain text in the software ... I > can store it as sha1 or other kind of hash. Wouldn't that solve most of it? > Or some implementation of SSL. You are confusing

Re: [sqlite] Create a GUI for interacting with a test questions sqlite db

Arthur, Nokia's Qt4 may be worth a look. Amit On Mon, Sep 6, 2010 at 7:51 AM, Arthur Avramiea wrote: > > Thank you very much for your answers. I already have mysql, php, c and some > beginner c++ experience. Learning a new language wouldn't be about > difficulty, but

Re: [sqlite] Create a GUI for interacting with a test questions sqlite db

Thank you very much for your answers. I already have mysql, php, c and some beginner c++ experience. Learning a new language wouldn't be about difficulty, but about time :). I am also considering java for it. What do you think? The pass doesn't have to be in plain text in the software ... I can