ArtOfCode‭

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...

0 answers  ·  posted 4y ago by ArtOfCode‭  ·  edited 4y ago 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 ...

posted 4y ago by ArtOfCode‭

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...

posted 3y ago by ArtOfCode‭

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 ...

posted 4y ago by ArtOfCode‭

#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...

posted 4y ago by ArtOfCode‭

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...

posted 3y ago by ArtOfCode‭

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...

posted 3y ago by ArtOfCode‭

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.

posted 3y ago by ArtOfCode‭

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 ...

posted 2y ago by ArtOfCode‭

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...

posted 4y ago by ArtOfCode‭

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...

posted 3y ago by ArtOfCode‭

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...

posted 4y ago by ArtOfCode‭

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...

posted 3y ago by ArtOfCode‭

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!

posted 2y ago by ArtOfCode‭

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 ...

posted 2y ago by ArtOfCode‭