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
First store the universe of potential elements as a sequence, then encode each set as an unsigned integer interpreted as follows: if the 1s bit in binary is set (1), the set contains the 0th elemen...
I believe one of the main strengths of Q&A websites is that they provide a more digestible alternative to dense documentation. Especially for programmers who do not yet know how to find/use th...
Apparently there just isn't an equivalent of additionalProperties in Ansible. The way around this is to break the dictionary argument into a list of key/value pairs: argument_specs: main: ...
the answer is incredibly long It really isn't - though it might look that way because of the extensive use of large font headlines. I think it is a good answer - there's no problem in discussi...
I'm trying to replace Flot.js with Chart.js. In my application, Flot.js is included as a normal JavaScript file, like so: <script language="javascript" type="text/javascript" src="jquery.flot-...
Best I could do was: cd /foo/bar && code --new-window . && code baz.txt The cd is not necessary but makes the command cleaner. I would still like to know if there's a cleaner wa...
How to delete a local git branch which hasn't been pushed to anywhere, and only exists locally?
There may be a better way to handle this but this eventually worked for me. It's necessary to add quote: true below each field name with a dash. E.g.: tables: - name: my_table ...
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 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.
