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 |
|---|---|---|---|---|
| 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 4 years ago |
| Edit | Post #278992 |
Post edited: added relevant tag |
— | over 4 years ago |
| Edit | Post #279035 |
Post edited: Removed irrelevant information |
— | over 4 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 4 years ago |
| Edit | Post #279035 | Initial revision | — | over 4 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 4 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 4 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 4 years ago |
| Edit | Post #279002 |
Post edited: added relevant tag |
— | over 4 years ago |
| Edit | Post #278695 |
Post edited: removed useless tag |
— | over 4 years ago |
| Edit | Post #279014 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #279008 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #279007 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #279006 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #278771 |
Post edited: added relevant tags |
— | over 4 years ago |
| Edit | Post #278547 |
Post edited: added relevant tag |
— | over 4 years ago |
| Comment | Post #278988 |
@Moshi That would be great and intuitive for anyone using such a feature. (more) |
— | over 4 years ago |
| Edit | Post #278988 | Initial revision | — | over 4 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 4 years ago |
| Comment | Post #278982 |
Not sure, but shrink gets the database to 4GB and reindexing gets it to about ~5GB. (more) |
— | over 4 years ago |
| Edit | Post #278983 |
Post edited: removed meta related tags |
— | over 4 years ago |
| Edit | Post #278982 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #278981 |
Post edited: added the question |
— | over 4 years ago |
| Edit | Post #278981 | Initial revision | — | over 4 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 4 years ago |
| Comment | Post #278952 |
@Moshi That's a good idea. I will raise an issue @ GitHub repo. Thanks. (more) |
— | over 4 years ago |
| Edit | Post #278959 |
Post edited: fixed code alignment |
— | over 4 years ago |
| Edit | Post #278959 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #278958 |
Post edited: added missing code |
— | over 4 years ago |
| Edit | Post #278958 | Initial revision | — | over 4 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 4 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 4 years ago |
| Edit | Post #278952 | Initial revision | — | over 4 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 4 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 4 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 4 years ago |
| Comment | Post #278789 |
I have fixed it. Thanks. (more) |
— | over 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 years ago |
| Comment | Post #278650 |
This suggestion has been included. Thanks. (more) |
— | over 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 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 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 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 4 years ago |
| Edit | Post #278625 | Post edited | — | over 4 years ago |