Python Database

Question

My question is how to create a simple database in python. My example is:

User = {
'Name' : {'Firstname', 'Lastname'},
'Address' : {'Street','Zip','State'},
'CreditCard' : {'CCtype','CCnumber'},
}

Now I can update this User's information just fine, but how do I

1. Add more users to this data structure. A dictionary of dictionaries?
2. Allow users to have more than one credit card, a many to one relationship

Thanks for any responses, I've been trying to wrap my head around this for awhile

Answer 1

You might be interested in SQLAlchemy. It makes an actual database, such as SQLite or MySQL, work more like Python classes.

Answer 2

Most key-value stores I've seen are either a dictionary of dictionaries (like mongo*) or a dictionary of strings (like redis). There are pros and cons to both approaches. I don't know what you want, so I'll give the simplest answer: Go with a list of dictionaries:

Users = []
Users.append({
  'Name' : {'Firstname', 'Lastname'}, # Are these sets?
  'Address' : {'Street','Zip','State'},
  'CreditCard' : {'CCtype','CCnumber'},
})

*OK, to be fair, Mongo is more like a dictionary of magic strings. It's json, but the lookups are handled internally, so you can treat it like a dictionary of arbitrary (but json-serializable) data structures.