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.
Posts by Alexei
Note: this is mostly a personal preference that I use when moderating the posts Generally, no While "Hello" and "Thank you" are noise (overhead) for the questions and answers, they are also part ...
Despite the fact that I have programmed against SQL Server for quite a while I did not pay much attention to the tempdb database. This is especially true if application logic is mostly written usin...
I have a hard time deciding if How to get conditional running cumulative sum based on current row and previous rows? should be closed or not. As mentioned in the comments, it was already flagged t...
Context I noticed that an application was flooding the database with simple SELECTs. The investigation revealed some bugs in the health check which theoretically implemented caching (to avoid quer...
Context I am currently migrating a Web application from on-prem infrastructure to K8s. The legacy infrastructure relies on defining some tokens in the configuration files and these are replaced d...
I am currently working on an Angular SPA that supports multiple languages and relies on ngRx for state management. Although the application state is handled by ngRx, the current language is stored...
If you do not mind having so much code on a single line, the builder pattern might be useful here. Something along the lines: Note: the example is adapted based on an implementation I have done in...
Many questions and answers on Software might involve a lot of code that typically require more width and/or height to be displayed in a way that is easy to read. Why simply not enforce resize: non...
I am interested in finding out all the aspects I need to cover in order to correctly assess if a user has stopped interacting with a web page. So far, I found the following: Idle Detection API -...
During a presentation of a pipeline configuration, a colleague showed a SonarQube integration and one of its reports. A warning was caused by overrunning the max value for the code complexity thres...
I would like to ask a question about the pros/cons of using a library or more generally a way of assertion of complex data models. This is more related to testing than it is to actual coding, but ...
Based on my experience auto-mapping has some drawbacks: "find all references" not working as expected - anyone relying on the "find all references" functionality or similar will miss the impli...
Server-side solution If you can customize the server-side search functionality, you could add some logging information there. The advantages in this case are: store the data in a useful format ...
Our team is currently transferring all functionality (+ some changes) from small and very old project A (almost code freeze) to project B (actively developed). As part of the data migration, there ...
I agree that company name tags should not be used, since tag can point to a product, framework etc. and that tag description includes the information about the owner of the product. Of course, for ...
Not returning a value on all code paths is error-prone because the function might not return the expected value in the non-covered cases. That is why it is better to explicitly return a value. As ...
Not a direct answer, but it should clarify some things. It redirects me to where the variable was declared Yes, this is called "go to definition/declaration" and it works out of the box in ma...
I don't think this is possible in MySQL due to its computed columns limitations: Literals, deterministic built-in functions, and operators are permitted. A function is deterministic if, given th...
I have reached OpenAI's support and one way to generate more accurate multiline responses is to use a clear separator between each question and answer block of text. My final working code is the fo...
As indicated by your source using (or not) JS is mostly independent of accessibility since the latter is obtained mainly through HTML and CSS. As a side note, while not using JavaScript is an opti...
As explained by manassehkatz, the message (aka the body) is a text in PHP (and many other programming languages). If your e-mails have a certain structure, you should create a function that takes ...
I have extensive working experience with Entity Framework ORM and have noticed two major ways of writing LINQ (LINQ2SQL): lot of eager loading: the most prevalent, uses (lots) of Includes to eag...
Enable text-area for comments to be resized is a duplicate of Can comment input fields be vertically scalable?. I am trying to close it as a duplicate and provide the older question link, but I re...
I can provide an answer based on Stack Overflow experience. SO offered watches by tags. By using a general tag along with a more specific tag, users interested in [sql] will also get the question i...
I have recently posted this question on Web Application SE and I am wondering if such a question would be on-topic here. The questions deals with understanding a feature of Google Chrome Developer ...
