If you are only after storage (leaving aside querying, indexing, ...)
a simple JSON column [1] could do. The advantage being portability
between databases. I've used this to as simple key-value store of data
associated with a row.
regards
robert
[1] http://docs.sqlalchemy.org/en/rel_0_8/core/types.html#marshal-json-strings
On Thu, Dec 20, 2012 at 11:20 AM, Andreas Jung zopyxfil...@gmail.com wrote:
Using Postgres 9.1, SqlAlchemy 0.8.
I need to store information like
[
[10, 'liters', 'tea'],
[20, 'milliliters', 'salt'],
]
as one column into Postgres.
What is the best way to do this? Of course I use a second table with a 1:N
relationship
I am thinking about using the Postgres Array type for this...is there a
better option?
Right now there are numeric and string values to be stored. I can of course
convert numeric values to strings if needed.
Any options?
Andreas
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/9jnn5iZY68IJ.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.