Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
andri9up2944yBut but... I only know mysql😭
I like cartography and geographical information.
Postgres + GIS made me realize how limited MySQL is. Not just because of the awesome stuff you can do with GIS, but I feel so handicapped without CTEs.
MySQL is improving, but it still feels like: too little too late.
Florens4654ySo what are other recommended options? I see postgresql or whatever it's called being praised, anything else?
Still very new to this but I started with MariaDB.
@Florens MariaDB is the same as MySQL. Very few differences. It's good for storing data, but very bad for querying it.
Where it sucks however is flexibility when linking all of these languages together with other queries. And that's where Microsoft SQL Server shines. But that's in the next p
@Florens so now about Microsoft SQL Server.
They're now on Linux! Yay!
Is it free? Probably not. But since you're paying for PaaS anyway (Amazon RedShift for example), you might as well pay the same for Azure.
So why is it good?
Well, it's the fastest of any of the alternatives, especially when it comes to huge rows (tables with 100 columns or such). It's also very fast, as it often neglects the user's idiocy (by not having an index on a 5 million row table before querying it), and performs fast anyway. The best part of Microsoft SQL Server is that its language T-SQL integrates very well with SQL. You can declare a variable anywhere you want, use it, assign it, and output dynamic data sets without any issue. That's why it's also quite easy to make pivot tables in T-SQL, which you can't do in other systems. It's also extensible, using CRL assemblies.
Where it sucks is on basic functionality. Much poorer than PostgreSQL.
Florens4654y@apisarenco Woah, thanks so much for this explanation.
Never had problems with MySQL. Then again never had the chance to build any complex applications that TS mentioned.
@chasb96 Well that was the question: why do people still use it? There are only a handful of RDBMS out there that are worse than MySQL, and you've surely never heard of them.
MySQL suffers the same rant as PHP being a shitty DB. But like PHP it depends on the user. MySQL can be pretty much powerful if well optimized and running on a good environment. I have created financial systems running on the good old MySQL which has proven the database reliable. You are not providing reliable facts on why MySQL sucks and why a suitable alternative is needed.
@allankibet i have. Read again.
Write back when mysql deserves "sql" in it by supporting standard sql,
Like full outer joins, proper aggregation and group by, proper null handling in least and greatest functions, that doesn't change (breaking stuff) in a minor version. It's also slow.
Want fast? Go Postgresql, MSSQL. Mysql shouldn't even exist. It was never the best in any segment, and is now one of the worst in existence.