Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users

Dashboard
Notifications
Mark all as read

Activity for Alexei‭

Type On... Excerpt Status Date
Comment Post #282206 I have fixed the tag name. Thanks.
(more)
3 days ago
Edit Post #282230 Initial revision 3 days 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)
3 days ago
Edit Post #282203 Post edited:
added relevant tag
4 days ago
Edit Post #282121 Post edited:
removed a server name from the post
9 days ago
Edit Post #282121 Initial revision 10 days 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)
10 days ago
Edit Post #282119 Post edited:
added relevant tag
10 days ago
Edit Post #281659 Post edited:
switched tag to have less redundancy
10 days ago
Comment Post #282094 Now everything makes sense. Btw - page refreshes are typically noticeable (some flicker). Is this happening in your case? Thanks for posting an answer.
(more)
10 days ago
Edit Post #281659 Post edited:
added relevant tag
11 days ago
Edit Post #282023 Post edited:
added relevant tags
11 days ago
Edit Post #282079 Post edited:
11 days ago
Edit Post #282083 Post edited:
added relevant tags
11 days ago
Comment Post #282079 That sounds strange as I see that the service is provided in the root. Can you share the code from a component where you use `LogService `?
(more)
11 days ago
Edit Post #282050 Post edited:
added reference to OpenAI community
13 days ago
Edit Post #282050 Initial revision 13 days 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)
13 days ago
Edit Post #282044 Post edited:
added relevant tags
13 days ago
Edit Post #282019 Post edited:
added breaking change text
15 days ago
Edit Post #282019 Initial revision 15 days 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)
15 days ago
Edit Post #282018 Initial revision 15 days 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)
15 days ago
Comment Post #281995 Not an expert on the matter, but coming from .NET development area, native JS date/time manipulation looks like a mess. I would definitely consider using a library, if possible: https://terodox.tech/migrating-away-from-momentjs-part1/
(more)
16 days ago
Edit Post #281991 Post edited:
added relevant tag
16 days ago
Edit Post #278622 Post undeleted 20 days ago
Edit Post #281928 Initial revision 22 days 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)
22 days ago
Edit Post #278578 Post undeleted 23 days ago
Edit Post #278572 Post undeleted 23 days ago
Edit Post #278570 Post undeleted 23 days ago
Edit Post #278325 Post undeleted 23 days ago
Edit Post #278762 Post undeleted 23 days ago
Edit Post #278532 Post undeleted 23 days ago
Edit Post #278361 Post undeleted 23 days ago
Edit Post #278360 Post undeleted 23 days ago
Edit Post #277933 Post undeleted 23 days ago
Edit Post #278367 Post undeleted 23 days ago
Edit Post #278334 Post undeleted 23 days ago
Edit Post #278333 Post undeleted 23 days ago
Edit Post #277931 Post undeleted 23 days ago
Edit Post #277930 Post undeleted 23 days ago
Edit Post #278576 Post undeleted 23 days ago
Edit Post #277262 Post undeleted 23 days ago
Comment Post #281859 Both. However, I think the tooltips are the quick win because they are shorter and more accessible (I expect that the tooltips are read more often than a particular help page). This would hopefully help the users understand why their questions/answers are getting downvotes.
(more)
25 days ago
Edit Post #281859 Initial revision 27 days 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)
27 days ago
Edit Post #281817 Post edited:
added relevant tags
27 days ago
Edit Post #281853 Initial revision 27 days 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)
27 days ago
Edit Post #281797 Post edited:
added more information
about 1 month ago
Edit Post #281797 Initial revision about 1 month 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)
about 1 month ago
Comment Post #281762 This question is being referenced by [a Power Users meta post](https://powerusers.codidact.com/posts/281782).
(more)
about 1 month ago
Edit Post #281784 Initial revision about 1 month 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)
about 1 month ago
Comment Post #281762 I will try to migrate this to the newly created [Power Users community](https://powerusers.codidact.com/), but I will have to clarify if it is on-topic there.
(more)
about 1 month ago
Edit Post #281762 Question closed about 1 month ago
Edit Post #281762 Post edited:
about 1 month ago
Edit Post #281762 Post edited:
Replaced title with a clear question
about 1 month ago
Comment Post #281640 @Lundin Please check the "what types of questions can I ask here" on its [help page](https://software.codidact.com/help/on-topic). Of course, it is not set in stone, so yes, it is still open for suggestions. Please use a separate meta question to suggest improvements for it.
(more)
about 1 month ago
Edit Post #281730 Question closed about 1 month ago
Comment Post #281730 Welcome to Codidact. Unfortunately, the question is not on-topic unless you include a reference to the algorithm used by tradingview (btw - the link is broken for me) to compute the exponential moving average (EMA) indicator.
(more)
about 1 month ago
Comment Post #281663 Isn't INFORMATION_SCHEMA generated based on the actual database objects (tables, views, security)? I expect that by recreating those objects at the destination to also get the metadata in INFORMATION_SCHEMA.
(more)
about 1 month ago
Edit Post #281624 Initial revision about 1 month 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)
about 1 month ago
Edit Post #281616 Initial revision about 1 month 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)
about 1 month ago
Comment Post #281606 X class (instance) seems like a [God object](https://en.wikipedia.org/wiki/God_object) to me. Why do you need to centralize so much heterogenous functionality in one place?
(more)
about 1 month ago
Edit Post #281605 Post edited:
added tsql tag
about 1 month ago
Comment Post #281606 This is an interesting question. I am thinking of something like Redux which deals with state management. It would be useful if you can provide a simple example like 3 classes with 3 data types to understand the nature of your application (e.g. is the data related to the state or is it something else...
(more)
about 1 month ago
Edit Post #281605 Initial revision about 1 month 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)
about 1 month ago
Edit Post #281604 Initial revision about 1 month 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)
about 1 month ago
Edit Post #281566 Post edited:
about 2 months ago
Edit Post #281566 Post edited:
fixed the old text
about 2 months ago
Edit Post #281566 Post edited:
added response to the actual question
about 2 months ago
Edit Post #281566 Initial revision about 2 months 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)
about 2 months ago
Comment Post #281565 However, I think that we could minimize conflict by replacing some comments with downvoting (e.g. for no research or effort) or flagging (e.g. for seriously wrong content such as homework dumps). I do not see how endless debates in comments help with removing bad content.
(more)
about 2 months ago
Comment Post #281565 Yes, I agree that snark is very hard to define. Also, agree that SO policy of being way too welcoming is not beneficial for the advanced users (e.g. in the last two years, I could not get any serious question being answered unless I placed a bounty).
(more)
about 2 months ago
Edit Post #281560 Post edited:
added call for action
about 2 months ago
Edit Post #281560 Initial revision about 2 months 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)
about 2 months ago
Comment Post #280112 Recently, a major Node.js upgrade (12 -> 14) on a target server required the removal of the `node_modules`. Other than that, no need to remove it.
(more)
about 2 months ago
Comment Post #281539 Thank you for providing this answer. I will soon ask a question on meta about how to add comments (what is OK and what is not OK) so that the community can reach a consensus about this topic. Anyway, I agree that being digressive is sometimes necessary.
(more)
about 2 months ago
Comment Post #281517 This question is being discussed on [meta](https://software.codidact.com/posts/281528).
(more)
about 2 months ago
Edit Post #281531 Post edited:
fixed the link
about 2 months ago
Comment Post #281530 @meriton However, your second comment mostly deals with the poster's asking style rather than the post itself. I hope that I am clearer now. Normally, I would have moved the comments to a separate chat (comments are not meant for long conversations between users), but this option is not available her...
(more)
about 2 months ago
Comment Post #281530 @meriton This is not what I have said. What I have said is that feedback (regardless of being negative or not) should be constructive. Your first comment provides such feedback by suggesting in a nice way to check a reference before asking the question, because it seems that the information is easy t...
(more)
about 2 months ago
Edit Post #281531 Initial revision about 2 months 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 2 months ago
Edit Post #281528 Post edited:
added relevant tag
about 2 months ago
Edit Post #281530 Initial revision about 2 months 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 2 months ago
Comment Post #281517 This is a very relevant article on this topic: https://danielmiessler.com/study/difference-between-uri-url/ . A quick answer to your question: a book identifier (ISBN - ...) is an URI which is not an URL.
(more)
about 2 months ago
Comment Post #281517 I have removed the comments that are not relevant. Please use comments to ask for clarifications or generally speaking, to improve the question.
(more)
about 2 months ago
Comment Post #281448 @artaxerxe‭ If you don't need to compute this too often and the data volume is pretty low (<100K records, also depends on the frequency), you can fetch all the required data in the application layer and implement the algorithm there. Languages such as Java or C# are better equipped for recursivity, t...
(more)
about 2 months ago
Comment Post #281232 @JDB The N/A case is typically approached by having the form field not required. So, you either enter a valid URL or nothing at all. This leads to consistent results (either "" or a valid URL), as people might write things like N/A, - , none etc.
(more)
about 2 months ago
Comment Post #281506 I think the issue is this one: https://github.com/codidact/qpixel/issues/268
(more)
about 2 months ago
Edit Post #281486 Post edited:
about 2 months ago
Comment Post #281491 We can [blame the cache](https://shouldiblamecaching.com/) for this issue. Entering edit mode for the questions indeed displays C++ tag in the list. Related: https://software.codidact.com/posts/278952
(more)
about 2 months ago
Comment Post #281486 @Istiak Code golf is about solving problems with the least amount of code (bytes). The software development community is (among others) about getting solutions to programming problems.
(more)
about 2 months ago
Comment Post #281484 I have edited the title because "really exists" is quite hard to answer objectively. A simple search indicates that they exist, but it is not very clear what they are. Also, it would be useful to indicate the source where you read about these languages.
(more)
about 2 months ago
Edit Post #281484 Post edited:
Made the title a little bit clear
about 2 months ago
Edit Post #281464 Post edited:
added relevant tag
about 2 months ago
Edit Post #281301 Nominated for promotion about 2 months ago
Edit Post #281341 Nominated for promotion about 2 months ago
Edit Post #281415 Nominated for promotion about 2 months ago
Comment Post #281448 @PeterTaylor - While I have experience writing stored procedures, I am also aware of [the many disadvantages](https://stackoverflow.com/a/9483781/2780791) that they might bring in the project. AFAIK, unless there is a really serious reason to incorporate business logic in a stored procedure (e.g. avo...
(more)
about 2 months ago
Edit Post #281448 Post undeleted about 2 months ago
Edit Post #281448 Post edited:
about 2 months ago
Edit Post #281448 Post edited:
about 2 months ago
Edit Post #281448 Post deleted about 2 months ago
Edit Post #281448 Post edited:
about 2 months ago
Edit Post #281448 Post edited:
about 2 months ago
Edit Post #281448 Initial revision about 2 months 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 2 months ago
Edit Post #281385 Post edited:
2 months ago
Comment Post #281385 Is "What elements should an authentication module include"? a suitable title (summary) for your post? I think the post's body suggestion such a summary (or similar).
(more)
2 months ago
Comment Post #281385 Possible interesting reading: https://cybersecurity.ieee.org/blog/2016/06/02/design-best-practices-for-an-authentication-system/
(more)
2 months ago
Edit Post #281381 Initial revision 2 months 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)
2 months ago
Edit Post #281365 Question closed 2 months ago
Comment Post #281365 Unfortunately, this question is offtopic here as well, since it is not related to software development. Please, read [this help page](https://software.codidact.com/help/on-topic) for more details about what is on-topic and offtopic in this community.
(more)
2 months ago
Edit Post #281341 Post edited:
added relevant tag
2 months ago
Comment Post #281315 Ideally, always knowing created by and created on behalf of might be useful, but the whole impersonation thing is kind of an edge case. It is a necessary evil to quicker reproduce issues coming from the users and very few are able to activate it. All other flows should be executed with impersonation ...
(more)
2 months ago
Comment Post #281308 As currently written, I also think this belongs more to meta than the main site. I will try to figure out a way to migrate it there and reopen it (have an issue with migration due to meta tags).
(more)
2 months ago
Comment Post #281304 "As we do it: with logging" - this indeed seems to be the best approach. Just had a conversation with my boss and confirmed that such a solution was used for an important product that was externally audited. The audit said it is fine to allow users to fully impersonate someone else as long everything...
(more)
2 months ago
Edit Post #281301 Initial revision 2 months 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)
2 months ago
Comment Post #281192 @DerekElkins Yes, this can also happen and a smoke is complementary to the deployment using migrations. Also, production has a health monitoring in place which also checks that SELECTs can be performed against the database.
(more)
3 months ago
Comment Post #281288 Besides the nice lexicographic order you get by default with YYYY-mm-dd, the timestamps are often extended with hour, minute, seconds, milliseconds. By starting with the year , adding them is done in a consistent way (see [this](https://www.w3.org/TR/NOTE-datetime)).
(more)
3 months ago
Comment Post #281253 That playground is awesome. Also, I think that grouping the affected controls in a FormGroup makes perfect sense. Thanks.
(more)
3 months ago
Comment Post #281200 Storing function names in string and dynamically invoking those functions is not actually a nice thing (the linter and the transpiler cannot check if these functions actually exist). That's why I am asking if by chance I have missed something and had to rely on such a solution.
(more)
3 months ago
Edit Post #281232 Initial revision 3 months 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)
3 months ago
Comment Post #281202 @JohnDoea The first example (using fetch API) should replace your code using xhr. The example hardcodes the method (POST), but you can replace it if your own.
(more)
3 months ago
Edit Post #281202 Post edited:
added the jQuery way
3 months ago
Edit Post #281202 Initial revision 3 months 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)
3 months ago
Comment Post #281199 What is contactForm.method containing? If it is 'POST', I do not see the request body to be sent to the server: https://developer.mozilla.org/en-US/docs/Web/API/XMLHttpRequest/send
(more)
3 months ago
Edit Post #281200 Initial revision 3 months 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)
3 months ago
Comment Post #281193 Have you tried using a heredoc string? https://stackoverflow.com/a/1848974
(more)
3 months ago
Edit Post #281192 Post edited:
fixed migrations table name
3 months ago
Edit Post #281192 Initial revision 3 months 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)
3 months ago
Edit Post #281188 Initial revision 3 months 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)
3 months ago
Comment Post #281180 @JohnDoea Yes, I think that is the way to define the message content type.
(more)
3 months ago
Edit Post #281180 Initial revision 3 months 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)
3 months ago
Edit Post #281171 Post edited:
removed rude acronym
3 months ago
Comment Post #281168 A quick "frame challenge": Why not always insert a [UTC timestamp in the table](https://stackoverflow.com/questions/16609724/using-current-time-in-utc-as-default-value-in-postgresql) and [display the local time](https://stackoverflow.com/questions/36341060/convert-a-utc-timezone-in-postgresql-to-est-...
(more)
3 months ago
Comment Post #281158 I am a fan of keeping things simple. If there is no strong reason to rely on something else, why not have everything provided by the same provider: the client accesses the form hosted on example.com (your provider), fills the form and your script running on example.com sends an e-mail to your contact...
(more)
3 months ago
Comment Post #281158 I would go with "buying an email box from my domain registrar" because it seems to be the easiest + safest solution. As long as the contact form is not abused, I do not think you will ever run into trouble with the spam filters. You did not mention, but is the destination an e-mail address on your do...
(more)
3 months ago
Comment Post #281159 It is not clear what the exact problem is here. [This](https://logging.apache.org/log4net/release/manual/configuration.html) shows that it is possible to read the configuration from a file. Indeed this is a structured file (XML), not an "arbitrary data structure". Do you mean something like an YAML c...
(more)
3 months ago
Edit Post #281148 Post edited:
added relevant tag
3 months ago
Comment Post #281058 Do you receive a response from the server? Typically servers provide a response, except for the case when the connection cannot be made (timeout, explicit connection reset from the server). I think there is no exception, but an HTTP code that should be available if you read the response from the line...
(more)
3 months ago
Edit Post #281058 Post edited:
added relevant tags
3 months ago
Comment Post #281049 I think "traditional" is more appropriate than "standard" (see [International email](https://en.wikipedia.org/wiki/International_email) ).
(more)
3 months ago
Comment Post #281043 @JohnDoea‭ Ok, so they are handling authentication behind the scene. `mail` seems to return only true or false (success), so I think the only option is to check (or ask your provider to) the e-mail logs which should contain the cause of the error.
(more)
3 months ago
Comment Post #281043 [This] might (https://stackoverflow.com/a/32413860/2780791) be relevant if my guess is right.
(more)
3 months ago
Comment Post #281043 There are many years since I have sent an e-mail using PHP, but I remember that e-mails required some kind of authentication to be treated correctly by the e-mail providers (they need to be sure that they come from the domain they seem to use). Failing to provide this, most of them reached the Spam ...
(more)
3 months ago
Comment Post #281025 I think you will get better search results using "contact form service" instead. Results indicate headlines like "custom forms with no server code", "simple contact form service" and others. All the solutions seem to allow the client to construct the form and use it as a third-party service.
(more)
3 months ago
Comment Post #281001 Indeed my post lacked important information about the usage. I edited the post, but your answer is very useful anyway. Thanks.
(more)
3 months ago
Edit Post #280998 Post edited:
added further details for the question
3 months ago
Edit Post #280998 Initial revision 3 months 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)
3 months ago
Edit Post #280985 Initial revision 3 months 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)
3 months ago
Comment Post #280970 @meriton Yes, it does not seem to cover your case. Since we can safely assume that the time between the order SELECT and shipment INSERT is very short, is it acceptable to fix such issues (which will be very rare) using an async job or similar?
(more)
3 months ago
Edit Post #280977 Question closed 4 months ago
Edit Post #280975 Question closed 4 months ago
Comment Post #280975 Relevant Q&A to provide some insight about how hashes are used in picture comparison: https://stackoverflow.com/questions/4853185/how-does-comparing-images-through-md5-work
(more)
4 months ago
Comment Post #280974 Currently, the question lacks quite a deal of information to be able to help you. What programming language/framework are you using? Should this be done programmatically or you only need a piece of software to do this?
(more)
4 months ago
Edit Post #280974 Question closed 4 months ago
Comment Post #280965 I was the one that missed including this point in the on-topic section. Sorry about that. I have updated the section and provided an answer with more details.
(more)
4 months ago
Edit Post #280978 Initial revision 4 months 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)
4 months ago
Edit Post #278625 Post edited:
added missing on-topic type about troubleshooting
4 months ago
Comment Post #280970 What you are describing seems to be a concurrency management control issue. I am not sure what ORM you are using, but it might have support for concurrency. I have experience mainly with EF which can take care of these cases through [concurrency checks](https://www.learnentityframeworkcore5.com/handl...
(more)
4 months ago
Comment Post #280933 I have closed this question because the issue is a simple typographical error (format is an argument for the print, not a function to be applied to the print result). Also, check [this help page](https://software.codidact.com/help/on-topic).
(more)
4 months ago
Edit Post #280933 Question closed 4 months ago
Edit Post #280852 Post edited:
4 months ago
Edit Post #280852 Initial revision 4 months 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)
4 months ago
Comment Post #280795 I also think this question is too general as it is right now and I agree with the reasons stated in the other comments.
(more)
4 months ago
Edit Post #280795 Question closed 4 months ago
Comment Post #280778 @FractionalRadix I agree to keep this type of question at the current stage. However, one non-technical reason (e.g. too broad) IMO is that for a developer it is far more useful to try and error and ask focused questions than having a general question with some answer(s). It involves much more effort...
(more)
4 months ago
Comment Post #280778 This is an interesting question, but it is quite broad. We encourage people to search a bit for possible solutions and ask more specific questions in our community. Please take a look at [How to ask a great question](https://software.codidact.com/help/how-to-ask).
(more)
4 months ago
Comment Post #280662 Your question from Software Engineering SE is no longer available (I guess it was removed in the meantime).
(more)
4 months ago
Comment Post #280666 For non-relational databases (I have little experience with them) I would use a repository for each of them. Never used a TransactionScope like this, but I guess I would have the transaction outside of the Application (in some repository or service). Is it recommended to work like this? I thought tha...
(more)
4 months ago
Edit Post #280666 Initial revision 4 months 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)
4 months ago
Comment Post #280662 Check [this article](https://www.thereformedprogrammer.net/is-the-repository-pattern-useful-with-entity-framework-core/) for a good insight about your issue.
(more)
4 months ago
Comment Post #280223 @TechnologicallyIlliterate‭ No, it does not confirm. By "cloud technologies" we mean the part that is related to software development. E.g. how to configure some authentication service, user and access rights or a load balancer when using a cloud provider. As written, your question is more related to...
(more)
5 months ago
Edit Post #280624 Initial revision 5 months 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)
5 months ago
Comment Post #280607 @Moshi It is the case, but I noticed this only after luap42 asked me to provide the URL. However, the closing as the duplicate process is a little bit confusing since it does not mention that the URL should be from the same community (or even better validate it on client side).
(more)
5 months ago
Comment Post #280607 Just noticed that I have entered the URL (https://meta.codidact.com/posts/277177), but the placeholder says that it also accepts the ID. I think the issue is that I pointing to a duplicate from another site (community).
(more)
5 months ago
Edit Post #280607 Initial revision 5 months 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)
5 months ago
Edit Post #279712 Post edited:
removed irrelevant tag
5 months ago
Edit Post #279676 Post edited:
removed irrelevant tag
5 months ago
Edit Post #280380 Post edited:
5 months ago
Edit Post #280222 Post edited:
added relevant tag
5 months ago
Edit Post #280528 Post edited:
added relevant tags
5 months ago
Edit Post #280523 Initial revision 5 months 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)
5 months ago
Comment Post #280512 Ref. to "PHP 7 PHP object is faster and lighter than array", can you please provide a reference to at least one benchmark? It is nice to provide references, so that future readers are able to find more.
(more)
5 months ago
Edit Post #280490 Post edited:
5 months ago
Edit Post #280490 Post edited:
5 months ago
Edit Post #280380 Post edited:
5 months ago
Comment Post #280397 I added "Do not use" because currently there is no option to remove the tag. I could use a tag merge to get rid of it though.
(more)
5 months ago
Edit Post #280380 Initial revision 5 months 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)
5 months ago
Comment Post #280223 Unfortunately, this question is not [about Software Development](https://software.codidact.com/help/on-topic).
(more)
6 months ago
Edit Post #280223 Question closed 6 months ago
Edit Post #280201 Post edited:
added relevant tag
6 months ago
Comment Post #280169 In most cases, the canonical way to fetch data from an external application is though its API. Reddit seems [to expose one](https://www.reddit.com/wiki/api).
(more)
6 months ago
Edit Post #280142 Initial revision 6 months 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)
6 months ago
Comment Post #280112 I also suspect this reason. Unfortunately, where I work it sometimes happens that folks to just copy-paste old projects configuration (in this case Jenkins job configuration) without wondering why a step is there. Thanks.
(more)
6 months ago
Edit Post #280097 Initial revision 6 months ago
Question Is it necessary for a build server to remove node_modules before an AOT build?
I am currently dealing with an Angular application that is being deployed using an CI orchestrator and Jenkins. Jenkins job is configured to do the following (relevant steps only): - fetch sources from Git - remove nodemodules - `npm install` - perform AOT build (`--prod` + other optimizati...
(more)
6 months ago
Edit Post #280089 Question closed 6 months ago
Comment Post #280089 Questions about programming resources are currently off-topic, as indicated [here](https://software.codidact.com/help/on-topic). However, asking questions about specific programming issues when working in Julia is on-topic.
(more)
6 months ago
Edit Post #278920 Post edited:
added relevant tag
6 months ago
Edit Post #277455 Post edited:
added relevant tags
6 months ago
Comment Post #279853 Not sure if this was mentioned, but we can have a "sandbox" or similar category just like they have on World Building SE: https://worldbuilding.meta.stackexchange.com/questions/639/how-does-the-sandbox-work-how-do-i-use-it . However, the flow is quite tedious (ask in the Sandbox, get feedback. post o...
(more)
6 months ago
Comment Post #279853 This is an interesting idea, but there are some drawbacks as shown on SO: https://meta.stackoverflow.com/questions/252781/would-it-be-a-terrible-idea-to-split-so-up-into-a-tiered-platform .
(more)
6 months ago
Comment Post #279744 Also, it is not clear why I need more classes. Indeed I might need more code in the tests since each test class defines its own mocks as opposed to the in-memory provider which might have a single place to define all mock data. The setup is actually simpler because it consists of defining mocks for D...
(more)
6 months ago
Comment Post #279744 That's an interesting perspective as I failed to realize that indeed the tests have to know something about the infrastructure (the DbSets actually). However, some aspects of your answer are not clear. In my case unit tests require the class to be tested + mocking. The alternative requires the class ...
(more)
6 months ago
Comment Post #279712 To be more precise, it is not saying that the questions are posted by luap42, but that the last change was made by luap42. In fact, this is true, but the issue is that that change is invisible for regular users (e.g. who cannot remove answers).
(more)
6 months ago
Edit Post #279671 Post edited:
added relevant tag
7 months ago
Edit Post #279649 Post edited:
added relevant tag
7 months ago
Edit Post #279555 Initial revision 7 months ago
Question What are the cons of directly mocking Entity Framework DbSets instead of working with an in-memory database when unit testing the application?
I have recently contributed to a Clean Code project and had a discussion about how to implement unit tests. The project author argues for using an in-memory database (which easily replaces the real one) instead of mocking the DbSets and now I am doubting my own approach. The in-memory database...
(more)
7 months ago
Comment Post #279449 I think in order to fully understand you should provide more details. Is this task a custom task? (e.g. removes an existing file and downloads a newer version). The error might also appear when the file to delete is not found. Since this is not always happening, I suspect it is not related to Jenkins...
(more)
7 months ago
Edit Post #279436 Initial revision 7 months ago
Answer A: How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?
This answers your questions, not what I suspect to be real issue. According to the specifications a VARCHAR(100) will need actual data stored length + 1. So, the actual size would have mattered if you have used CHAR(100) instead: > The compact family of InnoDB row formats optimize storage fo...
(more)
7 months ago
Comment Post #278978 Also, can you provide more information about "run out of memory"? Is it the stack (too much recursion?) or another type of memory?
(more)
7 months ago
Comment Post #278978 Can you please post the relevant parts of your procedure? As written, this looks like an XY problem (i.e. the issue seems to be in the way the procedure is written not the VARCHAR length).
(more)
7 months ago
Edit Post #279424 Initial revision 7 months ago
Question Are any downsides of hiding the actual Entity Framework Core DbSets and exposing only some generic methods?
I have recently started a project based on the clean architecture principle and noticed that it did not rely on generic repositories since Entity Framework's DbSets are doing the job just fine. In the referenced project the database context class implements an interface that exposes all the DbSets, b...
(more)
7 months ago
Edit Post #279277 Post edited:
added relevant tags
7 months ago
Edit Post #279317 Initial revision 7 months ago
Answer A: How to automatically run Entity Framework Core migrations for an application which uses a user with read/write rights on certain tables?
Migrations are applied during the application startup (initialization) only when the application is not accessible yet. One way to go is to leave the existing user as it is and define a designated one for the migrations. Applying the migrations requires powerful roles (create or drop table): - ...
(more)
7 months ago
Edit Post #279316 Initial revision 7 months ago
Question How to automatically run Entity Framework Core migrations for an application which uses a user with read/write rights on certain tables?
I have decided to convert a legacy database-first ASP.NET Core project to code-first. However, I have noticed that the project used the same database as another bigger project and the Entity Framework user had the minimal rights (read and write on some tables). Clearly, this does not allow the app...
(more)
7 months ago
Edit Post #279187 Post edited:
fixed a typo
7 months ago
Edit Post #279187 Post edited:
fixed variable name
7 months ago
Edit Post #279187 Post edited:
fixed the link
7 months ago
Edit Post #279187 Initial revision 7 months ago
Answer A: Is there a way to automatically fix MySQL tables where the auto_increment has fallen behind the correct value?
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` AUTOINCREMENT = ', @nextId[]()); PREPARE st FROM @sql; EXECUTE st; However, if the values fall frequently you should try ...
(more)
7 months ago
Edit Post #279144 Post edited:
added relevant tag
7 months ago
Edit Post #279097 Post edited:
added tag
7 months ago
Edit Post #279146 Initial revision 7 months ago
Answer A: In MySQL is there a limit to the number of keys in a IN() clause?
According to the documentation for the MySQL IN function: > The number of values in the IN() list is only limited by the maxallowedpacket value. The default value for it is 67108864. So, you should be able to squeeze quite a big number of identifiers, but you should definitely try it out to...
(more)
7 months ago
Edit Post #279059 Post edited:
added MoreLINQ reference
7 months ago
Comment Post #278952 I have reported the issue on GitHub (thanks Monica for moving it to the right place, now I know that qpixel is the actual project :) ): https://github.com/codidact/qpixel/issues/268
(more)
7 months ago
Edit Post #279059 Initial revision 7 months ago
Answer A: How to perform LEFT JOIN using LINQ method call notation?
Note: this was tested in a .NET Framework 4.6.2 project. This answer provides an extension method that greatly simplifies (and makes it more intuitive) the written code: public static IQueryable LeftJoin( this IQueryable outer, IQueryable inner, Expression> outerK...
(more)
7 months ago
Edit Post #279058 Post edited:
simplified the query
7 months ago
Edit Post #279058 Initial revision 7 months ago
Question How to perform LEFT JOIN using LINQ method call notation?
I am interested in performing a LEFT JOIN using LINQ-2-SQL when working with method call notation. This answer suggests a way that relies on GroupJoin but it is more verbose than expected: var leftJoin = p.Person .GroupJoin(p.PersonInfo, n => n.PersonId, m => m.PersonId, ...
(more)
7 months ago
Edit Post #279034 Post edited:
added relevant tag
7 months ago
Edit Post #279051 Initial revision 7 months ago
Answer A: Is it possible in MySQL to require each row in a table have at least one foreign key record in a join table?
`ghost-in-the-zsh`‭ provided a direct answer and I will try to offer a more general complementary one. One possible thing to try is a trigger that checks the integrity, but it cannot work for inserts because the order must be something along the lines: START TRANSACTION INSERT INTO B ...
(more)
7 months ago
Edit Post #278992 Post edited:
added relevant tag
7 months ago
Edit Post #279035 Post edited:
Removed irrelevant information
7 months ago
Comment Post #279035 @Charlie Brumbaugh‭ Yes, that means that the index contains that column + columns in the PK. That would explain the second point which actually seems to be the only point: all indexes will only cover the column in the PK.
(more)
7 months ago
Edit Post #279035 Initial revision 7 months ago
Answer A: Why would an unique index get moved to the primary key after the underlying column is dropped?
I can't say that I fully understood what you did, but I think I got the explanation: - removed 1+ columns that were part of the index. The index will be updated to not include that column. > If columns are dropped from a table, the columns are also removed from any index of which they are apar...
(more)
7 months ago
Comment Post #279002 @FractionalRadix Yes, [binding] is very general, but it is what I heard being used for frameworks such a Windows Forms. WPF, Angular and Xamarin. Maybe something like [android-viewbinding] is more appropriate, but I am not sure if this is what you are using (never programmed directly with Java in And...
(more)
7 months ago
Comment Post #279002 I have also added [binding] tag as the concept seems to be used (bind view to viewmodel). Very good question btw.
(more)
7 months ago
Edit Post #279002 Post edited:
added relevant tag
7 months ago
Edit Post #278695 Post edited:
removed useless tag
7 months ago
Edit Post #279014 Initial revision 7 months ago
Question Do we really need the [tools] tag?
During my review of the posts and tags, I have seen the tools tags. It is very generic and I am sure if it is helpful. What do you think?
(more)
7 months ago
Edit Post #279008 Initial revision 7 months ago
Answer A: How can I add "withCredentials:true" for HTTP requests generated by Swagger UI?
One way to solve this without customizing the Swagger UI is to deal with it on the server side. The following assumes that the swagger docs is served at `/swagger` relative path. Middleware /// /// Middleware to protect API Swagger docs /// public class SwaggerAuthorization...
(more)
7 months ago
Edit Post #279007 Initial revision 7 months ago
Question How can I add "withCredentials:true" for HTTP requests generated by Swagger UI?
I have added Swagger UI for an ASP.NET Core 3.1 application and I have realized that all endpoints requiring Windows Authentication fail. This issue is created by the fact that generated HTTP requests do not include withCredentials (what I used in the Angular client consuming the same API). This S...
(more)
7 months ago
Edit Post #279006 Initial revision 7 months ago
Answer A: Is omitting braces for single statements bad practice?
Already good answers, but I can provide a slightly different perspective here: always use braces if there is a risk of getting into a pitfall. Examples (from C#, but the language is less relevant). - omit if the inner instruction fits on a single line and an extra blank line is inserted after:...
(more)
7 months ago
Edit Post #278771 Post edited:
added relevant tags
7 months ago
Edit Post #278547 Post edited:
added relevant tag
7 months ago
Comment Post #278988 @Moshi That would be great and intuitive for anyone using such a feature.
(more)
7 months ago
Edit Post #278988 Initial revision 7 months ago
Answer A: What is the point of tagging a question with both a parent and a child tag?
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 in their feed. While I could find this feature on Codidact, it makes sense to implement it in the futu...
(more)
7 months ago
Comment Post #278982 Not sure, but shrink gets the database to 4GB and reindexing gets it to about ~5GB.
(more)
7 months ago
Edit Post #278983 Post edited:
removed meta related tags
7 months ago
Edit Post #278982 Initial revision 8 months ago
Answer A: How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped?
One way to solve this is to shrink the database and reindex all tables to fix the indexes fragmentation: DBCC SHRINKDATABASE (TheDatabase); GO -- reindexing all tables to optimize performance after the DB shrink declare @TableSchema varchar(255) DECLARE @TableName varchar(255)   D...
(more)
8 months ago
Edit Post #278981 Post edited:
added the question
8 months ago
Edit Post #278981 Initial revision 8 months ago
Question How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped?
My project has the following set up for the production and preproduction ("clone") environment. - Production is not accessible at all for the development team, only the preproduction database. - Preproduction database is restored each day, but a post-restore script is run to strip away sensitive ...
(more)
8 months ago
Comment Post #278952 @Moshi That's a good idea. I will raise an issue @ GitHub repo. Thanks.
(more)
8 months ago
Edit Post #278959 Post edited:
fixed code alignment
8 months ago
Edit Post #278959 Initial revision 8 months ago
Answer A: How to create a delayed loading indicator when working with ngrx/store?
This heavily relies on this question which deals with another matter. In order to delay the loader, there must be a clear difference between the start of loaded from the caller's perspective and when the loader is actually displayed (i.e. `isLoading = true`). The following code does the trick: ...
(more)
8 months ago
Edit Post #278958 Post edited:
added missing code
8 months ago
Edit Post #278958 Initial revision 8 months ago
Question How to create a delayed loading indicator when working with ngrx/store?
I am working on an Angular application using ngrx and I have a loader state + reducer that is used to display a loader. However, very short AJAX calls cause a flicker and I need to delay showing the loaded to avoid being shown for very fast responses (e.g. < 300ms). My state is very simple: ...
(more)
8 months ago
Comment Post #278952 @Lundin Automatic removal would be really nice, but current caching makes things really confusing as shown in my example.
(more)
8 months ago
Edit Post #278952 Initial revision 8 months ago
Question Is there a way to add expiration for questions tags?
Comments from this question reveal that there is some aggressive caching related to question tags (what tags are used for a question). Unfortunately, after changing tags for several questions I have realized that glitches are quite often. Example for [formula] tag: - search indicates 6 usages ...
(more)
8 months ago
Comment Post #278785 On-topic now includes a quick introduction for those in a hurry (thanks to [this suggestion](https://software.codidact.com/questions/278648#answer-278666)). Having "a separate Meta post for every rule, and link to these canonical posts from the FAQ" is indeed possible, but leads to even more stuff to...
(more)
8 months ago
Comment Post #278788 I understand what "questions asked not to learn, but to off-load work", but it might sound too vague for newbies. From my experience with SO, I know there is a large number of posts that show no effort or do not include any attempts. It is such a serious issue that I favor explicitly mentioning our e...
(more)
8 months ago
Comment Post #278789 I have fixed it. Thanks.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278650 This suggestion has been included. Thanks.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278653 I have also updated the help to include a code review guideline and a designated item in the on-topic section pointing to it.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278667 I have applied this suggestion, but also added an example to off-topic item "questions about computers or software that are not connected to software development/engineering" (asking for recommendations). Thanks.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278666 Nice suggestion. I have added it as an introduction paragraph in the On-topic section as it kind of summarizes all the other points. Thanks.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278651 I have applied your suggestion (in a simplified form, as "database design" is repeated). Thanks.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278787 I have rephrased that item from the help section to correspond to your suggestion. Thanks.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278786 I have updated the section to reflect your suggestion ("keep it simple"). Thanks.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Edit Post #278922 Initial revision 8 months ago
Answer A: What is our policy on tags?
Thanks for raising this question. My answers to your questions: What type of tags will we allow? (Should specific tags like [UrlRewrite] be allowed?) I am not sure what is the best way to deal with this and I am waiting for community feedback. How many tags will we allow? (Should we delete a...
(more)
8 months ago
Comment Post #278817 I agree with these points and I have used Stack Overflow as a model because they have the advantage of time and size. They have millions of questions asked over years and by now tags must be in a stable state.
(more)
8 months ago
Edit Post #278324 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #277932 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #278322 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #278360 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #278366 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #278523 Post edited:
8 months ago
Edit Post #278525 Post edited:
8 months ago
Edit Post #278531 Post edited:
8 months ago
Edit Post #278567 Post edited:
8 months ago
Edit Post #278569 Post edited:
added relevant tag
8 months ago
Edit Post #278571 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #278565 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #278584 Post edited:
replaced tags with more meaningful ones
8 months ago
Edit Post #278527 Post edited:
added relevant tag
8 months ago
Edit Post #278324 Post edited:
added relevant tag
8 months ago
Comment Post #278899 The debate related to this question made me go further with [Super User site proposal](https://meta.codidact.com/questions/278833#answer-278908). Once we start it, we will migrate this question there.
(more)
8 months ago
Comment Post #278899 I have reopened it since we do not have the Power User community yet. I still think it might fit better in such a community, but since it is still not yet live, I guess we can have it here.
(more)
8 months ago
Edit Post #278899 Question reopened 8 months ago
Comment Post #278899 @‭Charlie Brumbaugh Yes, I think the context is important. I have little experience with working in Linux, but I assume the context used to issue the command (some tokens might not interpreted in the same way as when run from bash or similar). The context is also helpful to propose alternatives to ...
(more)
8 months ago
Edit Post #278899 Question closed 8 months ago
Comment Post #278899 @Matthias Braun Welcome to Software Codidact. Unfortunately, your question does not seem related to software development. I have already proposed a community [for this type of questions](https://meta.codidact.com/questions/278833), but we are not ready yet.
(more)
8 months ago
Edit Post #278335 Post edited:
8 months ago
Edit Post #278335 Post edited:
8 months ago
Comment Post #278322 @pnuts Is it OK to rename [tickboxes] to [checkboxes]? It has the advantage that it makes sense also for many other application types.
(more)
8 months ago
Edit Post #278892 Initial revision 8 months ago
Question Phantom answer in my notification list
My notification list includes the following entry: New answer to your question 'How many votes are required for special actions...' However, there is no answer for that question. I imagine that the author posted an answer and remove it, but as far as I know I am able to see delete posts.
(more)
8 months ago
Edit Post #278292 Post edited:
added tag
8 months ago
Edit Post #278208 Post edited:
replaced with more specific tag
8 months ago
Edit Post #278832 Initial revision 8 months ago
Question Should we get rid of [formula] tag and use more meaningful tags like [excel-formula] or [google-sheets-formula]?
We currently have quite a few questions tagged with formula. However, [formula] seems so general that I am inclined to replace it to a more specific formula based on the context. Examples: - [excel-formula] - [google-sheets-formula] - [lotus-formula] Is it OK to perform this tag split?
(more)
8 months ago
Edit Post #278831 Initial revision 8 months ago
Answer A: Which abstraction should I choose for background services and why?
I will provide an answer from a pragmatic perspective, rather than a direct answer to your question. This is particularly important when working on a real project (as opposed to homework). Short answer Try to use a third-party library instead of reinventing the wheel. Defining and managing back...
(more)
8 months ago
Comment Post #278780 @Lundin After reading the post, I did not see anything directly related to RAM memory (not sure, but memory management at application level normally deals with the virtual memory not with RAM directly). Indeed the answer argues about the RAM, but tagging applies to the question, not the answers. Feel...
(more)
8 months ago
Edit Post #277962 Post undeleted 8 months ago
Edit Post #277962 Post deleted 8 months ago
Edit Post #277860 Post edited:
removed the inappropriate picture
8 months ago
Comment Post #278782 Thanks for the comments, they provide great insight. Ref. to usage of ngrx/store: clearly overkill for this code alone, but this code is part of a much larger application where I have used this pattern.
(more)
8 months ago
Comment Post #277536 @jrh I have removed our last comments because they provide no value for the question.
(more)
8 months ago
Edit Post #277856 Post edited:
added tag
8 months ago
Comment Post #278780 @ArtOfCode I have made the edit 6h ago and I thought the same thing and waited and rechecked. So less likely to [blame the cache](https://shouldiblamecaching.com/).
(more)
8 months ago
Edit Post #278780 Initial revision 8 months ago
Question Schrödinger's tag - appears in view mode, but not in edit
After removing two tags and adding another one for this question I have noticed that the tag list is not the same between view mode and edit: - View mode: stack-memory + heap-memory + ram + memory-management - Edit mode: stack + heap + memory-management Before editing the question, I have rena...
(more)
8 months ago
Edit Post #277536 Post edited:
removed irrelevant tags + added one
8 months ago
Edit Post #277474 Post edited:
added tag
8 months ago
Comment Post #278727 @Moshi [iis-urlrewrite] can be defined, but I would try to keep tags count as low as possible. By using [iis] and [url-rewritting], we have only two tags that are quite reusable.
(more)
8 months ago
Edit Post #277441 Post edited:
added tag
8 months ago
Comment Post #277422 What does SDL stand for? Is it https://www.libsdl.org/ or something else?
(more)
8 months ago
Edit Post #278755 Initial revision 8 months ago
Answer A: How to use LazyCache library with Unity Container?
For LazyCache version 2.1.2 (maybe even earlier) UnityContainer must be instructed to call the default LazyCache constructor which probably relies on MemoryCache (default). container.RegisterType(new InjectionConstructor()); This worked with .NET Framework 4.6.1, Unity Abstractions 3.1.0.
(more)
8 months ago
Edit Post #278754 Initial revision 8 months ago
Question How to use LazyCache library with Unity Container?
I want to use LazyCache and UnityContainer together in an ASP.NET classic application (.NET framework 4.6.1+). Namely, to be able to inject IAppCache in various services. For ASP.NET Core and its default DI container it is as easy as: services.AddLazyCache(); How can this be done with Un...
(more)
8 months ago
Comment Post #278727 @Monica Cellio - yes, you are right: there are two aspects. I would use url-rewritting + iis.
(more)
8 months ago
Edit Post #278668 Post edited:
fixed the max width for UTF-8
8 months ago
Comment Post #278648 I will keep "What type of questions can I ask here?" section unchanged for a few more days and integrate the changes based on the support for each idea.
(more)
8 months ago
Edit Post #278728 Initial revision 8 months ago
Question Renaming sheets to the more specific google-sheets?
sheets tag sounds a little bit too generic and I feel that it should be replaced with the more specific [google-sheets]. I know that we should avoid using company names as much as possible, but in this case, I think it will prevent confusion for anyone not familiar with the Google sheets (e.g. we ...
(more)
8 months ago
Edit Post #278727 Initial revision 8 months ago
Question Should we rename urlrewrite tag to url-rewriting?
How do I get IIS UrlRewrite to handle CSS-delivered woff files appropriately? is the only question currently using urlrewrite tag. However, for future questions I would like to have a more general tag related to URL rewriting rather than the specific case of IIS URL rewriting. Is it OK to rena...
(more)
8 months ago
Edit Post #277375 Post edited:
added tags
8 months ago
Edit Post #277259 Post edited:
added tag + using lower case tag names only
8 months ago
Edit Post #278695 Initial revision 8 months ago
Question Setting the authentication token in an Angular application for generated API clients
This is a post of mine from Code Review Stack Exchange which did not get an answer yet. I am developing an Angular application that consumes an external REST API. I am using OpenAPI generator (TypeScript template) to generate the API clients. The happy flow is the following: - call a method ...
(more)
8 months ago
Edit Post #278694 Initial revision 8 months ago
Question Cache data using Redis Cache in an ASP.NET Core 3.1 project
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 (several times a day) but often read ( 10 K / day). For me, it is a good opportunity to toy with Redi...
(more)
8 months ago
Edit Post #278693 Initial revision 8 months ago
Question Measure ASP.NET Core 3.1 Web API action execution times
This is basically an unanswered code review request of mine from CodeReview Stack Exchange. I want to be able to log as accurately as possible, the time spent by a certain Web API action in an ASP.NET Core 3.1 Web API. I found out this very old question dealing with a similar issue in ASP.NET. ...
(more)
8 months ago
Edit Post #277415 Post edited:
added relevant tags
8 months ago
Comment Post #277373 Initially, I thought this was not an interesting question, but after digging a little I realized how hard it seems to be answerable for MySQL.
(more)
8 months ago
Edit Post #278668 Initial revision 8 months ago
Answer A: How to calculate how much data is stored in a MySQL column?
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 values may require more than 255 bytes However, I think this is true only for non-Unicode characters...
(more)
8 months ago
Comment Post #277303 Anti-pattern for alias names: a, b, c, d ... I have seen this being used in a project and I find it mind-blowing since I try to connect the alias to the table based on its starting char.
(more)
8 months ago
Edit Post #277303 Post edited:
8 months ago
Edit Post #277310 Post edited:
8 months ago
Edit Post #277310 Post edited:
added tag
8 months ago
Edit Post #277485 Post edited:
added explicit SO reference name
8 months ago
Comment Post #278628 @r~~ Based on feedback provided by you and Lundin I have already refined the scope, so this issue is pretty covered. Not having such a policy makes it almost impossible to provide a reference to anyone asking about why a question is considered offtopic. Not having a policy is like a very small scale ...
(more)
8 months ago
Comment Post #278628 @Lundin I agree and I have changed the scope page to include this topic with some restrictions (small enough and attempt to understand it). Despite a similar policy on SO, this type of questions are actually allowed ([example](https://stackoverflow.com/questions/18984775/what-does-this-code-do) ).
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Edit Post #278625 Post edited 8 months ago
Comment Post #278628 @r~~ I understand your concern, but having a "not yet done" policy is better than having none at all. This is not set in stone and can evolve along with the community. I think this is an important part of the community because any new member has no easy way to understand what they are allowed to ask ...
(more)
8 months ago
Comment Post #278527 I have edited this post and a few others to better emphasize the references to the SE sites (Stack Overflow or Power User). Please try to use similar references (the source name and the author are the most important elements) for future posts. Thanks for your contributions.
(more)
8 months ago
Edit Post #277930 Post edited:
made the reference more clear
8 months ago
Edit Post #278324 Post edited:
made the reference more clear
8 months ago
Edit Post #278527 Post edited:
made the reference more clear
8 months ago
Comment Post #277235 @Lundin Indeed it took quite much to have an official on-topic (and off-topic) section. Based on your input, now we have it [here](https://software.codidact.com/help/on-topic).
(more)
8 months ago
Comment Post #278624 @r~~ I think "Recommendation questions about which tools, libraries or technologies to use or where to find them." refers more to questions like "what tool to edit some video?" rather than questions about tools directly involved in software development (documenting the DDL changes belongs to software...
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Edit Post #278628 Initial revision 8 months ago
Answer A: Site scope - draft proposal
Based on this proposal, I have created a designated section within the Help section: What type of questions can I ask here? This can evolve over time based on feedback provided by the community.
(more)
8 months ago
Edit Post #278625 Post edited 8 months ago
Edit Post #278625 Post edited 8 months ago
Edit Post #278625 Post edited 8 months ago
Edit Post #277148 Post edited:
added relevant tags
8 months ago
Edit Post #277131 Post edited 8 months ago
Edit Post #277131 Post edited 8 months ago
Edit Post #277131 Post edited 8 months ago
Edit Post #278591 Initial revision 8 months ago
Answer A: How will you balance demanding high quality questions with maximising the number of users?
One aspect that helps with having a good balance is to have an enough number of users that help newbies ask good (or at least decent) questions. This is something reachable within rather small communities. I have seen this being put in practice by Politics.SE where there is a more effort put into ...
(more)
8 months ago
Edit Post #277216 Post edited:
8 months ago
Comment Post #278470 @Lundin While I cannot find right now a clear scope for Software Developement, your suggestion from here (https://meta.codidact.com/questions/74893#answer-276171) is a very good start.
(more)
8 months ago
Comment Post #278559 While I a am little bit familiar with Stack Overflow moderation (I have seen their queues and explanations provided by moderators), it would be very useful if you could provide a some references related to what moderation actually means, some guidelines to help the newbies to moderation. Thanks.
(more)
8 months ago
Comment Post #278559 Yes, I have seen this post, but I was not sure what to do. Indeed I would like to see this community grow, so I will take the bait :)
(more)
8 months ago
Edit Post #278549 Initial revision 8 months ago
Answer A: What is the rationale of having Cascade as a DeleteAction in EntityFramework.Core?
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 not actually trivial (clearing the navigation properties collections first leads to a save error, rem...
(more)
8 months ago
Edit Post #278474 Initial revision 8 months ago
Question What is the rationale of having Cascade as a DeleteAction in EntityFramework.Core?
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, if a parent record is removed, all descendants are removed. I remember that back in the days, whe...
(more)
8 months ago
Comment Post #278473 "Now of course this will directly work only within my network." - this is not clear. Why exactly? I expect the text file to be hosted on a server rather than on the client. You should start by making a little drawing containing the components of your applications, write what they are doing and how th...
(more)
8 months ago
Edit Post #278473 Post edited:
Removed irrelevant information + clarified the title
8 months ago
Edit Post #278468 Initial revision 8 months ago
Answer A: Should we have a Code Review Section / category?
I would definitely allow code review questions (requests) as they are an important part of any professional software developer. A special category might make sense, although a designated special tag (code-review) might be enough if it also results in a special highlight for at least for the tag.
(more)
8 months ago
Edit Post #278467 Initial revision 8 months ago
Question Implementing impersonation in an ASP.NET Core Web application
I am working at a proof-of-concept for porting an ASP.NET MVC application to an ASP.NET Core API + Angular SPA. One of the features of the existing application is the ability of an admin (typically tech support) to impersonate any other user. This is done through ASP.NET impersonation, but one sid...
(more)
8 months ago
Comment Post #278292 @Charlie Brumbaugh‭ Yes, the underlying technical issue is indeed having inserts and selects in the same time. That is why reporting typically has its own database where some aggregates can be recalculated and one almost never gets into trouble like this.
(more)
9 months ago
Comment Post #278278 Oh, it is way uglier than in T-SQL which allows to simply RETURN (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/return-transact-sql?view=sql-server-ver15)
(more)
9 months ago
Comment Post #278292 Ref. "we have a CRUD plus reporting application that talks to one MySQL database" - is there any way to use a separate database for the reporting application? Another way is to prevent the reports selects from locking the operational tables by using a "no-lock" option (SET SESSION TRANSACTION ISOLATI...
(more)
9 months ago
Edit Post #278285 Initial revision 9 months ago
Question Are questions about web browsers on topic on Software Applications?
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 Console: GRPR / GTM flag.
(more)
9 months ago
Edit Post #278208 Post edited:
9 months ago
Edit Post #278208 Post edited:
9 months ago
Edit Post #278197 Post edited:
9 months ago
Edit Post #278197 Post edited:
9 months ago
Comment Post #278219 Related: https://stackoverflow.com/questions/434414/what-is-the-most-evil-code-you-have-ever-seen-in-a-production-enterprise-environ/927301
(more)
9 months ago
Edit Post #278203 Post edited:
improved readability
9 months ago
Edit Post #278197 Post edited:
added tags + expanded acronym
9 months ago
Edit Post #278208 Post edited:
added relevant tag + minor edit
9 months ago
Edit Post #278224 Initial revision 9 months ago
Answer A: In MySQL, is it possible to disable triggers for only certain queries or users?
First of all, it seems that Mysql does not allow to disable triggers. One way would be to set a session variable which can be checked in each trigger. This still incurs some overhead (trigger is still fired for each record), but the actual trigger functionality is very small.
(more)
9 months ago
Comment Post #278151 Yes, you are right. I wonder if there is any way to migrate or should I simply ask there again and request an admin to remove this post from here.
(more)
9 months ago
Edit Post #278151 Initial revision 9 months ago
Question Adding a parent to a tag crashes on the server side (500)
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 = https://software.codidact.com/categories/38/tags/3338/edit - Added parent = office It seems tha...
(more)
9 months ago
Edit Post #278128 Initial revision 9 months ago
Answer A: In a stored procedure, is it possible to get the total number or rows updated by different statements?
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 for MYSQL to generate logs with affected rows that will be output like: [Transaction total : 10 ...
(more)
9 months ago
Comment Post #278069 So the quick answer is: a MySQL month is basically as long as a human month (edge cases might be debatable).
(more)
9 months ago
Edit Post #278083 Initial revision 9 months ago
Answer A: How to perform LINQ joins with multiple fields in a single join?
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 } Another way is combine the styles of writing the LINQ statements for more flexibility: ...
(more)
9 months ago
Edit Post #278082 Initial revision 9 months ago
Question How to perform LINQ joins with multiple fields in a single join?
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.field1 AND e1.field2 = e2.field2 What is the best way to write the LINQ query?
(more)
9 months ago
Edit Post #278081 Initial revision 9 months ago
Answer A: How can I reduce the size of .svn folder?
`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 get the same effect.
(more)
9 months ago
Edit Post #278080 Initial revision 9 months ago
Question How can I reduce the size of .svn folder?
Note: This question and its answer are an aggregate of the most up to date information about this topic from here. I have noticed that .svn folder has grown a lot and I want to reduce it. How can I achieve that?
(more)
9 months ago
Edit Post #278063 Initial revision 9 months ago
Question How can I fill in tag information_
I have noticed that most tags lack any usage information and moreover a more detailed wiki: Tag with no usage information or detailed wiki I would like to add the information for some of these tags, but I do not see how. I assume there is some kind of privilege to to this or the function is not...
(more)
9 months ago
Edit Post #278031 Post edited 9 months ago
Edit Post #277967 Post edited 9 months ago
Suggested Edit Post #277967 Suggested edit:
added tags
(more)
helpful 9 months ago
Suggested Edit Post #278034 Suggested edit:
added tag
(more)
declined 9 months ago
Suggested Edit Post #278031 Suggested edit:
added tags
(more)
helpful 9 months ago
Comment Post #277981 By migration I mean taking the relevant question and the relevant answer(s). Many questions have clearly outdated answers. Ref to closed questions, I am talking about those that are useful. I have provided two examples: one that was barely reopened and one that is currently locked (which is basically...
(more)
9 months ago
Edit Post #277980 Post edited:
9 months ago
Edit Post #277980 Initial revision 9 months ago
Question Strategy to migrate meaningful content from Stack Overflow
I was thinking about meaningful content that can be migrated (+ improved) from Stack Overflow. These categories pop into my mind: - closed questions: we know Stack Overflow is very picky when it comes to some matters ("primarily opinion based") and some questions are easily closed despite being ve...
(more)
9 months ago
Edit Post #277979 Initial revision 9 months ago
Answer A: Getting rid of "company tags" early on
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 the rare cases when the product name includes the company name or for disambiguation reasons (cannot ...
(more)
9 months ago
Edit Post #277946 Post edited:
added more details about the question
9 months ago
Edit Post #277946 Post edited:
10 months ago
Edit Post #277946 Post edited:
10 months ago
Edit Post #277946 Post edited:
fixed the code
10 months ago
Edit Post #277946 Initial revision 10 months ago
Question Is it recommended for ASP.NET Web API actions to always include a CancellationToken?
Note: This is basically a question from Stack Overflow that was closed for a very long period of time and I fear it might get closed again as primarily opinion based. I am wondering if my ASP.NET Core 3.1+ Web API should support cancellation for all its methods or only for those which are particu...
(more)
10 months ago
Comment Post #277551 @Lundin - I think the wrap can be achieved by using `overflow-wrap: break-word;` or similar. You will get the text displayed on multiple lines, but no actual line breaks are there (copy-pasting it in a text editor will get a single line). A similar behaviour is happening while editing code with long ...
(more)
10 months ago
Edit Post #277862 Post edited 10 months ago
Suggested Edit Post #277862 Suggested edit:
added relevant tag
(more)
helpful 10 months ago
Edit Post #277850 Post edited:
10 months ago
Suggested Edit Post #277833 Suggested edit:
Synced the title with the body + added a tag
(more)
declined 10 months ago
Edit Post #277850 Initial revision 10 months ago
Answer A: How to temporarily disable a MySQL user?
I think the closest thing to what the post body is suggesting is offline mode: > Connected client users who do not have the SUPER privilege are disconnected on the next request, with an appropriate error. Disconnection includes terminating running statements and releasing locks. Such clients a...
(more)
10 months ago
Edit Post #277551 Initial revision 10 months ago
Question Long code lines are not wrapped
This is a small bug (cosmetic) that I have noticed while adding some code in a post: Code with very long lines not being wrapped I have artificially added some whitespace here and there, otherwise the line would have been way longer.
(more)
10 months ago
Comment Post #277511 Not directly related to mysql CLI, but similar with broader explanations: https://stackoverflow.com/questions/47041712/is-it-secure-to-use-a-password-argument-in-a-windows-command
(more)
10 months ago
Comment Post #277469 Can you show the code for renaming the column? If rename performane depends on the data volume, it sounds really strange (8063 explained why below).
(more)
10 months ago
Edit Post #277485 Post edited:
clarified that number is expressed in days
10 months ago
Edit Post #277485 Initial revision 10 months ago
Answer A: How are integers interpreted in contexts that expect a date?
SQL Server uses '1900-01-01' as a "zero-point" in `DATEDIFF(dd, 0, somedate)`: select DATEDIFF(dd, 0, '1900-01-01') --> 0 select DATEDIFF(dd, 0, GETDATE()) --> 44066 days since the "zero-day" The whole expression is used to strip time from the `DATETIME` and still have it as a DATE...
(more)
10 months ago
Comment Post #277436 For complete information you can visit the [Stack Overflow question](https://stackoverflow.com/questions/43931986/how-to-upgrade-angular-cli-to-the-latest-version), but this was asked a very long time ago and some information from there is obsolete.
(more)
10 months ago
Edit Post #277437 Initial revision 10 months ago
Answer A: How to upgrade a recent (>= 8) Angular CLI?
I have recently upgraded Angular CLI from version 9 to version 10 and I simply installed it again. npm install -g @angular/cli Existing version λ ng version Angular CLI: 9.1.8 Node: 12.18.0 OS: win32 x64 Angular: ... Ivy Workspace: Package Versio...
(more)
10 months ago
Edit Post #277436 Initial revision 10 months ago
Question How to upgrade a recent (>= 8) Angular CLI?
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.
(more)
10 months ago
Edit Post #277435 Initial revision 10 months ago
Answer A: Initial List of Tags
A good start would be the most popular tags from Stack Overflow. Another approach is to start from scratch and search for tags on Stack Overflow whenever needed. Those tags are already curated and I don't think there is any need to reinvent the wheel here. Personally I do not mind of adding tag...
(more)
10 months ago
Comment Post #277429 @Moshi I am glad. Thanks.
(more)
10 months ago
Edit Post #277429 Initial revision 10 months ago
Question Asking software architecture related questions on Software Development community
Context Over the years I had a hard time addressing questions about software architecture like these ones . Soon after posting them, they receive a couple of downvotes and close votes which set the message that these are not welcomed in that community. One comment indicated that the communi...
(more)
10 months ago
Edit Post #277428 Initial revision 10 months ago
Question Mapping generic handler to generic query in MediatR
I am using MediatR in an ASP.NET Core 3.1 application and I want use a generic query and a generic request that deals with getting lists of some standard items I am using in drop-downs and similar: public class GetStandardListItemMapQuery : IRequest> where TEnt : class, IStandardListI...
(more)
10 months ago
Comment Post #277406 @WELZ No, I think it is more readable if the numbers are written without double quotes and only strings and other types serializable to strings are using them. By "more readable" I understand here "it conveys the message better" (i.e. item is an array of integers). Btw - what JSON serializer are you ...
(more)
10 months ago
Edit Post #277406 Initial revision 10 months ago
Answer A: Does using an Integer have any speed/performance benefits over a string in JSON
Before doing any performance testing, I think you have already noticed that the payload is significantly smaller by missing those double quotes. However, what I think is more important, especially when dealing with rather large applications and/or systems you do not own is using the appropriate da...
(more)
10 months ago