Replying to @ciroque @fullstacklover
IsAdultInUsa21=true or IsAdultInUsa18? International software and laws, to prevent teenagers from stuff make this even harder to correctly do.
5
Replying to @kav_kavi11
Great fix it, but don't change schema and don't add triggers. Just query alone.
739
Replying to @Sumits_X
A hash map with key-string, value-function pointer.
Allows clear separation and unless we absolutely botch the architecture, is a lot less overhead
2
832
Replying to @Sumits_X
IN will produce a much smaller AST for a parser, which may matter a tiny bit for hundreds of parameters
294
Replying to @tomt33701 @Dave_DotNet
Wow why haven't I though of that. I could've always try catch the value provider and goto yield_value; unless that doesn't work
1
28
Replying to @baney75 @FrameworkPuter
The frame frame is closer than you think. April can't come fast enough
2
19
Replying to @JamesNK
Luckily, when using SQLite as data store, you can mostly get away with those N+20 queries. And I'd guess SQLite is one of the more valuable targets for Aspire dashboard, at least for developers machines, where you can easily transfer those between PCs (export to SQLite maybe?)
1
875
Replying to @Its_Nova1012
Don't use numbers in Json. As the spec for them isn't clear. For financial values prefer transport as strings and ensure proper parsing server side instead of taking assumptions of your Json parser which may or may not internally parse to double and cast to target type.
1
3
143
Replying to @patilvishi
Tldr: Because Java.
That's not a "scalar" type, but a class named "Integer" which is cached for small numbers, which causes java reference equality to return true.
122
Replying to @patilvishi
Because it would be invalid once you deleted an entry. Suddenly you get entries with the same id as the previous. Sequences/auto increment do not permit this under regular use.
11
Replying to @javarevisited
It's stupid. Just define a collation that is case insensitive and do a simple comparison. As it shows, an iPhone or iphone would be the same name. Also makes proper use of indicies.
29
Replying to @SahilExec
For most cases? A. As that allows easier query building for dynamic column sorting, like where a user is able to sort the data by one or more columns in ascending or descending order.
B is an optimization if you find A to be too slow for your use case, but comes with caveats
4
Replying to @James_M_South
A new side of those same issues is people hating on maintainers who in their Free time, with their own money, use AI to actually get to get something done with their hour or two a week.
As long as AI is used responsibly and it's code reviewed, people should not blame for using it
21
Replying to @SahilExec
None of the issues goes past the firewall which prevents file sizes greater than 10 mib per chunk/request and filters headers for malicious stuff.
If anyone puts junior code out butt naked without a proper gateway and application firewall, there's your security vuln.
3
Replying to @lorenzocabrini @KentonVarda
Ensure enough space between lines, at least 20-200 newlines, or else you get issues when you have to add new features.
1
1
9
Replying to @CodeWithAmann
We have 32gib deployed, but constantly get it to swap and freeze the system. (Desktop application development, different web services, some docker containers, teams, browser, etc.)
64 would be nice, but RAMageddon doesn't allow upgrading (either all get the upgrade or no one)
28
Why hard-code currency symbol and amount in a template string, just have "$CUR_PREFIX$AMOUNT$CUR_SUFFIX for your $HOME"
great to have prefix and suffix to support other currencies than freedom country display format
1
33
Replying to @karthickdotxyz @Yuchenj_UW
Nah, just know what you want, use Plan mode and then let it go nuts.
My experience without plan mode and opus is that it's mid at best, but with plan mode it really speeds up the final (mostly working) implementation phase.
198
