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 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 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...
Yes, several. Example outcomes from various inputs and functions are shown in the table below, with those compliant with the current requirement highlighted: CEILING CEILING.MATH CEILING.PRECISE
An as yet unanswered Q from Stack Overflow [SO] enquired: how to stop looping this formula where the formulae were: in B9 =16,50 in B10 =B9-B11 in B11 =B10/2 without changing ...
This is an unanswered code review request of mine from Code Review Stack Exchange. Overview I have developed a small ASP.NET Core 3.1 Web API that provides information that is rarely changed (sever...
Since the formulae have circular references (Err:522) the spreadsheet setting needs to be changed to enable iteration (Tools > Options… > LibreOffice Calc > Calculation, tick Iterations an...
The reference indicated by jcsahnwaldt indeed specifies the space required by VARCHAR columns, namely (L = string length): L + 1 bytes if column values require 0 − 255 bytes, L + 2 bytes if valu...
I have noticed some time ago that Entity Framework assumes a CASCADE behaviour (implicit value, if not specified) for referential constraints (FKs) when deleting items. This means that by default, ...
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...
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'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...
