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 #281605 | Initial revision | — | almost 4 years ago |
| Question | — |
How to easily support time frame grouping in queries? I had a curiosity about how much the experienced users wait for their questions to be answered on Stack Overflow and had written a query for it: ``` SELECT YEAR(q.CreationDate) 100 + MONTH(q.CreationDate) AS YM, COUNT(1) Cnt INTO #acte FROM Posts AS q INNER JOIN Users qu ON qu.Id = q.Owne... (more) |
— | almost 4 years ago |
| Edit | Post #281604 | Initial revision | — | almost 4 years ago |
| Answer | — |
A: Etiquette for posting comments Before posting this on the help pages, I will compile the feedback in a separate answer. Generally speaking, comments should be helpful feedback and the following are not exhaustive lists. Can include - asking for question clarification. Examples: "what was the output of line X?", "can you i... (more) |
— | almost 4 years ago |
| Edit | Post #281566 |
Post edited: |
— | almost 4 years ago |
| Edit | Post #281566 |
Post edited: fixed the old text |
— | almost 4 years ago |
| Edit | Post #281566 |
Post edited: added response to the actual question |
— | almost 4 years ago |
| Edit | Post #281566 | Initial revision | — | almost 4 years ago |
| Answer | — |
A: Save migration info in separate DB schema If you want to use a custom entity framework migration table, you can set it when configuring the database context as shown here: ``` // this code belong to the database context class protected override void OnConfiguring(DbContextOptionsBuilder options) => options.UseSqlServer( co... (more) |
— | almost 4 years ago |
| Comment | Post #281565 |
However, I think that we could minimize conflict by replacing some comments with downvoting (e.g. for no research or effort) or flagging (e.g. for seriously wrong content such as homework dumps). I do not see how endless debates in comments help with removing bad content. (more) |
— | almost 4 years ago |
| Comment | Post #281565 |
Yes, I agree that snark is very hard to define. Also, agree that SO policy of being way too welcoming is not beneficial for the advanced users (e.g. in the last two years, I could not get any serious question being answered unless I placed a bounty). (more) |
— | almost 4 years ago |
| Edit | Post #281560 |
Post edited: added call for action |
— | almost 4 years ago |
| Edit | Post #281560 | Initial revision | — | almost 4 years ago |
| Question | — |
Etiquette for posting comments This question featured a quite heated discussion in the comments which led to some of them being removed. This action was discussed here and I have realized that our community lacks a guide about posting comments. I would like for us to build together a list of topics we can include and avoid resp... (more) |
— | almost 4 years ago |
| Comment | Post #280112 |
Recently, a major Node.js upgrade (12 -> 14) on a target server required the removal of the `node_modules`. Other than that, no need to remove it. (more) |
— | almost 4 years ago |
| Comment | Post #281539 |
Thank you for providing this answer. I will soon ask a question on meta about how to add comments (what is OK and what is not OK) so that the community can reach a consensus about this topic. Anyway, I agree that being digressive is sometimes necessary. (more) |
— | almost 4 years ago |
| Comment | Post #281517 |
This question is being discussed on [meta](https://software.codidact.com/posts/281528). (more) |
— | almost 4 years ago |
| Edit | Post #281531 |
Post edited: fixed the link |
— | almost 4 years ago |
| Comment | Post #281530 |
@meriton However, your second comment mostly deals with the poster's asking style rather than the post itself. I hope that I am clearer now. Normally, I would have moved the comments to a separate chat (comments are not meant for long conversations between users), but this option is not available her... (more) |
— | almost 4 years ago |
| Comment | Post #281530 |
@meriton This is not what I have said. What I have said is that feedback (regardless of being negative or not) should be constructive. Your first comment provides such feedback by suggesting in a nice way to check a reference before asking the question, because it seems that the information is easy t... (more) |
— | almost 4 years ago |
| Edit | Post #281531 | Initial revision | — | almost 4 years ago |
| Answer | — |
A: What is an example for a URI which is not a URL? This article shows in a concise and graphical way the difference between URIs and URLs. > A URI is an identifier of a specific resource. Like a page, or book, or a document. > A URL is special type of identifier that also tells you how to access it, such as HTTPs, FTP, etc.—like https://www.... (more) |
— | almost 4 years ago |
| Edit | Post #281528 |
Post edited: added relevant tag |
— | almost 4 years ago |
| Edit | Post #281530 | Initial revision | — | almost 4 years ago |
| Answer | — |
A: How are we supposed to give feedback for poor questions if such comments are deleted? Providing feedback can be done using comments. However, these comments are supposed to add constructive criticism and/or links to relevant resources. Your first comment does exactly this and it is a useful one. However, the subsequent comments seem to be a debate around available Wikipedia transla... (more) |
— | almost 4 years ago |
| Comment | Post #281517 |
This is a very relevant article on this topic: https://danielmiessler.com/study/difference-between-uri-url/ . A quick answer to your question: a book identifier (ISBN - ...) is an URI which is not an URL. (more) |
— | almost 4 years ago |
| Comment | Post #281517 |
I have removed the comments that are not relevant. Please use comments to ask for clarifications or generally speaking, to improve the question. (more) |
— | almost 4 years ago |
| Comment | Post #281448 |
@artaxerxe If you don't need to compute this too often and the data volume is pretty low (<100K records, also depends on the frequency), you can fetch all the required data in the application layer and implement the algorithm there. Languages such as Java or C# are better equipped for recursivity, t... (more) |
— | almost 4 years ago |
| Comment | Post #281232 |
@JDB The N/A case is typically approached by having the form field not required. So, you either enter a valid URL or nothing at all. This leads to consistent results (either "" or a valid URL), as people might write things like N/A, - , none etc. (more) |
— | almost 4 years ago |
| Comment | Post #281506 |
I think the issue is this one: https://github.com/codidact/qpixel/issues/268 (more) |
— | almost 4 years ago |
| Edit | Post #281486 |
Post edited: |
— | almost 4 years ago |
| Comment | Post #281491 |
We can [blame the cache](https://shouldiblamecaching.com/) for this issue. Entering edit mode for the questions indeed displays C++ tag in the list. Related: https://software.codidact.com/posts/278952 (more) |
— | almost 4 years ago |
| Comment | Post #281486 |
@Istiak Code golf is about solving problems with the least amount of code (bytes). The software development community is (among others) about getting solutions to programming problems. (more) |
— | almost 4 years ago |
| Comment | Post #281484 |
I have edited the title because "really exists" is quite hard to answer objectively. A simple search indicates that they exist, but it is not very clear what they are. Also, it would be useful to indicate the source where you read about these languages. (more) |
— | almost 4 years ago |
| Edit | Post #281484 |
Post edited: Made the title a little bit clear |
— | almost 4 years ago |
| Edit | Post #281464 |
Post edited: added relevant tag |
— | almost 4 years ago |
| Edit | Post #281301 | Nominated for promotion | — | almost 4 years ago |
| Edit | Post #281341 | Nominated for promotion | — | almost 4 years ago |
| Edit | Post #281415 | Nominated for promotion | — | almost 4 years ago |
| Comment | Post #281448 |
@PeterTaylor - While I have experience writing stored procedures, I am also aware of [the many disadvantages](https://stackoverflow.com/a/9483781/2780791) that they might bring in the project. AFAIK, unless there is a really serious reason to incorporate business logic in a stored procedure (e.g. avo... (more) |
— | almost 4 years ago |
| Edit | Post #281448 | Post undeleted | — | almost 4 years ago |
| Edit | Post #281448 |
Post edited: |
— | almost 4 years ago |
| Edit | Post #281448 |
Post edited: |
— | almost 4 years ago |
| Edit | Post #281448 | Post deleted | — | almost 4 years ago |
| Edit | Post #281448 |
Post edited: |
— | almost 4 years ago |
| Edit | Post #281448 |
Post edited: |
— | almost 4 years ago |
| Edit | Post #281448 | Initial revision | — | almost 4 years ago |
| Answer | — |
A: How to break infinite loop in CTE Estela's answer provides great insight about how to do it also in SQL Server. Unfortunately, there does not seem to be a build-in array functionality, so one way is to rely on strings as shown here. Basically, instead of accumulating values in an array, a string does this (way less efficiently for... (more) |
— | almost 4 years ago |
| Edit | Post #281385 |
Post edited: |
— | almost 4 years ago |
| Comment | Post #281385 |
Is "What elements should an authentication module include"? a suitable title (summary) for your post? I think the post's body suggestion such a summary (or similar). (more) |
— | almost 4 years ago |