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.
Activity for ArtOfCodeâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Answer | — |
A: How to speed up MySQL query? 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 milliseconds. Make use of the `EXPLAIN` function to find out what your queries are trying to do and wha... (more) |
— | 5 months ago |
| Answer | — |
A: Merge spreadsheet formula tags into single tag 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! (more) |
— | 11 months ago |
| Answer | — |
A: Merge [functions] with [function] Makes sense to me! Done as of a few minutes ago. (more) |
— | 11 months ago |
| Answer | — |
A: Why `excel` is set as a child tag of `openoffice-calc`? Good question. It's not any more 🙂 (more) |
— | 11 months ago |
| Answer | — |
A: Recursion without a procedure ("function") in JavaScript 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 structures like HTML where you don't know ahead of time the depth or breadth of the tree, recursion is... (more) |
— | about 2 years ago |
| Answer | — |
A: How do I search for "i++"? 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 aren't actually considered part of the index at all - just the words. While this works for most Q&A ... (more) |
— | about 2 years ago |
| Answer | — |
A: How to allow sign-ups without confirmation as an exception using devise confirmable? You should be able to pre-set `confirmedat` when you create the User instance: ```ruby user = User.new(confirmedat: DateTime.now) # plus any other details you want user.save! ``` (more) |
— | about 2 years ago |
| Answer | — |
A: redirect to "main" code in Ruby using Ctrl 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-click on the view name and it'll take you there. I can't remember off hand whether VS Code does or not for ... (more) |
— | almost 3 years ago |
| Answer | — |
A: highlighting code 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. (more) |
— | almost 3 years ago |
| Answer | — |
A: Text with many diacritic marks are not displayed correctly in posts 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 isn't exactly real-world usage, I'm marking this [status-declined] - if there are issues with display f... (more) |
— | about 3 years ago |
| Answer | — |
A: I didn't get notification after user mentioning me in comment 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 some improvements to the comments system overall in the works, which will include improvements to how y... (more) |
— | about 3 years ago |
| Answer | — |
A: Why do I, a logged in user, have to solve a captcha to post? 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 malicious. The exact rules it uses to do this aren't public, but we can tweak it some. It seems to trigger mo... (more) |
— | about 3 years ago |
| Answer | — |
A: How to properly deal with impersonation in a Web application? (security vs. usefulness for tech support) 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 identify issues that only appear for one user with a specific set of circumstances that would be difficul... (more) |
— | about 3 years ago |
| Answer | — |
A: min-height for HTML form's submit buttons from a web accessibility standpoint 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 as your text size isn't ridiculously small there's no problem with that. Don't make your buttons smaller ... (more) |
— | about 3 years ago |
| Answer | — |
A: Multiple code blocks have the code in different colors #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 added language hints, so they show the same now. (more) |
— | over 3 years ago |
| Answer | — |
A: Iterating through a MySQL table with a LIMIT clause and PHP gets progressively slower 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 efficient. It works... okay, for small page sizes and not-too-huge datasets, but when you're asking for... (more) |
— | over 3 years ago |
| Answer | — |
A: Access TypeScript class outside bundled code Easy enough: if this code is only ever going to be used in a browser, just add it to the Window object: ```typescript export default class AutoComplete { // ... }; window.AutoComplete = AutoComplete; ``` You can also do this from a general/index file by just importing `AutoComplete` ... (more) |
— | over 3 years ago |
| Answer | — |
A: Is there a naming convention for table aliases? 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 in autocomplete suggestions) is to abbreviate using the first letter of each word. In a table called ... (more) |
— | over 3 years ago |
| Answer | — |
A: How will you balance demanding high quality questions with maximising the number of users? 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 part, every community gets to choose its own way. That includes things like this - this community can... (more) |
— | over 3 years ago |
| Question | — |
Meet the Codidact Team! 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 Codidact team is here to support the growth of this site however we can. We'll keep tabs on how things... (more) |
— | over 3 years ago |