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.
Search
I have to add health checks to a rather new application (Web API, not a microservice) and I and a colleague are not agreeing about what other systems I should include in the check. This application...
This turned out to be a more difficult question to address than I initially thought! After many attempts at finding a way to use tempnam() with vfsStream, I only just now found out from the vfsStre...
One way to solve this is to shrink the database and reindex all tables to fix the indexes fragmentation: DBCC SHRINKDATABASE (TheDatabase); GO -- reindexing all tables to optimize performance ...
Currently the tag [stl] is marked as a sub-tag of c++, implying a meaning of "standard-template-library". However I see both of the questions currently using the tag mean the 3D object description ...
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...
An answer on a related Meta suggestion, Remove parent tags from a post where a child tag is present, provides a case where you might want to tag both. For example, if mammal is a parent of deer,...
Disclaimer: I don't know Go. This is all just me reading the specification. In the Go specification under Packages, it defines PackageName. PackageName = identifier Under Identifiers identi...
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...
This is as old as the ages, and the problem existed in the Yacc world long before CSS was invented. Keep both the SASS and the resulting CSS files in version control. Good: More predictable, eas...
Thanks for raising this question. My answers to your questions: What type of tags will we allow? (Should specific tags like [UrlRewrite] be allowed?) I am not sure what is the best way to deal wi...
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...
An as yet unanswered question on Web Applications, INDIRECT cell reference - Can't copy cell as reference cell pattern remains same, from @Daniel Klose is: I have an Overview Sheet where I want ...
When in ColumnC B can be returned with =char(Column()+63) and since not inside double quotes this will automatically adjust to C in ColumnD. This way a string acceptable to INDIRECT can be construc...
I have recently started a project based on the clean architecture principle and noticed that it did not rely on generic repositories since Entity Framework's DbSets are doing the job just fine. In ...
The easy way is to run this query. SELECT concat('DROP PROCEDURE IF EXISTS example_database.',routine_name ,';') FROM INFORMATION_SCHEMA.Routines WHERE ROUTINE_SCHEMA = 'example_database'; F...
To answer one specific part of the question: Does this have anything to do with some systems allowing a different representation of the null pointer other than zero? Sort of. A null pointer ...
Tags also serve for someone who stumbles across the question directly from a third party link to find related content. Perhaps the child tag would suffice if the parent tag is automatically inserte...
I am currently dealing with an Angular application that is being deployed using an CI orchestrator and Jenkins. Jenkins job is configured to do the following (relevant steps only): fetch source...
I'm developing the design framework for a certain Q&A site. We are currently using an external dependency for the tag selector on the post editor, but it has some disadvantages (not fitting int...
The easiest way to temporarily disable a MySQL user is to the change the value of the Host column in the mysql.user table to an invalid host. UPDATE mysql.user SET HOST = 'blocked' WHERE #your cond...
I believe the answer at the moment is "No" but a very simple formula in LibreOffice 5.4.3.2 can achieve the desired result: =LEN(SUBSTITUTE(B1;0;"")) where B1 contains: =BASE(A1;2;8) as valid and...
Add Microsoft.AspNetCore.Components.WebAssembly.Server nuget to the ASP.NET Core application. Reference the Blazor WebAssembly application from the ASP.NET Core application. <Project Sdk="Mi...
I have a bunch of stored procedures that look like something this CREATE PROCEDURE example() BEGIN UPDATE STATEMENT A; UPDATE STATEMENT B; UPDATE STATEMENT C; END// When I run them thr...
The select for finding tables without a specific column name is, SELECT DISTINCT table_name FROM information_schema.tables WHERE table_schema = 'DATABASE_NAME' AND table_name NOT IN( SELECT DI...
I have a number of MySQL stored procedures that use a cursor to go through a select and then pass the results to other stored procedures one row at a time. This can take a while to run, what is hap...
