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.
Activity for Alexei
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Answer | — |
A: What are the disadvantages of using static methods in Java? I am not a Java developer, but a C# .NET one, but I guess static concept is very similar between the two. As in many areas, it depends, but for most applications using static should be avoided: - Single Responsibility Principle violation - prevents polymorphism - prevents abstraction (canno... (more) |
— | over 2 years ago |
| Answer | — |
A: console.readline tag does not look good to me I have created this tag because reading lines from the standard input stream is a basic task found in many programming languages. I have also noticed that the tag exists on SO, but this is only to have a rough idea if the concept makes sense to more people (we do not have to copy their tags). [sta... (more) |
— | over 2 years ago |
| Answer | — |
A: What might happen if I ignore warning? 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 a side note, Languages such as C# and Java prohibit this (compiler error). (more) |
— | over 2 years ago |
| Answer | — |
A: Unfair accusation in a comment and consequent loss of *actual* reputation Thanks for raising this on meta. Indeed the comment author admitted to making a mistake by accusing of copy-pasting from Wikipedia and I have removed all the comments. > However, now my answer is at -3 votes, apparently because of that false accusation. Your answer now has 4 - 2 (only two dow... (more) |
— | almost 3 years ago |
| Question | — |
Using Software Codidact as a private community within a company Short version As you probably know SO offers Stack Overflow for Teams as a product for a knowledge management tool for private use (private teams). I am wondering if it is possible for Codidact to also offer something similar in the medium term. Long version Several years ago along with ... (more) |
— | almost 3 years ago |
| Answer | — |
A: How much research effort is expected from the asker by the community? There are multiple questions/aspects in your posts, so I will go one by one: > Stack Overflow which answers many questions While this is true, for many questions SO has an important drawback. If the question is old enough it might have a lot of outdated answers. By outdated I mean anything that... (more) |
— | almost 3 years ago |
| Answer | — |
A: Is it correct to downvote answers to bad questions? I think there are two aspects here: What to do about offtopic questions? Being offtopic should trigger a close/flagging action. I see voting mostly related to the post quality (useful, shows some research effort) which is relatively independent of being on-topic/offtopic. What to do about go... (more) |
— | almost 3 years ago |
| Answer | — |
A: Should "Hello", "Thank you", "Morning" and similar greetings be removed from posts? 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 of how we actually interact with each other as human beings. So, I would let them be. If the "tha... (more) |
— | almost 3 years ago |
| Question | — |
Sometimes entered tag information seems to get lost From time to time, I am filling in some information for the Software Codidact tags and I realized that for some tags I filled the information twice. An example would be winforms which I almost certainly edited a couple of weeks ago and today I found it without the description. I added it again... (more) |
— | almost 3 years ago |
| Question | — |
Renaming a tag to an existing one fails silently If I try to rename a tag to an existing one it silently fails. Example: trying to rename data-archiving to `archiving` fails with console error only: > application-f4dc10c11dc65439a992f7c98cb554bfbc419e710e5a5267f5048e7cb1f8794f.js:37 Failed to rename tag, somehow Not allowing duplicate tags i... (more) |
— | almost 3 years ago |
| Answer | — |
A: Is it correct to ask customer service-related questions? Asking customer service-related questions is generally offtopic unless there is a connection to the software development process. Taking your examples one by one: - How do I get my Facebook developer account confirmation code? - service-related if it is about manually (through human action) activa... (more) |
— | almost 3 years ago |
| Answer | — |
A: redirect to "main" code in Ruby using Ctrl 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 many IDEs for variables, function names etc. This is due to the fact that the IDE understands what the ... (more) |
— | almost 3 years ago |
| Question | — |
Mixing "operational" database models with archiving ones in the database context Context Our product owner has realized that some entities are duplicated from time to time and that a merge is required. This should clean up existing duplicates and also allow special users to merge entities in the future. The merge process is defined as follows (this should be done atomically... (more) |
— | almost 3 years ago |
| Answer | — |
A: How to create a MySQL generated column that uses a join in a concat? 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 the same data in tables, multiple invocations produce the same result, independently of the connected u... (more) |
— | almost 3 years ago |
| Question | — |
How to find out which packages target .NET 3.1 in a .NET 5 application? After upgrading a Web application from ASP.NET Core 3.1 to ASP.NET Core 5.0, it worked fine on an existing server. However, when deployed on a server that had only .NET 5.0 installed, the application pool crashed and said (as a logged event) that .NET Core 3.1 is missing. Clearly, some packages... (more) |
— | almost 3 years ago |
| Answer | — |
A: How to generate multi-line completions (code generation) with OpenAI? 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 following (`###` is the separator I have used): string text = @"Q: generate a standard model for Fo... (more) |
— | almost 3 years ago |
| Answer | — |
A: Is there any breaking change in regard to TrustServerCertificate property of System.Data.SqlClient for .NET 5? I think I have found the cause of this issue: > Changes default behavior of driver to not validate server certificate if client did not request encryption with "encrypt=true" but encryption was enforced by SQL Server. This is also mentioned in the SQL Client 2.0 breaking changes: > The dri... (more) |
— | almost 3 years ago |
| Question | — |
Is there any breaking change in regard to TrustServerCertificate property of System.Data.SqlClient for .NET 5? I have recently an issue at work after upgrading an ASP.NET Core 3.1 application to .NET 5. It worked correctly on all environments (e.g. PreProd, Prod) when targeting 3.1, but failed on Prod only after upgrade to .NET 5. The error was login related: > A connection was successfully established... (more) |
— | almost 3 years ago |
| Answer | — |
A: Is the concept of a PHP lint feasible? If I understand correctly what you are asking for is a static code analysis tool for PHP. A quick search reveals that Psalm would be such a tool. (more) |
— | almost 3 years ago |
| Question | — |
Do we need more specific up/down vote reasons for Software Development community? The help center includes a rather generic (it's the same for all communities) article about voting. Recently a user flagged a question asking why it had received so many downvotes. While flagging is not for this type of issue, this made me wonder if users are aware of how upvote and downvote are s... (more) |
— | almost 3 years ago |
| Question | — |
How to generate multi-line completions (code generation) with OpenAI? I have finally received access to a trial account on OpenAI and I took it for a spin. My interest is with code generation, so first tried something simple using the playground: ``` Q: generate a standard model for Foo A: public class Foo { public int Id { get; set; } pu... (more) |
— | almost 3 years ago |
| Question | — |
What are the risks of using iFrame as a temporary migration step for an internal web application? Overview Our development team is currently trying to develop and migrate a Web application that is split in two: - legacy: ASP.NET MVC 5, jQuery, old-style JS programming overall - "next": Angular SPA + ASP.NET Core 5 Each application has its own domain, but they are accessible only intern... (more) |
— | almost 3 years ago |
| Question | — |
Can we migrate office suite related questions to the Power Users community? Power Users has just been launched and I remember that Software Development has some content related to office suite usage (example). Is it OK to migrate these questions to the Power Users community? (more) |
— | almost 3 years ago |
| Answer | — |
Etiquette for posting comments Generally speaking, comments should be helpful feedback and the following are not exhaustive lists. Can include - asking for question clarification. Examples: "what was the output of line X?", "can you include the stack trace?", "can you provide a reference for the second paragraph?" - explain... (more) |
— | almost 3 years ago |
| Answer | — |
A: Is this a known design pattern: a piece of code is responsible for acting as a central proxy for data distributed in various places? General information As indicated in the comments you are looking for something similar to the Facade pattern. It is still not clear what you are trying to achieve, but the X class seems that it will tackle way too many things. In order to avoid adding a lot of logic in one class (even if it on... (more) |
— | almost 3 years ago |
| Question | — |
How to easily support time frame grouping in queries? 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.CreationDate) AS YM, COUNT(1) Cnt INTO #acte FROM Posts AS q INNER JOIN Users qu ON qu.Id = q.Owne... (more) |
— | almost 3 years ago |
| Answer | — |
A: Etiquette for posting comments Before posting this on the help pages, I will compile the feedback in a separate answer. Generally speaking, comments should be helpful feedback and the following are not exhaustive lists. Can include - asking for question clarification. Examples: "what was the output of line X?", "can you i... (more) |
— | almost 3 years ago |
| Answer | — |
A: Save migration info in separate DB schema If you want to use a custom entity framework migration table, you can set it when configuring the database context as shown here: ``` // this code belong to the database context class protected override void OnConfiguring(DbContextOptionsBuilder options) => options.UseSqlServer( co... (more) |
— | almost 3 years ago |
| Question | — |
Etiquette for posting comments This question featured a quite heated discussion in the comments which led to some of them being removed. This action was discussed here and I have realized that our community lacks a guide about posting comments. I would like for us to build together a list of topics we can include and avoid resp... (more) |
— | almost 3 years ago |
| Answer | — |
A: What is an example for a URI which is not a URL? 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 type of identifier that also tells you how to access it, such as HTTPs, FTP, etc.—like https://www.... (more) |
— | about 3 years ago |
| Answer | — |
A: How are we supposed to give feedback for poor questions if such comments are deleted? Providing feedback can be done using comments. However, these comments are supposed to add constructive criticism and/or links to relevant resources. Your first comment does exactly this and it is a useful one. However, the subsequent comments seem to be a debate around available Wikipedia transla... (more) |
— | about 3 years ago |
| Answer | — |
A: How to break infinite loop in CTE Estela's answer provides great insight about how to do it also in SQL Server. Unfortunately, there does not seem to be a build-in array functionality, so one way is to rely on strings as shown here. Basically, instead of accumulating values in an array, a string does this (way less efficiently for... (more) |
— | about 3 years ago |
| Question | — |
How to work with current entity changes when working with @ngrx/store and @ngrx/entity? I am fairly new to working with @ngrx pattern in Angular which is a state management pattern relying on Reactive Extensions. One of the convenient structures is @ngrx/entity which helps with managing record collections. One typical scenario in the application is to access of list of Foos and... (more) |
— | about 3 years ago |
| Question | — |
How to properly deal with impersonation in a Web application? (security vs. usefulness for tech support) Context Our team has begun migrating a pretty old internal application and one aspect that got my attention is the impersonation. This is implemented as follows: - only administrators are allowed to impersonate someone else - impersonation means setting the current session user to the imperso... (more) |
— | about 3 years ago |
| Answer | — |
A: Not obligating http:// or https:// in a url field of a contact form `input type="url"` works like this by design: > An empty string ("") indicating that the user did not enter a value or that the value was removed. > A single properly-formed absolute URL. This doesn't necessarily mean the URL address exists, but it is at least formatted correctly. In simple te... (more) |
— | about 3 years ago |
| Answer | — |
A: Submitting a form via XHR/AJAX causes partial data arrival to email inbox (only HTML without input) I am guessing a little here. By not preventingdefault, the form will POST the data to the server. If you switch to AJAX you have to provide the body as per documentation. However, I do not remember to ever using the XMLHttpRequest directly, because there are wrappers to help you. One example us... (more) |
— | about 3 years ago |
| Question | — |
How to enable or disable a bunch of reactive form controls? I want to conditionally disabled or not (enabled) a bunch of reactive form controls. However, I have noticed that neither `enable` or `disable` function has a boolean parameter to nicely conditionally disable a control (this is the solution I have seen in other frameworks to allow this, despite being... (more) |
— | about 3 years ago |
| Question | — |
How to tackle database migrations failure during application initialization on production systems? Context My ASP.NET Core application got stuck in Production with a 5xx error. By inspecting the logs, I have noticed that a database error occurred during application initialization, namely a SQL Server access error. This happened because the application restarted and at that very moment, it t... (more) |
— | about 3 years ago |
| Answer | — |
A: Are JavaScriptless forms accessible? 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 option, you must also consider the performance and UX implications of this: - client-side validations p... (more) |
— | about 3 years ago |
| Answer | — |
A: PHP emails are sent when $message is a string, but not when its an array 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 that structure (i.e. your array) and generate a string from it. This is a good idea also from an arch... (more) |
— | about 3 years ago |
| Question | — |
What should healthcheck of an Web API application actually check? I have to add health checks to a rather new application (Web API, not a microservice) and I and a colleague are not agreeing about what other systems I should include in the check. This application is the beginning of the writing of a legacy one (will work side by side for a long transition period). ... (more) |
— | about 3 years ago |
| Answer | — |
A: How to reason about transaction isolation during development One way to go is probably to use some kind of transaction scope to include everything (SELECT from order and INSERT into shipment) with a high enough transaction isolation (e.g. SERIALIZABLE for SQL Server). However, this might prove very expensive if you need a high transaction throughput. In pr... (more) |
— | about 3 years ago |
| Answer | — |
A: Are code troubleshooting posts allowed? Yes Questions about troubleshooting your non-working code are on-topic, provided that you include enough information for the community to understand the context (SO names this minimal reproducible example) and at least one attempt / debugging information. I have also updated the What type of qu... (more) |
— | about 3 years ago |
| Answer | — |
A: Is it possible to disable the "mysql: [Warning] Using a password on the command line interface can be insecure" warning? There are multiple ways to do this. Just picked two that I find more usable (not very insecure or hard to do). 1. Use a configuration file to store the credentials mysql --defaults-extra-file=/full/path/to/config.cnf and the configuration file should contain the login data: [cl... (more) |
— | about 3 years ago |
| Answer | — |
A: How to separate DB query logic from the application other than implementing a repository on top of an ORM? > p.s. I'm not sure whether the criticism applies only to generic repositories or not. This applies to generic repositories as most of their operations (e.g. get entity by id, update the entity, delete entity) are already being done by the DbSet). > consuming the ORM directly from the Appli... (more) |
— | about 3 years ago |
| Question | — |
What are the factors to consider when deciding to split ORM queries or use eager loading? 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 eager load children entities - split in multiple queries: rarely using Include, splits the loading in m... (more) |
— | about 3 years ago |
| Question | — |
Cannot close a question as a duplicate due to "Invalid input for other post" error 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 receive the following HTTP response: > {"status":"failed","message":"Invalid input for other post.... (more) |
— | about 3 years ago |
| Answer | — |
A: C# MVVM Login Project Things you might consider to improve your code: 1. Use `nameof` instead of magic strings. Example: `OnPropertyChanged("User");` can be replaced with `OnPropertyChanged(nameof(User));`. This allows for renaming to properly work. 2. Consider using on ORM such as Entity Framework Core instead of e... (more) |
— | over 3 years ago |
| Question | — |
Do we need the fullstack tag? 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? (more) |
— | over 3 years ago |
| Question | — |
How to manage views and stored procedures in an ASP.NET Core project? 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 are automatically run at API startup. However, the service also uses several dozens of views and store... (more) |
— | over 3 years ago |