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 st
Thank you for the explanation Roger. My apologies to Mark for hijacking
the thread.
Cheers,
Dave.
-Original Message-
From: Roger Binns [mailto:rog...@rogerbinns.com]
Sent: Sunday, September 05, 2010 12:07 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] 64 bit soft hea
Hi,
I'm trying to simulate primitive table inheritance.
There is my SQL code:
PRAGMA foreign_keys = ON;
CREATE TABLE base(
id INTEGER PRIMARY KEY,
n INTEGER
);
CREATE TABLE child1(
id INTEGER PRIMARY KEY REFERENCES base(id) DEFERRABLE INITIALLY DEFERRED,
t TEXT
);
-- when inserting row
On 5 Sep 2010, at 9:47am, Arthur Avramiea wrote:
> I would like to create a graphical interface which will allow me (after
> using the proper pass), to add or modify questions, that will allow the
> generation of the tests themselves,of the formatted test pages ready to be
> printed, and of a pag
On 5 Sep 2010, at 11:01am, Mark wrote:
> a new problem regarding this. Got it to work fine with your help, on an sqb
> database, trying to do the same with a db3 but it doesn't want to play. I
> don't particularily need it to dump anything, I just need a file, any file,
> to be created as a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/05/2010 02:17 PM, Arthur Avramiea wrote:
> The sqlite db will be encrypted with http://www.zetetic.net/code/sqlcipher
> so that the users of the application without the proper credentials will not
> be able to see or modify them.
The last part
> The column names on queries that do not have AS clauses on the columns are
> undefined and are subject to change. To get specific column names, use AS:
>
> select a1.txt AS a1, a2.txt AS a2
>
> Then your arr() will contain entries a(*), a(a1), and a(a2).
True, but in case of custom S
Hi there,
a new problem regarding this. Got it to work fine with your help, on an sqb
database, trying to do the same with a db3 but it doesn't want to play. I
don't particularily need it to dump anything, I just need a file, any file, to
be created as a trigger / signal to another part of t
Thanks again, I got it. it is very fast.
--- Drake Wilson wrote:
> Quoth Mike Zang , on 2010-09-05 17:49:31 +0900:
> > I converted about 2000 binary files to SQLite3, it spent about 5
> hours, I
> > want to know if this is normal?
> > Every file is about 2000 records. My process is very simple,
Sorry that I asked the simplest question, I try to run "PRAGMA synchronous
= 0" for iPad app, can I just run it in sqlite3_exec(database, "PRAGMA
synchronous = 0", ...)?
--- Drake Wilson wrote:
> Quoth Mike Zang , on 2010-09-05 17:49:31 +0900:
> > I converted about 2000 binary files to SQLite3,
Thanks for your info, I try again tonight.
--- Drake Wilson wrote:
> Quoth Mike Zang , on 2010-09-05 17:49:31 +0900:
> > I converted about 2000 binary files to SQLite3, it spent about 5
> hours, I
> > want to know if this is normal?
> > Every file is about 2000 records. My process is very simple
Quoth Mike Zang , on 2010-09-05 17:49:31 +0900:
> I converted about 2000 binary files to SQLite3, it spent about 5 hours, I
> want to know if this is normal?
> Every file is about 2000 records. My process is very simple, read file in
> NSData and set to struct pointer, then use this pointer to get
I converted about 2000 binary files to SQLite3, it spent about 5 hours, I
want to know if this is normal?
Every file is about 2000 records. My process is very simple, read file in
NSData and set to struct pointer, then use this pointer to get data and
insert into database, is there any faster to do
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 encrypted with http://www.zetetic.net/code/sqlcipher
14 matches
Mail list logo
