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 - [email protected] 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/ _______________________________________________ Tutor maillist - [email protected] To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
