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 ...
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...
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...
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 ...
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...
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 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 ...
I had a curiosity about how much the experienced users wait for their questions to be answered on Stack Overflow and had written a query for it: SELECT YEAR(q.CreationDate) * 100 + MONTH(q.Creatio...
This article shows in a concise and graphical way the difference between URIs and URLs. A URI is an identifier of a specific resource. Like a page, or book, or a document. A URL is special ...
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...
Edit: I have removed the tag. Thanks for the feedback. I am inclined to add a "do not use" request in fullstack tag's description because it is quite vague. What do you think about it?
I am slowly modernizing an older ASP.NET Core Web API and one of the steps involved migrating from database first to code first. Now, all schema changes and seeding is covered by migrations which ...
This is possible in two steps by using a dynamic SQL: SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` ); SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @nextId[]()); PREPA...
According to the documentation for the MySQL IN function: The number of values in the IN() list is only limited by the max_allowed_packet value. The default value for it is 67108864. So, you...
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 ...
