|
i think everyone will treat a database thread like it's kryptonite but gently caress it. i never see anyone else post about db garbage here and maybe it's because we don't have a dedicated place for it. post here to bitch about whatever terrible database you're using (they're all bad) or to confess to your crimes this is a safe space. all schemas are bad, as is schemaless
|
#
?
Jan 23, 2024 16:51
|
|
|
|
| # ? May 2, 2024 17:49 |
|
|
my favorite is the blockchain
|
|
#
?
Jan 23, 2024 17:06
|
|
|
anything is a database if you think about it, really
|
|
#
?
Jan 23, 2024 18:43
|
|
|
batadase
|
|
#
?
Jan 23, 2024 18:47
|
|
|
just put everything in the best data structure, a hashtable
|
|
#
?
Jan 23, 2024 18:48
|
|
|
rotor posted:just put everything in the best data structure, a hashtable
|
|
#
?
Jan 23, 2024 18:49
|
|
|
much like everything else i've learned i have a surface level understanding of the tech i use but dont have particularly strong opinions on anything relative to specific relational dbs just that you should use one, probably. sqlite3, mysql, postgres, whichever, they probably do what you need
|
|
#
?
Jan 23, 2024 18:50
|
|
|
conventional wisdom in tyool 2024 is still mssql if you're a microsoft shop and postgres otherwise, right?
|
|
#
?
Jan 23, 2024 18:53
|
|
|
postgres is good, actually
|
|
#
?
Jan 23, 2024 18:54
|
|
|
rotor posted:just put everything in the best data structure, a hashtable kvs can be pretty good, yeah
|
|
#
?
Jan 23, 2024 18:54
|
|
|
can i use this thread to complain about ORMs? orms suck.
|
|
#
?
Jan 23, 2024 18:55
|
|
|
Clark Nova posted:conventional wisdom in tyool 2024 is still mssql if you're a microsoft shop and postgres otherwise, right? p much. it's also important to know when you need to use more specialized tech like kv, document, graph, etc but for most use cases postgres is fine
|
|
#
?
Jan 23, 2024 18:56
|
|
|
also sqlite is surprisingly robust and you can use it for a surprisingly long time before it starts to be a problem
|
|
#
?
Jan 23, 2024 18:56
|
|
|
why are people off mysql now? oracle making GBS threads it up?
|
|
#
?
Jan 23, 2024 18:58
|
|
|
i helped a church i attended back in the mid to late 00s with their membership database once and it was built in microsoft access 95 or 97 and i wanted to kill myself that's my database story
|
|
#
?
Jan 23, 2024 19:04
|
|
|
Share Bear posted:why are people off mysql now? postgres is now fast enough to make tolerating mysqls weird poo poo unnecessary
|
|
#
?
Jan 23, 2024 19:05
|
|
|
i dont actually know, i'm just repeating poo poo i heard from people who sounded like they knew what they were talking about
|
|
#
?
Jan 23, 2024 19:06
|
|
|
i mean after what they tried to pull with java its not outside the realm of stuff being "ah we have something as good as mysql now thats not owned by oracle, use that" but that's my headcannon on people going to postgres and Might Not Be True
|
|
#
?
Jan 23, 2024 19:08
|
|
|
https://youtu.be/b2F-DItXtZs?si=vN_S709NATzH_1Na
|
|
#
?
Jan 23, 2024 19:09
|
|
|
wait, i'm wrong, i also had to use access to build a database in a computer class in junior high school. i dont remember the details, but it had a whole bunch of stuff in it and it had to connected to excel and word to generate letters and stuff. i remember thinking it was p cool and that i was like a wizard because i could do it but i've also literally never had to do that again since and i probably couldn't do it now if you put a gun to my head
|
|
#
?
Jan 23, 2024 19:09
|
|
|
orm money payday hmmm
|
|
#
?
Jan 23, 2024 19:09
|
|
|
my favorite database is the 18 meg excel file every director keeps a copy of and is also on sharepoint
|
|
#
?
Jan 23, 2024 19:12
|
|
|
Cat Face Joe posted:my favorite database is the 18 meg excel file every director keeps a copy of and is also on sharepoint You should try the non-relational version of that: A JSON file stored on disk with all the vital information for the random node app the department ended up getting too reliant upon.
|
|
#
?
Jan 23, 2024 19:29
|
|
|
LanceHunter posted:You should try the non-relational version of that: A JSON file stored on disk with all the vital information for the random node app the department ended up getting too reliant upon. i don't know what that is as i do not program the computer
|
|
#
?
Jan 23, 2024 19:33
|
|
|
my favorite database is jira
|
|
#
?
Jan 23, 2024 19:37
|
|
|
the switch to postgres from mysql was for two main reasons. yes, one of them was oracle buying mysql, you can't trust oracle. but there was also a more technical driver. the mysql ethos was, "let's build a fast execution engine (innodb) that can select from where, and we'll worry about all those Standards and Features later". meanwhile the postgres folks were all, "let's build a full-featured standards-compliant sql db, it might not be the fastest one out there, but we can optimize it later". and well, postgres got fast before mysql got good (arguably it still has not)
|
|
#
?
Jan 23, 2024 19:53
|
|
|
rotor posted:can i use this thread to complain about ORMs? orms suck. all are welcome to air their grievances here
|
|
#
?
Jan 23, 2024 20:14
|
|
|
i turned down a gig with mongo when they were still really young. now i'm looking at their stock and crying. ah! i am crying
|
|
#
?
Jan 23, 2024 20:18
|
|
|
we're on MySQL 5.7  but we have a migration to postgres making good progress 
|
|
#
?
Jan 23, 2024 20:36
|
|
|
mysql 5 is just comically bad by modern standards, it's missing huge chunks of standard sql and the query planner is absolute dogshit. innodb is fast but there was a jepsen report on it recently that showed that even in mysql 8 the robustness of the transaction isolation is pretty questionable mysql 8 added a whole bunch of features but it's still far, far from parity with postgres, and especially so if you count extensions too. just give postgres more ram, really
|
|
#
?
Jan 23, 2024 20:40
|
|
|
|
|
#
?
Jan 23, 2024 20:50
|
|
|
ngl mongodb sounds stupid
|
|
#
?
Jan 23, 2024 20:56
|
|
|
the only good thing i'll ever say about mariadb/mysql is that someone else made a package called vitess that can make your life easier re: migrations and sharding. i don't really understand postgres' citus but maybe it's fine idk i'm with rotor here though rotor posted:also sqlite is surprisingly robust and you can use it for a surprisingly long time before it starts to be a problem
|
|
#
?
Jan 23, 2024 20:57
|
|
|
Mssql has some really cool features, one of them is that you can copy and paste binary blobs into your SQL ide then run it with a command (can't remember what) to install it as an extension. This lets you easily add any missing features, such as this [Microsoft.SqlServer.Server.SqlFunction] public static SqlString http(SqlString url) { var wc = new WebClient(); var html = wc.DownloadString(url.Value); return new SqlString (html); }
|
|
#
?
Jan 23, 2024 20:58
|
|
|
mssql has builtin support for system versioned tables, which is really neat and I wish postgres had it too
|
|
#
?
Jan 23, 2024 21:00
|
|
|
distortion park posted:Mssql has some really cool features, one of them is that you can copy and paste binary blobs into your SQL ide then run it with a command (can't remember what) to install it as an extension. This lets you easily add any missing features, such as this i've worked with mssql before and the amount of nerds that want to shove every piece of business logic into a stored procedure is bad enough without this poo poo
|
|
#
?
Jan 23, 2024 21:04
|
|
|
one thing i wish postgres didn't have is that one very subtle statistics gotcha that makes the entire database grind to a halt one fine day because instead of using the perfectly good index it's been using for years it's started seq scanning a 100 gb table instead, thinking the index isn't selective enough to be worth using. sampling bias is a gently caress
|
|
#
?
Jan 23, 2024 21:07
|
|
|
mongodb ftw
|
|
#
?
Jan 23, 2024 21:12
|
|
|
TheFluff posted:mssql has builtin support for system versioned tables, which is really neat and I wish postgres had it too if you read the original postgres paper by stonebraker back in 1986, they actually had historical/versioned tables from the beginning. at some point during the evolution into postgresql they got taken out 
|
|
#
?
Jan 23, 2024 22:11
|
|
|
|
| # ? May 2, 2024 17:49 |
|
|
TheFluff posted:one thing i wish postgres didn't have is that one very subtle statistics gotcha that makes the entire database grind to a halt one fine day because instead of using the perfectly good index it's been using for years it's started seq scanning a 100 gb table instead, thinking the index isn't selective enough to be worth using. sampling bias is a gently caress what do you mean you want planner hints? those are bad, just run vacuum analyze more often. you should have tuned your statistics before that happened bro. i'm a postgres core dev and i am very smart!
|
|
#
?
Jan 23, 2024 22:13
|
|