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 #288843 |
What about software that works on top of existing AIs via their API, but implements a bunch of prompt engineering to extend their functionality? A good example is https://github.com/Significant-Gravitas/Auto-GPT.
Do you think questions about a tool like AutoGPT would be more suited for Power Users... (more) |
— | over 1 year ago |
| Edit | Post #289024 | Initial revision | — | over 1 year ago |
| Answer | — |
A: To transfer, or not to, that is the question: whether 'tis nobler to let it stay or to take arms against Stack Overflow's dominance of FAQ canonicals Hi and welcome to the site. :) I think the idea of a canonical like the one you linked is great. A lot of newbies have too little understanding of their topic to identify common patterns. So they keep asking many trivial variations of the same handful of basic questions. People with even intermedi... (more) |
— | over 1 year ago |
| Edit | Post #289009 |
Post edited: |
— | over 1 year ago |
| Edit | Post #289009 |
Post edited: |
— | over 1 year ago |
| Edit | Post #289009 |
Post edited: |
— | over 1 year ago |
| Comment | Post #289009 |
My goal here is to get an answer that is maybe 1-5 paragraphs, that outlines the main elements of such a setup, and drops enough specific keywords that I can figure out the rest by searching online. So while the question sounds broad, I'm not asking for a lot of *depth*.
Edit suggestions welcome! (more) |
— | over 1 year ago |
| Edit | Post #289009 | Initial revision | — | over 1 year ago |
| Question | — |
How do I use an existing AI model to classify pornographic images? In the last few months, AI has advanced considerably, notably in the area of generating images. We now have powerful models like DALL-E, Stable Diffusion, etc. These are quite competent at generating an image based on a text prompt. Can any existing models be used as a simple binary classifier of ... (more) |
— | over 1 year ago |
| Edit | Post #288982 | Initial revision | — | over 1 year ago |
| Question | — |
Does Snowflake NATURAL JOIN support outer-style join? I like using `NATURAL JOIN` in Snowflake, because I find it more elegant than explicit join clauses. However, it appears that the natural join behaves similar to an inner join, in that null values of the join key(s) are dropped. In some cases, I want to do a natural join, but I want to include col... (more) |
— | over 1 year ago |
| Comment | Post #288920 |
Hmm. Well, I would solve the concurrency issue by something like a [semaphore](https://en.wikipedia.org/wiki/Semaphore_(programming)) (I assume you have multiple threads here). SQLite also supports [write-ahead logging](https://www.sqlite.org/wal.html) to deal with concurrent writes (I haven't used W... (more) |
— | over 1 year ago |
| Comment | Post #288920 |
@#63591 Is enforcing types the only problem, or are there others? (more) |
— | over 1 year ago |
| Comment | Post #288920 |
Embedding Postgres/MySQL is a bad idea, they're huge and designed specifically not to be embedded. There are other *embedded* databases besides SQLite, but you should state exactly what your issue is with SQLite. (more) |
— | over 1 year ago |
| Comment | Post #288884 |
Worth saying that ORMs are very complex, advanced things. They require advanced knowledge of both SQL and Python. If either is lacking, things will be very confusing.
Moreover, unless you are doing some very complicated stuff (eg. large codebase maintained over years), the ORM often creates more b... (more) |
— | over 1 year ago |
| Edit | Post #288893 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Can pandas be used as a database backend for persistent storage? SQL is as good as it gets, generally speaking. The best engine for a small project is SQLite. If you need more, the next step is Postgres. Postgres is very capable and it's unlikely that you'll need more even as a medium sized company. But it sounds like you're asking about small personal projects. ... (more) |
— | over 1 year ago |
| Comment | Post #288764 |
Aha, I see. That does sound like a good reason to do multiple local copies. (more) |
— | over 1 year ago |
| Edit | Post #288765 |
Post edited: Used mainstream mathematical term for the concept being asked about |
— | over 1 year ago |
| Edit | Post #288068 |
Post edited: Converted example data to CSV for easy copy/paste, rearranged for readability. Deleted "what I tried": In this case, the question is simple enough so I think it's better to keep it short. |
— | over 1 year ago |
| Comment | Post #288764 |
Isn't this exactly what branches are meant to take care of? What specifically would not work if you simply used a branch here? Are you worried about accidentally pushing commits to the `upgrade` branch without meaning to? (more) |
— | over 1 year ago |
| Suggested Edit | Post #288765 |
Suggested edit: Used mainstream mathematical term for the concept being asked about (more) |
helpful | over 1 year ago |
| Edit | Post #288862 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Prevent vscode from inserting new lines in the middle of my code on format. It sounds like you have a Java formatter configured (by default?) and VSC is applying it to your code automatically (on save?). How code is formatted If your only gripe is these specific stylistic choices, but you do want auto-formatting for other things, you must figure out what formatter is bei... (more) |
— | over 1 year ago |
| Suggested Edit | Post #288068 |
Suggested edit: Converted example data to CSV for easy copy/paste, rearranged for readability. Deleted "what I tried": In this case, the question is simple enough so I think it's better to keep it short. (more) |
helpful | over 1 year ago |
| Edit | Post #288861 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Remove entries by two-column ID everywhere, that meet a condition somewhere This is solved in 2 steps: Find rows matching remove conditions Do anti-left-join on the the composite key `(Die, Cell)` To filter out the rows: ``` Read in the data df = pd.readcsv("data.csv") Identify cells with low current b100 = df[(df["Resistance"] < 100000) & (df["Current"] == 1... (more) |
— | over 1 year ago |
| Edit | Post #288842 | Initial revision | — | over 1 year ago |
| Question | — |
Are AI prompt engineering questions on topic? Recently, AI models like ChatGPT have shown themselves capable of generating content and even source code. Just like with human helpers, clear and precise communication is key (especially when asking for big tasks) to avoid being misunderstood and receiving a response different from what was desired.... (more) |
— | over 1 year ago |
| Comment | Post #288841 |
This is very similar to the existing answer, but I didn't want to suggest edit because I wasn't sure the OP meant to write it that way. I thought I'd add it as a "ELI5" version, though. (more) |
— | over 1 year ago |
| Edit | Post #288841 | Initial revision | — | over 1 year ago |
| Answer | — |
A: When using the compare function in Array.prototype.sort, how to avoid an element to be processed more than once? Create a hash map and precalculate the sort key in it: ```js // Set up: Create mock input let u = ['4', '16', '8', '2', '6']; function expensivekeyfn(x) { console.log("Doing expensive operation on: " + x) return String(x); } // Create an optimized sort function let sortKey = {} u.... (more) |
— | over 1 year ago |
| Comment | Post #285715 |
Obviously C pointers can do everything references do. Indeed, what other languages call "references" are just locked down pointers. So do these alleged C++ programmers have an actual point? Aren't they just splitting hairs? (more) |
— | over 1 year ago |
| Edit | Post #288787 | Initial revision | — | over 1 year ago |
| Answer | — |
A: How do I find disjoint sets in a dataset Your example is a bipartite graph in adjacency list format. The cars are nodes on the left, the people are nodes on the right. When a person "has" a car, there is an edge between the car and person. Your question is equivalent to asking for the connected components of the graph. This can be done w... (more) |
— | over 1 year ago |
| Comment | Post #288753 |
This is what I was looking for. But does this restrict you to one `extre-index-url`, or can you also specify multiple? (more) |
— | over 1 year ago |
| Edit | Post #288735 | Initial revision | — | over 1 year ago |
| Question | — |
How to configure Python pip to look for packages in a private index first? When I run `pip install foo`, pip looks for `foo` in PyPi. I want it to look for it first in a private repo, let's say `pypi.bar.com`. Only if `foo` cannot be found in `pypi.bar.com`, should `pip` then look for it in PyPi. How can I configure pip to do this? (more) |
— | over 1 year ago |
| Edit | Post #288668 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288685 | Initial revision | — | over 1 year ago |
| Answer | — |
A: For scripting what are the pros and cons of command line arguments versus capturing input at the start? I largely agree with existing answers, but wanted to add this: In many cases, there is no clear answer one way or the other. Take the program `wc` which counts characters and lines. Should the interface be `wc file.txt` or `cat file.txt | wc`? Compelling arguments can be made for the value of eith... (more) |
— | over 1 year ago |
| Edit | Post #288671 |
Post edited: |
— | over 1 year ago |
| Edit | Post #288671 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Should I delete my trivial, lack-of-research question? I don't think the question is trivial. Maven is very complex and confusing at first. The documentation is also quite something. It's not easy to figure out what's going on unless you already know. Your question explains a valuable thing. My real concern is discoverability: It has nothing to do... (more) |
— | over 1 year ago |
| Comment | Post #278190 |
To be fair, the "tutorial sites" are content farms that are SEO'd out the wazoo. They're not trying to promote knowledge, they are trying to get the most search hits with the least effort. The articles are by necessity always going for the whole headline. It's like the saying "all chiefs, no indians"... (more) |
— | over 1 year ago |
| Comment | Post #278190 |
The quote reminded me of Wikipedia in the 2000's. This was exactly their problem, the biggest one by far, for many years. Back when you would get an F on your middle school homework for citing wikipedia, the early adopter experts (professors and other SMEs) were struggling to create "proper" content ... (more) |
— | over 1 year ago |
| Edit | Post #288670 | Initial revision | — | over 1 year ago |
| Answer | — |
A: Do we want a wiki (or similar) alongside Q&A? There are a few ways to understand "wiki". 1. Like wikipedia - an interlinked web of articles in a standardized format. 2. Like SO's documentation project or Github wikis - a stripped down wiki that is kind of sort of like a wiki but also weirdly shallow. 3. A post without answers, where the pos... (more) |
— | over 1 year ago |
| Comment | Post #278211 |
I disagree that self-answering is "awkward". I get where you're coming from, but if you think about it, it's actually extremely natural. Self answering questions is one of the most popular teaching styles from K-12 to college and beyond. Everyone is familiar with it. The ancient Greeks used it to ela... (more) |
— | over 1 year ago |
| Comment | Post #288668 |
SO had a neat thing where you could post your JS code as a https://jsfiddle.net/ and it would show up as interactive.
What is the feasibility of doing that, but for SQL, so that people can create tables and run queries? Obviously we would first have to find a program that does in browser SQL, but ... (more) |
— | over 1 year ago |