How to database insert JSON?

[Apple]

@scalaris

full text search using gin/gist columms and tsvectors. We had been using elastic search but the gin/gist capability is equally performant on 5M+ records.

This looks cool stuff, thanks for sharing the insight!

It seems you're doing something similar to Ken's - I've opened a feature request for my specific use-case:

Database Insert/Update/Delete from JSON

Please consider a database query “users”: [ { "id": 1, "name": "George", "country": "NL" }, { "id": 2, "name": "Teodor", "country": "BG" } ] That’s a JSON representation of our rows. Through a series of steps, I modify the names: [ { "id": 1, "name": "George P.", "country": "NL" }, { "id": 2, "name": "Teodor T.", "country": "BG" } ] Now, I want to UPDATE the databas…