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 |
|---|---|---|---|---|
| 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 4 years ago |
| Edit | Post #278668 | Initial revision | — | over 4 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 4 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 4 years ago |
| Edit | Post #277303 |
Post edited: |
— | over 4 years ago |
| Edit | Post #277310 |
Post edited: |
— | over 4 years ago |
| Edit | Post #277310 |
Post edited: added tag |
— | over 4 years ago |
| Edit | Post #277485 |
Post edited: added explicit SO reference name |
— | over 4 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 4 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 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 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 4 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 4 years ago |
| Edit | Post #277930 |
Post edited: made the reference more clear |
— | over 4 years ago |
| Edit | Post #278324 |
Post edited: made the reference more clear |
— | over 4 years ago |
| Edit | Post #278527 |
Post edited: made the reference more clear |
— | over 4 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 4 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 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 years ago |
| Edit | Post #278628 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 years ago |
| 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 |