On 5/16/06, John Stanton <[EMAIL PROTECTED]> wrote:
Storing BLOBs in a database then acessing elements of them using other
tools does not look like good design. The purpose of a database and its
data manipulation language is to give access to all data elements. Are
you really using the DB in
Large chunks of the array will be accessed. Very rarely (if ever)
will just one value of the array be needed. From what you guys are
saying, this makes it seem like a BLOB would be the way to go. Another
thing i forgot to mention, each name will most likely have not one, but
many arrays
Test
(
TEST_ID integer PRIMARY KEY AUTOINCREMENT,
PATIENT_ID varchar(15),
TEST_TYPE integer,
DATE timestamp,
CONTENT blob
}
> -Original Message-
> From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
> Sent: 15 May 2006 18:39
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] C++ A
Do you intend to access array elements using SQL?
Kevin Piciulo wrote:
Hey everyone,
This may not be the place to ask (if not please direct me.) I'm
relatively new to sql, and newer to sqlite. Through experimenting i've
figured out how to add a string to a table, create a table, remove
On 5/15/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote:
Both ideas are very helpful. I'll definately be visiting that sql
site a lot. I'm not sure about BLOBs though, is it just like a catch
all. Where if you can't save data as something better, just save it as
a BLOB? As you can imagine a
of storing and
retrieving list attributes in a relational database.
-Clark
- Original Message
From: Kevin Piciulo <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, May 15, 2006 9:30:49 AM
Subject: [sqlite] C++ Arrays in sqlite
Hey everyone,
This may not be
else will post something more helpful
than me.
Mark
-Original Message-
From: Kevin Piciulo [mailto:[EMAIL PROTECTED]
Sent: 15 May 2006 17:31
To: sqlite-users@sqlite.org
Subject: [sqlite] C++ Arrays in sqlite
Hey everyone,
This may not be the place to ask (if not please
> -Original Message-
> From: Kevin Piciulo [mailto:[EMAIL PROTECTED]
> Sent: 15 May 2006 17:31
> To: sqlite-users@sqlite.org
> Subject: [sqlite] C++ Arrays in sqlite
>
>
> Hey everyone,
>
> This may not be the place to ask (if not please direct me.) I'm
>
On 5/15/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote:
Hey everyone,
This may not be the place to ask (if not please direct me.) I'm
relatively new to sql, and newer to sqlite. Through experimenting i've
figured out how to add a string to a table, create a table, remove a
string, some
Hey everyone,
This may not be the place to ask (if not please direct me.) I'm
relatively new to sql, and newer to sqlite. Through experimenting i've
figured out how to add a string to a table, create a table, remove a
string, some basic stuff like that.
What I'd like to do is add an
10 matches
Mail list logo
