Top all-time · #5560
Oleg Bartunov
Personal blog · obartunov.livejournal.comdataprogramming
Oleg Bartunov's personal blog at obartunov.livejournal.com covers data and programming. Since 2013, 14 different Hacker News readers have linked it 15 times, most often “Hstore development for 9.4 release”. No feed was found, so read it on the site itself.
Too few sampled comments (7) to say how often HN recommends it.?
Why HN links it
HN readers cite Oleg Bartunov's LiveJournal posts on PostgreSQL's document and NoSQL-style features, such as hstore, jsonb, and performance comparisons with MongoDB, as sources on Postgres development.
Summarised by Claude from a sample of 7 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Hstore development for 9.4 release3 people · 3 mentions · first linked 2013-11-07
- SQL/JSON Standard-2016 Conformance for PostgreSQL, Oracle, SQL Server and MySQL3 people · 3 mentions · first linked 2019-03-01
- PostgreSQL 9.4 will support document database model using Hstore2 people · 2 mentions · first linked 2013-07-08
- PostgreSQL: Jsonb has committed2 people · 2 mentions · first linked 2014-03-24
What Hacker News says?
Postgres 11 doesn't follow the standard at all (as per your link). A third party implemented the standard [0] which was submitted on pghackers[1] very late in the Postgres 11 cycle[2] (at 75k gzipped the patch is pretty humongous). A quick googling doesn't show any information pertaining it being integrated (in part or full) into pg12 so IDK. edit: apparently https://commitfest.postgresql.org/17/1471/ has been "Wait…
Comment linking /200076.html
on “JSON with Sqlite”Submitted PostgreSQL: Jsonb has committed as a story · 416 points
HN discussionMaybe this is what you are looking for: http://www.sai.msu.su/~megera/postgres/talks/hstore-dublin-2... How the ideas migrated from hstore to jsonb is briefly described here: http://obartunov.livejournal.com/177247.html http://www.postgresql.org/message-id/53304439.8000602@dunsla...
Comment linking /177247.html
on “PostgreSQL: Jsonb has committed”Submitted Hstore development for 9.4 release as a story · 310 points
HN discussionIf your operations are tied in some way to government, it might be required that software you are using have legally recognizable developer or owner, officially certified by competent government structures (e.g. in terms of being secure) and/or has someone who is contractually obliged to help you resolve any issues you might face while using it. I would assume Oracle has a very strong presences in Russia in those te…
Comment linking /181484.html
on “Oracle's letter to Russian IT companies”Submitted SQL/JSON Standard-2016 Conformance for PostgreSQL, Oracle, SQL Server and MySQL as a story · 3 points
HN discussion> Subject: Re: Russian (8-bit) Search ? https://obartunov.livejournal.com/174726.html
Comment linking /174726.html
on “Google's 20th Birthday”Submitted Oleg Bartunov: My Postgres Story: Internationalization as a story · 2 points
HN discussion>Web 3.0 Is that what we're calling this whole 30 lines of javascript, mongo and redis behind the WAN, dynamic language runtime inside the DB era? Cool. EDIT: saying that, some kind of featureful document store implementation inside postgres seems inevitable. Isn't that all going to be hstore-based though, what with the new stuff coming in 9.4? I thought the json type was meant to be kind of a stopgap until the full…
Comment linking /175235.html
on “PgREST: Node.js in the Database, compatible with MongoLab and Firebase API”Submitted Wildspeed for Postgres – a fast wildcard search for LIKE operator as a story · 2 points
HN discussionPostgresql 9.4 will likely extend hstore to store things other than strings. http://obartunov.livejournal.com/172503.html
Comment linking /172503.html
on “Rapid schema development with PostgreSQL”Submitted PostgreSQL 9.4 will support document database model using Hstore as a story · 2 points
HN discussionPostgresql has gradually and intelligently been incorporating NoSql features e.g: hstore, hstore2, json, jsonb, etc. There are powerful features like indexing, etc. There are even cases where performance has been found to be better than e.g: mongo: source: http://obartunov.livejournal.com/175235.html There is a lot of momentum behind the improvements/additions. We will be seeing much more NoSql in 9.4, 9.5, and beyo…
Comment linking /175235.html
on “Using PostgreSQL Arrays The Right Way”Submitted SQL/JSON Standard-2016 Conformance for PostgreSQL, Oracle, SQL Server and MySQL as a story · 1 points
HN discussionSubmitted Jsonb: "Wildcard" query as a story · 1 points
HN discussion
