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 toraritte
Type | On... | Excerpt | Status | Date |
---|---|---|---|---|
Comment | Post #290329 |
It was the latter (i.e., present finding in an answer). How would you clarify the question? The question arose from my ignorance of how a browser makes sure that a website's SSL certificate is valid. (Hm, perhaps I should put "HTTP" in the question.) I also aimed to ask a fairly general question to i... (more) |
— | 2 days ago |
Edit | Post #290329 |
Post edited: |
— | 2 days ago |
Edit | Post #290330 | Initial revision | — | 3 days ago |
Answer | — |
A: How does a client verify a server's SSL certificate? What are the specific steps? Found this old article at the bottom of the search results to be the best explanation to date: (The longer version is here, SSL Handshake (Sun Java System Directory Server Enterprise Edition 6.0 Reference). If it doesn't work, here's the archived version.) > ### Server Authentication During S... (more) |
— | 3 days ago |
Edit | Post #290329 | Initial revision | — | 3 days ago |
Question | — |
How does a client verify a server's SSL certificate? What are the specific steps? I have little to no idea what happens after a client obtains the server's certificate. It has to make sure that it (somehow) valid, but how? (more) |
— | 3 days ago |
Edit | Post #290275 |
Post edited: |
— | 9 days ago |
Edit | Post #290275 |
Post edited: |
— | 10 days ago |
Edit | Post #290275 |
Post edited: |
— | 11 days ago |
Edit | Post #290275 | Initial revision | — | 11 days ago |
Answer | — |
A: How to programmatically evaluate Excel data validations using .NET? 0. State of the art (as 11/22/2023) The `NPOI.SS.Formula.DataValidationEvaluator` class seems to mirror Apache POI's `DataValidationEvaluator` class, but NPOI's version only implemented the `IsType` method thus far. (For reference, here's Apache POI's `isType`.) There also seems to be no .NET E... (more) |
— | 11 days ago |
Edit | Post #290274 | Initial revision | — | 11 days ago |
Question | — |
How to programmatically evaluate Excel data validations using .NET? What I would like to do: 1. Set a cell value. 2. Check with a program if cell values conform to data validation rules. I could extract all the information needed to create a validation function, but I don't want to re-invent the wheel. What I have in mind is along the lines of how NPOI allo... (more) |
— | 11 days ago |
Edit | Post #290255 |
Post edited: |
— | 11 days ago |
Edit | Post #290256 |
Post edited: |
— | 11 days ago |
Edit | Post #290255 |
Post edited: |
— | 11 days ago |
Edit | Post #290256 |
Post edited: |
— | 11 days ago |
Edit | Post #290263 |
Post edited: |
— | 12 days ago |
Edit | Post #290264 |
Post edited: |
— | 12 days ago |
Edit | Post #290264 | Initial revision | — | 12 days ago |
Answer | — |
A: Drop-down values in Excel cells are not specified in Data Validation rules and global search didn't find them in workbook, so where do they come from? It took a day and a half, but found it: 1. LEFT column's valid values, `Assessed` and `Pending` Started with the left column, because if it is not set, then the right column is "inactive", so it clearly has to trigger something. After several global workbook searches on the string `Pending`, I ... (more) |
— | 12 days ago |
Edit | Post #290263 | Initial revision | — | 12 days ago |
Question | — |
Drop-down values in Excel cells are not specified in Data Validation rules and global search didn't find them in workbook, so where do they come from? On top of values seemingly coming from nowhere in multiple columns, they also affect each other's behavior: In the GIF below, if the cells in the left column have no value selected, then there is no dropdown in the cells in the right column and they also don't accept arbitrary values (as a validation... (more) |
— | 12 days ago |
Edit | Post #290256 | Initial revision | — | 13 days ago |
Answer | — |
A: Which .NET project can programmatically validate a cell's value out of the box based on Excel data validation constraints? Here's a list of popular Excel .NET projects that don't have this functionality: | | Has built-in cell validation? | |--------------|-------------------------------| | Open XML SDK | no | | NPOI | no | | EPPlus | no? (see section 3. belo... (more) |
— | 13 days ago |
Edit | Post #290255 | Initial revision | — | 13 days ago |
Question | — |
Which .NET project can programmatically validate a cell's value out of the box based on Excel data validation constraints? Are any of the popular Excel .NET projects have a functionality similar to Apache POI's `DataValidationEvaluator` class? (more) |
— | 13 days ago |
Edit | Post #290254 | Initial revision | — | 13 days ago |
Question | — |
How to "materialize" Ionide function signature type hints as comments? For example, given this function head, this is the hint that is generated: ```fsharp let updateCell workbook sheetIndex rowIndex columnIndex value = // XSSFWorkbook -> int -> int -> int -> string -> unit ``` Helpful, but this hint cannot be saved with the source code, and it also cannot be c... (more) |
— | 13 days ago |
Comment | Post #290226 |
Thanks, but please don't bother - I just realized that the books I've been reading were written before .NET Core, when it probably made more sense to use it... (more) |
— | 20 days ago |
Edit | Post #290226 |
Post edited: Add backticks around code in quote |
— | 20 days ago |
Comment | Post #290227 |
Thanks! I figured as much, and, at this point, I'm just going to use my question to document stuff I find:) (more) |
— | 20 days ago |
Edit | Post #290225 |
Post edited: |
— | 20 days ago |
Comment | Post #290226 |
Thank you for the answer! I did some digging in the meantime, and indeed the consensus is that using `paket` pays off mostly when the project reaches a certain level of complexity.
So I'm not going to worry about it as my project is not a big one. What gnaws at me is that I can't figure out why it... (more) |
— | 20 days ago |
Suggested Edit | Post #290226 |
Suggested edit: Add backticks around code in quote (more) |
helpful | 20 days ago |
Edit | Post #290225 | Initial revision | — | 20 days ago |
Question | — |
Where is the `.fsproj` project file documented? More specifically: Is there a dedicated docs page listing "properties" that are idiosyncratic to F# `.fsproj` project files? Why am I asking? Started learning F# a couple of days ago, but just now starting to realize that I will also have to learn the .NET ecosystem as well: Came across the ... (more) |
— | 20 days ago |
Edit | Post #290209 |
Post edited: |
— | 22 days ago |
Edit | Post #290209 |
Post edited: |
— | 22 days ago |
Edit | Post #290209 | Initial revision | — | 22 days ago |
Question | — |
How to automatically add package reference into project file after installing .NET package? Just getting into F#, finally figured out how to add .NET packages to projects, but the way I managed to get it to work doesn't make sense. Once the package is installed (either with `nuget` or `paket`), I have to manually add a reference to the project file (either by editing it directly or with `do... (more) |
— | 22 days ago |
Comment | Post #290197 |
Thank you! I added it to my answer. (more) |
— | 22 days ago |
Edit | Post #290198 |
Post edited: Add python tools |
— | 22 days ago |
Edit | Post #290198 |
Post edited: |
— | 23 days ago |
Edit | Post #290197 |
Post edited: |
— | 23 days ago |
Edit | Post #290197 |
Post edited: |
— | 23 days ago |
Edit | Post #290198 | Initial revision | — | 23 days ago |
Answer | — |
A: How to create and manipulate (read/write) Excel (XLSX) documents with complex rules using general programming languages? All of these projects use Microsoft's OpenXML SDK for Office behind the scenes: 1. .NET (F#, C#) The F# Guide recommends NPOI, which also seems to be the most popular and most up-to-date, but there are others as well (ClosedXML, EPPlus). 2. Elixir + `elixlsx` seems to be only for manipula... (more) |
— | 23 days ago |
Edit | Post #290197 | Initial revision | — | 23 days ago |
Question | — |
How to create and manipulate (read/write) Excel (XLSX) documents with complex rules using general programming languages? Our organization (blindness non-profit in California) is obligated to submit reports to grant organizations (e.g., Department of Rehabilitation) on a regular basis. Most of the time, this means exporting data from our case management system and copying it manually into an Excel template file containi... (more) |
— | 23 days ago |
Comment | Post #290189 |
To the point, and explains exactly how it should be done without getting lost in specifics. (more) |
— | 24 days ago |
Edit | Post #290185 | Initial revision | — | 25 days ago |
Answer | — |
A: What are the benefits of starting a Git repo with an empty commit? Quoting an answer from SO: > Perhaps there was an advantage years ago prior to version 1.17.12 which added the `--root` option to rebase. Nowadays though, I can't think of any reason to start with an empty commit for a new repository. > > However, there may still be some minor advantages when r... (more) |
— | 25 days ago |
Edit | Post #290182 | Initial revision | — | 25 days ago |
Question | — |
What are the benefits of starting a Git repo with an empty commit? Found an article about starting a repo with an empty commit. Read the post a couple of times, but still don't understand the reasoning: 1. > ##### 1. `git log` and other commands blow up with terrifying error messages. > ##### 2. You can’t `git reset` back to that initial state. Based on... (more) |
— | 25 days ago |
Edit | Post #290181 | Initial revision | — | 25 days ago |
Answer | — |
A: What is the point of triggering CI/CD with an empty git commit? Based on the SO comments, this is not a good general practice, and I believe the point of the posts mentioned in the question is that + it can be done (but one probably shouldn't) + this can be used to test a CI/CD build service/system without having to add a contrived change. It seems that a ... (more) |
— | 25 days ago |
Edit | Post #290180 | Initial revision | — | 25 days ago |
Question | — |
What is the point of triggering CI/CD with an empty git commit? I read posts (e.g., 1, 2, 3) that recommend triggering a CI build process by pushing an empty git commit. I don't understand how this is a good idea as the commit history will be peppered with meaningless entries, and they can't be removed without re-writing the hashes (e.g., `git rebase --intera... (more) |
— | 25 days ago |
Edit | Post #290096 |
Post edited: |
— | about 1 month ago |
Edit | Post #290096 | Initial revision | — | about 1 month ago |
Question | — |
How to programmatically click through a list of elements if one has to wait for a click to load a set of predefined new elements? I would like to download the old-time radio show I Love a Mystery from the OTRR website. I figured out how to construct the list of right URLs, ```javascript const urlStub = "https://otrr.org/OTRRLibrary/jukebox/"; copy(Array.from( document.getElementsByTagName('a')). map( a => `"$... (more) |
— | about 1 month ago |
Edit | Post #289948 |
Post edited: Clarify "program" |
— | about 2 months ago |
Comment | Post #289948 |
Your comment is so spot on: I didn't realize how misleading the word "program" would be, so one would naturally think of "software" or "application", when I'm talking about "federal / state program for non-profits to be able to provide services".
Thank you so much for pointing this out!
(more) |
— | about 2 months ago |
Comment | Post #289948 |
Never heard of it, but by the sound of it I would say yes:) Thank you also for your question regarding performance, because I should have foreseen how this would be an important aspect. The answer is that performance is not an important factor:
There are only a couple hundred clients a year, less... (more) |
— | about 2 months ago |
Comment | Post #289975 |
Thank you for providing real-world examples!
The example in the question is indeed from an introductory book to logical database design (Database Design for Mere Mortals), and the author points out several times that some aspects may not be possible with a given RDBMS / not easy to implement.
I wa... (more) |
— | about 2 months ago |
Comment | Post #289948 |
> Does a table for program A have different columns from an analogous table for program B? Is it possible to make a reasonable design where creating a new program is as simple as inserting some rows? I would assume not, but the requirements you listed don't jump out at me as things that should requir... (more) |
— | about 2 months ago |
Comment | Post #289948 |
> you haven't really provided enough information to answer that question, at least not clearly.
I didn't want to inundate readers with the details when the database structures are indeed fundamentally different (should have spelled this out probably), and the only entities common are the clients a... (more) |
— | about 2 months ago |
Comment | Post #289948 |
> The structure of this question is kind of awkward. [..] What I think your actual question is is "what is a good software architecture for your problem".
You are right, and this is not a good question, but one that reflects my ignorance in this topic. Also, your suggestion is right, but spending ... (more) |
— | about 2 months ago |
Edit | Post #289948 |
Post edited: |
— | about 2 months ago |
Edit | Post #289948 | Initial revision | — | about 2 months ago |
Question | — |
What software architecture are available for developing an application with multiple business domains that only share some common aspects? > NOTE\ > The meaning of the word "program" below is > > > (PROGRAM) A federal or state initiative that offers grants for non-profits so that they can provide service at low cost or free of charge. > > and not a software application or online service. When I mean software, I use "application". ... (more) |
— | about 2 months ago |
Edit | Post #289938 |
Post edited: |
— | about 2 months ago |
Edit | Post #289938 | Initial revision | — | about 2 months ago |
Question | — |
How to implement a relationship between 2 tables where the type of participation is mandatory and RESTRICT rule for both? Found the example below in a book teaching logical database design, but I'm stuck on how one would implement this in PostreSQL: ![enter image description here][1] The diagram reflects the following business rule: > An instructor must teach one class, but no more than eight classes. This i... (more) |
— | about 2 months ago |