On Jan 16, 2008 2:18 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Mike,
>
> Do you need to be able to access the individual array elements with SQL
> statements, or do you simply need to save and restore entire arrays?
The arrays are a set, so they would never be addressed as individual
elements
Mike McGonagle wrote:
Basically, I am trying to connect SQLite up to Pure Data (a dataflow
programming language), and I am creating arbitrary lists of floating point
numbers that I would like to be able to store as sets. The SQL code from my
original message is what I am currently using for the
On Jan 14, 2008 11:28 PM, mark pirogovsky <[EMAIL PROTECTED]> wrote:
> It is really hard to give you some idea without knowing more of you
> problem... but your proposed implementation does carry a lot of
> overhead - for every number you have two extra fields, not to mention
> the database inter
On 1/15/08, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > On 1/14/08, mark pirogovsky <[EMAIL PROTECTED]> wrote:
> > > Some relational (PostgreSQL for example) databases allow you to store
> > > arbitrary array as a field in on row.
>
> I was not aware of Postgres arrays or that it is part of the
> SQL
> On 1/14/08, mark pirogovsky <[EMAIL PROTECTED]> wrote:
> > Some relational (PostgreSQL for example) databases allow you to store
> > arbitrary array as a field in on row.
I was not aware of Postgres arrays or that it is part of the
SQL:1999 standard:
http://www.postgresql.org/docs/8.0/interac
with SQLite being the db...
On 1/14/08, mark pirogovsky <[EMAIL PROTECTED]> wrote:
> Some relational (PostgreSQL for example) databases allow you to store
> arbitrary array as a field in on row. So your retrieval would be much
> easier.
> Also depending on your performance requirements you can st
Some relational (PostgreSQL for example) databases allow you to store
arbitrary array as a field in on row. So your retrieval would be much
easier.
Also depending on your performance requirements you can store your
numbers in CSV format in the single text filed. The search for the
group will
Depending upon your needs an alternative would be to store the numbers list as
a blob. Then the list can be retrieved as a single select.
Just an idea.
Ken
Mike McGonagle <[EMAIL PROTECTED]> wrote: Hello all,
This isn't s question specific to SQLite, so I hope that you don't mind...
but, I am
8 matches
Mail list logo
