On 14 Sep 2009, at 10:38am, CityDev wrote: > Bear in mind a relational database is designed around relations. > It's not > obvious what your 'data model' is but there is a suggestion it > contains > variable types of things. If you want to store variable things then > many of > the features of a relational database don't work. > > Often an object maps reasonably to an entity, and an entity shares its > structure with other entities of the same entity type. In this case > you can > easily map object attributes to fields in a table. > > Maybe you are storing something more esoteric. You may have to > serialize the > object rather than store it as fields.
You can use property lists. And you can use a relational database to implement property lists. For instance, TABLE properties: Object Property Value Car PurchaseDate 2001 Car Colour Orange Camera Colour Silver Camera Make Panasonic Cat Colour Black Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users