On Tue, 2005-04-26 at 11:56 +0930, Jake Skinner wrote:
> Does anyone know if there is a maximum number of precompiled queries you
> can attach to a database?
There is no arbitrary limit. You can have as many precompiled
statements as you have memory to store them in.
--
D. Richard Hipp <[EMAIL
Hello all,
Does anyone know if there is a maximum number of precompiled queries you
can attach to a database? I only ask as some of my precompiled queries
are not working (ie nothing happens to the database, but no errors are
reported), however if I just execute the same SQL query, everything
On 4/25/05, Griggs, Donald wrote:
> Regarding: "I have an SQLite database with 2 columns and 66,000+ rows
> that I would like to use on a Palm Tungsten T3."
>
> I googled up the following.
> http://www.jpilot.org/pipermail/jpilot/2002-November/001121.html
> It implies that
On Mon, 25 Apr 2005, D. Richard Hipp wrote:
When you get your copy of tiger, I image that an SQLite
command-line shell will be included. (I do not know this;
I'm just guessing.) So start up a command-line shell
and type:
select sqlite_version();
That will tell you right away what version is
On Mon, 2005-04-25 at 16:53 +0100, Tim Anderson wrote:
> However Apple was a bit vague about how it is used and the people there
> weren't sure if it was 2.x or 3.x that is integrated.
>
The very earliest use of SQLite by Apple was version 2.x
since they have been working on integrating SQLite
> A --> B --> C
> \
>\--> D --> E
You've drawn a tree, but your comments indicate that you
want something more general.
If you can restrict yourself to trees, you can probably
use nested sets (invented by Joe Celko). These are fairly
simple to manipulate. A Google search will turn
At 4:53 PM +0100 4/25/05, Tim Anderson wrote:
I attended a press launch for "Tiger" today and was glad to see SQLite
on one of the slides.
However Apple was a bit vague about how it is used and the people there
weren't sure if it was 2.x or 3.x that is integrated.
I wondered if anyone has a quick
Regarding: "I have an SQLite database with 2 columns and 66,000+ rows that I
would like to use on a Palm Tungsten T3."
Klaus,
I googled up the following.
http://www.jpilot.org/pipermail/jpilot/2002-November/001121.html
It implies that comma-delimited data is importable to the pilot.
Hi,
I'm aware that this is slightly off-topic, but I have an SQLite
database with 2 columns and 66,000+ rows that I would like to use on a
Palm Tungsten T3. PilotSQL seems to want the user to ring in data
manually, which is obviously out of question. Has any of you
succeeded in using an SQLite
On Apr 25, 2005, at 17:53, Tim Anderson wrote:
However Apple was a bit vague about how it is used and the people there
weren't sure if it was 2.x or 3.x that is integrated.
The Mail database in Tiger is a 3.x database, so I'm pretty sure that's
what they are using. In some earlier betas, 2.x was
I attended a press launch for "Tiger" today and was glad to see SQLite
on one of the slides.
However Apple was a bit vague about how it is used and the people there
weren't sure if it was 2.x or 3.x that is integrated.
I wondered if anyone has a quick summary of how SQLite is used in the
Apple
D. Richard Hipp wrote:
Please tell me what *you* think the column name should be in
the following cases. Also, please tell me what PostgreSQL and
MySQL and perhaps Oracle do. The decision of how to name
result columns is complex and I am unwilling to go about
making random changes here and there
George Ionescu said:
> notice the uppercase F from Field1, although field1 is requested.
> So, it seems that sqlite returns column names as defined in schema, not as
> requested by the user. This may not seem a big problem, but it becomes one
> when working with columns and trying to refer them
Great reply! The column name management seems to be an ongoing issue.
It would be nice to see it finally put to rest. Conforming to either
the standard(?) or common practice makes the most sense to me. At least
it is not a multi user issue that was not designed for in the first
place :-)
Fred
Oracle and DB2 treat all object names in a case-insensitive manner,
and to that end store all object names in upper case in the data
dictionary. As such, field names, unless an alias is provided using AS,
come back in all upper case for those databases. MS SQL Server returns
the field name
Hi,
I trying to design a table schema that will allow link relationships between
objects with the following features:
* Show a direct link relationship between two objects
* Be able to remove relationships
* Find indirect links between objects (This is were it gets tricky)
I have persisted
On Mon, 2005-04-25 at 15:12 +0300, George Ionescu wrote:
> sqlite3 test.db
> create table test(Field1 text(20));
> insert into test values ('a value');
> select field1 from test;
>
Please tell me what *you* think the column name should be in
the following cases. Also, please tell me what
>>notice the uppercase F from Field1, although field1 is requested.
>>So, it seems that sqlite returns column names as defined in schema, not as
>>requested by the user. This may not seem a big problem, but it becomes one
>>when working with columns and trying to refer them by name and not
Op maandag 25 april 2005 14:12, schreef George Ionescu:
> Hello Dr. Hipp,
> Hello dear sqlite users,
>
> while working with sqlite v3.2.1, I've noticed another annoyance in the way
> sqlite returns column names (besides the bug with #1141, duplicated as
> #1218).
>
> Using sqlite command line,
>notice the uppercase F from Field1, although field1 is requested.
>So, it seems that sqlite returns column names as defined in schema, not as
>requested by the user. This may not seem a big problem, but it becomes one
>when working with columns and trying to refer them by name and not wanting
Hello Dr. Hipp,
Hello dear sqlite users,
while working with sqlite v3.2.1, I've noticed another annoyance in the way
sqlite returns column names (besides the bug with #1141, duplicated as #1218).
Using sqlite command line, enter the following:
sqlite3 test.db
create table test(Field1
please stop crossposting.
msaka msaka wrote:
how works with time stamp in sqlite..
can you write here some examples (create time stamp field in integer or
timestamp ??? and so on)
-P?vodn? spr?va-
Od: Ken & Deb Allen [mailto:[EMAIL PROTECTED]
Odoslan?: 22. apr?la 2005 21:02
Komu:
how works with time stamp in sqlite..
can you write here some examples (create time stamp field in integer or
timestamp ??? and so on)
>-P?vodn? spr?va-
>Od: Ken & Deb Allen [mailto:[EMAIL PROTECTED]
>Odoslan?: 22. apr?la 2005 21:02
>Komu: sqlite-users@sqlite.org
>Predmet: Re: [sqlite]
23 matches
Mail list logo
