Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »

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
Comment Post #280514 @yaskur like this - just use the username without any spaces
(more)
over 3 years ago
Comment Post #279716 Norepro on that jQuery breakage here, so perhaps it's something to do either with your setup, or with theirs as it relates to your request.
(more)
over 3 years ago
Comment Post #279716 `1:21 GET https://code.jquery.com/jquery-2.2.2.min.js net::ERR_TOO_MANY_REDIRECTS` is your problem - the jQuery server is broken and isn't serving you a working copy of jQuery
(more)
over 3 years ago
Comment Post #279716 Do you have JavaScript enabled?
(more)
over 3 years ago
Edit Post #279176 Initial revision over 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
Edit Post #279097 Post edited:
over 3 years ago
Edit Post #279105 Initial revision 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
Comment Post #278780 It's a non-expiring cache, @Alexei - only shows up in specific situations, but that's one of them. Most of the time it's correctly in sync, but every now and then...
(more)
over 3 years ago
Comment Post #278780 Caaaaaaaaaache.
(more)
over 3 years ago
Edit Post #277455 Post edited:
over 3 years ago
Edit Post #277558 Initial revision 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
Edit Post #277320 Initial revision 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
Comment Post #277158 Just realised I never actually responded to this. It's not one we thought of (the 2FA system was copied over from another, older, implementation of mine from before it was a recommended practice), but it's definitely one we should do.
(more)
over 3 years ago
Comment Post #277152 @Lundin This is much like a private beta for a new SE site; those things have not been defined yet, because they can and should be decided here on Meta by the folks who want to participate here - this community belongs to those people.
(more)
over 3 years ago
Comment Post #277152 @Lundin this site has an initial scope, which was hammered out on Meta.CD in the site proposal - it's in the [welcome post](https://software.codidact.com/q/277141) and at the top of the Q&A category. That can be changed here on Meta if that's useful.
(more)
over 3 years ago
Comment Post #277152 @Ringi I'm not sure what you mean. This site is not run by Stack Exchange, if that's what you're worried about - the folks who run this site are not the same people as those who can make decisions on Stack Exchange sites.
(more)
over 3 years ago
Comment Post #277148 Why the double-select? Why not just a single subquery, as in "where not in (select where is_excluded = 1)"?
(more)
over 3 years ago
Edit Post #277148 Post edited:
tags, syntax highlighting hints
over 3 years ago
Edit Post #277152 Initial revision 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
Edit Post #277144 Post edited:
over 3 years ago
Edit Post #277142 Post edited:
over 3 years ago
Edit Post #277142 Post edited:
over 3 years ago
Edit Post #277142 Initial revision 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