News for hackers. Stuff that matters.
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by nomilk on Sunday September 05, 2021 @07:35AM (#28423485)
As someone who does indie ruby stuff, often under time constraints, I find jsonb great for storing messy data that looks unnecessary, but which might be useful down the track. jsonb is just another type as far as postgres/rails is concerned, so it's fast implement (just like any other rails migration), fast to query, and easy to access using key/value (similar to the ruby hash).
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by paulryanrogers on Sunday September 05, 2021 @10:31AM (#28424613)
For speculative storage like that my preference is for files, ideally on something like S3. It's harder to analyze but IME the need is infrequent. Storage is usually significantly cheaper than a DB.
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by jrochkind1 on Sunday September 05, 2021 @08:46AM (#28423941)
If you are using Rails and jsonb, you may be interested in https://github.com/jrochkind/attr_json (by myself), or https://github.com/madeintandem/jsonb_accessor (an alternative).
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by bullfightonmars on Sunday September 05, 2021 @02:45PM (#28426648)
We wrote a similar library that hooks into ActiveRecord. https://github.com/data-axle/superstore
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by jrochkind1 on Sunday September 05, 2021 @02:46PM (#28426666)
Interesting, thanks, I hadn't seen this one before! So many of us inventing the same wheel! The docs on yours are kind of limited, I don't really understand how it maps to your postgres tables, what schema it's expecting. But I plan to find time to check it out just to compare and contrast with mine! Thanks!
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by bullfightonmars on Sunday September 05, 2021 @09:55PM (#28429507)
Yeah. We built this for our own use and haven’t really documented it extensively. We use it in conjunction with an elastic search ORM.

https://github.com/data-axle/elastic_record

Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by jrochkind1 on Monday September 06, 2021 @08:10AM (#28432903)
Again, interesting, thanks!

I hadn't seen that ElasticSearch ORM either! The more popular one of course is: https://github.com/elastic/elasticsearch-rails

It can be hard to know what open source is out there!