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
A couple of year ago a user of Super User reported difficulties with summing values purporting to be Euros imported to LibreOffice Calc in CSV format. In the Q the user does not mention the locale...
One way is to create a lookup table (sorted ascending) and take advantage of VLOOKUP's is_sorted parameter to opt for "the nearest match (less than or equal to the search key)". Say a table like so...
One part of an as yet unanswered Q on Super User asks whether conditional formatting in OpenOffice Calc can be used to highlight an entire row based on whether a checkmark in the row has been selec...
After toying a little more with Delete actions for referentials, I think the rational of having the CASCADE DELETE as default is the following: having to DELETE the children before the parent is ...
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...
I don't really see the point of listing specific things as "on topic." Any such list is bound to either be incomplete or have a grey area overlap with things off-topic. I also disagree with some of...
I need to rename one column in 170 tables in a MySQL database and its going really slow. [...] Doesn't make much sense. A column name should be easy to rename and somewhat independent of the data...
One could either do a unique constraint on those foreign keys or a composite primary key on those columns. For elegance, canonicity, a primary key is necessary. You would initially have a primary...
Angular CLI official page indicated how to install the CLI, but provides no information about how to upgrade it. I am interested in how to upgrade the CLI.
I'm using GNU/Linux. I'd need some program or script or solution which would wrap make so that it would launch cpulimit on g++ processes in order to be nice to sensors output. Or, more genericall...
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...
