|
Salt Fish posted: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. *adds index to speed up reporting, website slows to a crawl due to huge index size*
|
# ? May 12, 2016 23:35 |
|
|
# ? May 4, 2024 03:05 |
|
qhat posted: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. conversely, i've seen a mysql server holding onto huge quantities of memory and just generally making GBS threads itself after an application generated a whole lot of prepared statements by mistake. even after the connection had been closed and associated resources should have been cleaned up. never figured what that was all about and the server had to be rebooted in the end
|
# ? May 12, 2016 23:37 |
|
At least mysql has on the wire compression going for it. It's a real shame nothing like that is supported by SQL server.
|
# ? May 13, 2016 00:46 |
|
yeah man gotta compress those tables so they fit in the pipes better
|
# ? May 13, 2016 01:08 |
|
Yes?
|
# ? May 13, 2016 01:12 |
|
qhat posted:SQL server has had absolutely no parallel since 2012. Maybe oracle but that poo poo is loving expensive for what you get. isn't that about the same time it got row numbering, or was that 2008
|
# ? May 13, 2016 01:24 |
|
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. postgres has transactional ddl create index concurrently too oh and jsonb now and upserts i mean there's even weird things like pg_trgm which lets you index things and search by regex
|
# ? May 13, 2016 01:26 |
|
i haven't used sql server since uh 2007-8 i think but it's still drat good at what it does but uh you have to kinda have a dba who knows deep dark magic to get it to perform miracles also the MSR work on hekaton/bw-trees/llama/deuteronomy is kinda neat
|
# ? May 13, 2016 01:28 |
|
MongoDB
|
# ? May 13, 2016 01:31 |
|
Janitor Prime posted: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. yes its very useful and i don't know why sql doesn't have a just_arbitrarily_pick_one() aggregate function
|
# ? May 13, 2016 01:33 |
|
tef posted:isn't that about the same time it got row numbering, or was that 2008 2012 was the first version that came with alwayson availability groups, which are super great
|
# ? May 13, 2016 01:33 |
|
PleasureKevin posted:MongoDB (which hired the wiredtiger group (i.e the other half of berkleydb, which was bought out by oracle), ...) mongodb built a product, got a user base, and is now taking that sweet, sweet, support money and buying up people with skills i mean tbh laugh at mongodb all you like but it's kinda rare to sell a database and make money edit: as a startup tef fucked around with this message at 01:59 on May 13, 2016 |
# ? May 13, 2016 01:48 |
|
more like blunderdome
|
# ? May 13, 2016 01:50 |
|
sql server, because 'MSSSMS' is a great loving name
|
# ? May 13, 2016 03:38 |
|
we use mysql and we put it on os x and we like it that way
|
# ? May 13, 2016 03:46 |
|
csv txt
|
# ? May 13, 2016 06:25 |
|
tmesis posted:we use mysql and we put it on os x and we like it that way um
|
# ? May 13, 2016 07:04 |
|
Lets talk about which geospatial extensions are our favorite. I have only used postgis and its cool and good, but I hear all the other players have their own?
|
# ? May 13, 2016 07:05 |
|
tmesis posted:we use mysql and we put it on os x and we like it that way Who is we?
|
# ? May 13, 2016 07:15 |
|
ADINSX posted:Lets talk about which geospatial extensions are our favorite. I have only used postgis and its cool and good, but I hear all the other players have their own? i got some GIS data once from a map provider and it was in a oracle database format and it was a huge pile of poo poo the data was ok, but oracle's poo poo is just a huge mess to work with. wouldnt bother. postgis supremacy
|
# ? May 13, 2016 07:45 |
|
db2 is nice if you have 100's of TBs of relational data
|
# ? May 13, 2016 10:22 |
|
spectres of autism posted:more like blunderdome
|
# ? May 13, 2016 12:06 |
|
microsoft excel, op
|
# ? May 13, 2016 12:27 |
|
spectres of autism posted:more like blunderdome
|
# ? May 13, 2016 13:06 |
|
lol if your job doesnt consist of 90% hacking through useless peon's hackjob SQL statements that are embedded directly into VBA modules in bespoke excel sheets because we only care about speed to market..
|
# ? May 13, 2016 13:11 |
|
refleks posted:lol if your job doesnt consist of 90% hacking through useless peon's hackjob SQL statements that are embedded directly into VBA modules in bespoke excel sheets because we only care about speed to market..
|
# ? May 13, 2016 15:30 |
|
op get the gently caress out of yospos
|
# ? May 13, 2016 16:20 |
|
refleks posted:lol if your job doesnt consist of 90% hacking through useless peon's hackjob SQL statements that are embedded directly into VBA modules in bespoke excel sheets because we only care about speed to market..
|
# ? May 13, 2016 16:25 |
|
bump
|
# ? May 13, 2016 16:27 |
|
oh wait i thought this thread was in CoC for some reason
|
# ? May 13, 2016 16:27 |
|
MSSQL is the best database
|
# ? May 13, 2016 16:46 |
|
im curious how mysql got more adoption than postgres, or seems to have been more widely adopted in the 00s i'd be money on the default php library being made to target it or something like that mongo is a pos i will never work with mongo again as long as i live unless the money is really good
|
# ? May 13, 2016 17:00 |
|
Share Bear posted:im curious how mysql got more adoption than postgres, or seems to have been more widely adopted in the 00s yes it's because php
|
# ? May 13, 2016 17:46 |
|
Share Bear posted:im curious how mysql got more adoption than postgres, or seems to have been more widely adopted in the 00s not my sql
|
# ? May 13, 2016 19:52 |
|
why is it even called mysql
|
# ? May 13, 2016 19:52 |
|
there's a python mysql library called oursql
|
# ? May 13, 2016 19:53 |
|
MALE SHOEGAZE posted:why is it even called mysql named after one of the creator's daughter i think
|
# ? May 13, 2016 20:27 |
|
CRIP EATIN BREAD posted:i got some GIS data once from a map provider and it was in a oracle database format and it was a huge pile of poo poo I'm repairing an oracle spacial db as we speak that somehow managed to corrupt itself over two weeks ago with no one noticing until it restarted for patches. good times, totally not a clusterfuck or anything.
|
# ? May 13, 2016 20:32 |
|
I'm getting a poor vibe about oracle ITT. I mean I've not actually had to use it personally, and I've heard it has some nice performance features which are unrivaled, but also that it costs an order of magnitude higher than basically everything else. Databases corrupting themselves on a semi regular basis isn't something that sounds all that great to work with, however.
qhat fucked around with this message at 21:10 on May 13, 2016 |
# ? May 13, 2016 21:06 |
|
|
# ? May 4, 2024 03:05 |
|
mongodb, works for me!
|
# ? May 13, 2016 21:11 |