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.

Posts by John C‭

11 posts
80%
+6 −0
Q&A Why is SQL usually written in CAPS?

Since the tradition doesn't have any enforcement anywhere, we can't necessarily pinpoint a single reason, but it probably has a lot to do with the available technology of the early 1970s when Chamb...

posted 1y ago by John C‭

Answer
80%
+6 −0
Meta Don't close questions for lack of detail/confusion

As a newcomer here, I'd like to suggest two additional issues that weigh in favor of closing unworkable questions. First, a site that wants to grow its community needs to moderate its content. If...

posted 2y ago by John C‭

Answer
77%
+5 −0
Q&A What is the correct cost formula for the average case in insertion sort algorithm?

The difference (and the page that you cite actually does mention it, even if broadly) is that algorithmic analysis has interests and (arguably) traditions that most people find counter-intuitive. ...

posted 1y ago by John C‭  ·  edited 1y ago by John C‭

Answer
75%
+4 −0
Q&A Extracting Firefox Local Data

How does one parse/decode/extract information stored by a web page in Firefox's browser local storage without the browser? So far, I've worked out that the data lives at ~/.mozilla/firefox/${profi...

1 answer  ·  posted 1y ago by John C‭  ·  last activity 1y ago by Zoe‭

Question json sqlite firefox
75%
+4 −0
Q&A How to sort the output of meta / slash commands in psql?

It's been a while, but the answer is "yes and no," I believe. No: The describe-schema command doesn't (last I heard) allow any modification. Yes: The describe-schema command also doesn't do any...

posted 2y ago by John C‭  ·  edited 2y ago by toraritte‭

Answer
66%
+2 −0
Q&A How do websites built by website builders defend security threats or follow secure coding?

My understanding (from sometimes working on the older form) is that your instinct hits pretty close to the mark. It often depends on what you need and (increasingly importantly) how rigid a system...

posted 4mo ago by John C‭

Answer
66%
+2 −0
Q&A Link to Markdown line on Bitbucket

It looks like they do have...something. From https://support.atlassian.com/bitbucket-cloud/docs/hyperlink-to-source-code-in-bitbucket/: URI Template for src {+bitbucket}{/owner, repository_nam...

posted 9mo ago by John C‭

Answer
66%
+2 −0
Q&A Creating PDF from HTML on Debian Bookworm; tools?

I originally didn't bother to mention it because I have typically used it from Pandoc, making it equivalent to LaTeX. However, Weasyprint both works as Pandoc's alternative HTML-to-PDF path and ru...

posted 10mo ago by John C‭

Answer
66%
+4 −1
Q&A Where to place digit separators in C23?

This probably makes for a thoroughly unsatisfying answer, but there's probably far stronger cultural pressure than technical pressure. In European-derived cultures, we mostly group numbers by powe...

posted 2y ago by John C‭

Answer
60%
+1 −0
Q&A Testing an opaque type's internals

I'd propose (and have generally used, back when I worked on C projects) a fourth option that I don't think gets too far out of line. If I understand the situation correctly, that you want to test ...

posted 2y ago by John C‭

Answer
50%
+0 −0
Q&A Compile-time rounding with the pre-processor

If you can truncate (get the floor() of a number), then you can round the number by adding 0.5 first. Or, I suppose that, for the sake of completeness, you add "the equivalent of 0.5," since a giv...

posted 4mo ago by John C‭

Answer