|
Shaggar posted:MSSQL is the best database it's the king of poo poo mountain
|
#
?
May 13, 2016 21:12
|
|
|
|
| # ? Apr 26, 2024 09:46 |
|
|
qhat posted: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. I'm p.sure this is fallout from the incompetent dba we shitcanned and nothing directly oracle's fault. don't hire a 45k dba, its stupid and you'll lose data
|
|
#
?
May 13, 2016 21:36
|
|
|
nah, oracle is a huge pile of poo poo. it's like mysql from 20 years ago and they make no attempt to make it more dev friendly. they also charge u to use it and force you into other proprietary garbage in order to make it harder to switch to a good db.
|
|
#
?
May 13, 2016 21:46
|
|
|
wish the OP would denormalize he self
|
|
#
?
May 13, 2016 21:49
|
|
|
Roosevelt posted:mongodb, works for me! MongoloidDB
|
|
#
?
May 13, 2016 21:54
|
|
|
Roosevelt posted:mongodb, works for me! Eat hell and go to hell
|
|
#
?
May 13, 2016 21:56
|
|
|
Janitor Prime posted:Also if you care about standards lol at all of this mysql: an rdbms for clowns
|
|
#
?
May 14, 2016 02:49
|
|
|
one of our vendors uses mysql for a mission critical application and it's as much of a daily shitshow as you are imagining
|
|
#
?
May 14, 2016 02:50
|
|
|
Julie And Candy posted:one of our vendors uses mysql for a mission critical application and it's as much of a daily shitshow as you are imagining this very forum uses mysql for mission critical posting
|
|
#
?
May 14, 2016 03:06
|
|
|
i still have foxbase and whatever the gently caress as/400 runs in my daily workflow gently caress you hipster kids, i'm the one actually living in the early 90s
|
|
#
?
May 14, 2016 03:34
|
|
|
my org actively uses FileMaker, and not as legacy software
|
|
#
?
May 14, 2016 04:01
|
|
|
we use a combination of xlsx, cvs, and mat files stored in SVN
|
|
#
?
May 14, 2016 04:12
|
|
|
literally just earlier today the idea "hey lets stick all this poo poo in a database" was shot down in favor of bespoke artisanal handcrafted text files to be parsed with "perl or matlab" for storing extremely tabular data. this is all new work too theres no legacy hangups other than old loving idiots
|
|
#
?
May 14, 2016 04:14
|
|
|
Bloody posted:we use a combination of xlsx, cvs, and mat files stored in SVN lomarfdb
|
|
#
?
May 14, 2016 04:17
|
|
|
tef posted:postgres has transactional ddl update materialized view concurrently too, gonna see how bad that blows up in prod next week
|
|
#
?
May 14, 2016 04:38
|
|
|
postgresql is good thanks bye
|
|
#
?
May 14, 2016 05:15
|
|
|
Bloody posted:we use a combination of xlsx, cvs, and mat files stored in SVN my front end is basically excel that pulls previously mentioned as/400, foxbase and access stuff via odbc connectors & kilometers of vba can this be the terrible db implementation thread? i've seen some stuff man...
|
|
#
?
May 14, 2016 06:59
|
|
|
as/400 uses something called db400, it's basically db2. protip: you can probably login with l/p db2/db2 and get basically-root access to the db
|
|
#
?
May 14, 2016 08:21
|
|
|
i use the non-relational (nosql) database named mongodb. perhaps you've heard of it. it's very good.
|
|
#
?
May 14, 2016 08:44
|
|
|
Bloody posted:we use a combination of xlsx, cvs, and mat files stored in SVN lmaao
|
|
#
?
May 14, 2016 09:47
|
|
|
Roosevelt posted:i use the non-relational (nosql) database named mongodb. perhaps you've heard of it. it's very good. have they fixed the thing where you can't make writes without checking the server if the error flag is set after every single one?
|
|
#
?
May 14, 2016 12:16
|
|
|
have they fixed the thing where doing a write acquires an exclusive lock on the entire loving database, making write performance utter trash and generating contention with the rebalancing process thus ensuring that adding a new machine to the cluster will take on the order of a week if the db is under load?
|
|
#
?
May 14, 2016 16:45
|
|
|
who cares what sql database you use, they all suck anyway and you'll never build a query the "right" way as long as it isn't some obviously terrible garbage like mongo
|
|
#
?
May 14, 2016 19:48
|
|
|
if you want to spend money but not too much get mssql if you want to spend all of your money get oracle if you're cheap get postgres if you're stupid get mongo
|
|
#
?
May 14, 2016 20:03
|
|
|
Bloody posted:literally just earlier today the idea "hey lets stick all this poo poo in a database" was shot down in favor of bespoke artisanal handcrafted text files to be parsed with "perl or matlab" for storing extremely tabular data. this is all new work too theres no legacy hangups other than old loving idiots This is every company in finance. The foundation is COBOL mainframes, and frontend is always the most incomprehensible mess of .csv and .txt files stored on networked drives to be loaded into excel. like, people will actually call their collection of .csv files a database. "Oh yeah, we have that in our database, just go to x-drive" *Folder with a .csv file for every transaction for every day in the last 5 years*
|
|
#
?
May 14, 2016 21:22
|
|
|
postgresql was very slow in the early 2000s and the garbage tier shared hosts everyone used couldn't really run it. therefore mysql proliferated
|
|
#
?
May 14, 2016 22:05
|
|
|
vertica is p deece for olap
|
|
#
?
May 14, 2016 22:09
|
|
|
LP0 ON FIRE posted:who cares, sql is shite that needs to be used sometimes, and it's very boring
|
|
#
?
May 14, 2016 22:19
|
|
|
anytime i need to install something and it needs a db i choose poastgres and it just werks
|
|
#
?
May 14, 2016 22:21
|
|
|
YeOldeButchere posted:have they fixed the thing where doing a write acquires an exclusive lock on the entire loving database, making write performance utter trash and generating contention with the rebalancing process thus ensuring that adding a new machine to the cluster will take on the order of a week if the db is under load? yes quote:WiredTiger is a new storage engine for MongoDB, developed by the architects of Berkeley DB, the most widely deployed embedded data management software in the world. WiredTiger scales on modern, multi-CPU architectures. Using a variety of programming techniques such as hazard pointers, lock-free algorithms, fast latching and message passing, WiredTiger performs more work per CPU core than alternative engines. https://github.com/wiredtiger/wiredtiger/wiki/LevelDB-Benchmark
|
|
#
?
May 14, 2016 23:13
|
|
|
the talent deficit posted:postgresql was very slow in the early 2000s and the garbage tier shared hosts everyone used couldn't really run it. therefore mysql proliferated replication wasn't really there sql standard support was but autovacuum wasn't postgres got good at 9.0
|
|
#
?
May 14, 2016 23:22
|
|
|
compuserved posted:vertica is p deece for olap yeah it is. it's also got a weird bug where if you're using more than say 2000+ placeholders in a query the driver will suck up many gigs of memory and won't give it back to the OS
|
|
#
?
May 16, 2016 10:14
|
|
|
use the most widely deployed db, sqlite
|
|
#
?
May 16, 2016 13:04
|
|
|
the talent deficit posted:postgresql was very slow in the early 2000s and the garbage tier shared hosts everyone used couldn't really run it. therefore mysql proliferated my impression is postgres was made to be standards compliant first and made fast laster, whereas mysql did the opposite, and surprise: its a lot easier to optimize a standards-compliant implementation than to change the behavior of something people are already using, to make it more standard
|
|
#
?
May 16, 2016 13:09
|
|
|
qhat posted:yeah it is. it's also got a weird bug where if you're using more than say 2000+ placeholders in a query the driver will suck up many gigs of memory and won't give it back to the OS lomarf. i recently found a bug regarding time zone handling in their java sdk. also someone else found some bug involving union all and nulls cascading when they shouldn't.
|
|
#
?
May 16, 2016 13:18
|
|
|
treasure bear posted:use the most widely deployed db, sqlite it's like old mongo where writes lock the whole database SQLite has its uses but if more than one person is using the system that's not it
|
|
#
?
May 16, 2016 13:25
|
|
|
what about blockchain technology
|
|
#
?
May 16, 2016 13:35
|
|
|
treasure bear posted:what about blockchain technology good choice if you want a single transaction to use more electricity than my air conditioner uses in July
|
|
#
?
May 16, 2016 13:42
|
|
|
huh. that's kinda unexpected, i assumed mongo would just keep using whatever they had before while proudly advertising "web-scale read/write scalability!" on their front page
|
|
#
?
May 16, 2016 15:47
|
|
|
|
| # ? Apr 26, 2024 09:46 |
|
|
we have a pseudo dB in excel. There are loads of tables and even stuff like foreign keys and I think it's fully normalised somehow. it also breaks database design patterns in lots of exciting and different ways so that it looks just the way management likes it
|
|
#
?
May 16, 2016 22:26
|
|
