Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Posts by ArtOfCode
This can depend on both your flavor of SQL and your personal preference - I've seen a number of schemes in use. For MySQL, the most common scheme I've seen used (and the scheme that my editor uses ...
If you've poked around the mod tools here a bit, you may have noticed that QPixel has an impersonation feature, live on prod. It's there for much the same reasons: so that developers can test and i...
As we start on building a new community here together, we're bound to find some sticking points. Those might be bugs, new features you need, things you need support with... whatever they are, the C...
The question is not "what will you do", but "what will we do?" This site is community-run. While of course there are a few rules that we need to impose to be able to host a community, for the most ...
The typical way to do something like this without involving recursion would be to build an array and iterate through that. However, in this case, recursion is a more appropriate option. With tree ...
Looks like it's guessed at a language for both of those code blocks, and got it wrong. If you need a code block without syntax highlighting, you can use ```plain to start the code block.
#NotABugForOnce This is down to language guessing. If you don't tell the highlighter what language your code is in, it guesses. Sometimes, it guesses wrong, like here. I've edited the post and ad...
There is no universal accessibility standard for how tall your buttons should be. Consider that when you're using a simple link, users have to click on the text itself to follow the link; as long a...
We don't actually serve any captchas: it's all done by Cloudflare. Cloudflare runs a firewall that scans incoming requests and issues a captcha challenge to any that appear to be automated or malic...
It's because of the comma. Our comment-ping notification system isn't particularly smart and gets tripped up fairly easily, including by punctuation, so that ping wouldn't have worked. We've got s...
LIMIT/OFFSET, fundamentally, is slow for large datasets. With a clause like LIMIT 10000 OFFSET 150000, you're asking the query engine to find 160,000 rows, then throw away 150,000 of them. Hardly e...
My go-to IDEs are VS Code for most things, and RubyMine for Ruby/Rails projects specifically. For that specific line of code you're looking at, I'm using RubyMine, which does enable you to Ctrl-cli...
You should be able to pre-set confirmed_at when you create the User instance: user = User.new(confirmed_at: DateTime.now) # plus any other details you want user.save!
It looks like the answer is "you don't", unfortunately. Because of how our search system works, the "+" character is always treated as an operator. Not that it matters, because non-word characters ...
Easy enough: if this code is only ever going to be used in a browser, just add it to the Window object: export default class AutoComplete { // ... }; window.AutoComplete = AutoComplete; You c...
Good question. It's not any more 🙂
Done. I've merged all these tags together and synonymized them. I've also gone ahead and given you the ability to edit tag wikis - we're in need of people who can curate tags!
Sounds like you may also have a problem with your database structure. A query that fetches 800 records from a table with only those 800 records in it should not take a full second - it should be mi...
The solution here is as for many of these edge cases with weird Unicode: don't do that. The difference here is minor enough that I had trouble picking it out in your screenshots. Given that this i...
