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
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)
about 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)
about 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)
about 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)
about 4 years ago
Edit Post #278285 Initial revision about 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)
about 4 years ago
Edit Post #278208 Post edited:
about 4 years ago
Edit Post #278208 Post edited:
about 4 years ago
Edit Post #278197 Post edited:
about 4 years ago
Edit Post #278197 Post edited:
about 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)
about 4 years ago
Edit Post #278203 Post edited:
improved readability
about 4 years ago
Edit Post #278197 Post edited:
added tags + expanded acronym
about 4 years ago
Edit Post #278208 Post edited:
added relevant tag + minor edit
about 4 years ago
Edit Post #278224 Initial revision about 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)
about 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)
about 4 years ago
Edit Post #278151 Initial revision about 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)
about 4 years ago
Edit Post #278128 Initial revision about 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)
about 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)
about 4 years ago
Edit Post #278083 Initial revision about 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)
about 4 years ago
Edit Post #278082 Initial revision about 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)
about 4 years ago
Edit Post #278081 Initial revision about 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)
about 4 years ago
Edit Post #278080 Initial revision about 4 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)
about 4 years ago
Edit Post #278063 Initial revision about 4 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)
about 4 years ago
Edit Post #278031 Post edited about 4 years ago
Edit Post #277967 Post edited about 4 years ago
Suggested Edit Post #277967 Suggested edit:
added tags
(more)
helpful about 4 years ago
Suggested Edit Post #278034 Suggested edit:
added tag
(more)
declined about 4 years ago
Suggested Edit Post #278031 Suggested edit:
added tags
(more)
helpful about 4 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)
about 4 years ago
Edit Post #277980 Post edited:
about 4 years ago
Edit Post #277980 Initial revision about 4 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)
about 4 years ago
Edit Post #277979 Initial revision about 4 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)
about 4 years ago
Edit Post #277946 Post edited:
added more details about the question
about 4 years ago
Edit Post #277946 Post edited:
about 4 years ago
Edit Post #277946 Post edited:
about 4 years ago
Edit Post #277946 Post edited:
fixed the code
about 4 years ago
Edit Post #277946 Initial revision about 4 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)
about 4 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)
about 4 years ago