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
While I tend to agree with @Alexei that reading from the standard input is quite a common issue I also think that console.readline tag is too narrow and therefore it shouldn't exists. On the other...
Proposal: Can Include A link to a chat room related to the question or answer. Even if tangentially. I've always found SO to be too dry. Sure, pleasantries are as helpful in a question o...
Currently, Java 16 is the latest version, and there's no support to branch reset yet. But one - still far from ideal - alternative is to use lookarounds: Pattern pattern = Pattern.compile("([aeiou...
You've got an inefficiency in your code, as you always do replacements 3/2 times the length of the string. That is unnecessarily expensive. By instead testing in each iteration whether the length ...
What's the better way to store base64 in SQLite Database? I was thinking to put base64 as TEXT since base64 has lots of chars. CREATE TABLE name (id INTEGER PRIMARY KEY AUTO_INCREMENT, image TEXT)...
In the example.xsd file I have an import to an external xsd file that looks like this: <schema xmlns="http://www.w3.org/2001/XMLSchema" targetNamespace="http://test.example.com" ...
Some new tag "software practices" just popped up, no wiki. What's the purpose of this tag and how is it useful? What exactly in software development is not "software practices"? Seems quite superfl...
I am writing a spoof of the fs module; the actual storage mechanism is not the the filesystem but rather a database. Overall, however, the api will function exactly like fs. So far my code is compa...
On a Linux server, if you leave the .git folder unprotected in the public_html folder, its possible that someone could download the folder and then gain access to your files. There are two ways I h...
If you can, have the repository locally and/or in a Git server. Use rsync to deploy updates to public_html. If the repository still needs to live in that same server, same applies (rsync, just loca...
What are my options here? Do I need to switch the module I'm using to access the db? Do I need to write C code? Or is there a really clever technique to directly solve this problem, using only nod...
This is possible in SQL Server using the built-in @@ROWCOUNT variable. Something like this DECLARE @rows INT = 0; -- INSERT ... SET @rows = @rows + @@ROWCOUNT; -- UPDATE ... SET @rows = @rows + @...
I've just lowered the reputation requirement for both Edit and Edit Tag from 250 to 200. If folks here want it to be lower -- young communities have different needs, after all -- please make a met...
Okay, I'll be the contrarian. For this case, yes, I think a regex-based approach can be used to validate these properties. This approach will not guarantee that the provided input is valid HTML; in...
I think your edited post merits a new answer! You're right that you can make some sort of connection between addition, concatenation, and logical ‘and’—these are all operators that can be considere...
svn cleanup --vacuum-pristines can be used to clean up the pristine copies that might take a lot of space (version 1.10+). In Windows, TortoiseSVN client has the option Vacuum pristine copies to ge...
Note: this is an aggregate of the answer provided for this question. I want to get the LINQ equivalent of the following from SQL: SELECT .. FROM entity1 e1 JOIN entity2 e2 ON e1.field1 = e2.fie...
The quickest way is to make an equal join on two anonymous objects: var result = from x in entity join y in entity2 on new { x.field1, x.field2 } equals new { y.field1, y.field2 } Ano...
Can regex be used to check if input conforms to a very strict subset of HTML? The theoretical answer is Yes. The Javascript regex language is more than powerful enough to parse a recursive gramm...
One rather complicated way to get what you want (may be extended to multiple calls of statements and/or procedures) is through usage of MySQL Row-Based Binary Logs as explained here. This allows fo...
Cross posted to Meta: https://meta.codidact.com/questions/278198 If I try to provide a parent to a tag, it crashes with 500. Error Id = 6bd06f30-539d-4b88-8743-eca32a8465cd Tag to edit = htt...
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...
I hear the walk-before-we-run argument. I think this would be a good thing to try once we reach running speed, though. Personally, I don't like self-answered questions; I think they're an awkward f...
Having had the dubious honor of experiencing the closing process from the perspective of a question author, it seems to me that closing does not adequately communicate why the question was closed, ...
We rather need to make a close reason for every kind of off-topic reason. In this specific case, the reason could for example be Purely subjective question rather than the old "primarily opinion-ba...
