|
another one in the "query builders are superior" pile i guess
|
# ? Aug 8, 2021 06:28 |
|
|
# ? Nov 4, 2024 04:53 |
|
just use stored procedures like god intended
|
# ? Aug 8, 2021 08:11 |
|
the less features your rdbms has, the less galaxy brained things people will try to do on the data layer
|
# ? Aug 8, 2021 09:04 |
|
bob dobbs is dead posted:another one in the "query builders are superior" pile i guess yes, i use a query builder: "SELECT * FROM users WHERE username=" . $_REQUEST["username"] ." AND password='" . $_REQUEST["password"] ."'"
|
# ? Aug 8, 2021 10:16 |
|
Powerful Two-Hander posted:just use stored procedures like god intended
|
# ? Aug 8, 2021 13:16 |
|
Powerful Two-Hander posted:just use stored procedures like god intended but never tell your colleagues which few of the thousands of ever-changing procedures stored are the correct ones to use, like satan intended.
|
# ? Aug 8, 2021 15:06 |
|
Wheany posted:yes, i use a query builder: This is so loving stupid. I don't even know where to begin. - There is no need to use the string concat operator for this, just embed it straight in the string. - It is really insecure to have users send creds over the network like this. Someoke could mitm it and then the user is hosed. You should be having the client side handle auth checks in the browser. - Why even do string concat for SQL generation? You really want that overhead on EVERY CALL? Just have the client construct the query and send it back, and pg_query that poo poo. You don't get paid by the CPU cycle my dude.
|
# ? Aug 8, 2021 15:51 |
|
What else?
|
# ? Aug 8, 2021 15:58 |
|
CPColin posted:What else? I would have started with the obvious SQL injection but I suppose string concats will make other people madder.
|
# ? Aug 8, 2021 16:35 |
|
i thought we were doin the ol fuckin around thing where we make outrageous comments about the nittiest small things and avoid mentioning the injection
|
# ? Aug 8, 2021 16:40 |
|
I'm new here I'm sorry
|
# ? Aug 8, 2021 16:43 |
|
just put the db in the client imo
|
# ? Aug 8, 2021 17:02 |
|
https://pouchdb.com
|
# ? Aug 8, 2021 17:10 |
|
Carthag Tuek posted:just put the db in the coconut imo
|
# ? Aug 8, 2021 17:18 |
|
Pouch is impressive on that it never reconnects on failure
|
# ? Aug 8, 2021 21:10 |
|
lmao wtf pls tell me it's silent
|
# ? Aug 8, 2021 21:12 |
|
MrMoo posted:Pouch is impressive on that it never reconnects on failure just like my dad
|
# ? Aug 8, 2021 22:00 |
|
Carthag Tuek posted:lol, lmao 501 changed files, 700 additions, 93500 deletions
|
# ? Aug 9, 2021 10:35 |
|
Powerful Two-Hander posted:501 changed files, 700 additions, 93500 deletions smashes merge at speed of sound
|
# ? Aug 9, 2021 10:43 |
|
Powerful Two-Hander posted:501 changed files, 700 additions, 93500 deletions what % of the codebase is this? it's beautiful
|
# ? Aug 9, 2021 10:48 |
|
champagne posting posted:smashes merge at speed of sound
|
# ? Aug 9, 2021 11:01 |
|
Powerful Two-Hander posted:501 changed files, 700 additions, 93500 deletions
|
# ? Aug 9, 2021 11:24 |
|
Chalks posted:what % of the codebase is this? it's beautiful not as much as it looks on the face of it because a lot of those files were aspx page + 2 backer files that weren't referenced in the solution but had been left in the repo by the idiot that did it. even without that and just the included but unreferenced classes it's probably a lot though. It was incredibly verbose code, with almost no comments at all.
|
# ? Aug 9, 2021 11:30 |
|
Powerful Two-Hander posted:501 changed files, 700 additions, 93500 deletions
|
# ? Aug 9, 2021 14:09 |
|
Powerful Two-Hander posted:501 changed files, 700 additions, 93500 deletions
|
# ? Aug 9, 2021 14:15 |
|
Powerful Two-Hander posted:501 changed files, 700 additions, 93500 deletions amazing.
|
# ? Aug 9, 2021 15:44 |
|
MrMoo posted:Pouch is impressive on that it never reconnects on failure Powerful Two-Hander posted:just like my dad
|
# ? Aug 9, 2021 15:53 |
|
I’m starting to find web-architects are becoming more obnoxious than simply incompetent webdevs, maybe just being lucky and avoiding them so far. From typing too many words for doing nothing: http://highscalability.com/blog/2021/8/2/evolution-of-search-engines-architecture-algolia-new-search.html To this, superstar of tech journalism, https://world.hey.com/joaoqalves/disasters-i-ve-seen-in-a-microservices-world-a9137a51
|
# ? Aug 10, 2021 02:28 |
|
MrMoo posted:
this one is funny because it goes through loads and loads of problems caused by chasing an architecture based on it being hip rather than practical, but instead of providing and alternative s or solutions just goes 'guess we better just keep trying lol!: the statement of "if you use a single database you introduce problems like accidentally dropping an index or being unable to determine what is touching a table" is not some incredible problem you can't solve, it's a problem you created yourself by being an idiot and doing a classic webdev "a database is a mysterious so of course the solution is some bullshit involving various aws services
|
# ? Aug 10, 2021 07:25 |
|
Today a ticket was opened because automatically was spelled with one l
|
# ? Aug 10, 2021 07:26 |
|
DoomTrainPhD posted:Today a ticket was opened because automatically was spelled with one l *sucks teeth* gonna have to think about the best way to tackle this one, might need to break it down over a couple of sprints
|
# ? Aug 10, 2021 10:09 |
|
a clear example of a 1 point task
|
# ? Aug 10, 2021 10:10 |
|
I feel like I had one of those once and said it should be zero points and when the PM said that wasn't allowed I said I could have fixed it already in just the time we'd been talking about it. I was not a team player. Edit: I should have had a laptop and fixed it while I was talking.
|
# ? Aug 10, 2021 13:57 |
|
There's no such thing as a 1 point task either
|
# ? Aug 10, 2021 14:05 |
|
there’s no point in a task either
|
# ? Aug 10, 2021 14:08 |
|
1 point task? Are you kidding me?! First we have to create a ticket, but before that we need to define the parameters of said ticket. How do we prevent this from happening in the future? We need to add automatic spell checking to the CI/CD process. What dictionary do we use? Oxford or Webster? How do we define user-facing text in an automated fashion? We need to set up a few meetings to ensure we are all on the same page about this. 8 points at a minimum. (it’s already been fixed.)
|
# ? Aug 10, 2021 14:10 |
|
my current client doesn’t use tasks in jira and only sparingly uses GitHub issues to track broad topics with the day to day up to whomever is working on it it’s pretty great. stand ups are about actual problems or just small talk instead of a death march through the board
|
# ? Aug 10, 2021 14:10 |
|
DoomTrainPhD posted:(it’s already been fixed.) the dev who fixed it without making either a fuzz or a story will be given a talking to and strict orders to not do it again it’s me, I’m that dev.
|
# ? Aug 10, 2021 14:12 |
|
can’t check in a code change without an associated ticket number and only the business side can raise tickets and prioritise them for the sprint so they know what they’re spending their money on everyone will just have to deal with the typo until ~Q2 2022 at current velocity
|
# ? Aug 10, 2021 14:20 |
|
|
# ? Nov 4, 2024 04:53 |
|
Powerful Two-Hander posted:this one is funny because it goes through loads and loads of problems caused by chasing an architecture based on it being hip rather than practical, but instead of providing and alternative s or solutions just goes 'guess we better just keep trying lol!: reminds me of a coworker who constantly pushed for nosql in new projects (usually parse server) because he was completely incapable of imagining how to use an rdbms without implementing an eav anti-pattern
|
# ? Aug 10, 2021 14:27 |