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

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

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 &lt; FILENAME which triggers a warning, mysql: [Warning] Using a password on the command line int...

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

72%
+6 −1
What is do { } while(0) in macros and should we use it?

Background I can see the need to use {} when implementing a function-like macro such as this one: #define HCF(code) fprintf(stderr, "halt and catch fire"); exit(code); Because if we use the fo...

2 answers  ·  posted 2y ago by Lundin‭  ·  last activity 2y ago by Pete W‭

66%
+4 −1
How can I write an egrep (grep -E) regexp that matches lines containing two stanzas in arbitrary order?

I have line-based data on the form x1=y2; a3=b4; c5=d6; ... Matching this with a extended regular expression is fairly straightforward; for example, one can do something not entirely dissimilar...

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

62%
+3 −1
What's the difference between null pointers and NULL?

Someone told me that I shouldn't write "NULL pointer" with capital letters, because a null pointer and NULL are different terms. And that NULL is a "null pointer constant". What's the meaning of th...

3 answers  ·  posted 2y ago by Lundin‭  ·  last activity 2y ago by EJP‭

83%
+8 −0
How do I find the order that yields the shortest path?

The Problem I have a path optimization problem that in some ways reminds me of the Traveling Salesman Problem, but differs in some key respects. I have a group of items that need to be used by a m...

1 answer  ·  posted 2y ago by matthewb‭  ·  edited 2y ago by matthewb‭

16%
+0 −8
Delete specific cells with shift cells up

Answers to Excel - Get only values from column that are not Zero “0” asked by @CiscoNewb includes ones applying AGGREGATE: =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(A$2:A$12&gt;0),ROW(A1)))...

0 answers  ·  posted 2y ago by pnuts‭  ·  edited 2y ago by luap42‭

66%
+2 −0
What are the cons of directly mocking Entity Framework DbSets instead of working with an in-memory database when unit testing the application?

I have recently contributed to a Clean Code project and had a discussion about how to implement unit tests. The project author argues for using an in-memory database (which easily replaces the rea...

1 answer  ·  posted 2y ago by Alexei‭  ·  last activity 2y ago by Goyo‭

71%
+3 −0
Union of queries depending on variable in list

I have a big Cypher query that is depending on a variable. Example: With REGION = 'Canada' query I want to execute this query several times based on different values on a list and return the UN...

1 answer  ·  posted 2y ago by Guilherme Costa‭  ·  edited 2y ago by Alexei‭

90%
+17 −0
Should a salt be stored in the same database as the hash?

To protect against dictionary and rainbow table attacks it is well known that passwords should be salted before hashing. The salt (unique to each password) gets stored with the hash, often in the s...

3 answers  ·  posted 2y ago by jla‭  ·  last activity 2y ago by Canina‭

66%
+2 −0
Search paths where all nodes are in a relationship with same node

Using the below graph as an example: I am trying to determine all Persons which are_sons of Persons all born in the same country. Is there an elegant way to achieve this with Cypher?

1 answer  ·  posted 2y ago by Guilherme Costa‭  ·  last activity 2y ago by r~~‭

66%
+2 −0
How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?

In a stored procedure let's say I have a VARCHAR variable, DECLARE example_variable VARCHAR(100); how much memory is allocated to it and is that independent of the length of the data in the var...

2 answers  ·  posted 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by Alexei‭

75%
+4 −0
Static and thread_local initialization order

Is there any guarantee regarding initialization of static and thread_local objects? In example, is there any guarantee about the value printed by the following program? #include&lt;iostream&gt; s...

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

90%
+17 −0
Does the location of an import statement affect performance in Python?

When writing Python-based apps (e.g. Django, Flask, etc.), it's often the case that import statements can be found all over the place, often more than once for the same module. For example, you can...

1 answer  ·  posted 2y ago by ghost-in-the-zsh‭  ·  last activity 2y ago by ghost-in-the-zsh‭

66%
+2 −0
How to automatically run Entity Framework Core migrations for an application which uses a user with read/write rights on certain tables?

I have decided to convert a legacy database-first ASP.NET Core project to code-first. However, I have noticed that the project used the same database as another bigger project and the Entity Framew...

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

83%
+8 −0
Is MISRA-C useful outside safety-critical and embedded programming?

When discussing best or safest C programming practices with various C gurus on the Internet, the "MISRA-C guidelines for the use of C language in critical systems" often pops up as a source. This ...

1 answer  ·  posted 2y ago by Lundin‭  ·  last activity 2y ago by ghost-in-the-zsh‭

54%
+4 −3
How can I make --reset-author the default?

I do a lot of rebasing and amending of my topic branches. I don't think it's especially useful for me or my colleagues to see in the logs what date it was when I first started working on the partic...

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

git
75%
+4 −0
Unable to `mount` overlayfs in Docker container when inside a LXC with a ZFS pool

Summary/Context I'm currently working to improve performance and throughput of our automation infrastructure, most of which is a combination of Bash/Shell scripts, Python scripts, Docker, Jenkins,...

1 answer  ·  posted 2y ago by ghost-in-the-zsh‭  ·  last activity 2y ago by ghost-in-the-zsh‭

86%
+11 −0
Are there best practices for sticking conditions in WHERE clauses vs the JOIN statement?

Lets say I have two tables, A and B and I need to join a subset of them. Is there best practices of sticking the conditions in the WHERE clause like this, SELECT * FROM A JOIN B on a.fk_b = b....

2 answers  ·  posted 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by klutt‭

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 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by Alexei‭

71%
+3 −0
In PHP what is the use case for include instead of require when including PHP scripts?

In PHP one can either use include or require to include files, the difference is that if the file doesn't exist it will emit a fatal error and halt with a require and only emit a warning with inclu...

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

php
71%
+3 −0
In MySQL is there a limit to the number of keys in a IN() clause?

I have a PHP program that does a SELECT and then updates some of the values based on an algorithm. Rather than updating one row at a time UPDATE example_table SET COLUMN_A = 1 WHERE primary_k...

2 answers  ·  posted 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by Alexei‭

71%
+3 −0
How to make Microsoft.Build.Evaluation.Project use same base properties as Visual Studio?

Microsoft.Build.Evaluation.Project seems to have some rather odd ideas of what values to use when loading projects. In particular, I have a number of projects with the following dependency: &lt;Pa...

1 answer  ·  posted 2y ago by Peter Taylor‭  ·  last activity 2y ago by Peter Taylor‭

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 &lt; 10000000; $x += 1...

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

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 2y ago by Alexei‭  ·  last activity 2y ago by Alexei‭

71%
+3 −0
Why would an unique index get moved to the primary key after the underlying column is dropped?

So I had a table with a primary key and a bunch of different columns. Columns A, B, and C were all unsigned ints (like the primary key column) and each column had a unique constraint I dropped the...

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

77%
+5 −0
Is it possible in MySQL to require each row in a table have at least one foreign key record in a join table?

I have tables A and B and then I have a many to many join table with foreign keys to both called a_b. Neither foreign key can be null and the combinations for the foreign keys to A and B are unique...

2 answers  ·  posted 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by Alexei‭

50%
+0 −0
Is it possible to rebuild a STL file from gcode?

I have a couple of 3d example projects in gcode for my printer but the printer bed has a couple of bumps in the center (where things are printed by default) and in order to print the objects I woul...

0 answers  ·  posted 2y ago by Charlie Brumbaugh‭  ·  edited 2y ago by Moshi‭

50%
+0 −0
How to drop all stored procedures from a MySQL database

I need to drop all of the stored procedures from my MySQL database before I recreate them. How can I do so?

1 answer  ·  posted 2y ago by Charlie Brumbaugh‭  ·  edited 2y ago by Peter Mortensen‭

75%
+4 −0
How can I add "withCredentials:true" for HTTP requests generated by Swagger UI?

I have added Swagger UI for an ASP.NET Core 3.1 application and I have realized that all endpoints requiring Windows Authentication fail. This issue is created by the fact that generated HTTP reque...

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

71%
+3 −0
SID to login for access via a group

I have a query that returns the owner of jobs on an SQL instance, select s.name as JobName , s.owner_sid , ISNULL(L.name,'AccessViaGroup') as LoginName --Trying to figure out how to turn that ...

0 answers  ·  posted 2y ago by James Jenkins‭  ·  edited 2y ago by Alexei‭

60%
+1 −0
Permutations of an array - APL

In Dyalog APL, there's a predefined function in the dfns library to generate a matrix of permutations for a list of the numbers from 1 to n. I want to create the same functionality, except that it...

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

60%
+1 −0
How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped?

My project has the following set up for the production and preproduction ("clone") environment. Production is not accessible at all for the development team, only the preproduction database. Pr...

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

60%
+1 −0
How to create a delayed loading indicator when working with ngrx/store?

I am working on an Angular application using ngrx and I have a loader state + reducer that is used to display a loader. However, very short AJAX calls cause a flicker and I need to delay showing th...

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

50%
+1 −1
Create encrypted zip archive with bsdtar [closed]

I'm trying to create an encrypted¹ zip archive using bsdtar. Here's where I got stuck: bsdtar -c --options='zip:encryption' --passphrase "secret" -f test.zip test This is the error I get: bs...

0 answers  ·  posted 2y ago by Matthias Braun‭  ·  closed 2y ago by Lundin‭

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 2y ago by Zerotime‭  ·  edited 2y ago by Alexei‭

83%
+8 −0
For scripting what are the pros and cons of command line arguments versus capturing input at the start?

Let's say I have a script that needs the user to set X number of variables at the start. One can either Pass the arguments in on the command line. Start the program and then have the user input th...

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

71%
+3 −0
How do I track down intermittent locks in a MySQL database?

Currently, we have a CRUD plus reporting application that talks to one MySQL database. Intermittently users will report locks when searching, currently, I can only get the approximate time of when ...

0 answers  ·  posted 2y ago by Charlie Brumbaugh‭  ·  edited 2y ago by Alexei‭

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 2y ago by Charlie Brumbaugh‭  ·  edited 2y ago by Alexei‭

72%
+6 −1
Which abstraction should I choose for background services and why?

Which concept is best for managed background services? 1. RunAsync(CancellationToken): interface IWorker { Task RunAsync(CancellationToken cancellationToken = default); } ... IWorker worker =...

1 answer  ·  posted 2y ago by Kir_Antipov‭  ·  last activity 2y ago by Alexei‭

66%
+2 −0
Are hyphens and/or underscores valid in golang package names?

Can a Go package name validly contain a hyphen and/or an underscore? The godocs say that By convention, packages are given lower case, single-word names; there should be no need for underscores or...

1 answer  ·  posted 2y ago by laserkittens‭  ·  last activity 2y ago by Moshi‭

40%
+0 −1
How do World Wide Web interactions happen in a general level? [closed]

I understand that any World Wide Web interaction works this way: Stage 1: Client (human or software) ⟶ User agent ⟶ HTTP/S web-server request (with an unresolved domain) Stage 2: ISP-initiated Rou...

0 answers  ·  posted 2y ago by deleted user  ·  last activity 2y ago by Alexei‭

web
81%
+7 −0
Function call; `this` gets bound to unexpected value

I recently encountered a strange situation in javascript; if I have: let obj = { a: function() { return (this === obj) ? this.b : 'bye'; }, b: 'hello' }; I can call obj.a with this bound...

2 answers  ·  posted 2y ago by Gershy‭  ·  last activity 2y ago by Alexei‭

77%
+12 −2
What gets allocated on the stack and the heap?

I was told by my professor/book that computer programs use two kinds of memory and that all variables get allocated either on the stack or on the heap. Is this true? How can I tell where a variable...

2 answers  ·  posted 2y ago by Lundin‭  ·  edited 2y ago by Alexei‭

80%
+6 −0
How are integers interpreted in contexts that expect a date?

I found a confusing construction in several stored procs in an MS SQL 2008 R2 database: DATEADD(dd, 0, DATEDIFF(dd, 0, some_date)) As I understand it, these are the relevant function signatures: D...

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

66%
+2 −0
Xcode, SDL app showing in a single quarter of the window.

Why SDL (the Simple Directmedia Layer) apps are showing in a single quarter of the window, while the other three are blacked out, and what can I do about it? I'm using Xcode. I think this started h...

0 answers  ·  posted 2y ago by .                                                .‭  ·  edited 2y ago by .                                                .‭

77%
+5 −0
How does Caveat work?

One of the fonts available (to me) on Google Docs is Caveat. The following is in 18-point Caveat on Google Docs: I found that Caveat is available at https://github.com/googlefonts/caveat/tree/ma...

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

60%
+1 −0
How to use LazyCache library with Unity Container?

I want to use LazyCache and UnityContainer together in an ASP.NET classic application (.NET framework 4.6.1+). Namely, to be able to inject IAppCache in various services. For ASP.NET Core and its d...

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

77%
+5 −0
What would the pros and cons of storing the compiled CSS output of SASS in version control?

If one is using SASS to build a websites CSS and using version control one can either, Keep both the SASS and the resulting CSS files in version control. Only storing the SASS files in version con...

4 answers  ·  posted 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by ben‭

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 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by Alexei‭

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 2y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by manassehkatz‭