pointsofdata posted:Yeah letting the applications control the data structures is a surefire way to end up with a lovely db, loads of duplication and misrecs everywhere hello
|
|
# ? Nov 2, 2018 12:11 |
|
|
# ? Oct 13, 2024 14:38 |
on 80% of our web projects a database level not null condition on a field is technically impossible, because the php orm used shits it’s bed immediately
|
|
# ? Nov 2, 2018 12:12 |
|
hi thanks for your urgent hotfix pr, however sorry for being pedantic but can you remove these newlines and add some here please thanks
|
# ? Nov 2, 2018 12:23 |
|
cinci zoo sniper posted:on 80% of our web projects a database level not null condition on a field is technically impossible, because the php orm used shits it’s bed immediately curse of the orm strikes again
|
# ? Nov 2, 2018 12:48 |
|
no
|
# ? Nov 2, 2018 12:49 |
|
pointsofdata posted:Yeah letting the applications control the data structures is a surefire way to end up with a lovely db, loads of duplication and misrecs everywhere a combination of huge views and an orm is likewise a terrible idea although views a pretty good, if the underlying db is bad then, well it’s all gonna be bad
|
# ? Nov 2, 2018 12:57 |
|
gonadic io posted:hi thanks for your urgent hotfix pr, however sorry for being pedantic but can you remove these newlines and add some here please thanks lmao
|
# ? Nov 2, 2018 13:13 |
|
cinci zoo sniper posted:on 80% of our web projects a database level not null condition on a field is technically impossible, because the php orm used shits it’s bed immediately gonadic io posted:hi thanks for your urgent hotfix pr, however sorry for being pedantic but can you remove these newlines and add some here please thanks pointsofdata posted:curse of the orm strikes again Boiled Water posted:a combination of huge views and an orm is likewise a terrible idea the talent deficit posted:in practice you just join the application layer and make sure you handle referential integrity problems at that level. like if someone wants to see all `tags` for a `post` or something you shouldn't just retrieve the tags via the post id, you should also check that the post id is still valid. you can't do this transactionally but it rarely matters with this kind of thing. if you do need transaction and strict referential integrity, just put the related things in the same db and use the same microservice to manage them Kevin Mitnick P.E. posted:stonebraker is still salty about sql winning lol pangstrom posted:Maybe it's there under a different name. It's a 4d database pangstrom posted:good stuff for me, a terrible programmer. Was excited to see one of our major and terrible systems not even warrant a mention in the dozens and dozens of things he listed cinci zoo sniper posted:hello fired fired fired fired fired fired your all fired
|
# ? Nov 2, 2018 13:16 |
|
finally, I'm free
|
# ? Nov 2, 2018 13:18 |
|
AggressivelyStupid posted:finally, I'm free
|
# ? Nov 2, 2018 13:24 |
|
redleader posted:so is jooq good? it sounds ok and the maintainer sounds like the reasonable sort of crazy It's really good. CPColin posted:jOOQ barely seems different from raw SQL strings. Like, you're just writing SQL with a different syntax. I guess the compile-time sanity checking is nice, but I don't see the appeal. The difference is that with jOOQ if you write a query that has a different syntax in a different dialect, it does the translation automatically. https://blog.jooq.org/2018/03/13/top-10-sql-dialect-emulations-implemented-in-jooq/ Plus you can write bindings to convert from/to java types transparently. Like if you are binding potsgres's "timestamp with time zone" type, and you created a binding for a ZonedDateTime, you can have things like: code:
|
# ? Nov 2, 2018 13:34 |
|
Bulgakov posted:fired fired fired fired fired fired my buddies are all gone, I quit bitch
|
# ? Nov 2, 2018 13:35 |
|
Janitor Prime posted:I wish I had spent more time figuring out how to integrate JOOQ with Spring since we use that for transaction management. spring boot ships with a jooq transaction manager that uses spring's tx stuff. so... it was already done for you if you use spring boot. if not, you can just copy the class.
|
# ? Nov 2, 2018 13:36 |
|
prisoner of waffles posted:my buddies are all gone, I quit bitch sorry to miss over you you are EXTREMELY fired
|
# ? Nov 2, 2018 13:37 |
|
prisoner of waffles posted:my buddies are all gone, I quit bitch clogging the company toilet after taking such large dumps of code??? fire fired MEGA FIRED
|
# ? Nov 2, 2018 13:38 |
|
Bulgakov posted:fired fired fired fired fired fired You seem to have fired yourself which is definitely going to break something
|
# ? Nov 2, 2018 13:43 |
|
pointsofdata posted:You seem to have fired yourself which is definitely going to break something yes that was part of the plan the commune needs an anarchic shuffle
|
# ? Nov 2, 2018 13:51 |
|
gonadic io posted:hi thanks for your urgent hotfix pr, however sorry for being pedantic but can you remove these newlines and add some here please thanks Whenever an application breaks, the users can 100% tell that the reason for it breaking is not enough new lines or spaces after commas. Above all else, formatting is the sure sign of quality code that everyone can feel.
|
# ? Nov 2, 2018 13:59 |
|
floatman posted:Whenever an application breaks, the users can 100% tell that the reason for it breaking is not enough new lines or spaces after commas. I wonder if this has ever happened about minimised js users complaining that the company's js that they see in the browser uses bad variable names and no comments or whitespace
|
# ? Nov 2, 2018 14:04 |
|
gonadic io posted:I wonder if this has ever happened about minimised js it definitely has. i've seen it. it's probably a gently caress-up on our end, or maybe the minify tool, and it should never happen, but it does.
|
# ? Nov 2, 2018 14:27 |
|
cjs: what's the solution for a CTO that works 16-20 hour days but does nothing but work on features/bugs that are all low-medium priority when everyone else is crunching to get high-priority bugs fixed because we were supposed to launch this terrible russian platform months ago. note: this is a startup dev team of me, a junior dev, and CTO.
|
# ? Nov 2, 2018 15:44 |
|
Finster Dexter posted:cjs: what's the solution for a CTO that works 16-20 hour days but does nothing but work on features/bugs that are all low-medium priority when everyone else is crunching to get high-priority bugs fixed because we were supposed to launch this terrible russian platform months ago. someone might get fired it's probably not the CTO
|
# ? Nov 2, 2018 15:50 |
|
oh good CTO just slack'd me with some code cleanup tips on this russian garbage, which is about the most turd polishing/pig lipsticking thing I can think of.
|
# ? Nov 2, 2018 15:51 |
|
Boiled Water posted:someone might get fired (hint: it's the junior dev, who everyone hates because he insists on leaving at a normal time every day) My goal at this point is to just ride this posh private jet of figgies right into the ground, and my parachute plan is contracting until I find a lovely bank job and slowly sink back into nothingness.
|
# ? Nov 2, 2018 15:53 |
Finster Dexter posted:(hint: it's the junior dev, who everyone hates because he insists on leaving at a normal time every day)
|
|
# ? Nov 2, 2018 15:57 |
Osmosisch posted:Protip: also start doing this if you aren't.
|
|
# ? Nov 2, 2018 16:00 |
|
Osmosisch posted:Protip: also start doing this if you aren't. pros of not leaving on time: nothing cons: all of the cons
|
# ? Nov 2, 2018 16:00 |
|
Boiled Water posted:pros of not leaving on time: nothing but you’re not going to get that promotion to the next ICT level if you’re not a team player that delivers impressive results! the best way to get it is to switch companies
|
# ? Nov 2, 2018 16:08 |
|
Osmosisch posted:Protip: also start doing this if you aren't.
|
# ? Nov 2, 2018 16:15 |
|
Leave before you even hit 8 hours.
|
# ? Nov 2, 2018 17:28 |
|
Finster Dexter posted:cjs: what's the solution for a CTO that works 16-20 hour days but does nothing but work on features/bugs that are all low-medium priority when everyone else is crunching to get high-priority bugs fixed because we were supposed to launch this terrible russian platform months ago. take the important work, mark it trivial, assign it to cto
|
# ? Nov 2, 2018 17:44 |
|
Kevin Mitnick P.E. posted:take the important work, mark it trivial, assign it to cto lmao
|
# ? Nov 2, 2018 17:48 |
|
pointsofdata posted:Yeah letting the applications control the data structures is a surefire way to end up with a lovely db, loads of duplication and misrecs everywhere there are legit usecases where the app should control the database schema and there are legit usecases where the database schema is its own thing and >1 app uses the same database.
|
# ? Nov 2, 2018 18:26 |
|
Kevin Mitnick P.E. posted:take the important work, mark it trivial, assign it to cto "how to gently caress with people using the issue tracker" a book I would buy
|
# ? Nov 2, 2018 18:27 |
|
ctps i used to think yaml was an overcomplicated, unpredictable and dangerous file format but now i'm learning about anchors and merge keys and i'm realizing it is even worse than i thought
|
# ? Nov 2, 2018 21:39 |
|
suffix posted:ctps i used to think yaml was an overcomplicated, unpredictable and dangerous file format wao, that's... interesting. seeing that, my immediate reaction is "if I were using YAML on a team, I think we'd want to strictly limit the use of anchors etc" e: lomarf at the deserialization vulnerabilities that no doubt were crawling all over the ruby libraries, for a start.
|
# ? Nov 2, 2018 21:55 |
|
orms are bad sprocs are worse bye
|
# ? Nov 2, 2018 22:47 |
|
dbs are bad not dbs is worse
|
# ? Nov 2, 2018 23:10 |
everything is bad especially me
|
|
# ? Nov 3, 2018 00:30 |
|
|
# ? Oct 13, 2024 14:38 |
|
Finster Dexter posted:cjs: what's the solution for a CTO that works 16-20 hour days but does nothing but work on features/bugs that are all low-medium priority when everyone else is crunching to get high-priority bugs fixed because we were supposed to launch this terrible russian platform months ago. you know the answer
|
# ? Nov 3, 2018 01:23 |