Hobson Lane · @hobs
778 followers · 2326 posts · Server mstdn.social

@masukomi
I don't use regularly, just in , so I'm guessing:
1. Mongo users could port data into pg using existing & infrastructure, then they'd have both SQL and mongo query/dump/load options for future
2. The pg API will lag mongo's and sunset existing features later. And api as a fallback
3. A mongo app could transition to pg incrementally or partially, increasing maintainability by using mongo queries and SQL queries where they make sense

#SQL #migrations #recovery #Backup #PG #jsonb #mongo

Last updated 2 years ago

Francesco Tisiot · @ftisiot
278 followers · 71 posts · Server hachyderm.io

Are you in world, bashing your head against the (or ) column?

Check out the new !

aiven.io/developer/postgresql-

#postgresql #json #jsonb #CheatSheet

Last updated 2 years ago

Francesco Tisiot · @ftisiot
168 followers · 46 posts · Server data-folks.masto.host

Can I use a to store, parse and analyse data?

It turns out is pretty good at it with the dedicated functions

Check out an example, finding a good restaurant in India!

aiven.io/blog/pg-json-indian-r

#relationaldatabase #semistructured #json #PostgreSQL #jsonb

Last updated 3 years ago

bmarwell · @bmarwell
43 followers · 489 posts · Server layer8.space

Typical example where YAGNI failed me. I wrote a java lib for accessing a specific rest API. Because Y., I had only two modules: api and jaxrs-jackson-impl.
Now another project used . Sigh.

#maven #jakarta #jsonb

Last updated 3 years ago

bmarwell · @bmarwell
43 followers · 489 posts · Server layer8.space

Blog post:
How to use (by @lhazlewood@twitter.com) with (Bind-API). Works with both Eclipse Yasson (used by @OpenLibertyIO@twitter.com) and Apache Johnzon.

blog.bmarwell.de/2022/05/12/us

#jjwt #jakarta #jsonb

Last updated 3 years ago