๐Ÿ‡ฉ๐Ÿ‡ช Kura Bloodlust is a user on niu.moe. 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.
๐Ÿ‡ฉ๐Ÿ‡ช Kura Bloodlust @kura

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

what are your opinions?

ยท 0 ยท 0

@kura Believe it or not I've been asked what I think of shitstemd during an interview. I've never decided I don't even want the job so quickly before.

@kura Oops did I misspell systemd again

@noriko i like systemd thank you very much :smug_kura:

though init system wasnt my question in the first place

@kura Oh darn it I read too fast. I thought you were asked about these during an interview.

Back to your problem then; SQL is what you want. 99.9% of the time at least.

@noriko for interviews i have the most clever answers all the time. usually. maybe. x)

@kura #postgres

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.

@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

@kura I wrote an app first with RethinkDB and later I changed to PostgreSQL after the news of RethinkDB shutting down... X'D It had more performance and it was easier to work with after I changed to PostgreSQL... :O

@mb tbh it all depends. i really love rethinkdb's changeset feature.

@mb PS: not using rdb bc of the issues with the repo