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
Community Proposals
Community Proposals
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 »

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Activity for Alexei‭

Type On... Excerpt Status Date
Edit Post #278625 Post edited over 4 years ago
Edit Post #278625 Post edited over 4 years ago
Edit Post #277148 Post edited:
added relevant tags
over 4 years ago
Edit Post #277131 Post edited over 4 years ago
Edit Post #277131 Post edited over 4 years ago
Edit Post #277131 Post edited over 4 years ago
Edit Post #278591 Initial revision over 4 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 4 years ago
Edit Post #277216 Post edited:
over 4 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 4 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 4 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 4 years ago
Edit Post #278549 Initial revision over 4 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 4 years ago
Edit Post #278474 Initial revision over 4 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 4 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 4 years ago
Edit Post #278473 Post edited:
Removed irrelevant information + clarified the title
over 4 years ago
Edit Post #278468 Initial revision over 4 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 4 years ago
Edit Post #278467 Initial revision over 4 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 4 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 4 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 4 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 4 years ago
Edit Post #278285 Initial revision over 4 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 4 years ago
Edit Post #278208 Post edited:
over 4 years ago
Edit Post #278208 Post edited:
over 4 years ago
Edit Post #278197 Post edited:
over 4 years ago
Edit Post #278197 Post edited:
over 4 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 4 years ago
Edit Post #278203 Post edited:
improved readability
over 4 years ago
Edit Post #278197 Post edited:
added tags + expanded acronym
over 4 years ago
Edit Post #278208 Post edited:
added relevant tag + minor edit
over 4 years ago
Edit Post #278224 Initial revision over 4 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 4 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 4 years ago
Edit Post #278151 Initial revision over 4 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 4 years ago
Edit Post #278128 Initial revision over 4 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 4 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 4 years ago
Edit Post #278083 Initial revision over 4 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 4 years ago
Edit Post #278082 Initial revision over 4 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 4 years ago
Edit Post #278081 Initial revision over 4 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 4 years ago
Edit Post #278080 Initial revision over 4 years ago