The CULT PONY is a user on pony.social. You can follow them or interact with them if you have an account anywhere in the fediverse. If you don't, you can sign up here.

i hate this moment during dev:
#nosql (probably mongo) vs #sql (postgres)

what are your opinions?

The CULT PONY @cult

@kura

Once you discover all the neat features this RDBMS has, you never want to go back.

Any why would you? PG offers NoSQL features via JSONB. Heck, I can even treat anything inside a JSON just like any column in my database with PG.

99% of the time, standard SQL is all you need. The 1% of the time you need the non-standard SQL features of PG.

Β· 1 Β· 1

@cult yeah, its sad for psql to not be the ultimate tool for everything. i wish it could brew my coffee.

@kura @cult I find that the times I need a sql db are a superset of the ones I need a document db.

if you're talking about time series and graph dbs then yeah they're the (more) useful kind of nosql