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 #290282 | Initial revision | — | over 1 year ago |
| Answer | — |
A: How to speed up MySQL query? The main issue with your approach is that, in some cases, you execute a lot of queries to fetch the data. When working with SQL (regardless of relational flavor), you must aim from a set-based approach, that is, you do not execute multiple queries in a loop, but a bigger query. In your case, that ... (more) |
— | over 1 year ago |
| Edit | Post #290249 |
Post edited: formatted the code |
— | over 1 year ago |
| Edit | Post #290217 | Initial revision | — | over 1 year ago |
| Answer | — |
A: How to automatically add package reference into project file after installing .NET package? Manually editing the `.fsproj` file followed by `dotnet build` worked because some `dotnet` commands have an implicit restore. I think this is the fastest way to add a dependency when you know its version. I have always used NuGet through its Visual Studio package manager, but I guess this is just... (more) |
— | over 1 year ago |
| Edit | Post #290216 |
Post edited: highlighted the problem the question is about |
— | over 1 year ago |
| Comment | Post #290165 |
Caching is typically used for storing reasonably small pieces of data. Is there any reason not to store the computed result in the database and use the streaming capabilities most database connectors offer to do your processing? (more) |
— | over 1 year ago |
| Edit | Post #290124 | Question closed | — | over 1 year ago |
| Comment | Post #290124 |
Can you include the source code related to the endpoint that is not found? Depending on the technology used for that API, there might be some kind of route prefix that you are missing out (e.g. `api`). (more) |
— | over 1 year ago |
| Edit | Post #290084 |
Post edited: reverted the last edit because it does display properly |
— | over 1 year ago |
| Edit | Post #290043 | Question closed | — | over 1 year ago |
| Edit | Post #289998 | Initial revision | — | over 1 year ago |
| Answer | — |
A: What software architecture are available for developing an application with multiple business domains that only share some common aspects? Important note: this is primarily based on personal fairly long experience with monolithic architectures and limited microservice-based architecture combined with others' experience with microservice-based architecture Based on your rather vague requirements and the data volume indicated in the co... (more) |
— | over 1 year ago |
| Comment | Post #289948 |
Is Modular Monolithic Architecture an option? Do you have at least a basic idea about the performance requirements? Example: programs will be added/changed at a max of 100s/day, clients served in the 1000s. (more) |
— | over 1 year ago |
| Comment | Post #289985 |
Indeed, such questions are not exactly welcomed as one of the close reasons states:
not constructive
This question cannot be answered in a way that is helpful to anyone. It's not possible to learn something from possible answers, except for the solution for the specific problem of the asker.
I... (more) |
— | over 1 year ago |
| Edit | Post #289891 |
Post edited: removed irrelevant tag |
— | over 1 year ago |
| Edit | Post #289932 | Question closed | — | over 1 year ago |
| Edit | Post #289887 | Question closed | — | over 1 year ago |
| Comment | Post #289887 |
Developer Tools -> Performance Tab might be helpful here. Is this happening only in Firefox or does the same happen in other browsers (e.g. Chrome, Edge, Safari)? (more) |
— | over 1 year ago |
| Comment | Post #289985 |
Ref to "the code review section can be used for this." (for questions like "why is this code breaking" or "how do I fix this method returning wrong value".)
Code review explicitly states that the code must work:
Requests for reviews of existing code (must already work). (more) |
— | over 1 year ago |
| Comment | Post #289985 |
Ref. to "A lot of people complain about such questions, because they are too localized/specific.": Can you clarify if this point from your post refers to SO or to Codidact? I think that this used to be a close reason for SO.
I have rechecked the help section and this type of question is allowed on... (more) |
— | over 1 year ago |
| Comment | Post #289975 |
It seems that postgresql allows to define check constraints that use a custom function. In this case it would include a select count children for a particular parent id. The downsides you have mentinoned are still there: harder to spot on table definition and might lead to performance issues.
Con... (more) |
— | over 1 year ago |
| Comment | Post #289932 |
Gbee.ai seems to be a rather large platform with multiple services. What are you trying to achieve? Without more context, it is hard to receive an answer. (more) |
— | over 1 year ago |
| Edit | Post #289928 |
Post edited: inlined the link for the Git documentation + minor fixes |
— | over 1 year ago |
| Comment | Post #289891 |
Why the design-feedback tag? It sounds like a tag related to UI/UX. human-readable might be more appropriate, but it does not sound in the spirit of [Tag creation/deletion criteria for Software Development?](https://software.codidact.com/posts/289420). (more) |
— | over 1 year ago |
| Comment | Post #289891 |
It is not clear what you want to achieve. For me, it sounds like a way to do the following operations:
- (already happening) Some logs provide Maildir filenames (not exactly human readable)
- run a script to read the file and fetch minimal human-readable information like a truncated subject
I ... (more) |
— | over 1 year ago |
| Edit | Post #289889 |
Post edited: removed irrelevant tag |
— | over 1 year ago |
| Comment | Post #289887 |
Can you provide more context information that makes this question more about Software Development (e.g. page being slowed down by a script you own) rather than Power User (some website that has a slow page)? (more) |
— | over 1 year ago |
| Comment | Post #289844 |
Ref. to "I would like to have my code separated while working on it, but would like my users to just import "MyLibrary" and have all the important stuff together there."
Is it supposed to be a convenience for the library consumer? I am asking because both Visual Studio and AFAIK Rider can automati... (more) |
— | over 1 year ago |
| Edit | Post #289863 |
Post edited: added relevant tag |
— | over 1 year ago |
| Comment | Post #289829 |
You can have a local Git branch that has been pushed (the question suggests that a local branch is the same as an unpushed one).
[This article](https://www.freecodecamp.org/news/how-to-delete-a-git-branch-both-locally-and-remotely/) provides a nice explanation about removing a local branch. This c... (more) |
— | over 1 year ago |
| Comment | Post #289741 |
Ref. to "a big cache of things-each-user-can-see". In your case, it is reasonable to pre-compute the user access to some entities, if these are rarely changed (which most likely happens). I have seen this done in an application and it can work decently.
I would recommend trying to do this for 2-3 ... (more) |
— | over 1 year ago |
| Edit | Post #289741 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Alternatives to `EXPLAIN ANALYZE` for queries that won't complete Note: I have limited experience with PostgreSQL, but extensive experience working with SQL Server, so not everything below might apply to PostgreSQL. > I have a large and complex PostgreSQL query that I would like to make faster. (..) When run, it does not complete in any reasonable amount of t... (more) |
— | over 1 year ago |
| Comment | Post #289714 |
@dnmnbg I have closed the question because it cannot be unanswered in its current form. Add more details as specified by Karl Knechtel by [editing it](https://software.codidact.com/posts/289714/edit) and we will reopen it. (more) |
— | over 1 year ago |
| Edit | Post #289714 | Question closed | — | over 1 year ago |
| Comment | Post #289691 |
As I agree that Software Development should welcome questions of type, would it make sense to tag them using `[computer-science]` (for questions related to the more theoretical part of programming) or similar? This would also help in the future, should we decide to create a special category for them.... (more) |
— | over 1 year ago |
| Comment | Post #289691 |
This question is being discussed on [meta](https://software.codidact.com/posts/289694). (more) |
— | over 1 year ago |
| Edit | Post #283051 |
Post edited: |
— | over 1 year ago |
| Edit | Post #286199 |
Post edited: |
— | over 1 year ago |
| Comment | Post #289625 |
Is the tensorflow-graph-mode added tag related to https://www.tensorflow.org/guide/intro_to_graphs?
Also, it sounds very narrow, I am not sure if we should have a tag about this. (more) |
— | over 1 year ago |
| Edit | Post #289625 |
Post edited: minor fixes + improved code formatting |
— | over 1 year ago |
| Edit | Post #289578 |
Post edited: added relevant tag |
— | over 1 year ago |
| Comment | Post #285541 |
I stumbled across this topic after one year and realized other resources are indicating to actually mocking the cache, [including the author](https://github.com/rgvlee/LazyCache.Testing).
I had completely forgotten about this Q&A, but it appeared in one of my Google searches. (more) |
— | over 1 year ago |
| Comment | Post #289539 |
It would be helpful to provide more context (where is the non-working code placed? Is it inside a controller?).
These [controller-related](https://docs.phalcon.io/5.0/en/controllers#request---response) docs for 5.0 might help to understand how to get the request reference. (more) |
— | over 1 year ago |
| Edit | Post #289539 |
Post edited: |
— | over 1 year ago |
| Edit | Post #289539 |
Post edited: improved message formatting |
— | over 1 year ago |
| Edit | Post #289508 | Nominated for promotion | — | over 1 year ago |
| Edit | Post #289440 | Nominated for promotion | — | over 1 year ago |
| Edit | Post #289464 | Nominated for promotion | — | over 1 year ago |