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 matthewsnyderâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Comment | Post #288660 |
If this question reaches a conclusion, it would be good if the CD software could try to detect a user is trying to post tabular data (based on tags?), and display a link to here. (more) |
— | over 1 year ago |
| Comment | Post #288668 |
Also, technically Markdown supports tables - SO is just not compliant and doesn't render them. But maybe CD could add support for rendering them? That would be pretty cool! (more) |
— | over 1 year ago |
| Comment | Post #288668 |
I know you're asking about spreadsheet, so SQL is kind of a weird option for you. But as a general solution to "tabular data", I think it's probably a great choice, so I included for other people who will see this answer later. You can always skip SQL and try CSV or Markdown. (more) |
— | over 1 year ago |
| Edit | Post #288668 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Best practices for posting tabular data Some good options to consider: SQL `create table as` statements. This way you can define multiple tables all in one file, that can be copy/pasted easily. It also matches a very common thing: SQL exercises in things like Leetcode. CSV. It's a bit ugly, but it's very easy to work with it, and man... (more) |
— | over 1 year ago |
| Comment | Post #277930 |
Thanks for the edit, @#53177! I agree that this example is better.
Out of curiosity, why do you say the fuzzy wuzzy is problematic? Is it because `zz` is repetitive, and you could do a bad solution by merely counting chars? (more) |
— | over 1 year ago |
| Edit | Post #277930 |
Post edited: I don't think all the history of the SO question helps and it distracts from the main point. I used a new example in case it's a copyright thing. IMO the new version is much shorter, but asks the same thing. |
— | over 1 year ago |
| Edit | Post #288623 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288623 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288623 | Initial revision | — | over 1 year ago |
| Answer | — |
A: What is a good modern language to use for a Business Rules project? SQL is the right tool for this job. You say the data is already in a database, probably a SQL database You don't have to deal with moving the data out of the database and "into a programming language" as you would with others This is an extremely common application of SQL, and you will find a... (more) |
— | over 1 year ago |
| Suggested Edit | Post #277930 |
Suggested edit: I don't think all the history of the SO question helps and it distracts from the main point. I used a new example in case it's a copyright thing. IMO the new version is much shorter, but asks the same thing. (more) |
helpful | over 1 year ago |
| Comment | Post #278366 |
The title says "combine the first character with another cell" but then in the example you are also doing case changes. The case change really doesn't have anything to do with the concatenation. IMO conflating two separate questions like this into one confuses things, and makes the question less usef... (more) |
— | over 1 year ago |
| Comment | Post #288621 |
Another way to deal with the commas and dots is to use the https://help.libreoffice.org/6.0/en-US/text/scalc/01/func_numbervalue.html function, which lets you directly say what the digit and group separators are for that number. (more) |
— | over 1 year ago |
| Comment | Post #288552 |
Wait, is this generating a requirements based on static analysis of the code? Wow, that definitely solves my problem, better! Thanks. (more) |
— | over 1 year ago |
| Edit | Post #288490 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Queries to count points lying on arbitrary line Since you didn't mention memory, I'll assume O(N^2) is acceptable. Setup pseudocode: ``` for every p1, p2: ln = line(p1, p2) pointsonline[ln.m, ln.c] += [p1, p2] ``` If there are at least 2 colinear points on your line, you can get them in O(1) with `pointsonline[m, c]`. If not, yo... (more) |
— | over 1 year ago |
| Edit | Post #288489 | Initial revision | — | over 1 year ago |
| Answer | — |
A: How to prevent Visual Studio Code from opening an extra blank window? I was able to fix this by deleting the `/.config/VSCode/Workspaces` folder. To figure this out, I: Backed up my `VSCode` folder to `/var/tmp` Deleted `/.config/VSCode`, after this VS Code stopped opening two windows (and created a lot of new files in `VSCode/`) Used `fd` to make a list... (more) |
— | over 1 year ago |
| Comment | Post #288201 |
It would be a lot easier to use something like Jinja for this, or even plain Python, or similar tools in other languages. `jq` can also do it. The advantage of these is that they are more flexible and better documented. (more) |
— | over 1 year ago |
| Edit | Post #288488 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288488 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288488 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288488 | Initial revision | — | over 1 year ago |
| Question | — |
Automatically install all packages needed When running various Python scripts, I often need to do this annoying dance: ```shell $ python script.py ... ModuleNotFoundError: No module named 'foo' $ pip install foo $ python script.py ... ModuleNotFoundError: No module named 'bar' $ pip install bar $ python script.py ... ModuleNotFou... (more) |
— | over 1 year ago |
| Edit | Post #288420 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288420 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288420 | Initial revision | — | over 1 year ago |
| Answer | — |
A: When would one not want to return an interface? I think the main reason to do this is when the interfaces fail to account for some subtlety of the contract between caller and implementation. For example, let's pretend for a moment that your use case is a performance edge case, and `List` in particular can handle it due to a peculiarity of its i... (more) |
— | over 1 year ago |
| Edit | Post #288419 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Why are commas not needed for modulo string formatting when printing? `%` is one of the oldest Python syntaxes for interpolating strings. It basically works like: ``` templatestring % datatuple ``` In fact, you can literally do that: ``` >>> s = "%d %d" >>> t = (1, 2) >>> s % t '1 2' ``` `templatestring` is the template, `datatuple` is the values to be... (more) |
— | over 1 year ago |
| Comment | Post #288367 |
Hmm... That unfortunately didn't change anything, I tried both true and false. It wasn't set before. (more) |
— | over 1 year ago |
| Comment | Post #288299 |
No, and yes alembic is probably the solution here :) I had forgotten about it. (more) |
— | over 1 year ago |
| Comment | Post #288299 |
The test data is created ad-hoc and not managed.
For example, say I'm developing a microblogging webapp with users and tweets. I'll run it, create some users, post some test messages, and done: I have fairly realistic data in the database for testing features like a "feed" view.
I am looking fo... (more) |
— | over 1 year ago |
| Comment | Post #288330 |
>Great answers both answer...
Yes, but IMO a great answer (generalized) is wasted on a specific troubleshooting question, because many people will ignore it because they think they have a different problem, even though the answer applies to them anyway.
My point is that generalized, great answe... (more) |
— | over 1 year ago |
| Comment | Post #288304 |
I'd say I'm well aware of the duplicates. There is an antipattern on SO where a newbie asks "hey here's my code it's crashing why", and then the question gets closed as a duplicate, but the duplicate (for a newbie) is impossible to recognize as such. The close notice gives very little explanation, no... (more) |
— | over 1 year ago |
| Comment | Post #288302 |
I'm on Arch Linux. This is likely not an issue that happens with a clean install, but something to do with my workspaces, or other configuration. I'm hoping someone might now where to look for the problem. (more) |
— | over 1 year ago |
| Edit | Post #288330 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Are code troubleshooting posts allowed? These questions are very helpful to the person asking, and great for driving activity. I think it is good to allow these questions to be asked and to answer them. At the same time, they are not good for keeping on the site indefinitely. Many years ago, I did not understand what lambdas were and as... (more) |
— | over 1 year ago |
| Edit | Post #288257 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288257 |
Post edited: |
— | over 1 year ago |
| Comment | Post #288321 |
I would say yes.
1. People who hate recs can avoid them by not going into that section.
2. People with PTSD from Stack's moderation can clearly see that yes, recs are okay.
3. Outdoors already set the precedent.
That is, assuming it's not a lot of work to add a section. If it requires changes... (more) |
— | over 1 year ago |
| Edit | Post #288321 | Initial revision | — | over 1 year ago |
| Question | — |
How are software recommendations handled? How are software recommendations handled on https://software.codidact.com/ ? https://outdoors.codidact.com/ has a "gear recommendations" section, so it seems like Codidact is open to the idea. I saw https://software.codidact.com/posts/287107 but it's about books specifically. What about questio... (more) |
— | over 1 year ago |
| Comment | Post #285739 |
I agree with this, but I think it will be unhelpful down the line to characterize UI/UX as "choosing fonts and colors". UI design and UX design are design disciplines with a lot of depth beyond that. Using that phrasing risks alienating a lot of actual design experts and also perpetuates an unhelpful... (more) |
— | over 1 year ago |
| Edit | Post #288305 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288305 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Should I post a link to the Github repo for code reviews? If it's so large that you must link the repo rather than reposting code, I think it is too large to reasonably expect anyone to review. Bored people will read a couple dozen lines, and point out a thing or two. But nobody (?) is bored enough to audit 1k+ LoC just for the asking. I personally would... (more) |
— | over 1 year ago |
| Comment | Post #286000 |
I think he means he's a noob of the site, not a noob of Python. (more) |
— | over 1 year ago |
| Edit | Post #288304 | Initial revision | — | over 1 year ago |