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 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.
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 store
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:
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:1999
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 internal
Hello all,
This isn't s question specific to SQLite, so I hope that you don't mind...
but, I am trying to store an ordered lists of numbers of arbitrary length in
a table. I am not really sure what the best method of doing this, but the
way that I have come up with is to create a table with the
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
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