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) <shaun.seck...@firaxis.com> escribió: > De: Shaun Seckman (Firaxis) <shaun.seck...@firaxis.com> > Asunto: Re: [sqlite] Question on converting objects into relational db > Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > 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: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Kavita Raghunathan > Sent: Thursday, September 10, 2009 12:02 PM > To: kennethinbox-sql...@yahoo.com; > 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" <kennethinbox-sql...@yahoo.com> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > 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 > <kavita.raghunat...@skyfiber.com> > wrote: > > > From: Kavita Raghunathan <kavita.raghunat...@skyfiber.com> > > Subject: [sqlite] Question on converting objects into > relational db > > To: "sqlite-users" <sqlite-users@sqlite.org> > > 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 > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
