Re: [GENERAL] Dynamic data model, locks and performance

This example is certainly a workable situation. However it does require understanding the constraints of an ALTER TABLE statement and manually developing appropriate scripts. The update model offered my ChronicDB accounts for schema changes of considerable complexity, such as merging fields, parti

Re: [GENERAL] Dynamic data model, locks and performance

On 07/30/2010 10:20 PM, John R Pierce wrote: On 07/30/10 1:08 PM, Andreas Joseph Krogh wrote: You might want to take a look at TopicMaps, http://www.topicmaps.org/ One of the greatest topicmap-engines is opensource: http://www.ontopia.net/ Huh, visited both those sites, and I still have no i

Re: [GENERAL] Dynamic data model, locks and performance

On 07/30/10 1:08 PM, Andreas Joseph Krogh wrote: You might want to take a look at TopicMaps, http://www.topicmaps.org/ One of the greatest topicmap-engines is opensource: http://www.ontopia.net/ Huh, visited both those sites, and I still have no idea what TopicMaps actually are. -- Sent vi

Re: [GENERAL] Dynamic data model, locks and performance

On 07/29/2010 05:15 AM, Pierre Thibault wrote: 2010/7/28 Craig Ringer > On 29/07/10 07:06, Pierre Thibault wrote: I doubt anyone can make any useful recommendations without a more complete explanation of what you're trying to achieve and why you wa

Re: [GENERAL] Dynamic data model, locks and performance

On 29/07/10 22:36, Pierre Thibault wrote: > Why so? This is something expected by a database used in a constant > integration environment. Maybe I did not expressed myself very well. Users > are not changing their models all the time. They create new models which > mean create new tables and from

Re: [GENERAL] Dynamic data model, locks and performance

Pierre Thibault wrote: Hello people of the Postgresql world! I am wondering if Postgresql would a great choice for my database needs. I would like to create a db with dynamic data model. I would like to be able to add tables and columns to existing tables while other queries are running. It s

Re: [GENERAL] Dynamic data model, locks and performance

On 29/07/10 11:15, Pierre Thibault wrote: > What I would like to do is enable users to create their own data model. Then, really, SQL databases aren't wonderful for your needs. You can use them for dynamic, user-defined schema, but you'll always be swimming up hill. > I thought about using a tab

Re: [GENERAL] Dynamic data model, locks and performance

On Wed, Jul 28, 2010 at 10:15 PM, Pierre Thibault wrote: > > What I would like to do is enable users to create their own data model. > Enable them to create a model and make > it evolve. For example, it would be > cool to create a model to represent car adds. Then, the buyers can search > adds

Re: [GENERAL] Dynamic data model, locks and performance

2010/7/28 Craig Ringer > On 29/07/10 07:06, Pierre Thibault wrote: > I doubt anyone can make any useful recommendations without a more > complete explanation of what you're trying to achieve and why you want > to do what you have described. > Thank you Craig, Yes, I was not very specific. I hav

Re: [GENERAL] Dynamic data model, locks and performance

On 29/07/10 07:06, Pierre Thibault wrote: > Hello people of the Postgresql world! > > I am wondering if Postgresql would a great choice for my database needs. > > I would like to create a db with dynamic data model. I would like to be > able to add tables and columns to existing tables while othe

[GENERAL] Dynamic data model, locks and performance

Hello people of the Postgresql world! I am wondering if Postgresql would a great choice for my database needs. I would like to create a db with dynamic data model. I would like to be able to add tables and columns to existing tables while other queries are running. Will Postresql be able to mana