|
Microsoft SQL Server is the best, thread loving over.
|
# ? May 12, 2016 20:30 |
|
|
# ? Apr 25, 2024 22:05 |
|
Ok I'll allow a limited number of alternative SQL databases. Go
|
# ? May 12, 2016 20:37 |
|
postgres rules everything around me also get out you're a fuckin terrible poster
|
# ? May 12, 2016 20:38 |
|
lmfao
|
# ? May 12, 2016 20:38 |
|
first post to refute the ultimate truth of my post, and you bring up loving postgres
|
# ? May 12, 2016 20:39 |
|
graph im requestin' a pity ban for the op here
|
# ? May 12, 2016 20:40 |
|
who cares, sql is shite that needs to be used sometimes, and it's very boring
|
# ? May 12, 2016 20:40 |
|
LP0 ON FIRE posted:who cares, sql is shite that needs to be used sometimes, and it's very boring SQL is more important to the modern economy than anything you do on the reg
|
# ? May 12, 2016 20:41 |
|
SQL server has had absolutely no parallel since 2012. Maybe oracle but that poo poo is loving expensive for what you get.
|
# ? May 12, 2016 20:41 |
|
Captain Foo posted:SQL is more important to the modern economy than anything you do on the reg it's still very boring though.
|
# ? May 12, 2016 20:43 |
|
Captain Foo posted:SQL is more important to the modern economy than anything you do on the reg important and boring. just like it's very difficult to master the game go, go is still boring
|
# ? May 12, 2016 20:44 |
|
microsoft are even putting it on linux now so really there is no excuse to not use it if you're actually serious about your databases
|
# ? May 12, 2016 20:44 |
|
im enjoying* the op taking the anti-shaggar gimmick in one thread and the shaggar gimmick in another *not in the least
|
# ? May 12, 2016 20:53 |
|
mongodb, the database of idiots who think fat32 permissions are too complicated
|
# ? May 12, 2016 20:54 |
|
BangersInMyKnickers posted:mongodb, the database of idiots who think fat32 permissions are too complicated write permission equivalent to /dev/null, read permission equivalent to /dev/zero
|
# ? May 12, 2016 20:55 |
|
qhat posted:SQL server has had absolutely no parallel since 2012. Maybe oracle but that poo poo is loving expensive for what you get. we had three different oracle db's manage to corrupt themselves while rebooting for patches this month. never had a single blip on the mssql ones. oracle is for SAP backends or if you hate yourself and love to do a bunch of bullshit busywork to justify your existence
|
# ? May 12, 2016 20:55 |
|
gas op ban thread
|
# ? May 12, 2016 20:55 |
|
This thread while Tori is probed? Cowardly move, bitch.
|
# ? May 12, 2016 20:58 |
|
Smythe posted:This thread while Tori is probed? Cowardly move, bitch.
|
# ? May 12, 2016 20:59 |
|
sqlite op
|
# ? May 12, 2016 21:05 |
|
im going to say the phrase db2 and see what happens
|
# ? May 12, 2016 21:06 |
|
Captain Foo posted:im enjoying* the op taking the anti-shaggar gimmick in one thread and the shaggar gimmick in another this has nothing to do with gimmicks. to tell you the truth i really don't like windows poo poo but i have to hand it to microsoft, SQL Server is ridiculously versatile.
|
# ? May 12, 2016 21:07 |
|
my company uses oracle. that's not the funny part. the funny part is that we promoted half the DBAs to management and fired almost all the rest, so if we want a table change it's a 2+ month wait. DBAs dont actually design the table changes, they just make sure the table and column names fit with the company policy and press the "Approve" button. upper management is helpless to fix the situation
|
# ? May 12, 2016 21:10 |
|
yard salad posted:my company uses oracle. that's not the funny part. the funny part is that we promoted half the DBAs to management and fired almost all the rest, so if we want a table change it's a 2+ month wait. DBAs dont actually design the table changes, they just make sure the table and column names fit with the company policy and press the "Approve" button. upper management is helpless to fix the situation
|
# ? May 12, 2016 21:17 |
|
qhat posted:this has nothing to do with gimmicks. to tell you the truth i really don't like windows poo poo but i have to hand it to microsoft, SQL Server is ridiculously versatile. you're out of your depth.
|
# ? May 12, 2016 21:18 |
|
Captain Foo posted:you're out of your depth. sounds like you have something interesting to say about this database technology. let's hear it then
|
# ? May 12, 2016 21:21 |
|
qhat posted:sounds like you have something interesting to say about this database technology. let's hear it then
|
# ? May 12, 2016 21:24 |
|
it's really weird up how oracle's hosed up proprietary sql syntax is frozen immediately at the moment when it got really huge and popular
|
# ? May 12, 2016 21:25 |
|
when would you use postgres instead of mysql besides hating on the man, the myth, the legend
|
# ? May 12, 2016 21:31 |
|
mariadb is a good database (works) but i hear postgres is faster. my queries are simple though so why bother changing what works.
|
# ? May 12, 2016 21:34 |
|
paying for oracle DB indirectly contributed to a federal judge learning java, so that's a mega argument in one column or another for oracle, but I can't tell which tbqh
|
# ? May 12, 2016 22:26 |
|
Share Bear posted:when would you use postgres instead of mysql besides hating on the man, the myth, the legend when you need to do more than just shove data in tables and then retrieve the exact same thing later. or you need to use an index more complex than a b-tree or hash. or you actually care about transaction support for more than crud operations. or you sort of care about preserving the integrity of your database and not being able to do poo poo like deleting the tables behind your views without your db having a problem with that i can't say that the mysql c client barfing out gigabytes of warnings at me the last time i had to compile it really helped my perception either i'm also gonna say db2 is the best even though i've never used it or read anything about it since i really like mainframes and that kind of fancy hardware crap
|
# ? May 12, 2016 23:04 |
|
i have to use embarcadero software sometimes at work and that poo poo is the loving worst. not a db but i just wanted to say it
|
# ? May 12, 2016 23:19 |
|
Maximum Leader posted:mariadb is a good database (works) but i hear postgres is faster. my queries are simple though so why bother changing what works. hope you've intenalised the 1000 weird mysql edge cases here's a bunch of them from someone who likes mysql http://mysql.rjweb.org/doc.php/ricksrots eg quote:⚈ OR may be very inefficient; turn into UNION. ah yes, good query optimiser we have here
|
# ? May 12, 2016 23:20 |
|
mysql has a query optimizer?
|
# ? May 12, 2016 23:24 |
|
i mean, other than the dude you pay to rewrite queries all day
|
# ? May 12, 2016 23:25 |
|
It doesn't matter which one you use because your boss wants to store every single hit to the website in a single 300gb table with no index.
|
# ? May 12, 2016 23:27 |
|
my stepdads beer posted:hope you've intenalised the 1000 weird mysql edge cases Although you could probably make a list this large on the MSSQL MERGE syntax alone
|
# ? May 12, 2016 23:30 |
|
YeOldeButchere posted:mysql has a query optimizer? the best thing about mysql is the stored procedures don't have their query plans cached server side. they are generated every single time a connection is opened.
|
# ? May 12, 2016 23:31 |
|
|
# ? Apr 25, 2024 22:05 |
|
Share Bear posted:when would you use postgres instead of mysql besides hating on the man, the myth, the legend Also if you care about standards If you're doing a group by and try to include a column in the select statement that isn't part of the group by then every other SQL backend complains, but MySQL will just helpfully return some value without complaining making it seem like it's correct and then later the query planner fucks you and actually returns a different unexpected value. If you ask MySQL to return a null date column it will instead return 0000-00-00 which then breaks your Java code, hopefully your admin changed the mode of MySQL to not do this poo poo
|
# ? May 12, 2016 23:33 |