Objects maps to tables... fields maps to objects properties.. if you want just store all objects and read all objects.... create an entitites tables like: create table entity ( object as text ) and serialize that objects to database.
--- El jue 10-sep-09, Shaun Seckman (Firaxis) <[email protected]> escribió: > De: Shaun Seckman (Firaxis) <[email protected]> > Asunto: Re: [sqlite] Question on converting objects into relational db > Para: "General Discussion of SQLite Database" <[email protected]> > Fecha: jueves, 10 de septiembre de 2009, 1:18 pm > You could either store the object as > a blob in the database or if you > had your own custom collection of these objects it's > possible that you > could create a virtual table that can be used as the glue > between SQLite > and this collection. > > -Shaun > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] > On Behalf Of Kavita Raghunathan > Sent: Thursday, September 10, 2009 12:02 PM > To: [email protected]; > General Discussion of SQLite Database > Subject: Re: [sqlite] Question on converting objects into > relational db > > The entity consists of an entity ID, and an attribute list. > The > attribute list could > be thought of as an array of integers or vector of > integers, and the > like. > > The problem I'm encountering by my affinity towards object > oriented is: > I dont want to keep 2 sets of data. One inside sqlite, and > one to read > from sqlite and model it as an object. > It would be cool if I could store this object > in the database. > > ----- Original Message ----- > From: "Ken" <[email protected]> > To: "General Discussion of SQLite Database" <[email protected]> > Sent: Thursday, September 10, 2009 8:45:11 AM GMT -08:00 > US/Canada > Pacific > Subject: Re: [sqlite] Question on converting objects into > relational db > > table might have columns, integer ID and BLOB entity. > > But it would be better if you could fully describe the > "Entity" internal > types instead of just a var arg... > > > > --- On Thu, 9/10/09, Kavita Raghunathan > <[email protected]> > wrote: > > > From: Kavita Raghunathan <[email protected]> > > Subject: [sqlite] Question on converting objects into > relational db > > To: "sqlite-users" <[email protected]> > > Date: Thursday, September 10, 2009, 10:30 AM > > > > I have a very high level question, not dealing with > bits > > and bytes of sqlite: > > > > I currently have an object called entity_list, that > has a > > list of all entities on the system. > > While thinking about it, it sounds like a list of > entities > > is like having a database. Would > > it be possible to transfer the object entity-list into > a > > sqlite database ? > > > > > > How would my schema look ? > > > > > > I have enclosed an idea of how my class looks. Any > links to > > useful information is > > appreciated! > > > > > > Kavita > > > > > > --------------- > > > > class entity_list > > { > > public: > > entity_list(); > > ~entity_list(); > > entity *get_specific_entity(int entity_id); > > entity *add_entity(int entity_id, void > *attr_list,...); > > remove_entity(int entity_id); > > vector<entity*> m_entity_list; > > > > > > private: > > }; > > > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Yahoo! Cocina Encontra las mejores recetas con Yahoo! Cocina. http://ar.mujer.yahoo.com/cocina/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
