Christophe Leske wrote:
>>> Can I spare some bytes in my DB by defining the ID field of the
>>> standard
>>> table as being a foreign key of the rtree table? In other words, when
>>> defining a foreign key, is the coloumn referencing the ID field of the
>>> foreign table and thus NOT replicating
On 11/19/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
>
> >> Can I spare some bytes in my DB by defining the ID field of the
> >> standard
> >> table as being a foreign key of the rtree table? In other words, when
> >> defining a foreign key, is the coloumn referencing the ID field of the
>
>> Can I spare some bytes in my DB by defining the ID field of the
>> standard
>> table as being a foreign key of the rtree table? In other words, when
>> defining a foreign key, is the coloumn referencing the ID field of the
>> foreign table and thus NOT replicating them (using a smaller memory
On Nov 19, 2008, at 4:36 AM, Christophe Leske wrote:
> Hi,
>
> first i´d like to thank the people on this list that I have found to
> be
> very helpful in the past. This list is truly great and friendly.
>
> I got two questions today:
>
> I have two tables, a standard one and an rtree table, wh
Hi,
first i´d like to thank the people on this list that I have found to be
very helpful in the past. This list is truly great and friendly.
I got two questions today:
I have two tables, a standard one and an rtree table, which are both
linked together logically by the ID field of the rtree ta
I'll definitely move on to using Python to work with SQLite, so I
guess this won't be a problem eventually, but for now the command line
program is a very easy way to test out things and just use a database
on the fly, without having to write the extra code involved in
connecting to it via a separ
"John Salerno" <[EMAIL PROTECTED]> wrote:
> Just as a follow-up, I noticed that one of my columns *did* expand to
> fit a longer name, yet another column didn't. Could it be because the
> one that expanded contained a string of a single word, while the
> column that didn't expand contained multiple
Is it possible to change the width of columns in column mode in some
general way? What I mean is, I know I can do .width X X X etc., but
that requires knowing how many columns you have. Is there some way to
set it so that the column will simply expand to fit the information?
Second, I created a r
Question 1
Is #PRAGMA SYNCRONOUS a global database setting or is it possible to open
two handles on the same database and set two different values for #PRAGMA
SYNCRONOUS on the two handles ?
Question 2
Is it possible to change the value of #PRAGMA SYNCRONOUS on the same handle
during the execution
9 matches
Mail list logo