4 ms·
What would be the advantage of using this instead of simple jsonb columns?
by salomonk_mur 2y ago
What would be the advantage of using this instead of simple jsonb columns?
- imnotjames 2y agoLooks like it natches the mongo node API
- joshmanders 2y agoIt uses JSONb under the hood. Just gives you a very "mongo" feel to using PostgreSQL. Not sure how I feel about it. CREATE TABLE IF NOT EXISTS %I (_id UUID PRIMARY KEY, data JSONB)
- wood_spirit 2y agoCan they make it use uuid7 for ids for better insert_becomes_append performance?
- lgas 2y agoYes
- oskar_dudycz 2y agoYes, I'm using JSONB underneath and translating the MongoDB syntax to native queries. As they're not super pleasant to deal with, then I thought that it'd be nice to use some familiar to many MongoDB API. Regarding IDs, you can use any UUID-compliant format.
- lopatin 2y agojsonb isn't web scale. Mongo is web scale.
- digger495 2y agoI see what you did there