[Tutor] Fwd: Which databases allow lists as record fields?

[Alan Gauld]

> To elaborate on my above question, I mean: Which database (which a Python
> program can access) allows a record to have not just simple fields but also
> fields that are variable-length lists?

You don't. You create a second table to hold the list.
Then in the second table you include be reference back to the first.

For example an order may have a list of order items.
You don't create an order_item field with multiple values.
Instead you create a new order_Item table. Each order_item
has a reference to the owning order.

That concept is fundamental to relational database theory

>
> For my application, records in one database table might have 1 list, those
> in another have,  say, 4. Each list has a variable number of integers, no
> list contains embedded lists.
>
> The purpose of asking this question is to know which database to learn.
>
> Before asking this question, I looked at Alan Gauld's SQLite
> tutorial<http://www.alan-g.me.uk/tutor/tutdbms.htm>and the list
> of data types in W3school's SQL
> tute<http://www.w3schools.com/sql/sql_datatypes.asp>,
> plus a few Google searches.
>
> Trung Doan
>
>
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> http://mail.python.org/mailman/listinfo/tutor
>


-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/