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
Tabletop RPGs
Tabletop RPGs
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »

Activity for Alexei‭

Type On... Excerpt Status Date
Edit Post #288152 Post edited:
added related tag
3 days ago
Edit Post #288121 Nominated for promotion 15 days ago
Edit Post #288099 Nominated for promotion 15 days ago
Edit Post #288041 Nominated for promotion 25 days ago
Edit Post #288091 Nominated for promotion 25 days ago
Edit Post #287994 Nominated for promotion 27 days ago
Edit Post #288085 Nominated for promotion 27 days ago
Comment Post #288059 Can you print out (echo?) your queries and include them in the post, so that it is clear what is being executed? This should help with identifying the issue. Security tip: Try using [parameterized queries](https://www.php.net/manual/en/mysqli.prepare.php) to avoid SQL Injection.
(more)
about 1 month ago
Edit Post #288059 Post edited:
replaced what seems to be a real e-mail with an example one
about 1 month ago
Edit Post #288046 Post edited:
minor fixes
about 1 month ago
Edit Post #288046 Initial revision about 1 month ago
Answer A: Updating the database reverses previous changes
I did not find the exact cause of your issue, but inserts should not be treated as updates. One way to do this is the following: ```c# static void InsertPost(Post post) { using var context = new BloggingContext(); context.Posts.Add(post); context.SaveChanges(); } var newPost =...
(more)
about 1 month ago
Comment Post #288042 I think this paragraph requires some clarification: "Unfortunately, the presence of this file will automatically kick off an npm install in Digital Ocean App Platform. This is causing some issues because I intentionally am not building that kind of app." If I understand correctly, you are using...
(more)
about 1 month ago
Edit Post #288034 Nominated for promotion about 2 months ago
Comment Post #285937 This is an interesting approach. I can't tell for Java, but for .NET (ASP.NET Core mostly) using an in-memory provider is not fashionable anymore due to various limitations and quirks. References include a [Jimmy Bogard's article](https://jimmybogard.com/avoid-in-memory-databases-for-tests/) and the ...
(more)
about 2 months ago
Comment Post #287994 I cannot check right now what happens by generating data in the database and actually run the code, but the fact that you are using entities across "database context boundaries" (e.g. blog is obtained as an entity from a disposed context and then used in other database contexts) is a red flag for me....
(more)
2 months ago
Edit Post #287970 Nominated for promotion 2 months ago
Edit Post #287940 Post edited:
Shortened the title
3 months ago
Edit Post #287940 Post edited:
split in paragraphs for better readability
3 months ago
Comment Post #287931 I have updated the [on-topic list](https://software.codidact.com/help/on-topic) based on your suggestions.
(more)
3 months ago
Edit Post #278625 Post edited:
added information about SEO
3 months ago
Edit Post #287932 Nominated for promotion 3 months ago
Comment Post #287918 Oh, sorry. Somehow I forgot to mention the SE ecosystem which has a dedicated community for Webmasters and the SEO-related questions are split (the programming ones can be asked on SO while the others on the Webmasters community). I have fixed my post.
(more)
3 months ago
Edit Post #287918 Post edited:
added missing information
3 months ago
Edit Post #287918 Initial revision 3 months ago
Question Should we allow SEO related questions?
We have recently received a search engine optimization (SEO) question. Our scope currently does not explicitly include or exclude such questions, so I thought we should clarify this. Possible options: - allow only programming-related SEO questions (e.g., ensuring website compatibility with d...
(more)
3 months ago
Edit Post #287914 Post edited:
added relevant tag
3 months ago
Edit Post #287914 Post edited:
title is a question
3 months ago
Edit Post #287914 Post edited:
used example.com instead of the actual blog
3 months ago
Edit Post #287903 Nominated for promotion 3 months ago
Edit Post #287905 Nominated for promotion 3 months ago
Edit Post #287856 Nominated for promotion 4 months ago
Edit Post #287856 Post edited:
added relevant tags
4 months ago
Edit Post #287851 Post edited:
minor title fix + added tag
4 months ago
Edit Post #287814 Nominated for promotion 4 months ago
Edit Post #287814 Post edited:
added back tags
4 months ago
Edit Post #287845 Nominated for promotion 4 months ago
Comment Post #287818 Thanks for the code review. My initial code was a complete mess. I have applied your second suggestion. Indeed I also favor composition over inheritance (which is also favored due to using DI basically everywhere except for some infrastructure code).
(more)
4 months ago
Edit Post #287804 Post edited:
added rewritten code based on review
4 months ago
Comment Post #287783 @#53549 I am wondering if it wouldn't be easier to read the registry key using [winreg](https://docs.python.org/3/library/winreg.html) instead of doing it indirectly using Powershell.
(more)
4 months ago
Edit Post #287807 Nominated for promotion 4 months ago
Edit Post #287799 Nominated for promotion 4 months ago
Comment Post #287785 Did you check the EventViewer? I expect for IIS to log something there when a worker is crashing.
(more)
4 months ago
Comment Post #287783 @ghost-in-the-zsh‭ Sorry about that. I didn't notice the Python tag. I have rolled back to your last version until we found a way to make it work when calling it from Python.
(more)
4 months ago
Edit Post #287783 Post edited:
rolled back to previous version because there are issues running it in Python
4 months ago
Edit Post #287783 Post edited:
added info for Windows 11
4 months ago
Comment Post #287783 @#53549 AFAIK, all Windows versions after Windows 7 include a PS installed. This is confirmed by [this article](https://learn.microsoft.com/en-us/powershell/scripting/learn/ps101/01-getting-started?view=powershell-7.3). No need for enterprise, I have mentioned it because it was the OS I was using for...
(more)
4 months ago
Edit Post #287804 Initial revision 4 months ago
Question Health checks with caching in ASP.NET Core
Context I noticed that an application was flooding the database with simple SELECTs. The investigation revealed some bugs in the health check which theoretically implemented caching (to avoid querying external sources too often), but it was not working properly. The application health check in...
(more)
4 months ago
Edit Post #287782 Nominated for promotion 4 months ago
Edit Post #287783 Post edited:
added information about Windows 10
4 months ago
Edit Post #287754 Nominated for promotion 4 months ago
Edit Post #287697 Post edited:
fixed the code
5 months ago
Comment Post #287682 I have closed this question because it is basically a typo.
(more)
5 months ago
Edit Post #287682 Question closed 5 months ago
Edit Post #287659 Nominated for promotion 5 months ago
Edit Post #287659 Post edited:
added relevant tag
5 months ago
Edit Post #287660 Initial revision 5 months ago
Answer A: EF-core Find method doesn't include other entities
What you want would be called `DbSet<>.Find()` combined with eager loading of the related entities. According to the docs, eager loading is not mentioned and its sole purpose is to easily get an entity based on its type and keys: > Finds an entity with the given primary key values. If an entity w...
(more)
5 months ago
Edit Post #287630 Nominated for promotion 5 months ago
Edit Post #287635 Initial revision 5 months ago
Question Deciding if a concept can be materialized to a tag
Note: this is inspired by the comments on this post and especially this one which mentions: > We have tags for languages because people have interest or expertise in languages; likewise frameworks, design patterns, etc. Who is an ‘interface’ enthusiast? This discussion made me question the way...
(more)
5 months ago
Edit Post #287612 Nominated for promotion 5 months ago
Edit Post #287602 Nominated for promotion 5 months ago
Comment Post #287616 Indeed, my solution is a poor man's solution to configuration management, and using a dedicated solution such as Consul is better. I have chosen this following my more ops-inclined colleagues' advice, but it is not set in stone and we can transition to the modern way of doing it. Thanks.
(more)
5 months ago
Edit Post #287612 Post edited:
added drawing tool reference
5 months ago
Edit Post #287614 Initial revision 5 months ago
Answer A: How to inject environment configuration values when deploying an Angular application in Kubernetes or similar infrastructure?
Note: this is mainly based on Build your Angular App Once, Deploy Anywhere article. Read this article, especially the drawbacks section. The basic idea is to create and read a configuration file that is kept as is when the Angular application is built (transpiled). I have made the following steps:...
(more)
5 months ago
Edit Post #287613 Post edited:
added relevant tags
5 months ago
Edit Post #287613 Initial revision 5 months ago
Question How to inject environment configuration values when deploying an Angular application in Kubernetes or similar infrastructure?
Context I am currently migrating a Web application from on-prem infrastructure to K8s. The legacy infrastructure relies on defining some tokens in the configuration files and these are replaced during the deployment as follows: - ASP.NET Core: appsettings.json tokens are replaced - Angular...
(more)
5 months ago
Edit Post #287612 Initial revision 5 months ago
Question Dealing with code maintenance when saving a large and complex entity in a single business transaction
Context I am currently working on migrating a legacy application to an ASP.NET Core + Angular application. The Web API's main project is based on Jason Taylor's template (clean architecture) and among others relies on MediatR library. The UI/UX experience for already migrated business flows rel...
(more)
5 months ago
Comment Post #287607 @#53410 As referenced in my post, the (language agnostic) concept of interface is quite heavily used on SO. It is also an important concept used for most applications developed in C# or Java.
(more)
5 months ago
Comment Post #287607 AFAIK, "interface" is virtually the same thing in C# and Java. Not sure about other languages that seem to use the concept (e.g. ADA - https://www.adaic.org/resources/add_content/standards/05rat/html/Rat-2-4.html ). I guess that multiple languages that do not support multiple inheritance needs the co...
(more)
5 months ago
Comment Post #287606 I do not have a MAC to check this and could not find the docs about this difference, but it seems to refer to the same thing. Taking a look at the debugging settings from [here](https://github.com/MicrosoftDocs/visualstudio-docs/blob/main/docs/debugger/map-methods-on-the-call-stack-while-debugging-in...
(more)
5 months ago
Edit Post #287607 Initial revision 5 months ago
Answer A: interface and interface-type tags
Yes, I have added that tag. I tried to create a tag to match the "interface when working with objects" concept. I am not happy with interface-type because it suggests `typeof(ISomeInterface)`, but I think it is less ambiguous than interface. What about interface-object-type? I am open to su...
(more)
5 months ago
Edit Post #287602 Post edited:
added relevant types
5 months ago
Comment Post #287598 What is the context of " I don't know what to do with the movies_scenes relation"? Why did you create this table in the first place?
(more)
5 months ago
Edit Post #287594 Post edited:
split in paragraphs for better readability
5 months ago
Edit Post #287595 Post edited:
fixed typo
5 months ago
Edit Post #287595 Initial revision 5 months ago
Answer A: Closed Question Too Generic, Reason Unhelpful
I will provide an answer to this question in the context of this, now deleted question which included this relevant text before being edited and removed: > How to implement a variable trust-based privileges system, so that there []() always the same number of users with the top trust level and an...
(more)
5 months ago
Edit Post #287594 Post edited:
minor fixes + added relevant tag
5 months ago
Edit Post #287585 Nominated for promotion 5 months ago
Edit Post #287568 Post edited:
added extra reference to newly received question
5 months ago
Edit Post #287568 Initial revision 5 months ago
Question Should we allow answers generated by ChatGPT?
We got our first (mostly) ChatGPT answer in our community. Also, a question includes an adapted ChatGPT code that does not seem to do the job. StackOverflow has already banned ChatGPT answers and I am wondering how we should proceed in this case. From my perspective, we should also ban ChatGPT...
(more)
5 months ago
Comment Post #287565 The cited answer suggests `is_single_file` flag. This should not be specified by the user, but based on media type (1 for movies, 0 for applications etc.). As a side note, I am not confident that the answer covers the entire question.
(more)
5 months ago
Comment Post #287560 It would be useful to provide an example to better understand what are looking for. Just a couple of record values for each table would be enough. If `media` contains a lot of NULL values for some columns, one solution is to define another 1:1 table (uuid + those columns) and add a row there only ...
(more)
5 months ago
Comment Post #287551 A few/several thousand should be computed fast enough by "normal" (not involving more specialized hardware) math (i.e. using the CPU), that is solving those two equations mentioned in the other thread: computing a and b from your linear function f(x) = a*x + b.
(more)
6 months ago
Comment Post #287551 How many such points do you have? I guess the answer depends a lot if we are talking about thousands vs. millions.
(more)
6 months ago
Comment Post #287551 Not sure if I understood entirely your question, but it seems to boil down to a simple set of equations with two variables: The function is f(x) = a*x + b f(-1) = 0 => -a + b = 0 f(1) = 319 => a + b = 319 => b = 319 / 2, a = 319 / 2 Of course, this can be generalized to solve the equations...
(more)
6 months ago
Edit Post #287506 Nominated for promotion 6 months ago
Comment Post #287509 Any reason to avoid defining an "utility" function for it? It is something normal in virtually all programming languages because frameworks and libraries will miss some specific functionality we need.
(more)
6 months ago
Comment Post #287512 Can you include the relevant details instead of providing links to repositories? This would make the question clearer.
(more)
6 months ago
Edit Post #287512 Question closed 6 months ago
Comment Post #287506 Never worked with Qt, but I am wondering if `setStyleSheet` sets the entire styling for the element instead of merging existing styling (maybe inherited from some global styling). Possible relevant discussion [here](https://forum.qt.io/topic/135223/is-it-possible-to-append-stylesheet-into-existing-st...
(more)
6 months ago
Comment Post #287498 I am not into 3d development, but I am wondering about the following: - how src/main/resources/textures.png actually looks? - shouldn't the picture file be in some vectorial format to properly be displayed?
(more)
6 months ago
Edit Post #287498 Post edited:
added relevant tags
6 months ago
Comment Post #287493 Ref. to "there is something wrong with the expression of the first guard of this function below" - it is not clear what is the problem here.
(more)
6 months ago
Edit Post #287493 Question closed 6 months ago
Edit Post #287432 Nominated for promotion 6 months ago
Comment Post #287443 The post includes several topics which cannot be handled in a single answer: - "I am not able to upload it on Netlify or Vercel" - what is the exact issue you are encountering here? - "on Firebase as it may require some changes in my backend code and I don't how to do it" - what database are you ...
(more)
6 months ago
Edit Post #287443 Question closed 6 months ago
Comment Post #287432 I am unfamiliar with Flutter, but I guess there must be some code to push the mutation (it seems like a JSON payload to me, is it a GraphQL query?). Not sure if that's relevant to the question, but it might be.
(more)
6 months ago
Edit Post #287407 Initial revision 6 months ago
Question Implement translatable UI in a Single Page Application when working with ngRx
I am currently working on an Angular SPA that supports multiple languages and relies on ngRx for state management. Although the application state is handled by ngRx, the current language is stored in the database. The translated resources come from outside the store (resource files read using the...
(more)
6 months ago
Edit Post #287384 Post edited:
added relevant tag
6 months ago
Edit Post #287374 Nominated for promotion 7 months ago
Comment Post #287364 Mod note: removed the previous comment, as it was not OK (see [Code of Conduct](https://software.codidact.com/policy/code-of-conduct)).
(more)
7 months ago
Edit Post #286575 Nominated for promotion 7 months ago
Edit Post #287335 Nominated for promotion 7 months ago
Comment Post #287357 Not sure why your latest information was added as an answer, but I have noticed that you have edited your post in the meantime included the relevant information (the new error messages) and removed the answer.
(more)
7 months ago
Edit Post #287356 Post edited:
added relevant tag
7 months ago
Edit Post #287349 Post edited:
added relevant tag
7 months ago
Edit Post #284596 Nominated for promotion 7 months ago
Edit Post #287307 Post edited:
removed tag
7 months ago
Edit Post #287313 Post edited:
Fixed the code and minor spelling error fix
7 months ago
Edit Post #287313 Post edited:
fixed the tags
7 months ago
Edit Post #287314 Initial revision 7 months ago
Answer A: How to provide additional information when raising exception
Python documentation suggests that you can simply add other parameters when raising the Exception and retrieve them using args: Code ```python try: raise Exception('spam', 'eggs') except Exception as inst: print(inst.args) # arguments stored in .args x, y = inst.args # unpack ar...
(more)
7 months ago
Edit Post #287307 Question closed 7 months ago
Comment Post #287300 EF is designed to track list changes (additions or removals) in DbSets only. It cannot know (or at least not in a predictable/performant way) that someone constructed some kind of list using dbset dereferenced values and then added/removed from that list.
(more)
7 months ago
Edit Post #287122 Nominated for promotion 7 months ago
Edit Post #287298 Nominated for promotion 7 months ago
Edit Post #287300 Post edited:
added a note related to not working directly with EF models
7 months ago
Edit Post #287300 Initial revision 7 months ago
Answer A: Datagrid in MVVM saves edits but not inserts
Entity Framework is able to save the changes by using a tracking mechanism (i.e. what is added, deleted, removed). I guess `repository.GetAllGoals()` implementation is something like `context.Goals` or `context.Set()`, so when you are constructing the `ObservableCollection` you actually get a lis...
(more)
7 months ago
Edit Post #287288 Initial revision 7 months ago
Answer A: How to define Polly policies when working with Refit library in ASP.NET Core?
Refit allows such configuration out of the box bt using `AddRefitClient` (which resembles the well-known AddHttpClient). This indeed requires explicit configuration for the HttpClient, but the configuration and usage will be simpler: Refit and resilience configuration ```c# private static ISer...
(more)
7 months ago
Edit Post #287287 Initial revision 7 months ago
Question How to define Polly policies when working with Refit library in ASP.NET Core?
Note: this is based on my question on SO and subsequent activity there I am trying to add resilience using Polly to HTTP calls that are performed using Refit library. I am using the Refit factory method `RestService.For<>` and I have a working code, but I feel it is way more complex than it sho...
(more)
7 months ago
Comment Post #287272 I guess one way to understand what happens is to get your hands on the application (crash) logs and let us know if there is some relevant information there. [This](https://developer.android.com/games/optimize/crash) might be a good start.
(more)
7 months ago
Edit Post #287272 Post edited:
added relevant tag + improved the formatting
7 months ago
Edit Post #287235 Nominated for promotion 7 months ago
Edit Post #287255 Question closed 8 months ago
Comment Post #287255 I have edited your question to include the error message (which should be added in the question, not an answer). Can you provide more details such as the application type, relevant package versions, etc.? Without it, it is hard to receive an answer and the question will be closed.
(more)
8 months ago
Edit Post #287255 Post edited:
added details from answer
8 months ago
Edit Post #287235 Post edited:
added relevant tag
8 months ago
Edit Post #287242 Post edited:
added a side note
8 months ago
Edit Post #287242 Initial revision 8 months ago
Answer A: How to refer to the same class twice from one Entity Framework entity?
I tried to replicate your case and the only workable solution I could find is to use OnModelCreating configuration (fluent style) instead of attributes: ```c# public class Contestant { public int Id { get; set; } public int AvatarID { get; set; } public virtual Picture? Avatar { get; ...
(more)
8 months ago
Edit Post #287152 Nominated for promotion 8 months ago
Comment Post #287152 Never worked with Lua, but [this page](https://www.gammon.com.au/scripts/doc.php?lua=os.rename) suggests that the function returns two values: `ok, message = os.rename (oldname, newname)`. Does it work to fetch a message in this case and thus receive (hopefully) an error?
(more)
8 months ago
Edit Post #287152 Post edited:
added relevant tag
8 months ago
Comment Post #286910 @#54029 That's a good suggestion and this is currently being [discussed on meta](https://software.codidact.com/posts/287107). You might refine your comment and post it as an answer there.
(more)
8 months ago
Edit Post #287107 Initial revision 8 months ago
Question Should asking about book recommendations directly connected to software development be on-topic?
Context We have recently received a suggestion to allow questions about recommending books directly connected to software development. The way I see this now (pros and cons) Pros: - allow more questions that help software developers Cons: - tend to be open-ended, unless there is not a...
(more)
8 months ago
Comment Post #286976 I have forked a StackBlitz from Angular docs and it seems to work as expected: https://stackblitz.com/edit/angular-c2kmlm?file=src/app/datepicker-locale-example.html
(more)
8 months ago
Edit Post #287010 Post edited:
8 months ago
Comment Post #287010 Do you receive any of those authentication errors when "it works" (Angular app renders something)? Anyway, this seems more of a networking issue rather than a software development one. [Power users Codidact](https://powerusers.codidact.com/) deals with such questions.
(more)
8 months ago
Comment Post #287009 http://acuriostudi.apps.cloud.local/api-hub/api-hub/designs is not solved for me. Also, this is an HTTP URL and your error suggests that an HTTPS resource (port 443 instead of 80) is used.
(more)
8 months ago
Edit Post #286974 Nominated for promotion 9 months ago
Edit Post #286974 Post edited:
added relevant tag
9 months ago
Edit Post #286940 Post edited:
added relevant tag
9 months ago
Edit Post #286910 Post edited:
removed tag
9 months ago
Edit Post #286934 Post edited:
Made the title more specific + added relevant tag
9 months ago
Edit Post #286911 Nominated for promotion 9 months ago
Edit Post #286813 Post edited:
added status
9 months ago
Comment Post #286910 We currently consider asking for recommendations [offtopic](https://software.codidact.com/help/on-topic).
(more)
9 months ago
Edit Post #286910 Question closed 9 months ago
Edit Post #286904 Post edited:
Put a more relevant title
9 months ago
Edit Post #286813 Post edited:
fixed the tag name
9 months ago
Edit Post #286813 Post edited:
added resolution
9 months ago
Edit Post #286895 Post edited:
cleanup up the title a little bit
9 months ago
Comment Post #286884 When do you receive the error? Is it a runtime error or a build error? I am wondering if the issue is not related to [the one described here](https://stackoverflow.com/questions/49820069/how-to-change-uwp-app-folder-name-or-path).
(more)
9 months ago
Edit Post #286876 Post edited:
added relevant tag
9 months ago
Edit Post #286876 Post edited:
clarified what programming language we are dealing with
9 months ago
Comment Post #286813 Yes, data-presentation sounds OK.
(more)
9 months ago
Edit Post #286861 Post edited:
added extra information based on received feedback
10 months ago
Edit Post #286849 Nominated for promotion 10 months ago
Edit Post #286861 Initial revision 10 months ago
Question Renaming GNU/Linux tag to gnu
I have noticed that we have several questions tagged with GNU/Linux. I would like to rename this tag to gnu to reflect what seems to be the canonical name and also be consistent with tag naming (all letters are lowercase, avoid slashes). Based on provided answers, I know consider the following ...
(more)
10 months ago
Edit Post #286789 Nominated for promotion 10 months ago
Edit Post #286835 Post edited:
added relevant tags
10 months ago
Edit Post #286817 Nominated for promotion 10 months ago
Edit Post #286813 Initial revision 10 months ago
Question Dealing with table tag
This question which is tagged with table tag. I am trying to find a better replacement for it since there are multiple types of tables such as HTML tables or data tables. The question seems to refer to a table displayed within a graph (a rendered table), but I am not sure how to tag such a tabl...
(more)
10 months ago
Edit Post #286726 Nominated for promotion 10 months ago
Edit Post #286764 Nominated for promotion 10 months ago
Edit Post #286776 Nominated for promotion 10 months ago
Edit Post #286720 Post edited:
highlighted the core answer for the question (TL;DR)
11 months ago
Edit Post #286715 Initial revision 11 months ago
Question Working with a generic class that uses a type that should be of generic type
I have followed Nick Chapsas' tutorial to avoid throwing a ValidationException to treat validation errors and instead rely on `LanguageExt.Common.Result<>` from LanguageExt library. I have managed to develop a working solution that relies on MediatR (which uses queries, commands and validators fo...
(more)
11 months ago
Edit Post #286713 Post edited:
clarified that the steps were manually performed
11 months ago
Edit Post #286713 Initial revision 11 months ago
Answer A: How to migrate NLog configuration from XML file(s) to application settings (JSON)?
FreeFormatter resource mentioned in the question is useful and I could use the output as a base for getting to a working configuration. All the changes were manually performed. []()- enable throw configuration exceptions and allow for internal log messages to be output in a file for understanding ...
(more)
11 months ago
Edit Post #286712 Initial revision 11 months ago
Question How to migrate NLog configuration from XML file(s) to application settings (JSON)?
I have just created an ASP.NET Core 6 application and added NLog support for logging: ```c# NLogBuilder.ConfigureNLog("nlog.config").GetCurrentClassLogger() ``` However, this API is almost deprecated as the remarks says: > It is now recommended to use NLog.LogManager.Setup().LoadConfigura...
(more)
11 months ago
Edit Post #286696 Nominated for promotion 11 months ago
Edit Post #286694 Initial revision 11 months ago
Answer A: How to generate lots of hyperlinks rather fast using ClosedXML library?
One faster alternative is to use a formula to create the hyperlink. An example is provided below: ```c# public static IXLCell SetHyperLink(this IXLCell cell, string url, string text = "link") { if (string.IsNullOrWhiteSpace(url)) return cell; // ensure a valid hyperlink text string a...
(more)
11 months ago
Edit Post #286693 Initial revision 11 months ago
Question How to generate lots of hyperlinks rather fast using ClosedXML library?
I am using ClosedXML library to generate an Excel containing thousands of hyperlinks using cell's `Hyperlink` property: ```c# cell.SetValue(text).Hyperlink = new XLHyperlink(url); ``` Such a call takes about 3ms which seems very fast, but this leads to exports taking up to one minute for larg...
(more)
11 months ago
Edit Post #286634 Post edited:
fixed the title
11 months ago
Comment Post #285148 I have rolled back to the last version that includes the code (not sure why the OP decided to remove the code though).
(more)
11 months ago
Edit Post #285148 Post edited:
rolled back to a version that contains the code
11 months ago
Edit Post #285298 Post edited:
rollback to previous version
11 months ago
Comment Post #286641 I have rolled back the question to its initial version and this answer is now obsolete.
(more)
11 months ago
Edit Post #285218 Post edited:
rollback to the original content
11 months ago
Comment Post #285222 I have rolled back the last edit because it removed all the meaningful information in the post.
(more)
11 months ago
Edit Post #285222 Post edited:
rollback to a revision that actually contains meaningful information
11 months ago
Edit Post #286573 Nominated for promotion 11 months ago
Edit Post #286570 Nominated for promotion 12 months ago
Edit Post #286578 Nominated for promotion 12 months ago
Edit Post #286573 Post edited:
added relevant tags
12 months ago
Edit Post #286568 Post edited:
not tested
12 months ago
Edit Post #286568 Post edited:
added more info
12 months ago
Edit Post #286568 Initial revision 12 months ago
Answer A: Order a subcollection from linq
If you are using .NET Core 5.0 or more you should be able to write something like the following (not tested): ```c# var data = context.TblOrder .OrderBy(o => o.OrderDate) .Select(o => new { Order = o, OrderLines = o.TblOrderLine.OrderBy(ol => ol.ProductName) ...
(more)
12 months ago
Edit Post #286550 Post edited:
added relevant tag
12 months ago
Comment Post #286520 @#8135n OK. This makes sense. I haven't worked with WPF / MVVM pattern for quite some time, so the following might not apply. Normally, the UI (the grid in this case) should not directly work with database models as what you store is typically different from what you display and also due to a sep...
(more)
12 months ago
Comment Post #286520 What does `_context.TagType` contain when you are trying to save in `SaveAllTagTypes`? I assume it contains the initially loaded items, because [the documentation](https://docs.microsoft.com/en-us/dotnet/api/system.collections.objectmodel.observablecollection-1.-ctor?view=net-6.0#system-collections-o...
(more)
12 months ago
Edit Post #286511 Post edited:
added relevant tag
about 1 year ago
Edit Post #286480 Nominated for promotion about 1 year ago
Comment Post #286440 Offtopic/inflammatory comments removed
(more)
about 1 year ago
Edit Post #286444 Initial revision about 1 year ago
Question Measuring the impact of using exceptions instead of return values in an ASP.NET Core application
Context This Q&A from SO suggests that throwing exceptions is incredibly expensive when compared to returning values (return codes): > that with return codes instead of exceptions the same program runs less than one millisecond, which means exceptions are at least 30,000 times slower than retu...
(more)
about 1 year ago
Edit Post #286440 Post edited:
added relevant tags + minor fixes
about 1 year ago
Edit Post #286405 Nominated for promotion about 1 year ago
Edit Post #277428 Post edited:
added another attempt
about 1 year ago
Edit Post #277428 Post edited:
removed app name
about 1 year ago
Comment Post #286390 Strangely, we had two tags with the exact same name, so I have merged them.
(more)
about 1 year ago
Edit Post #286390 Post edited:
merged the tags, so this issue is solved
about 1 year ago
Edit Post #286372 Post edited:
Replaced the title to match what is actually being asked
about 1 year ago
Comment Post #286306 I closed the question because it is not clear what it is being asked. The title suggests a way to remove the pseudo elements, but a previous comment actually mentions removing regular text inside a DOM element.
(more)
about 1 year ago
Edit Post #286306 Question closed about 1 year ago
Comment Post #285801 Since the solution was to use the correct type of parenthesis, it is not particularly helpful for future readers.
(more)
about 1 year ago
Edit Post #285801 Question closed about 1 year ago
Edit Post #286353 Post edited:
added relevant tag
about 1 year ago
Edit Post #286345 Post edited:
added relevant tag
about 1 year ago
Edit Post #286349 Post edited:
added relevant tags
about 1 year ago
Edit Post #282685 Question closed about 1 year ago
Edit Post #286306 Post edited:
about 1 year ago
Comment Post #286306 I think it makes sense to understand how the pseudo-elements are actually creating the trouble in your case and why you want them removed. I am not very knowledgeable in CSS, but I guess that such brute-force approaches might seriously mess the layout (i.e. the pseudo-elements are there for a reason)...
(more)
about 1 year ago
Edit Post #286307 Post edited:
fixed the attribution link
about 1 year ago
Edit Post #286304 Post edited:
added relevant tag
about 1 year ago
Edit Post #286302 Post edited:
added relevant tag
about 1 year ago
Edit Post #286276 Question closed about 1 year ago
Comment Post #286276 This question is not on-topic on Software Development. Please use the Power User site. Be sure to include any relevant details (what have you tried, error messages).
(more)
about 1 year ago
Edit Post #286275 Question closed about 1 year ago
Comment Post #286275 This question is not on-topic on Software Development. Please use the [Power User site](https://powerusers.codidact.com/). Be sure to include any relevant details (what have you tried, error messages).
(more)
about 1 year ago
Comment Post #286272 Thanks for letting us know about the underlying cause of your issue. Since you are still not happy with the solution and have another question, can you please post it separately?
(more)
about 1 year ago
Edit Post #286262 Post edited:
added minor note
about 1 year ago
Edit Post #286262 Initial revision about 1 year ago
Question What version of runtime environment does a .NET 5 application actually needs?
Our team deals with a legacy application that relies on a rather old deployment process and infrastructure: - we deploy the application on an environment very similar to the production called Clone. Clone is a Windows Server that has (among other versions) a version of .NET 5.0.x (e.g. .NET 5.0.16...
(more)
about 1 year ago
Edit Post #286256 Post edited:
added relevant tag
about 1 year ago
Edit Post #286196 Nominated for promotion about 1 year ago
Edit Post #286219 Post edited:
removed non-applicable tag
about 1 year ago
Comment Post #286210 Just a thought. I think imask complains because it is not the only managing input's value (what it displays), since NgbDatePicker is also trying to change it following date selection. Why not use [NgbDatePicker's](https://ng-bootstrap.github.io/#/components/datepicker/overview) formatting options ins...
(more)
about 1 year ago
Comment Post #286219 Actually, it is just something I have noticed and that needs to be taken into account when looking for a solution. It makes things more complicated when compared to all nodes being in DOM, but hidden.
(more)
about 1 year ago
Comment Post #286219 When clicking on a parent node, the child nodes are lazy-loaded (they do not exist in the DOM). Initial state ``` <div class="CategoryTreeChildren" style="display:none"></div> ``` After clicking (abbreviated): ``` <div class="CategoryTreeChildren" style=""> <div class="CategoryTree...
(more)
about 1 year ago
Comment Post #286216 Can you please also provide the HTML / the way it is built dynamically? Currently, the relationship between nodes and their children is not clear and it is needed to be able to go through the descendants and uncollapse through clicking.
(more)
about 1 year ago
Edit Post #286216 Post edited:
added relevant tag
about 1 year ago
Edit Post #286210 Post edited:
added relevant tag
about 1 year ago
Comment Post #286210 Can you please provide the relevant code? It is hard to fully understand the issue without it.
(more)
about 1 year ago
Edit Post #286176 Post edited:
added relevant tags + removed irrelevant ones
about 1 year ago
Edit Post #286163 Question closed about 1 year ago
Edit Post #286168 Initial revision about 1 year ago
Answer A: WPF MVVM ListBox not updating
I haven't worked in WPF for a long time, but you might try setting a new list (clone the old one and add the new element) instead of adding the element to the existing list: ```c# demo.Value++; var newList = new List(demo.AllValues); newList.Add(demo.Value); demo.AllValues = newList; OnProper...
(more)
about 1 year ago
Edit Post #286163 Post edited:
added relevant tags
about 1 year ago
Edit Post #286164 Post edited:
added relevant tag
about 1 year ago
Comment Post #286164 Does it work if you set a new list (clone the old one and add the new element) instead of adding the element to the existing list? (basically, the bound value is immutable)
(more)
about 1 year ago
Comment Post #286151 Please post your compilation errors as text, not as an image. Check [this post](https://software.codidact.com/posts/284871) for more details.
(more)
about 1 year ago
Edit Post #286135 Question closed about 1 year ago
Edit Post #286125 Post edited:
improved the title + minor fixes
about 1 year ago
Edit Post #286041 Nominated for promotion about 1 year ago
Edit Post #286065 Post edited:
removed non-applicable tag
about 1 year ago
Edit Post #286069 Initial revision about 1 year ago
Answer A: How to get rid of HTML tags and convert entities in SQL Server?
One way is to create a scalar function that takes an NVARCHAR(MAX) input and performs the following operations: - replaces frequent tags with they plain text equivalent (e.g. `` with chars 13 + 10) - replaces spacial entities with their correspondent UTF character (e.g. `&copy;` with `©`) - comp...
(more)
about 1 year ago
Edit Post #286068 Initial revision about 1 year ago
Question How to get rid of HTML tags and convert entities in SQL Server?
I have to migrate a bunch of text from an old application into a new one. Some of these texts contain HTML tags and entities (HTML editor was used) and now they do not want to support this in the new application. How to get rid of the tags and transform the HTML entities?
(more)
about 1 year ago
Comment Post #286065 I am wondering if it works if you change the server-side "reload" to a [client-side one](https://developer.mozilla.org/en-US/docs/Web/API/Location/reload): `location.reload()`
(more)
about 1 year ago
Comment Post #286065 I have not programmed in PHP for ages, but looking [at the docs](https://www.php.net/manual/en/function.setcookie.php) it seems that "Once the cookies have been set, they can be accessed on _the next page load_ with the $_COOKIE array." Your code seems to immediately redirect and the cookies array mi...
(more)
about 1 year ago
Edit Post #285946 Nominated for promotion about 1 year ago
Edit Post #282226 Post edited:
added relevant tags
about 1 year ago
Comment Post #286047 I am not working with a Java IDE, but I am wondering if you have the option to place a breakpoint for `x.foo` and step over it (might also work with dragging current execution point to a subsequent instruction).
(more)
about 1 year ago
Edit Post #286047 Post edited:
added relevant tag
about 1 year ago
Edit Post #286045 Post edited:
removed useless reference to another user
about 1 year ago
Comment Post #286041 [This article](https://www.danielsieger.com/blog/2021/01/03/generating-platonic-solids.html) might be useful in getting a more generic way of building a dodecahedron.
(more)
about 1 year ago
Edit Post #286041 Post edited:
add/remove tags
about 1 year ago
Edit Post #286031 Post edited:
added relevant tag
over 1 year ago
Edit Post #286027 Post edited:
using existing tag
over 1 year ago
Edit Post #286029 Initial revision over 1 year ago
Answer A: How to create an object, call one of it's methods and pass it as an argument as a oneliner?
If you do not mind having so much code on a single line, the builder pattern might be useful here. Something along the lines: Note: the example is adapted based on an implementation I have done in a .NET and deviates from the canonical example shown in the reference. Define the builder ```ja...
(more)
over 1 year ago
Comment Post #286017 How about using [the builder pattern](https://howtodoinjava.com/design-patterns/creational/builder-pattern-in-java/). You create a builder class (`FooBuilder`) for Foo. I guess the test could like the following: `new FooBuilder().withX(42).build().getY()`. The advantage of this pattern is that ...
(more)
over 1 year ago
Edit Post #286008 Post edited:
added relevant tags
over 1 year ago
Edit Post #284194 Nominated for promotion over 1 year ago
Edit Post #285898 Nominated for promotion over 1 year ago
Edit Post #285973 Initial revision over 1 year ago
Answer A: Software recommendations category
> Shouldn't it be a category of Software Development too? Probably not Unless it is a very specific question as in the examples provided by Lundin which are clearly related to software development, I would not like general software recommendations on Software Development: - Power User Codid...
(more)
over 1 year ago
Edit Post #279543 Post edited:
over 1 year ago
Edit Post #277134 Post edited:
over 1 year ago
Edit Post #278262 Post edited:
over 1 year ago
Edit Post #277137 Post edited:
over 1 year ago
Edit Post #281624 Post edited:
over 1 year ago
Edit Post #278939 Post edited:
over 1 year ago
Edit Post #278625 Post edited:
over 1 year ago
Edit Post #277134 Post edited:
added order
over 1 year ago
Edit Post #277136 Post edited:
added order
over 1 year ago
Edit Post #277137 Post edited:
added order
over 1 year ago
Edit Post #284175 Nominated for promotion over 1 year ago
Edit Post #282565 Nominated for promotion over 1 year ago
Edit Post #284553 Nominated for promotion over 1 year ago
Edit Post #284596 Nominated for promotion over 1 year ago
Edit Post #284646 Nominated for promotion over 1 year ago
Edit Post #284708 Nominated for promotion over 1 year ago
Edit Post #278767 Nominated for promotion over 1 year ago
Edit Post #278767 Post edited:
added relevant tags
over 1 year ago
Edit Post #284910 Nominated for promotion over 1 year ago
Edit Post #285050 Nominated for promotion over 1 year ago
Edit Post #285104 Nominated for promotion over 1 year ago
Edit Post #285021 Nominated for promotion over 1 year ago
Edit Post #285225 Nominated for promotion over 1 year ago
Edit Post #285366 Nominated for promotion over 1 year ago
Edit Post #285499 Nominated for promotion over 1 year ago
Edit Post #285720 Nominated for promotion over 1 year ago
Edit Post #285746 Nominated for promotion over 1 year ago
Edit Post #285745 Nominated for promotion over 1 year ago
Edit Post #285844 Nominated for promotion over 1 year ago
Edit Post #285917 Nominated for promotion over 1 year ago
Comment Post #285875 I do not think we need this category, because we already allow such questions. Examples: [Best practices in setting up a development & production environments](https://software.codidact.com/posts/285908) [Why object-oriented instead of class-oriented?](https://software.codidact.com/posts/285720...
(more)
over 1 year ago
Edit Post #278625 Post edited:
over 1 year ago
Edit Post #278625 Post edited:
over 1 year ago
Comment Post #285870 This is a great idea. Based on your proposal and the only answer + its comments, I have changed the section contents. "What type of questions can I ask here?" has also become the first item in the Guidance category. I will follow this Q&A and update the section if needed.
(more)
over 1 year ago
Edit Post #278625 Post edited:
over 1 year ago
Edit Post #278625 Post edited:
cleanup based on https://software.codidact.com/posts/285870
over 1 year ago
Edit Post #285939 Post edited:
added relevant tag
over 1 year ago
Comment Post #285916 Using localstorage is a great idea. Ref. to "the app might be closed before the idle state is reached, and that a closing app might no longer be able to communicate with the outside", I thought about this and that is why I have mentioned the beforeunload event which allows to mark the tab/brows...
(more)
over 1 year ago
Edit Post #285911 Post edited:
fixed the question
over 1 year ago
Edit Post #285911 Initial revision over 1 year ago
Question Allow question and answers textareas to be resizable
Many questions and answers on Software might involve a lot of code that typically require more width and/or height to be displayed in a way that is easy to read. Why simply not enforce `resize: none` and allow the user to resize the textarea to their needs (if the browser allows it and they want t...
(more)
over 1 year ago
Comment Post #285844 @#53280 I thought of using this for the following: evaluating SPA usage time (i.e. consider last activity + a time interval) or automatically saving some data after an idle period.
(more)
over 1 year ago
Edit Post #285885 Initial revision over 1 year ago
Answer A: Preloading some data at application startup as fast as possible
One way to do this is to launch a Task at application startup as soon as possible (the DI is configured). The only hard part is to make DI available in the prewarm functionality. The following implementation is based on this article. ```c# /// /// Credit: https://anduin.aiursoft.com/post/202...
(more)
over 1 year ago
Edit Post #285884 Post edited:
added relevant tags
over 1 year ago
Edit Post #285884 Initial revision over 1 year ago
Question Preloading some data at application startup as fast as possible
I am caching some very static information (changes once per day) in my ASP.NET Core application. This is normally done when needed ("lazy"). One such cache item is a 50K list of items that are taking less than 500ms when the application is deployed and about one second in the development environme...
(more)
over 1 year ago
Edit Post #285843 Post edited:
added more code for the caching example
over 1 year ago
Edit Post #285873 Initial revision over 1 year ago
Question What are the drawbacks of using data snapshot testing?
Our team is finally focusing on writing more automatic testing and one of my ex-colleagues recommended to try out the Verify library. The tool does the following: - runs the test and compares the JSON serialization of the actual result with a JSON file named after the test name. The first run w...
(more)
over 1 year ago
Comment Post #285865 Software recommendation questions are [offtopic on Software Development](https://software.codidact.com/help/on-topic), but they seem [to be welcomed on Power Users](https://powerusers.codidact.com/posts/284817/284902#answer-284902).
(more)
over 1 year ago
Edit Post #285865 Question closed over 1 year ago
Edit Post #285843 Post edited:
added Derek's suggestion
over 1 year ago
Comment Post #285843 @#53398 Yes, you are right. TransactionScopes should be avoided. The only valid case where I needed explicit transaction management (as opposed to context save changes one) was when the transaction performed both reads and delete on the same records (read -> archive -> remove) and EF could not figure...
(more)
over 1 year ago
Edit Post #285844 Post edited:
minor fix
over 1 year ago
Edit Post #285844 Initial revision over 1 year ago
Question Detecting if a user has stopped interacting with a web view for a certain time
I am interested in finding out all the aspects I need to cover in order to correctly assess if a user has stopped interacting with a web page. So far, I found the following: - Idle Detection API - this seems to do most of the work for idle detection. However, it requires user permission - Detect ...
(more)
over 1 year ago
Edit Post #285843 Post edited:
added more information
over 1 year ago
Edit Post #285843 Initial revision over 1 year ago
Answer A: How to write database friendly code when using an ORM?
Note: this is mostly based on personal experience rather than benchmarks. The examples would focus on using EF with SQL Server, but some points might apply to other ORMs and relational databases The provided references explain why ORM and relational databases are quite incompatible but do not prov...
(more)
over 1 year ago
Edit Post #285841 Initial revision over 1 year ago
Question How to write database friendly code when using an ORM?
There are a lot of articles and presentations that show little love for ORMs. This is mainly because some queries are so complex and heavy on the database that they lead to significant issues in production. After quickly reading the aforementioned article I understand that there are many incomp...
(more)
over 1 year ago
Edit Post #285839 Post edited:
added changes performed based on received feedback + add out run output
over 1 year ago
Edit Post #285839 Post edited:
fixed the initialization code
over 1 year ago
Comment Post #285839 @#53305 Ref. to "Just a stupid idea: What if the observed results are not due to the use of checked, but an artifact of the JIT compiler or due to external factors influencing your benchmark run (like, do you have other stuff running on your box that might possibly intermittently load the CPU and che...
(more)
over 1 year ago
Edit Post #285838 Post edited:
added information based on feedback
over 1 year ago
Comment Post #285838 @#53305 Not familiar with how SonarQube actually works, but I guess it computes the cyclomatic complexity and complains about going beyond a certain threshold. So it ignores the actual instructions. Ref. how to avoid I have never used anything beyond the simple mapping. And also in this case, I wo...
(more)
over 1 year ago
Edit Post #285839 Post edited:
Fixed the title
over 1 year ago
Edit Post #285839 Initial revision over 1 year ago
Question Measuring arithmetic overflow checking overhead in C#
Overflow checking for integral-type arithmetic operations is disabled by default and it can be explicitly enabled by using using `checked` function or the `-checked` compiler switch. Since I mainly develop business applications where the main focus is correctness, I am wondering if globally switch...
(more)
over 1 year ago
Edit Post #285838 Post edited:
added complexity clarification
over 1 year ago
Edit Post #285836 Post edited:
minor fixes
over 1 year ago
Edit Post #285838 Initial revision over 1 year ago
Answer A: Why static code analyzers such as SonarQube indicate a high code complexity for switch statements?
I would skip the theoretical part of actually computing the cyclomatic complexity of a switch statement and mention that it can see as a bunch of `if` statements. Since each `if` adds to the complexity, the higher the number of `case`s, the higher the complexity. While a simple switch such as the ...
(more)
over 1 year ago
Edit Post #285836 Post edited:
added language tag
over 1 year ago
Edit Post #285836 Post edited:
added relevant code
over 1 year ago
Edit Post #285836 Initial revision over 1 year ago
Question Why static code analyzers such as SonarQube indicate a high code complexity for switch statements?
During a presentation of a pipeline configuration, a colleague showed a SonarQube integration and one of its reports. A warning was caused by overrunning the max value for the code complexity threshold in a function containing a fairly large switch statement. Why are switch statements considered t...
(more)
over 1 year ago
Comment Post #285829 I agree and I will wait for a few days for other feedback before adding a line to the on-topic list.
(more)
over 1 year ago
Edit Post #285828 Post edited:
fixed the title
over 1 year ago
Edit Post #285828 Initial revision over 1 year ago
Question Should we allow questions about software quality assurance?
I would like to ask a question about the pros/cons of using a library or more generally a way of assertion of complex data models. This is more related to testing than it is to actual coding, but it is certainly tied to writing code. I am wondering if we should allow such questions in our comm...
(more)
over 1 year ago
Edit Post #285823 Initial revision over 1 year ago
Question Migrating HTML strings to a more secure alternative
Our team will have to migrate an old application to use a new tech stack. One of the features involves the usage of HTML editors which serialized the content as HTML and I am able to see valid HTML in the database for those fields. The HTML editor is quite limited (text formatting, links, but no s...
(more)
over 1 year ago
Edit Post #285784 Question closed over 1 year ago
Edit Post #285810 Post edited:
added relevant tag + minor title fix
over 1 year ago
Edit Post #285812 Post edited:
added relevant tags + minor fixes
over 1 year ago
Edit Post #285807 Initial revision over 1 year ago
Question Rationale of using database-level transactions inside a store procedure when application layer already manages a transaction
One of the legacy applications my team has to maintain has almost always this pattern for dealing with data modification: ```c# try { // get the connection // begin transaction // optional execution of some changes // optional call stored procedure // optional execution of o...
(more)
over 1 year ago
Edit Post #285769 Post edited:
removed irrelevant tag
over 1 year ago
Comment Post #285800 @#8176 I have used "branch prediction" in this case. Your answer already has +4 and I can make amendments to the on-topic/off-topic section as feedback comes.
(more)
over 1 year ago
Edit Post #285801 Post edited:
added relevant tag
over 1 year ago
Comment Post #285800 I have already integrated your feedback in the What type of questions can I ask here? section as it provides a good explanation about what is on-topic and what is not. Thanks.
(more)
over 1 year ago
Edit Post #278625 Post edited:
added UI/UX feedback from Lundin
over 1 year ago
Edit Post #285735 Post edited:
fixed the reference
over 1 year ago
Comment Post #285799 I remember working on a project where the initial devs defined explicit mappings for all the members, including the ones that were identical between the mapped models. The final code was way larger than using simple assignments.
(more)
over 1 year ago
Edit Post #285735 Post edited:
added action based on feedback
over 1 year ago
Edit Post #278625 Post edited:
added UI/UX in the ontopic list
over 1 year ago
Edit Post #285770 Initial revision over 1 year ago
Answer A: What are the disadvantages of using auto mapper libraries?
Based on my experience auto-mapping has some drawbacks: - "find all references" not working as expected - anyone relying on the "find all references" functionality or similar will miss the implicit assignments happening only at runtime due to automapping - property rename - if any of the proper...
(more)
over 1 year ago
Edit Post #285769 Initial revision over 1 year ago
Question What are the disadvantages of using auto mapper libraries?
I have noticed that lots of projects (both in real-world and within online courses) use Automapper to map domain models to view models, API models. The main advantage seems to be convenience by removing the need for lots of assignments when dealing with models with lots of properties. However, ...
(more)
over 1 year ago
Edit Post #285750 Post edited:
made the title easier to read
over 1 year ago
Edit Post #285750 Post edited:
added relevant tag
over 1 year ago
Edit Post #285745 Post edited:
simplified the title
over 1 year ago
Edit Post #285746 Initial revision over 1 year ago
Question In the current development context (2020+), is there any reason to use database triggers?
I have not used a database trigger in years in the projects of the teams I have worked in, but I have seen them being used by other teams. Back in 2009, it seemed like a heated debate, but I am wondering if they are useful anymore for modern software applications. By modern software application...
(more)
over 1 year ago
Edit Post #285745 Post edited:
fixed the title
over 1 year ago
Edit Post #285745 Initial revision over 1 year ago
Question When stored procedures are preferred over application layer code?
[]()A person I used to work with several years ago was hired to rewrite a product using a .NET-based modern tech stack. One of the aspects that stroke me was that he believes that the product should mostly rely on stored procedures and less on the ORM (e.g. Entity Framework). I have also heard this a...
(more)
over 1 year ago
Edit Post #285742 Post edited:
added relevant tags
over 1 year ago
Edit Post #285735 Post edited:
simplified the title
over 1 year ago
Edit Post #285739 Post edited:
over 1 year ago
Comment Post #285735 @#8049 Done. It makes more sense as you mentioned. Thanks.
(more)
over 1 year ago
Edit Post #285739 Initial revision over 1 year ago
Answer A: Should we allow UI/UX questions in our community?
Yes I would allow UI/UX questions with some limitations. Examples: - on topic - UI/UX questions related to an interface that also involves some programming (e.g. web interfaces) - offtopic - questions about choosing fonts for banners or graffiti, color to be used in some ads etc.
(more)
over 1 year ago
Edit Post #285735 Post edited:
removed proposal info from the question
over 1 year ago
Edit Post #285735 Initial revision over 1 year ago
Question Should we allow UI/UX questions in our community?
[]()A significant fraction of software developers also needs to make some UI/UX-related decisions. I am wondering if we should such questions in the Software Development community. Based on feedback for this question, I have updated []()What type of questions can I ask here?.
(more)
over 1 year ago
Edit Post #285676 Post edited:
added relevant tag
over 1 year ago
Edit Post #285620 Post edited:
added relevant tags
over 1 year ago
Comment Post #285569 @#36363 Questions not about code are OK, as long as they are close to the development process. Example: https://software.codidact.com/posts/285389. Here I am not providing any code and neither do the answers. However, I am speaking about specific implementation details, not just a rough idea.
(more)
over 1 year ago
Edit Post #285574 Initial revision over 1 year ago
Answer A: Appropriate HTTP status code for "user confirmation required"
Unless there are reasons for keeping the "check for unintended consequences" and "perform the action" in the same endpoint, I would split them into two parts: 1. `GET /api/v1/action-can-charge-the-client/{id}`. This should respond with 200 and the required information so that the client knows that...
(more)
over 1 year ago
Comment Post #285569 @#36363 Software developers should understand the business requirements and think about a way to implement them. If they are not sure about a particular aspect of the architecture, they can come to Codidact, provide the relevant details and ask about the particular aspect they want to clarify. Of...
(more)
over 1 year ago
Comment Post #285569 Can you please make the question more about Software Development? Currently, it sounds more like a "marketing" or UX at best.
(more)
over 1 year ago
Edit Post #285569 Question closed over 1 year ago
Edit Post #285566 Post edited:
added relevant tag
over 1 year ago
Edit Post #285534 Post edited:
minor fix in the code
over 1 year ago
Edit Post #285542 Initial revision over 1 year ago
Answer A: How to mock LazyCache when performing unit testing?
LazyCache provides CachingService as a concrete implementation of the IAppCache. When unit testing simply instantiate the tested service using CachingService: ``` var testInstance = new FooService(new CachingService()); ```
(more)
over 1 year ago
Edit Post #285541 Initial revision over 1 year ago
Question How to mock LazyCache when performing unit testing?
A few of my services rely on LazyCache and they use it by injecting IAppCache. For unit testing, I would like to mock this. I have found MockCachingService, but it does not do any caching (as specified in the comments). What is the way to perform unit testing in this scenario?
(more)
over 1 year ago
Edit Post #285533 Post edited:
minor formatting fix
over 1 year ago
Edit Post #285534 Initial revision over 1 year ago
Answer A: How to create fire and forget tasks Q&A in ASP.NET Core with dependency injection support?
The way I made this work is not very quick but might provide extra benefit in the future. I have added Hangfire support to the application and use its BackgroundJob enqueuing mechanism as follows: Plugging Hangfire ``` using Hangfire; using Hangfire.MemoryStorage; public void ConfigureServ...
(more)
over 1 year ago
Edit Post #285533 Initial revision over 1 year ago
Question How to create fire and forget tasks Q&A in ASP.NET Core with dependency injection support?
One of the legacy applications our team manages contained the following pattern (in the controller): ``` // initialization private readonly IServiceScopeFactory serviceScopeFactory; public FooController(IServiceScopeFactory serviceScopeFactory) { serviceScopeFactory = serviceScopeFactor...
(more)
over 1 year ago
Comment Post #285489 @#53280 Yes, I have not realized the XY problem in my post. I have added a paragraph to clarify this.
(more)
over 1 year ago
Edit Post #285489 Post edited:
clarified the purpose of my question
over 1 year ago
Comment Post #285489 Unfortunately, the application I am developing now is running on servers that are shared by multiple .NET applications and the memory is not that generous (although its price is pretty low when compared to other software development costs).
(more)
over 1 year ago
Edit Post #285502 Post edited:
improved readability
over 1 year ago
Edit Post #285502 Initial revision over 1 year ago
Answer A: How to deeply clone an array in Angular / TypeScript?
These can be achieved in several ways, but there might be some drawbacks: - through JSON serialization/deserialization: `const cloned = JSON.parse(JSON.stringify(array));` The advantage is that it works for any type of object, but there are some drawbacks such as converting some values like...
(more)
over 1 year ago
Edit Post #285500 Initial revision over 1 year ago
Question How to deeply clone an array in Angular / TypeScript?
I have an array that I need to clone in Angular / Typescript. That is, any change done on an element from the cloned array should not affect the content of the initial array. How can I achieve this?
(more)
over 1 year ago
Edit Post #285499 Initial revision over 1 year ago
Question Using nested paths vs. flat ones for API resources
This is based on a code review discussion that I had with a colleague about the way I have designed the resources paths for an ASP.NET Core controller that is currently consumed only internally (by a SPA). The paths were flattened (e.g. GET /api/productreview/{reviewId}) and my colleague argued th...
(more)
over 1 year ago
Edit Post #285399 Post edited:
added Quasímodo‭'s feedback
over 1 year ago
Comment Post #285399 @#53919 Indeed, I have also noticed that SO managed to get more and more users, but there are simply not enough folks to answer them. Before Codidact, in order to get answers for most of the questions I had to rely on bounties. Now I have Codidact :) This is also shown in the answer rate graph fr...
(more)
over 1 year ago
Edit Post #285493 Post edited:
added relevant tag
over 1 year ago
Edit Post #285489 Initial revision over 1 year ago
Question Can I set a memory limit for the .NET Core garbage collector to collect objects more aggressively?
I have an ASP.NET Core 5 web application that provides functionality that involves file upload + rather large processing (memory consumption mainly). After each processing (with success or not) the memory could be reclaimed. I have a stress test the endpoint with large files and checked the w3wp.e...
(more)
over 1 year ago
Edit Post #285472 Post edited:
added relevant tag
over 1 year ago
Comment Post #285472 Would a userscript that defines a hotkey to hide the element be OK? Somethink like: ``` window.addEventListener("the_key", setupHideElement, false); function setupHideElement(key) { // locate and hide element here } ```
(more)
over 1 year ago
Comment Post #285396 @#8176 It is similar to that (did not know it exists, but it is a very nice thing). However, I think it is easier to have a default text for a question directly as a question body. I guess this is the main reason why GitHub uses this method: it helps the user not to forget to include important inform...
(more)
over 1 year ago
Edit Post #285399 Post edited:
added Lundin's suggestion
over 1 year ago
Edit Post #285454 Post edited:
added relevant tags
over 1 year ago
Edit Post #285456 Initial revision over 1 year ago
Answer A: Tracking what users are searching in a content management system
Server-side solution If you can customize the server-side search functionality, you could add some logging information there. The advantages in this case are: - store the data in a useful format and avoid parsing general-purpose logs - you can also store some metadata related to the found resu...
(more)
over 1 year ago
Edit Post #285451 Post edited:
added relevant tag
over 1 year ago
Edit Post #285451 Post edited:
added relevant tag
over 1 year ago
Comment Post #285399 @#54706 I guess you are talking about [this](https://meta.codidact.com/posts/280058). I do not remember seeing them actually used though. I guess it requires explicit activation at the community level.
(more)
over 1 year ago
Comment Post #285399 @#54706 Yes, I would not advertise it now. However, I think it makes sense to tackle this somehow before the numbers run high and include it in future site promotion. Professionals tend to dislike messy questions and an important fraction of newbies posts low-quality posts. Without a separation like ...
(more)
over 1 year ago
Edit Post #285399 Post edited:
added suggestions from Monica
over 1 year ago
Edit Post #285394 Post edited:
added relevant tag
over 1 year ago
Edit Post #285399 Initial revision over 1 year ago
Question Promoting the advantages Codidact Software has over Stack Overflow or similar communities
Note: some of these points are relevant for all communities, but I would like to focus on Software Development for now I am thinking of promoting Software Codidact, but I could not find a single page to include a list of advantages it has over other similar platforms, mostly against the SO. Wha...
(more)
over 1 year ago
Edit Post #285398 Initial revision over 1 year ago
Question How to promote Software Development Codidact on LinkedIn?
I have recently blown off the dust off my LinkedIn profile and I have realized that I have hundreds of connections. An important fraction of all these connections are into software development and might be interested into using a platform like Codidact. The Codidact Foundation is also on LinkedIn ...
(more)
over 1 year ago
Edit Post #285396 Initial revision over 1 year ago
Question Question templates for guidance
I am wondering if it makes sense to define a template for questions. This would act as a guideline rather than a strict template to be followed. I have seen this being used for GitHub issues and I think it would help virtually all users to tick some points when asking most of the software developm...
(more)
over 1 year ago
Comment Post #285389 The files are immutable. Only addition and deletion are allowed to the actual content. Only metadata might be updated.
(more)
over 1 year ago
Edit Post #285389 Initial revision over 1 year ago
Question Transferring files from a legacy project to an existing one as varbinary
Our team is currently transferring all functionality (+ some changes) from small and very old project A (almost code freeze) to project B (actively developed). As part of the data migration, there are about 10GB of files to be transferred. Currently, project B stores files as varbinary in the data...
(more)
over 1 year ago
Edit Post #285366 Post edited:
added relevant tag
over 1 year ago
Edit Post #285177 Post edited:
properly formatted the code
over 1 year ago
Edit Post #285298 Post edited:
minor fixes, removed the fluff
over 1 year ago
Edit Post #285218 Question reopened over 1 year ago
Comment Post #285218 @#54706 I have approved your edit as it is clearly better than the initial post (no useless code provided). However, it still sounds like "do my homework for me" as opposed to asking a more targeted question (as suggested in another comment thread).
(more)
over 1 year ago
Edit Post #285274 Post edited:
added relevant tag
over 1 year ago
Edit Post #278063 Post edited:
minor fixes
over 1 year ago
Comment Post #285244 I do not know Python, but it support [dictionaries](https://www.programiz.com/python-programming/dictionary). You can construct a dictionary for the second table : Name -> { Description, Amount}. You iterate through the first table row by row and perform lookups in the constructed dictionary. This s...
(more)
over 1 year ago
Edit Post #285225 Post edited:
replaced tag with a more specific one
over 1 year ago
Comment Post #285218 Can you include in the question the actual problem you have in the code? Is the replacement working as expected? If it does, consider [adding a review](https://software.codidact.com/posts/new/1/44) instead. If it does not work as expected, specify what is wrong (e.g. wrong string after replacement or...
(more)
over 1 year ago
Edit Post #285204 Post edited:
added relevant tags + clarified the text
over 1 year ago
Comment Post #285190 Since the underlying cause is mostly a typo (extra # in the element id) as per [this comment](https://software.codidact.com/comments/thread/5265#comment-15191) and the existing answer) I closed this question.
(more)
over 1 year ago
Edit Post #285190 Question closed over 1 year ago
Comment Post #285190 Did you check [FormData's documentation / examples](https://developer.mozilla.org/en-US/docs/Web/API/FormData/Using_FormData_Objects)? It seems that you cannot directly construct a FormData from an Element.
(more)
over 1 year ago
Comment Post #285179 Debouncing is meant to reduce strain on the server and its period can be tweaked (latency vs. number of issued requests). This can be coupled with cancellation to play nice with the server and inform about the obsolete requests. An example using Angular can be seen [here](https://alligator.io/angular...
(more)
over 1 year ago
Edit Post #285176 Post edited:
fixed the last paragraph
over 1 year ago
Edit Post #285176 Post edited:
clarified the title
over 1 year ago
Edit Post #285176 Initial revision over 1 year ago
Question Dealing with GETs with long query strings in ASP.NET Core
One of the recent business requirements is to be able to search through a list of entities using a bunch of filters. Most of these filters allow multiple values and the user might theoretically provide more than 100 selected filter values (some of the filters are even implemented as tree views due to...
(more)
over 1 year ago
Comment Post #285169 Before trying to understand the code, it would be better to understand the concept. Example: https://www.geeksforgeeks.org/linked-list-set-1-introduction/
(more)
over 1 year ago
Edit Post #285162 Post edited:
fixed code + added relevant tags
over 1 year ago
Edit Post #285118 Post edited:
properly formatted the code
over 1 year ago
Edit Post #285104 Post edited:
properly formatted the code
over 1 year ago
Edit Post #285100 Post edited:
made the title match the content
over 1 year ago
Comment Post #285100 Welcome to Software Codidact. Please avoid pasting images of code or errors, if they can be simply pasted as text. More details [here](https://software.codidact.com/posts/284871).
(more)
over 1 year ago
Comment Post #284612 @#54212 Yes, that's basically a duplicate. I cannot close it as duplicate (cannot provide a link outside of this community), but I have added a note.
(more)
over 1 year ago
Edit Post #284612 Post edited:
add duplication comment
over 1 year ago
Edit Post #285068 Post edited:
added relevant tag
over 1 year ago
Comment Post #285054 @#53196 Yes, you are right. However, since the post does not contain the whole relevant code, I was wondering about the actual issue. I feel that this might be an XY problem, but it is impossible to tell without more code.
(more)
over 1 year ago
Comment Post #285054 Ref. to "the input isn't recognized (the form won't be submitted)" - this sounds strange. When a form is submitted, all its values (except the disabled controls one I guess) should be posted. Normally, there should be no need for explicit event dispatching, unless there is a particular way to impleme...
(more)
over 1 year ago
Edit Post #285054 Post edited:
added relevant tags
over 1 year ago
Comment Post #285019 Until the relevant HTML and the entire JS code are provided, it is virtually impossible to answer this question, so I have closed this question. Of course, once it becomes answerable, I will reopen it.
(more)
over 1 year ago
Edit Post #285019 Question closed over 1 year ago
Edit Post #285021 Post edited:
minor fix
over 1 year ago
Edit Post #285021 Initial revision over 1 year ago
Question Handling high frequency requests with cancellations in an ASP.NET Core application
Issue I have recently discussed with a friend a performance issue he and his colleagues have encountered in an ASP.NET Core 5 application (a checkout app, microservices architecture). The problematic flow is related to computing the prices of basket items. The computation may take more than it ...
(more)
over 1 year ago
Comment Post #281308 @#36356 Yes, I was confused. I have removed the tag. Thanks.
(more)
over 1 year ago
Edit Post #281308 Post edited:
removed irrelevant tag
over 1 year ago
Edit Post #281308 Post edited:
remove irrelevant tag + added relevant one
over 1 year ago
Edit Post #285019 Post edited:
added relevant tags
over 1 year ago
Edit Post #284985 Post edited:
added note
over 1 year ago
Edit Post #284985 Initial revision over 1 year ago
Answer A: Questions easily answered by studying a beginner-level book
I would have a separation between what is on-topic / offtopic and what is worth upvoting or downvoting. Thus for the specific case of questions showing no research, but are on-topic, I would consider downvoting, not closing (more details in this suggestion which received mixed reactions). If I ...
(more)
over 1 year ago
Edit Post #284980 Post edited:
added relevant tag
over 1 year ago
Edit Post #284977 Post edited:
narrowed down the scope of the question
over 1 year ago
Edit Post #284977 Post edited:
added relevant tag
over 1 year ago
Edit Post #284935 Post edited:
added relevant tags
over 1 year ago
Comment Post #284935 "When you update the DOM, the reflow and repaint happen. Every time the DOM changes, the browser needs to recalculate the CSS, do a layout and repaint the web page." - [credit](https://stackoverflow.com/a/60201343/2780791).
(more)
over 1 year ago
Edit Post #284898 Post edited:
over 1 year ago
Comment Post #284872 Yes, good idea. I have already edited the "How to ask a great question" section. I guess that if we want to change this section in a consistent way across the whole network, I guess that this can be announced in the moderator-lounge so that moderators apply the change to their community page.
(more)
over 1 year ago
Edit Post #277136 Post edited:
added paragraph about avoiding images of code
over 1 year ago
Comment Post #284904 That's an interesting idea. I would call them "properties" instead (this might be better for devs, but worse for the general population though). For each post type, we could define (only moderators and staff) what properties are allowed for its answers. Example: Software general posts can have a prop...
(more)
over 1 year ago
Edit Post #284872 Post edited:
added SO source
over 1 year ago
Edit Post #284872 Initial revision over 1 year ago
Answer A: Why using images for code, errors, logs or similar should be avoided?
There are multiple reasons why using images of code, errors, logs and other text resources used in programming instead of the actual text is strongly discouraged. Shortly put, the question should be written in a form that helps both the fellow community members to answer it (e.g. easy to copy-pas...
(more)
over 1 year ago
Edit Post #284871 Initial revision over 1 year ago
Question Why using images for code, errors, logs or similar should be avoided?
I have noticed that virtually any question containing an image of some code or error got a comment asking to replace it with the actual code, error text. Why is it so bad to include an image instead of the actual text?
(more)
over 1 year ago
Edit Post #284378 Post edited:
Changed to on-topic list based on feedback
over 1 year ago
Edit Post #284832 Post edited:
added relevant tags
over 1 year ago
Edit Post #284806 Post edited:
removed non-applicable tag
over 1 year ago
Edit Post #284811 Post edited:
added relevant tags
over 1 year ago
Edit Post #284806 Post edited:
added relevant tag
over 1 year ago
Comment Post #284806 Can you provide the actual waiting time for running your code? Example: run your code for 10K times and tell us how much it took to end.
(more)
over 1 year ago
Comment Post #284803 Can you please replace the picture of the code with the actual code? This helps with copy-paste of your code in order for folks to check it and provide an answer.
(more)
over 1 year ago
Edit Post #284803 Post edited:
added the question from own answer in the original post
over 1 year ago
Edit Post #284805 Post edited:
removed the additional question from the answer
over 1 year ago
Edit Post #284778 Post edited:
added relevant tag
over 1 year ago
Comment Post #284778 Hey, Fyoni‭! Welcome to Software Codidact. I am not sure if I understand correctly. Do you want to display the cart items grouped by store, in a two-level tree (view)? If this is what you want, please check [this](https://www.w3schools.com/howto/howto_js_treeview.asp) and [this](https://www.ph...
(more)
over 1 year ago
Comment Post #284747 Can you please also provide some explanation besides the code? This helps future readers understand the proposed solution.
(more)
over 1 year ago
Comment Post #278899 @#53023 Currently there is no automatic way to migrate a Q&A from a community to another. Can you please create a self-answered Q&A directly there (add a question, copy-paste from here, and add your answer to it)? Following this, I will edit the question here to include a link to the new location. Th...
(more)
over 1 year ago
Edit Post #284708 Post edited:
added relevant tags
over 1 year ago
Edit Post #284661 Initial revision over 1 year ago
Answer A: What solutions available for a CMS-agnostic contact form?
Besides the aforementioned solutions, Web components might be useful (can be reused in multiple contexts). Examples: - in Drupal - in ButterCMS - in Backdrop CMS - in WordPress However, if your form is not convoluted, I would also consider using the default form module provided by your CMS,...
(more)
over 1 year ago
Edit Post #284612 Post edited:
encoded tag
over 1 year ago
Edit Post #284646 Post edited:
added relevant tag
over 1 year ago
Edit Post #284612 Post edited:
fixed the issue
over 1 year ago
Edit Post #284612 Initial revision over 1 year ago
Question Specify framework / library version in the answer
As Stack Exchange (Stack Overflow mostly) is struggling to deal with outdated answers, they came with a proposal that we can learn from: Version labels for answers As already most of the feedback indicates, the proposed solution seems convoluted and thus hard to implement. Software Codidact...
(more)
over 1 year ago
Edit Post #284607 Initial revision over 1 year ago
Question What are the disadvantages of using SQL Server Replication - Transactional Replication type?
The context A reports related process is directly reading the production operational database once about two hours. This involves reading all the data from some 70 tables which takes a couple minutes to complete. My manager suggested that this is not OK and I concur also from a technical persp...
(more)
over 1 year ago
Edit Post #284444 Post edited:
added relevant tag
over 1 year ago
Edit Post #282832 Post edited:
removed very broad question (What does OOP actually mean?)
over 1 year ago
Edit Post #284554 Post edited:
added relevant reference
over 1 year ago
Edit Post #284554 Initial revision over 1 year ago
Question Is there any justification for having a single tempdb database to be used by all databases on a SQL Server intstances?
Despite the fact that I have programmed against SQL Server for quite a while I did not pay much attention to the `tempdb` database. This is especially true if application logic is mostly written using the ORM instead of stored procedure. However, I have just realized that the SQL Server architectu...
(more)
over 1 year ago
Edit Post #284553 Initial revision over 1 year ago
Question Are there any downsides related to using Maybe or Optional monads instead of nulls?
I have recently stumbled across the Maybe (or Optional) modal usage in .NET Code: - example code or this one - example article Based on everything I read, there are multiple advantages on relying Maybe instead of nulls: - no `NullReferenceException`s - leverage (some of) the functional p...
(more)
over 1 year ago
Comment Post #284549 @#53305 That's a good point and I have edited my answer. Thanks.
(more)
over 1 year ago
Edit Post #284549 Post edited:
narrowed down the second point as suggested in the comments
over 1 year ago
Edit Post #284549 Initial revision over 1 year ago
Answer A: Why did my question get a downvote?
For me the following reasons might lead to downvoting: - Posts that are not related to a specific programming issue, but are rather meant to start a discussion. Example - Asking for software products differences, unless it is directly connected to software development and asks about one or very...
(more)
over 1 year ago
Edit Post #284548 Initial revision over 1 year ago
Question Why did my question get a downvote?
Currently, there is no consensus about whether to provide tooltips for the voting buttons (especially the downvote one). However, the community now includes quite a lot of questions that attracted downvotes and sometimes this created long debates in comments and flagging. I would like for us to de...
(more)
over 1 year ago
Edit Post #284481 Post edited:
added relevant tags
over 1 year ago
Edit Post #284370 Post edited:
added relevant tag
over 1 year ago
Edit Post #284370 Post edited:
replaced tag with a more relevant one
over 1 year ago
Edit Post #284370 Post edited:
removed non-applicable tag
over 1 year ago
Edit Post #284357 Post edited:
added relevant tag
over 1 year ago
Edit Post #284357 Post edited:
added relevant tag
over 1 year ago
Comment Post #284465 Can you please replace images with actual code / output text?
(more)
over 1 year ago
Comment Post #284379 I have removed the comments in this thread. Please do not use the comments on a certain question to discuss issues about other posts.
(more)
over 1 year ago
Comment Post #284402 Based on your answer, I added some information to the What type of questions can I ask here? section. Thanks.
(more)
over 1 year ago
Edit Post #284424 Post edited:
added relevant tag
over 1 year ago
Comment Post #284424 hkotsubo‭ added the code in the question. Please [edit](https://software.codidact.com/posts/284424/edit) for changes to your questions, instead of posting an answer. I have already removed the answer as the code is visible in the post now.
(more)
over 1 year ago
Edit Post #278625 Post edited:
added on-topic item about troubleshooting applications used for software development
over 1 year ago
Comment Post #284415 Is [this documentation](https://developer.mozilla.org/en-US/docs/Web/API/Element/innerHTML) helpful? It provides multiple use-cases with examples.
(more)
over 1 year ago
Comment Post #284378 @#36356 Yes, but the flag was very useful for discussing this situation, because it happens very often to developers to run into trouble while installing IDEs, packages etc. Lundin already provided great insight into how to approach this and I will update the What type of questions can I ask here? se...
(more)
over 1 year ago
Edit Post #284379 Post edited:
added relevant tag
over 1 year ago
Edit Post #284394 Post edited:
added relevant tag
over 1 year ago
Edit Post #284378 Initial revision over 1 year ago
Question Should we allow questions about installation and configuration of software development tools?
A recent flag for this question suggested that it would be a better fit for the Linux community. There is no motivation provided, but I guess it is related to the fact that most of the question and the answer deal with installing various packages using Ubuntu's package manager. However, the quest...
(more)
over 1 year ago
Edit Post #284353 Initial revision over 1 year ago
Answer A: Get the length of a slice from a multi-dimensional array
I think what you are looking for is Array.GetLength which: > gets a 32-bit integer that represents the number of elements in the specified dimension of the Array.
(more)
over 1 year ago
Edit Post #284345 Post edited:
added relevant tags
over 1 year ago
Comment Post #284345 @#53207 Please promote your comment to an answer since it is clearly an answer to OP's question.
(more)
over 1 year ago
Edit Post #284343 Post edited:
added ubuntu tag, as the issue seems to be related to how the OS is configured
over 1 year ago
Edit Post #284320 Post edited:
added relevant tags
over 1 year ago
Edit Post #284260 Post edited:
added relevant tags
over 1 year ago
Edit Post #284246 Post edited:
added relevant tag
over 1 year ago
Edit Post #284245 Post edited:
minor fixes
over 1 year ago
Edit Post #284245 Initial revision over 1 year ago
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 1 year ago
Comment Post #284243 I have changed the title to what I think is better summarising the content. Feel free to change something more appropriate if it does not fit your needs.
(more)
over 1 year ago
Edit Post #284243 Post edited:
clarified the title
over 1 year ago
Edit Post #284216 Post edited:
added relevant tags
over 1 year ago
Edit Post #282065 Post edited:
added relevant tag
over 1 year ago
Edit Post #284220 Post edited:
added relevant tags
over 1 year ago
Edit Post #284184 Question closed over 1 year ago
Comment Post #284183 What web server are you using? I think that the application type does not matter in this case and how the web server allows integration with monitoring tools is relevant here.
(more)
over 1 year ago
Comment Post #284160 Which browser did you use to "display" the XML? If I remember correctly, some of them display a "pretty-print" version by default, even if no schema is specified.
(more)
over 1 year ago
Comment Post #283975 @#36363 If you managed to make it work, please include an answer containing the solution, so that future users benefit from it. Thanks.
(more)
over 1 year ago
Edit Post #283975 Post edited:
removed irrelevant tag
over 1 year ago
Comment Post #283975 OK. Does locally including (executing) a remote JS work for you? Check [this](https://stackoverflow.com/questions/779739/how-do-i-include-a-remote-javascript-file-in-a-greasemonkey-script)
(more)
over 1 year ago
Comment Post #283975 [This answer](https://superuser.com/a/2815/530691) also shows how to trick Greasemonkey to work with the same shared location regardless of browser/machine.
(more)
over 1 year ago
Comment Post #283975 Not sure what you are asking here. Do you want to manage the user script in a single place and have it sync on multiple browsers? Greasemonkey seems to support that [here](https://www.greasespot.net/2013/09/firefox-sync-coming-to-greasemonkey.html).
(more)
over 1 year ago
Edit Post #283830 Post edited:
over 1 year ago
Comment Post #283830 Based on this discussion I have decided to scrap [console.readline] at tag the question with [stdin] instead.
(more)
over 1 year ago
Comment Post #283912 I am not sure why it fails for you (does switching to HTTP makes it work?), but I do not think it is the correct approach. You might try getting a new token on expiration as indicated [here](https://stackoverflow.com/a/62340222/2780791).
(more)
over 1 year ago
Edit Post #281148 Post edited:
added relevant tag
over 1 year ago
Comment Post #283876 Yes, googling for linewise-read retrieves results about how to read line by line in all sort of languages, so it seems to do the job. Thanks.
(more)
over 1 year ago
Edit Post #283876 Post edited:
fixed a paragraph
over 1 year ago
Edit Post #283876 Initial revision over 1 year 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 1 year ago
Edit Post #283849 Post edited:
added relevant tag
over 1 year ago
Edit Post #283842 Post edited:
simplified the answer
over 1 year ago
Edit Post #283842 Post edited:
over 1 year ago
Edit Post #283842 Initial revision over 1 year 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 1 year ago
Edit Post #283839 Post edited:
added relevant tag + simplified the title
over 1 year ago
Edit Post #281148 Post edited:
added relevant tag
almost 2 years ago
Edit Post #283592 Post edited:
added relevant tag + minor typo fix
almost 2 years ago
Edit Post #283596 Post edited:
added relevant tags
almost 2 years ago
Edit Post #283615 Post edited:
added relevant tag
almost 2 years ago
Edit Post #283670 Post edited:
added relevant tag
almost 2 years ago
Edit Post #283711 Post edited:
added relevant tags
almost 2 years ago
Edit Post #283059 Post edited:
removed empty url reference
almost 2 years ago
Comment Post #283412 I have added the GitHub issue as a reference (if I understood correctly the missing dependency is installed using a different package manager, but it is the same package).
(more)
almost 2 years ago
Edit Post #283412 Post edited:
minor fix + added reference
almost 2 years ago
Comment Post #283198 It works for me, but I am a mod. Tried with a regular user on the development environment and it indeed does not work as expected: https://a.dev.codidact.org/posts/186/187#answer-187
(more)
almost 2 years ago
Edit Post #283050 Question closed almost 2 years ago
Edit Post #282843 Initial revision almost 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 2 years ago
Comment Post #282828 I had to remove the comments that are clearly not helpful / not relevant to the question. Please use comments to provide constructive criticism related to the question. I have temporarily locked this thread for cooldown.
(more)
almost 2 years ago
Comment Post #282828 As written, this question is quite unclear and very general as it asks about concepts that are used in many programming languages. We expect questions to be more focused.
(more)
almost 2 years ago
Edit Post #282828 Question closed almost 2 years ago
Edit Post #282806 Post edited:
almost 2 years ago
Edit Post #282806 Post edited:
clarified the title
almost 2 years ago
Edit Post #282806 Initial revision almost 2 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 2 years ago
Edit Post #282752 Post edited:
added relevant tags
almost 2 years ago
Comment Post #282708 (2 / 2) Also, a question about best practices without "best" criteria being provided or it appears that it cannot be answered using references or expertise consensus. By its own it is offtopic, but a good answer is possible (makes some assumptions, most likely requiring a question edit to make the qu...
(more)
almost 2 years ago
Comment Post #282708 (1 / 2) I think there is a gray area here. As an example, a question being off-topic because "asking for implementing a certain feature (or homework). You should include your (partially working) trials in the post" can receive a good answer. This does not make the answer "off-topic".
(more)
almost 2 years ago
Comment Post #282732 Some changes might be done using CSS &:before or &:after, but they are very limited. Example: https://stackoverflow.com/a/34938065/2780791
(more)
almost 2 years ago
Edit Post #282720 Initial revision almost 2 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 2 years ago
Edit Post #282714 Post edited:
clarified the post a little bit
almost 2 years ago
Edit Post #282708 Initial revision almost 2 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 2 years ago
Edit Post #282691 Post edited:
added relevant tag
almost 2 years ago
Edit Post #282685 Post edited:
added relevant tag
almost 2 years ago
Edit Post #282682 Initial revision almost 2 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 2 years ago
Comment Post #282573 I have checked the code and your idea worked as expected. I have also included the code that showed me meaningful target frameworks for most of my assemblies. Indeed some Microsoft.* assemblies are targeting 3.0 or 3.1. I am wondering if .NET Standard 2.0 as a target is an issue here (as opposed to 2...
(more)
almost 2 years ago
Edit Post #282573 Post edited:
added a fully working example
almost 2 years ago
Edit Post #282599 Post edited:
re-added tag
almost 2 years ago
Comment Post #282599 I tried changing the title to a more suggestive one. Since this is the first time I ever heard about Nannou, I hope I managed to catch the nature of the issue in the post.
(more)
almost 2 years ago
Edit Post #282599 Post edited:
almost 2 years ago
Edit Post #282599 Post edited:
Tried to put a more meaningful title for the issue
almost 2 years ago
Comment Post #282581 It might be relevant to mention the application type. I guess you are not using a Single Application Page with client-side routing and each stage means a full page refresh, right? (server-side rendering)
(more)
almost 2 years ago
Edit Post #282581 Post edited:
minor fixes
almost 2 years ago
Edit Post #282581 Post edited:
added relevant tag
almost 2 years ago
Comment Post #282558 @#53922 This question is OK for Software Codidact, why migrate it?
(more)
almost 2 years ago
Comment Post #282573 I cannot check it right now, but I will try it and let you know what I was able to find out. Thanks.
(more)
almost 2 years ago
Edit Post #281511 Post edited:
added relevant tag
almost 2 years ago
Comment Post #282044 @#53305 I have renamed libxml to libxml2 and I will let libxml1 be created should anyone feels a need for it.
(more)
almost 2 years ago
Edit Post #282569 Initial revision almost 2 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 2 years ago
Comment Post #282044 I am trying to write the usage information about the libxml tag and it is not clear if libxml or libxml2 should be used. A quick search suggests libxml2 much more often used and this also seems to be the main tag on SO (libxml is a synonym).
(more)
almost 2 years ago
Edit Post #282044 Post edited:
added relevant tag
almost 2 years ago
Comment Post #282541 For testing, I guess [Cucumber](https://cucumber.io/) or similar would be a good choice since the rules are written in a way compatible with the examples provided in the post.
(more)
almost 2 years ago
Comment Post #282558 Most if not all examples seem to be general purpose languages, rather than fit to manage business rules. When I saw the question, I thought about Cucumber, but I do not have any experience with it and I cannot understand if it can be used to process business rules or only to check them (for testing)....
(more)
almost 2 years ago
Comment Post #282544 In order to receive better feedback, you need to provide your attempt at computing the student with the top mark. Currently, your code is just parsing the CSV and displaying the data in the console.
(more)
almost 2 years ago
Edit Post #282532 Post edited:
added relevant tags
almost 2 years ago
Comment Post #282540 I have never known that HTML imports even existed before this answer was posted. Back in the days when I was working with PHP, I solely relied only on includes.
(more)
almost 2 years ago
Comment Post #282535 Yes. I was thinking about framework or library features. I have clarified that. 10x.
(more)
almost 2 years ago
Edit Post #282535 Post edited:
Clarified the ontopic for feature
almost 2 years ago
Edit Post #282536 Post edited:
almost 2 years ago
Comment Post #282536 Yes, I have already performed several tag-merges so far and this is one of those cases. However, it happened once that I renamed a tag and it did not work. If I remember correctly, several months ago it was actually possible to rename a tag to an existing name, thus getting duplicate tag names.
(more)
almost 2 years ago
Edit Post #282536 Post edited:
retagged as feature request
almost 2 years ago
Edit Post #282536 Initial revision almost 2 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 2 years ago
Edit Post #282535 Initial revision almost 2 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 2 years ago
Edit Post #282512 Initial revision almost 2 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 2 years ago
Edit Post #282504 Post edited:
added relevant tag
almost 2 years ago
Edit Post #282206 Post edited:
almost 2 years ago
Edit Post #282463 Post edited:
added relevant tags
almost 2 years ago
Edit Post #282465 Post edited:
added relevant tags
almost 2 years ago
Comment Post #282381 That's a good idea. Having clear names like ArchivedOrder is OK as I can still map to something that makes sense in DB like arc.Order, as I want to define a separate schema for these tables. 10x.
(more)
almost 2 years ago
Comment Post #282332 Yes, I have edited my question to include more information. Basically, the more DbSets with similar names, the more the chance to use the wrong one, especially given the fact that the archive related ones will be (almost) identical to the "operational" ones. I am inclined towards the EF approach, but...
(more)
almost 2 years ago
Edit Post #282332 Post edited:
explained the cons of EF approach
almost 2 years ago
Edit Post #282332 Initial revision almost 2 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 2 years ago
Comment Post #282270 @Istiak Yes, Code Review requires code that works ("does the job"), but requires review (improvements, patterns, performance, readability etc.). Currently, the provided code does not work as expected, so it is a good fit here (on main Q&A).
(more)
almost 2 years ago
Comment Post #282206 @Lundin I think tags now have case simply because by default string are input with a case (textboxes allow this by default and I guess this also happens in the database). I don't remember to have ever seen any upper-case letter for SO tags and I think we should always use lowercase in the tag names.
(more)
almost 2 years ago
Comment Post #282206 I have fixed the tag name. Thanks.
(more)
almost 2 years ago
Edit Post #282230 Initial revision almost 2 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 2 years ago
Edit Post #282203 Post edited:
added relevant tag
almost 2 years ago
Edit Post #282121 Post edited:
removed a server name from the post
almost 2 years ago
Edit Post #282121 Initial revision almost 2 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 2 years ago
Edit Post #282119 Post edited:
added relevant tag
almost 2 years ago
Edit Post #281659 Post edited:
switched tag to have less redundancy
almost 2 years 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)
almost 2 years ago
Edit Post #281659 Post edited:
added relevant tag
almost 2 years ago
Edit Post #282023 Post edited:
added relevant tags
almost 2 years ago
Edit Post #282079 Post edited:
almost 2 years ago
Edit Post #282083 Post edited:
added relevant tags
almost 2 years 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)
almost 2 years ago
Edit Post #282050 Post edited:
added reference to OpenAI community
almost 2 years ago
Edit Post #282050 Initial revision almost 2 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 2 years ago
Edit Post #282044 Post edited:
added relevant tags
almost 2 years ago
Edit Post #282019 Post edited:
added breaking change text
almost 2 years ago
Edit Post #282019 Initial revision almost 2 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 2 years ago
Edit Post #282018 Initial revision almost 2 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 2 years 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)
almost 2 years ago
Edit Post #281991 Post edited:
added relevant tag
almost 2 years ago
Edit Post #278622 Post undeleted almost 2 years ago
Edit Post #281928 Initial revision about 2 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)
about 2 years ago
Edit Post #278578 Post undeleted about 2 years ago
Edit Post #278572 Post undeleted about 2 years ago
Edit Post #278570 Post undeleted about 2 years ago
Edit Post #278325 Post undeleted about 2 years ago
Edit Post #278762 Post undeleted about 2 years ago
Edit Post #278532 Post undeleted about 2 years ago
Edit Post #278361 Post undeleted about 2 years ago
Edit Post #278360 Post undeleted about 2 years ago
Edit Post #277933 Post undeleted about 2 years ago
Edit Post #278367 Post undeleted about 2 years ago
Edit Post #278334 Post undeleted about 2 years ago
Edit Post #278333 Post undeleted about 2 years ago
Edit Post #277931 Post undeleted about 2 years ago
Edit Post #277930 Post undeleted about 2 years ago
Edit Post #278576 Post undeleted about 2 years ago
Edit Post #277262 Post undeleted about 2 years 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)
about 2 years ago
Edit Post #281859 Initial revision about 2 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)
about 2 years ago
Edit Post #281817 Post edited:
added relevant tags
about 2 years ago
Edit Post #281853 Initial revision about 2 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)
about 2 years ago
Edit Post #281797 Post edited:
added more information
about 2 years ago
Edit Post #281797 Initial revision about 2 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)
about 2 years ago
Comment Post #281762 This question is being referenced by [a Power Users meta post](https://powerusers.codidact.com/posts/281782).
(more)
about 2 years ago
Edit Post #281784 Initial revision about 2 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)
about 2 years 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 2 years ago
Edit Post #281762 Question closed about 2 years ago
Edit Post #281762 Post edited:
about 2 years ago
Edit Post #281762 Post edited:
Replaced title with a clear question
about 2 years 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 2 years ago
Edit Post #281730 Question closed about 2 years 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 2 years 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 2 years ago
Edit Post #281624 Initial revision about 2 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)
about 2 years ago
Edit Post #281616 Initial revision about 2 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)
about 2 years 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 2 years ago
Edit Post #281605 Post edited:
added tsql tag
about 2 years 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 2 years ago
Edit Post #281605 Initial revision about 2 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)
about 2 years ago
Edit Post #281604 Initial revision about 2 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)
about 2 years ago
Edit Post #281566 Post edited:
about 2 years ago
Edit Post #281566 Post edited:
fixed the old text
about 2 years ago
Edit Post #281566 Post edited:
added response to the actual question
about 2 years ago
Edit Post #281566 Initial revision about 2 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)
about 2 years 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 years 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 years ago
Edit Post #281560 Post edited:
added call for action
about 2 years ago
Edit Post #281560 Initial revision about 2 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)
about 2 years 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 years 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 years ago
Comment Post #281517 This question is being discussed on [meta](https://software.codidact.com/posts/281528).
(more)
about 2 years ago
Edit Post #281531 Post edited:
fixed the link
about 2 years 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 years 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 years ago
Edit Post #281531 Initial revision about 2 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 2 years ago
Edit Post #281528 Post edited:
added relevant tag
about 2 years ago
Edit Post #281530 Initial revision about 2 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 2 years 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 years 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 years 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 years 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 years ago
Comment Post #281506 I think the issue is this one: https://github.com/codidact/qpixel/issues/268
(more)
about 2 years ago
Edit Post #281486 Post edited:
about 2 years 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 years 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 years 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 years ago
Edit Post #281484 Post edited:
Made the title a little bit clear
about 2 years ago
Edit Post #281464 Post edited:
added relevant tag
about 2 years ago
Edit Post #281301 Nominated for promotion about 2 years ago
Edit Post #281341 Nominated for promotion about 2 years ago
Edit Post #281415 Nominated for promotion about 2 years 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 years ago
Edit Post #281448 Post undeleted about 2 years ago
Edit Post #281448 Post edited:
about 2 years ago
Edit Post #281448 Post edited:
about 2 years ago
Edit Post #281448 Post deleted about 2 years ago
Edit Post #281448 Post edited:
about 2 years ago
Edit Post #281448 Post edited:
about 2 years ago
Edit Post #281448 Initial revision about 2 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 2 years ago
Edit Post #281385 Post edited:
about 2 years 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)
about 2 years ago
Comment Post #281385 Possible interesting reading: https://cybersecurity.ieee.org/blog/2016/06/02/design-best-practices-for-an-authentication-system/
(more)
about 2 years ago
Edit Post #281381 Initial revision about 2 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 2 years ago
Edit Post #281365 Question closed about 2 years 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)
about 2 years ago
Edit Post #281341 Post edited:
added relevant tag
about 2 years 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)
about 2 years 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)
about 2 years 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)
about 2 years ago
Edit Post #281301 Initial revision about 2 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 2 years 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)
about 2 years 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)
about 2 years ago
Comment Post #281253 That playground is awesome. Also, I think that grouping the affected controls in a FormGroup makes perfect sense. Thanks.
(more)
about 2 years 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)
about 2 years ago
Edit Post #281232 Initial revision about 2 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 2 years 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)
about 2 years ago
Edit Post #281202 Post edited:
added the jQuery way
about 2 years ago
Edit Post #281202 Initial revision about 2 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 2 years 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)
about 2 years ago
Edit Post #281200 Initial revision about 2 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 2 years ago
Comment Post #281193 Have you tried using a heredoc string? https://stackoverflow.com/a/1848974
(more)
about 2 years ago
Edit Post #281192 Post edited:
fixed migrations table name
about 2 years ago
Edit Post #281192 Initial revision about 2 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 2 years ago
Edit Post #281188 Initial revision about 2 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 2 years ago
Comment Post #281180 @JohnDoea Yes, I think that is the way to define the message content type.
(more)
about 2 years ago
Edit Post #281180 Initial revision about 2 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 2 years ago
Edit Post #281171 Post edited:
removed rude acronym
about 2 years 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)
about 2 years 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)
about 2 years 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)
about 2 years 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)
about 2 years ago
Edit Post #281148 Post edited:
added relevant tag
about 2 years 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)
about 2 years ago
Edit Post #281058 Post edited:
added relevant tags
about 2 years ago
Comment Post #281049 I think "traditional" is more appropriate than "standard" (see [International email](https://en.wikipedia.org/wiki/International_email) ).
(more)
about 2 years 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)
about 2 years ago
Comment Post #281043 [This] might (https://stackoverflow.com/a/32413860/2780791) be relevant if my guess is right.
(more)
about 2 years 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)
about 2 years 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)
about 2 years 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)
about 2 years ago
Edit Post #280998 Post edited:
added further details for the question
about 2 years ago
Edit Post #280998 Initial revision about 2 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 2 years ago
Edit Post #280985 Initial revision about 2 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 2 years 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)
about 2 years ago
Edit Post #280977 Question closed about 2 years ago
Edit Post #280975 Question closed about 2 years 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)
about 2 years 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)
about 2 years ago
Edit Post #280974 Question closed about 2 years 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)
about 2 years ago
Edit Post #280978 Initial revision about 2 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 2 years ago
Edit Post #278625 Post edited:
added missing on-topic type about troubleshooting
about 2 years 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)
about 2 years 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)
about 2 years ago
Edit Post #280933 Question closed about 2 years ago
Edit Post #280852 Post edited:
over 2 years ago
Edit Post #280852 Initial revision over 2 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)
over 2 years 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)
over 2 years ago
Edit Post #280795 Question closed over 2 years 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)
over 2 years 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)
over 2 years ago
Comment Post #280662 Your question from Software Engineering SE is no longer available (I guess it was removed in the meantime).
(more)
over 2 years 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)
over 2 years ago
Edit Post #280666 Initial revision over 2 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #280624 Initial revision over 2 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #280607 Initial revision over 2 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)
over 2 years ago
Edit Post #279712 Post edited:
removed irrelevant tag
over 2 years ago
Edit Post #279676 Post edited:
removed irrelevant tag
over 2 years ago
Edit Post #280380 Post edited:
over 2 years ago
Edit Post #280222 Post edited:
added relevant tag
over 2 years ago
Edit Post #280528 Post edited:
added relevant tags
over 2 years ago
Edit Post #280523 Initial revision over 2 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 2 years 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)
over 2 years ago
Edit Post #280490 Post edited:
over 2 years ago
Edit Post #280490 Post edited:
over 2 years ago
Edit Post #280380 Post edited:
over 2 years 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)
over 2 years ago
Edit Post #280380 Initial revision over 2 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 2 years ago
Comment Post #280223 Unfortunately, this question is not [about Software Development](https://software.codidact.com/help/on-topic).
(more)
over 2 years ago
Edit Post #280223 Question closed over 2 years ago
Edit Post #280201 Post edited:
added relevant tag
over 2 years 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)
over 2 years ago
Edit Post #280142 Initial revision over 2 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 2 years 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)
over 2 years ago
Edit Post #280097 Initial revision over 2 years 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)
over 2 years ago
Edit Post #280089 Question closed over 2 years 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)
over 2 years ago
Edit Post #278920 Post edited:
added relevant tag
over 2 years ago
Edit Post #277455 Post edited:
added relevant tags
over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #279671 Post edited:
added relevant tag
over 2 years ago
Edit Post #279649 Post edited:
added relevant tag
over 2 years ago
Edit Post #279555 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #279436 Initial revision over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #279424 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279277 Post edited:
added relevant tags
over 2 years ago
Edit Post #279317 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279316 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279187 Post edited:
fixed a typo
over 2 years ago
Edit Post #279187 Post edited:
fixed variable name
over 2 years ago
Edit Post #279187 Post edited:
fixed the link
over 2 years ago
Edit Post #279187 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279144 Post edited:
added relevant tag
over 2 years ago
Edit Post #279097 Post edited:
added tag
over 2 years ago
Edit Post #279146 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279059 Post edited:
added MoreLINQ reference
over 2 years 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)
over 2 years ago
Edit Post #279059 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279058 Post edited:
simplified the query
over 2 years ago
Edit Post #279058 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279034 Post edited:
added relevant tag
over 2 years ago
Edit Post #279051 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278992 Post edited:
added relevant tag
over 2 years ago
Edit Post #279035 Post edited:
Removed irrelevant information
over 2 years 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)
over 2 years ago
Edit Post #279035 Initial revision over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #279002 Post edited:
added relevant tag
over 2 years ago
Edit Post #278695 Post edited:
removed useless tag
over 2 years ago
Edit Post #279014 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279008 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279007 Initial revision over 2 years 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)
over 2 years ago
Edit Post #279006 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278771 Post edited:
added relevant tags
over 2 years ago
Edit Post #278547 Post edited:
added relevant tag
over 2 years ago
Comment Post #278988 @Moshi That would be great and intuitive for anyone using such a feature.
(more)
over 2 years ago
Edit Post #278988 Initial revision over 2 years 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)
over 2 years ago
Comment Post #278982 Not sure, but shrink gets the database to 4GB and reindexing gets it to about ~5GB.
(more)
over 2 years ago
Edit Post #278983 Post edited:
removed meta related tags
over 2 years ago
Edit Post #278982 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278981 Post edited:
added the question
over 2 years ago
Edit Post #278981 Initial revision over 2 years 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)
over 2 years ago
Comment Post #278952 @Moshi That's a good idea. I will raise an issue @ GitHub repo. Thanks.
(more)
over 2 years ago
Edit Post #278959 Post edited:
fixed code alignment
over 2 years ago
Edit Post #278959 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278958 Post edited:
added missing code
over 2 years ago
Edit Post #278958 Initial revision over 2 years 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)
over 2 years ago
Comment Post #278952 @Lundin Automatic removal would be really nice, but current caching makes things really confusing as shown in my example.
(more)
over 2 years ago
Edit Post #278952 Initial revision over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Comment Post #278789 I have fixed it. Thanks.
(more)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Comment Post #278650 This suggestion has been included. Thanks.
(more)
over 2 years ago
Edit Post #278625 Post edited over 2 years 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)
over 2 years ago
Edit Post #278625 Post edited over 2 years 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)
over 2 years ago
Edit Post #278625 Post edited over 2 years 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)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Comment Post #278651 I have applied your suggestion (in a simplified form, as "database design" is repeated). Thanks.
(more)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Comment Post #278787 I have rephrased that item from the help section to correspond to your suggestion. Thanks.
(more)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Comment Post #278786 I have updated the section to reflect your suggestion ("keep it simple"). Thanks.
(more)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Edit Post #278922 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278324 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #277932 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #278322 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #278360 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #278366 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #278523 Post edited:
over 2 years ago
Edit Post #278525 Post edited:
over 2 years ago
Edit Post #278531 Post edited:
over 2 years ago
Edit Post #278567 Post edited:
over 2 years ago
Edit Post #278569 Post edited:
added relevant tag
over 2 years ago
Edit Post #278571 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #278565 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #278584 Post edited:
replaced tags with more meaningful ones
over 2 years ago
Edit Post #278527 Post edited:
added relevant tag
over 2 years ago
Edit Post #278324 Post edited:
added relevant tag
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278899 Question reopened over 2 years 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)
over 2 years ago
Edit Post #278899 Question closed over 2 years 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)
over 2 years ago
Edit Post #278335 Post edited:
over 2 years ago
Edit Post #278335 Post edited:
over 2 years 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)
over 2 years ago
Edit Post #278892 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278292 Post edited:
added tag
over 2 years ago
Edit Post #278208 Post edited:
replaced with more specific tag
over 2 years ago
Edit Post #278832 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278831 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #277962 Post undeleted over 2 years ago
Edit Post #277962 Post deleted over 2 years ago
Edit Post #277860 Post edited:
removed the inappropriate picture
over 2 years 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)
over 2 years ago
Comment Post #277536 @jrh I have removed our last comments because they provide no value for the question.
(more)
over 2 years ago
Edit Post #277856 Post edited:
added tag
over 2 years 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)
over 2 years ago
Edit Post #278780 Initial revision over 2 years 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)
over 2 years ago
Edit Post #277536 Post edited:
removed irrelevant tags + added one
over 2 years ago
Edit Post #277474 Post edited:
added tag
over 2 years 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)
over 2 years ago
Edit Post #277441 Post edited:
added tag
over 2 years ago
Edit Post #278755 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278754 Initial revision over 2 years 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)
over 2 years ago
Comment Post #278727 @Monica Cellio - yes, you are right: there are two aspects. I would use url-rewritting + iis.
(more)
over 2 years ago
Edit Post #278668 Post edited:
fixed the max width for UTF-8
over 2 years 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)
over 2 years ago
Edit Post #278728 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278727 Initial revision over 2 years 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)
over 2 years ago
Edit Post #277375 Post edited:
added tags
over 2 years ago
Edit Post #277259 Post edited:
added tag + using lower case tag names only
over 2 years ago
Edit Post #278695 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278694 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278693 Initial revision over 2 years 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)
over 2 years ago
Edit Post #277415 Post edited:
added relevant tags
over 2 years 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)
over 2 years ago
Edit Post #278668 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #277303 Post edited:
over 2 years ago
Edit Post #277310 Post edited:
over 2 years ago
Edit Post #277310 Post edited:
added tag
over 2 years ago
Edit Post #277485 Post edited:
added explicit SO reference name
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Edit Post #278625 Post edited over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #277930 Post edited:
made the reference more clear
over 2 years ago
Edit Post #278324 Post edited:
made the reference more clear
over 2 years ago
Edit Post #278527 Post edited:
made the reference more clear
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Edit Post #278628 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Edit Post #278625 Post edited over 2 years ago
Edit Post #277148 Post edited:
added relevant tags
over 2 years ago
Edit Post #277131 Post edited over 2 years ago
Edit Post #277131 Post edited over 2 years ago
Edit Post #277131 Post edited over 2 years ago
Edit Post #278591 Initial revision over 2 years 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)
over 2 years ago
Edit Post #277216 Post edited:
over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278549 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278474 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278473 Post edited:
Removed irrelevant information + clarified the title
over 2 years ago
Edit Post #278468 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278467 Initial revision over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278285 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278208 Post edited:
over 2 years ago
Edit Post #278208 Post edited:
over 2 years ago
Edit Post #278197 Post edited:
over 2 years ago
Edit Post #278197 Post edited:
over 2 years 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)
over 2 years ago
Edit Post #278203 Post edited:
improved readability
over 2 years ago
Edit Post #278197 Post edited:
added tags + expanded acronym
over 2 years ago
Edit Post #278208 Post edited:
added relevant tag + minor edit
over 2 years ago
Edit Post #278224 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278151 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278128 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #278083 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278082 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278081 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278080 Initial revision over 2 years 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)
over 2 years ago
Edit Post #278063 Initial revision over 2 years 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 woul[]()d like to add the information for some of these tags, but I do not see how. I assume there is some kind of privilege for this or the function is n...
(more)
over 2 years ago
Edit Post #278031 Post edited over 2 years ago
Edit Post #277967 Post edited over 2 years ago
Suggested Edit Post #277967 Suggested edit:
added tags
(more)
helpful over 2 years ago
Suggested Edit Post #278034 Suggested edit:
added tag
(more)
declined over 2 years ago
Suggested Edit Post #278031 Suggested edit:
added tags
(more)
helpful over 2 years 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)
over 2 years ago
Edit Post #277980 Post edited:
over 2 years ago
Edit Post #277980 Initial revision over 2 years 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)
over 2 years ago
Edit Post #277979 Initial revision over 2 years 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)
over 2 years ago
Edit Post #277946 Post edited:
added more details about the question
over 2 years ago
Edit Post #277946 Post edited:
over 2 years ago
Edit Post #277946 Post edited:
over 2 years ago
Edit Post #277946 Post edited:
fixed the code
over 2 years ago
Edit Post #277946 Initial revision over 2 years 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)
over 2 years 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)
over 2 years ago
Edit Post #277862 Post edited over 2 years ago
Suggested Edit Post #277862 Suggested edit:
added relevant tag
(more)
helpful over 2 years ago
Edit Post #277850 Post edited:
over 2 years ago
Suggested Edit Post #277833 Suggested edit:
Synced the title with the body + added a tag
(more)
declined over 2 years ago
Edit Post #277850 Initial revision over 2 years 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)
over 2 years ago
Edit Post #277551 Initial revision over 2 years 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)
over 2 years 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)
almost 3 years 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)
almost 3 years ago
Edit Post #277485 Post edited:
clarified that number is expressed in days
almost 3 years ago
Edit Post #277485 Initial revision almost 3 years 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)
almost 3 years 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)
almost 3 years ago
Edit Post #277437 Initial revision almost 3 years 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)
almost 3 years ago
Edit Post #277436 Initial revision almost 3 years 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)
almost 3 years ago
Edit Post #277435 Initial revision almost 3 years 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)
almost 3 years ago
Comment Post #277429 @Moshi I am glad. Thanks.
(more)
almost 3 years ago
Edit Post #277429 Initial revision almost 3 years 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)
almost 3 years ago
Edit Post #277428 Initial revision almost 3 years 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)
almost 3 years 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)
almost 3 years ago
Edit Post #277406 Initial revision almost 3 years 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)
almost 3 years ago