4 ms·
Postgresql has materialized views now: http://www.postgresql.org/docs/9.3/static/sql-creatematerializedview.html http://www.postgresql.org/docs/9.3/static/sql-
by lgas 12y ago
Postgresql has materialized views now:
http://www.postgresql.org/docs/9.3/static/sql-creatematerializedview.html http://www.postgresql.org/docs/9.3/static/sql-creatematerial...
Unless I'm misunderstanding what Xylakant means, that's certainly doable in Postgresql and has been in other relational databases for a long time.
- Xylakant 12y agoI didn't mean "view" in the sense of "database view" but rather in the sense of "page view". All data displayed on a page with multiple types of documents was returned in a single query. That's certainly doable in pg, but requires a lot of hacks and it's not efficient. Or you can use hstore and basically use pg as a nosql db.
- lgas 12y agoAh, that makes sense, though couldn't you solve this by something like creating a table called 'pages' and storing the materialized JSON (the same that mongo would generate) in the table?
- Xylakant 12y agoSure, you could. But CouchDB just makes that very easy to do while it is very hard and hacky in PG. On the flip side, the use case did not require the guarantees that PG has to offer, so why go through the pain for no gain :)