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 |