Top all-time · #6386
clarkdave.net
Personal blog · clarkdave.netdataprogramming
clarkdave.net is a personal blog at clarkdave.net about data and programming. Since 2013, 13 different Hacker News readers have linked it 13 times, most often “Historical records with PostgreSQL, temporal tables and SQL:2011”. The last post was in 2016, but the archive is still widely read.
Too few sampled comments (8) to say how often HN recommends it.?
Why HN links it
HN readers link these posts for using PostgreSQL's JSON type as a schema-less alternative to MongoDB, and for building historical records with temporal tables in Postgres.
Summarised by Claude from a sample of 8 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Historical records with PostgreSQL, temporal tables and SQL:20115 people · 5 mentions · first linked 2015-08-30
- What can you do with PostgreSQL and JSON? (2013)5 people · 5 mentions · first linked 2013-12-22
- Historical records with PostgreSQL, temporal tables and SQL:2011(2015)2 people · 2 mentions · first linked 2021-03-07
What Hacker News says?
Mongo is rarely the answer for high performance, high transaction systems. I use it quite happily to prototype applications due to it's very low boilerplate overhead. If you need schema-less data storage in a "real" database, use PostgreSQL's JSON type. http://clarkdave.net/2013/06/what-can-you-do-with-postgresql...
Comment linking /2013/06/what-can-you-do-with-postgresql-and-json/
on “Goodbye MongoDB, Hello PostgreSQL”Submitted Historical records with PostgreSQL, temporal tables and SQL:2011 as a story · 4 points
HN discussionCan't something like that work as SQL:2011 temporal tables? Postgres equivalent solution in this [0] rather complex but great tutorial [0]: https://clarkdave.net/2015/02/historical-records-with-postgr...
Comment linking /2015/02/historical-records-with-postgresql-and-temporal-tables-and-sql-2011/
on “Dolt is Git for Data: a SQL database that you can fork, clone, branch, merge”Submitted What can you do with PostgreSQL and JSON? (2013) as a story · 3 points
HN discussionSwitched over to PostgreSQL for a personal project for the json datatype. Great if you want some mongo-esque document storage without losing out on having a relational database. http://clarkdave.net/2013/06/what-can-you-do-with-postgresql...
Comment linking /2013/06/what-can-you-do-with-postgresql-and-json/
on “PostgreSQL 9.4 Released”Submitted Historical records with PostgreSQL, temporal tables and SQL:2011 as a story · 3 points
HN discussionHere's two more-- http://clarkdave.net/2015/02/historical-records-with-postgre... https://pgxn.org/dist/temporal_tables/
Comment linking /2015/02/historical-records-with-postgresql-and-temporal-tables-and-sql-2011/
on “PostgreSQL 10 Beta 1 Released”Submitted Historical records with PostgreSQL, temporal tables and SQL:2011(2015) as a story · 1 points
HN discussionYes, you can do extract values from JSON, filter based on those values and even create indices - not sure if that counts as "Mongo-style queries" but I've used it and it works pretty well: http://clarkdave.net/2013/06/what-can-you-do-with-postgresql... The only thing to note about current JSON support in PostgreSQL is that, as far as I know, there is no way to update parts of a JSON document - you have to rewrite th…
Comment linking /2013/06/what-can-you-do-with-postgresql-and-json/
on “PostgreSQL: Jsonb has committed”Submitted Historical records with PostgreSQL, temporal tables and SQL:2011 as a story · 1 points
HN discussionDelta queries can be serviced by any system that supports temporal tables[0][1], or another mechanism where data changes are tracked. [0] - https://en.wikipedia.org/wiki/SQL:2011 (temporal support) [1] - https://msdn.microsoft.com/en-us/library/dn935015.aspx [2] - http://clarkdave.net/2015/02/historical-records-with-postgre...
Comment linking /2015/02/historical-records-with-postgresql-and-temporal-tables-and-sql-2011/
on “Microsoft REST API Guidelines”You can use a plugin like assets-webpack-plugin [0] to get a JSON file that maps to the compiled file names. That's basically the same thing asset pipeline would do. Here's a blog post [1] explaining how to use webpack with rails. [0] https://github.com/kossnocorp/assets-webpack-plugin [1] http://clarkdave.net/2015/01/how-to-use-webpack-with-rails/#...
Comment linking /2015/01/how-to-use-webpack-with-rails/
on “Rails 5.1.0 Beta 1”JSON has non-string values and nesting. [1] I read somewhere that nesting in hstore is coming in the next version (Q3 2014?) and non-string types are on deck. Compared to the nightmarish development workflows and processes I've had to deal with resulting from using CouchDB as a main datastore, having to get the entire JSON value in order to update one key seems like not that big of a deal. What NoSQL databases even…
Comment linking /2013/06/what-can-you-do-with-postgresql-and-json/
on “Startups should use a relational database”
