Search SSWUG.ORG:

DATABASES

Using HStore for Archiving This is an off-site link.  Please review our Terms of Service for additional information.




(Leo Hsu and Regina Obe) I'm not a big proponent of schemaless designs, but they have their place. One particular place where I think they are useful is for archiving of data where even though the underlying table structure of the data you need to archive is changing, you want the archived record to have the same fields as it did back then. This is a case where I think Hstore and the way PostgreSQL has it implemented works pretty nicely.

Read this article...







comments powered by Disqus