Good Morning
-
pg can actually query into json fields!
Mysql can too, slow af tho.
-
I usually tell people running MySQL that they would probably be better off using a NoSQL key-value store, SQLite, or PostgreSQL, in that order. Most people using MySQL don't actually need an RDBMS. MySQL occupies this weird niche of being optimised for mostly reads, not a lot of concurrency and cosplaying as a proper database while being incompatible with SQL standards.
incompatible with SQL standards.
Wait... Wait a minute, is that Oracle's entrance music‽
-
Mysql can too, slow af tho.
oh i didn't know that. iirc postgres easily beats mongo in json performance which is a bit embarrassing.
-
oh i didn't know that. iirc postgres easily beats mongo in json performance which is a bit embarrassing.
Holy, never knew, and never would expect. Postgres truly is king.
-
Or portable like on a USB stick that you can put in any computer instead of installed on a single system.
Either way, the funny thing is that Postgres can do both too. You may not want to use it for those, but you absolutely can.
-
Kind of. I hope you don't like performance...
The performance is actually not bad. You're far better off using conventional columns but in the one off cases where you have to store queryable JSON data, it actually performs quite well.
-
The performance is actually not bad. You're far better off using conventional columns but in the one off cases where you have to store queryable JSON data, it actually performs quite well.
Quite well is very subjective. It's much slower than columns or specialized databases like MongoDB.
-
It isn't pronounceable as a word, it is an initialism because the letters that compromise it do not allow it to be pronounced as a word. Unlike something like NASA which is a full blown acronym because it can be pronounced
Do you say hetips for HTTPS?
The sequel thing didn't even start naturally, it picked up this sequel moniker because of some ancient trademark beef in the 70s between the original devs when it was named "Sequel" and some company (That isn't even in business anymore)
They renamed it SQL and out of protest against the company people continued to call it sequel even though it makes no sense and 50 damn years later here we are. Everybody involved with direct involvement is probably dead or longggg since retired. It wasn't termed because it was easier to say and it sure as hell wasn't termed because its proper.
If it was originally called SQL and the above never happened, I guarantee it would just be another DNS or HTTP and many many pointless debates about it would have never happened
Disclaimer, this doesn't apply to the MS product that is called sequel
Do you say hetips for HTTPS?
No but now I want to start (though I'd go hittips instead, and its insecure alternative, hittip). HTTPS has always been a mouthful lol
-
Kind of. I hope you don't like performance...
Sure, if you use a field often it is most likely better to extract it into a column with auto-updates from the JSON data.
But you have to tune it and see what is best for your use case. Just saying that you can add indexes to JSON fields as well!
-
This is literally me at every possible discussion regarding any other RDBMS.
My coworkers joked that I got paid for promoting Postgres.
Then we switched from Percona to Patroni and everyone agreed that... fuck yes, PostgreSQL is the best.
Sure, once you make the move it’s great. It’s just that it takes time and resources to actually make the move
-
Sure, once you make the move it’s great. It’s just that it takes time and resources to actually make the move
I mean, with mysql_fwd, I migrated the data quickly, and apart from manual 'on duplicate update' queries (or rare force index) it works the same.
