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 »
Q&A

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.

General Q&A about programming, scripting, software design & architecture, process, tools, testing, and more.

Filters (None)
77%
+5 −0
Is it unsecure to use a password on the command line to run a MySQL script on Windows?

Its possible to execute a MySQL file from the command line like so, mysql -u USER -pPASSWORD < FILENAME which triggers a warning, mysql: [Warning] Using a password on the command line int...

2 answers  ·  posted 3y ago by Charlie Brumbaugh‭  ·  edited 3y ago by ghost-in-the-zsh‭

50%
+1 −1
Count the number of occurrences in a text string

If I have some text in a cell, how can I find the number of times another piece of text appears in it? For example, suppose A1 contains Peter Piper picked a peck of pickled peppers.. pick occurs 2...

2 answers  ·  posted 3y ago by pnuts‭  ·  last activity 11mo ago by Dirk Herrmann‭

71%
+3 −0
PHP variables aren't expanded when inside HTML which is by itself inside PHP

I transfer emails from my Right To Left (RTL) contact form → to my local email box (powered by Roundcube). Emails reach my email box (inbox) just fine but I have a problem were PHP variables aren'...

1 answer  ·  posted 3y ago by deleted user  ·  last activity 3y ago by luap42‭

60%
+1 −0
Data validation applied to tickboxes

Given ColumnA contains a Text header (A1), an allowed maximum number (A2), fifty tickboxes (A3:A62) and a formula in A63 of: =countif(A3:A62,TRUE) how can I block application of more than the a...

0 answers  ·  posted 3y ago by pnuts‭  ·  last activity 3y ago by pnuts‭

80%
+6 −0
How to parse a date with more than 3 decimal digits in the fractions of second?

I'm using SimpleDateFormat to parse a string containing a date/time, but the result has a different date, hour, minute, second and millisecond: SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM...

1 answer  ·  posted 2y ago by hkotsubo‭  ·  last activity 2y ago by hkotsubo‭

50%
+1 −1
Nannou model requires a function pointer: How to return a function pointer

Trying to make a nannou app from the template but with a customizable model() function. The template has this main(): fn main() { nannou::app(model).update(update).run(); } The model t...

0 answers  ·  posted 2y ago by telefza‭  ·  edited 2y ago by Alexei‭

83%
+8 −0
Tools for debugging coredumps

For debugging running programs I often use whatever is integrated with the IDE I am using. QtDeveloper right now, but also used Eclipse, Netbeans and others. Most of them just use gdb under the hoo...

1 answer  ·  posted 3y ago by Estela‭  ·  last activity 5d ago by Invisible Mender‭

80%
+6 −0
Is it undefined behaviour to just make a pointer point outside boundaries of an array without dereferencing it?

I have heard that it is undefined behaviour to make a pointer point outside boundaries of an array even without dereferencing it. Can that really be true? Consider this code: int main(void) { ...

2 answers  ·  posted 4y ago by klutt‭  ·  last activity 3y ago by hkotsubo‭

72%
+6 −1
What are the pros and cons of using objects vs associative arrays for JSON results of a CURL request in PHP?

I have a PHP script that uses CURL to return a JSON result that looks //Curl set up code $result = curl_exec($ch); //Error checking code $json = json_decode($result, true); //Code to process r...

1 answer  ·  posted 3y ago by Charlie Brumbaugh‭  ·  last activity 3y ago by Yaskur‭

75%
+4 −0
Implementing impersonation in an ASP.NET Core Web application

I am working at a proof-of-concept for porting an ASP.NET MVC application to an ASP.NET Core API + Angular SPA. One of the features of the existing application is the ability of an admin (typically...

0 answers  ·  posted 3y ago by Alexei‭

77%
+5 −0
Mapping generic handler to generic query in MediatR

I am using MediatR in an ASP.NET Core 3.1 application and I want use a generic query and a generic request that deals with getting lists of some standard items I am using in drop-downs and similar:...

0 answers  ·  posted 3y ago by Alexei‭  ·  edited 2y ago by Alexei‭

50%
+0 −0
In a column, set populated cells to 1 and empty cells to 0

In an as yet unanswered Q from early this year a user of Stack Overflow asked: how to fill all non-empty cells of a column by 1 and the empty cells by 0. It's an xlsx file open with LibreOffice ...

1 answer  ·  posted 3y ago by pnuts‭  ·  last activity 3y ago by Alexei‭

42%
+1 −2
Resources for learning Julia [closed]

I have decide to try out Julia. Is anyone aware of some good resources to get started with the language?

0 answers  ·  posted 3y ago by Guilherme Costa‭  ·  closed 3y ago by Alexei‭

71%
+3 −0
Iterating through a MySQL table with a LIMIT clause and PHP gets progressively slower

I have a very large table that I need to iterate through with a PHP script and I can't do all of the results at once so I do it in sections with a LIMIT like for ($x = 0; $x < 10000000; $x += 1...

1 answer  ·  posted 3y ago by Charlie Brumbaugh‭  ·  last activity 3y ago by ArtOfCode‭

71%
+3 −0
What does android:ems do?

What does ems in xml do? I saw that I was using following line in EditText. But, I never thought what it does. I was trying to check what actually it does by removing the line. I couldn't see any d...

1 answer  ·  posted 2y ago by Anonymous‭  ·  edited 2y ago by Alexei‭

84%
+14 −1
What's the correct way to merge a branch and its dependent branch back to master?

In git I branched feature-A from master. To reduce eventual merge conflicts later, I branched feature-B, which heavily overlaps and depends on A, from feature-A. A build of the feature-B branch s...

2 answers  ·  posted 3y ago by Monica Cellio‭  ·  edited 2y ago by hkotsubo‭

70%
+5 −1
What do the number entries mean in the sympy poly.diff(...) tuple syntax?

I am looking to take a partial derivative of a sympy polynomial with respect to a symbol in the polynomial. In the sympy documentation for poly.diff(...) it gives sample code like this: from sympy ...

2 answers  ·  posted 3y ago by jrh‭  ·  last activity 3y ago by Derek Elkins‭

85%
+10 −0
Scheme for cross-platform warning control?

tl;dr I'd like to learn a compact, cross-compiler way of selectively suppressing compiler warnings. Consider the case where you really mean to make an exact floating-point comparison using ==, o...

1 answer  ·  posted 3y ago by dmckee‭  ·  last activity 3y ago by Someone‭

66%
+2 −0
Save migration info in separate DB schema

When creating a code-first solution in dot net core using Visual Studio, you manipulate the database by changing model classes and migrating the changes. I can set the schema for tables that I cre...

1 answer  ·  posted 3y ago by mcalex‭  ·  last activity 3y ago by Alexei‭

86%
+11 −0
How to do private encapsulation in C?

I'm using an object-oriented design for my C project and trying to implement classes with private encapsulation. How do I do this? Some things I've tried that are problematic: Using a struct f...

1 answer  ·  posted 2y ago by Lundin‭  ·  last activity 1y ago by Lundin‭

77%
+5 −0
Search tree supporting efficient bulk sequential insert

For holding ordered sets of keys, there are well-known data structures (the red-black tree, for example) that support O(log(n)) lookup and insertion algorithms. Of course this means that there triv...

0 answers  ·  posted 3y ago by r~~‭  ·  edited 3y ago by r~~‭

75%
+4 −0
dig -6 works but dig -4 does not

I can't get a response from IPv4 dig on my server but I can get one from IPv6 dig. See the below output: $ dig +short myip.opendns.com a @resolver1.opendns.com # Doesn't return anything, this used ...

1 answer  ·  posted 3y ago by cobertos‭  ·  last activity 3y ago by Canina‭

84%
+9 −0
What is a good modern language to use for a Business Rules project?

This is a rather vague question, but I'm trying to solve a specific problem and I'm inexperienced in most of the potential solutions, so please forgive the inherent ambiguity. I have access to a d...

3 answers  ·  posted 3y ago by Sigma‭  ·  last activity 11mo ago by matthewsnyder‭

20%
+0 −6
When an FPS game player can look down on the character shehe plays [closed]

I seek help in finding a term common in game development, particularly 3D First Person Shooter games (not at all in 2.5D games such as Doom). I understand that 3D first person shooter games can be...

0 answers  ·  posted 3y ago by deleted user  ·  closed 3y ago by Lundin‭

81%
+7 −0
Multiple catches with almost the same code.

I find myself often writing code like this. try { // code } catch( FailedReadException const & ex) { file.close(); std::cerr << "Read failure " << ex.readFailure() <&...

2 answers  ·  posted 3y ago by Estela‭  ·  edited 3y ago by Ayxan Haqverdili‭

77%
+5 −0
Validate All Object Properties with JSON Schema

I'm writing a JSON schema to validate asset files for a program. The JSON I need to parse is structured so: { "jobs": { "software-developer": { "job-description": "sw-dev.md:0", "pay": 800...

1 answer  ·  posted 3y ago by Josh Hyatt‭  ·  last activity 3y ago by elgonzo‭

86%
+11 −0
Can regex be used to check if input conforms to a very strict subset of HTML?

Tldr; I don't need to parse HTML, but I need to check if user submitted input conforms to a very strict subset of HTML. Can regex be a suitable tool for this? Details I have a frontend sanitiser th...

4 answers  ·  posted 3y ago by jla‭  ·  last activity 3y ago by Stephen C‭

75%
+4 −0
Would a MySQL database run more efficiently with smaller varchar lengths?

I have a database with quite a few VARCHAR fields. When the database was first built the lengths of the columns were set a bit larger than absolutely necessary. Now after, having used the DB for a ...

3 answers  ·  posted 3y ago by Charlie Brumbaugh‭  ·  last activity 3y ago by manassehkatz‭

75%
+4 −0
Is there a way to automatically fix MySQL tables where the auto_increment has fallen behind the correct value?

Due to a series of unfortunate events I have some tables where the auto_increment value got behind what it should be. If the auto_increment value is 9 and there are 20 rows in the table the next 1...

1 answer  ·  posted 3y ago by Charlie Brumbaugh‭  ·  last activity 3y ago by Alexei‭

50%
+2 −2
Conditionally format a pair of columns

A user of Web Applications asked "How should I fix the formula?" with reference to: =IF($K4<2,$K4) applied as a Conditional Formatting [CF] formula to J4:J8, where the desired (green fill) f...

1 answer  ·  posted 3y ago by pnuts‭  ·  edited 11mo ago by Wicket‭

75%
+4 −0
How to reason about transaction isolation during development

Consider the following code: public class OnlineShoppingService { @Transactional public void cancelOrder(String id) { if (shipmentRepository.findShipmentForOrder(id) != null) { ...

1 answer  ·  posted 3y ago by meriton‭  ·  last activity 3y ago by Alexei‭

75%
+4 −0
Is there an equivalent way of returning early in a MySQL stored procedure?

In programming instead of arrowcode where one has many layers of indented if statements, you can return a result as soon as possible. So instead of, if if end if end if It looks like if ret...

1 answer  ·  posted 3y ago by Charlie Brumbaugh‭  ·  edited 3y ago by Moshi‭

71%
+8 −2
Write to same file from multiple threads

I want to write a text file from multiple threads. The file structure is line-oriented. This means writing of lines should be atomic. I am using Qt 5.15.2. Is it enough to protect a shared QTextSt...

2 answers  ·  posted 3y ago by Silicomancer‭  ·  edited 9mo ago by Shree‭

72%
+6 −1
How to separate DB query logic from the application other than implementing a repository on top of an ORM?

I've been doing a lot of reading on implementing the repository pattern in C# projects and found controversy, or shall I say some strong criticism, made by seemingly very smart people with previous...

1 answer  ·  posted 3y ago by Marc.2377‭  ·  last activity 3y ago by Alexei‭

71%
+3 −0
How to calculate how much data is stored in a MySQL column?

I am considering either removing some columns or changing the datatypes if I could significantly reduce the amount of storage that is currently used by those columns. Some of the columns are ints a...

1 answer  ·  posted 3y ago by Charlie Brumbaugh‭  ·  last activity 3y ago by Alexei‭

82%
+12 −1
What is the difference between operator precedence and order of evaluation?

When doing something simple such as this int a=1; int b=2; int c=3; printf("%d\n", a + b * c); then I was told that operator precedence guarantees that the code is equivalent to a + (b * c)...

1 answer  ·  posted 3y ago by Lundin‭  ·  edited 3y ago by Lundin‭

50%
+0 −0
When is information schema not needed and when is it indeed when migrating from one website hosting provider to another?

In some situations, could it be problematic to migrate a website's database (MySQL) from one website hosting provider to another without the information schema or with the information schema? In m...

0 answers  ·  posted 3y ago by deleted user  ·  edited 3y ago by deleted user

57%
+2 −1
Are JavaScriptless forms accessible?

I consider to make my website's contact form totally javascriptless (only HTML-PHP-CSS --- no JavaScript at all). No modals or alerts No prevent default No AJAX/AJAX/XHR/JHR No form disappear...

1 answer  ·  posted 3y ago by deleted user  ·  last activity 3y ago by Alexei‭

37%
+1 −3
Are there textual-formats for documenting actions in Graphical Windows systems? [closed]

I've recently been involved with creating text documentation of steps for workflows in graphical windows systems (and web-pages). These are often somewhat wordy, for example: "Click on the 'Exit' ...

0 answers  ·  posted 3y ago by CodeFarmer‭  ·  closed 2y ago by Alexei‭

53%
+5 −4
What is an example for a URI which is not a URL?

Every URL is a URI but not every URI is a URL is a saying I know from long ago, but what is an example for a URI which is not a URL (whatever the user agent would be - a web browser, a *nix utility...

1 answer  ·  posted 3y ago by deleted user  ·  last activity 3y ago by Wezl‭

66%
+2 −0
How can I assign the result of an operation from within a function to the global environment?

I have a function that which does some calculations. I would like to assign the result of the function to the global environment from within the function, how do I proceed? A minimal example: meanF...

2 answers  ·  posted 3y ago by Zerotime‭  ·  edited 3y ago by Alexei‭

88%
+13 −0
Different behavior with relative imports when using flask vs py

I have a small new Python 3.8 Flask project with some relative import quirks. For the DB I use SQLAlchemy with Flask-Migrate. My project has the following general structure: controllers/ static/ te...

1 answer  ·  posted 4y ago by luap42‭  ·  last activity 4y ago by ajv‭

30%
+1 −5
How can software track [1] how many subscribers to subreddits, [2] if subreddit is private, [3] if submissions are restricted?

Master lists like 82 food subreddits and 128 tech subreddits don't indicate each's subscribers. if it's private. Sometimes moderators can make the sub private for several days, to clean i...

1 answer  ·  posted 3y ago by TextKit‭  ·  last activity 3y ago by r~~‭

66%
+2 −0
In MySQL, is it possible to disable triggers for only certain queries or users?

Almost every table in my DB has triggers that fire on INSERT, UPDATE, DELETE and write the changes to a separate read only DB. This makes it possible to track changes and undo things well after the...

1 answer  ·  posted 3y ago by Charlie Brumbaugh‭  ·  edited 3y ago by Alexei‭

60%
+1 −0
Backendly redirecting a user from a contact form webpage to a success webpage

On a CentOS Apache-MySQL-PHP environment I have a website with a simple HTML-PHP-CSS contact form; the contact form itself is working. This is how I backendly redirect a user from the contact form...

0 answers  ·  posted 3y ago by deleted user

33%
+0 −2
How do I find all the tables in a database that don't have a specific column?

I need to add one column with the same name to all of the tables in my database, how can I find which tables don't currently have a column with that name?

1 answer  ·  posted 3y ago by Charlie Brumbaugh‭  ·  last activity 3y ago by Charlie Brumbaugh‭

66%
+2 −0
How to perform LEFT JOIN using LINQ method call notation?

I am interested in performing a LEFT JOIN using LINQ-2-SQL when working with method call notation. This answer suggests a way that relies on GroupJoin but it is more verbose than expected: var le...

1 answer  ·  posted 3y ago by Alexei‭  ·  last activity 3y ago by Alexei‭

77%
+5 −0
F-bounded polymorphism, interface operators, and type inference in C#

C# language version 8.0 introduces limited support for static methods, operators, etc. in interfaces. However, there are still limitations. I was hoping to use the new language features to try a ge...

0 answers  ·  posted 3y ago by Peter Taylor‭

80%
+6 −0
Fail to send DICOM C-Echo, although DICOM Association seems successful.

I am building an Android app to perform a DICOM C-Echo. (DICOM is a standard for storing and transferring medical images; the specification is at dicom.nema.org). My purpose is to learn more about ...

0 answers  ·  posted 3y ago by FractionalRadix‭  ·  edited 3y ago by FractionalRadix‭

77%
+5 −0
Modern CSS for splitting form sections into columns

I have a mobile-only HTML contact form divided in source code into three sections; each section should contain fields by a different context. <!DOCTYPE html> <html> <head> ...

1 answer  ·  posted 3y ago by deleted user  ·  edited 3y ago by Alexei‭