wswope (u/wswope) - Readit News

wswope commented on Does OLAP Need an ORM clickhouse.com/blog/moose... · Posted by u/craneca0

odie5533 · 14 days ago

How do you convert your type-safe native objects to and from the database in a reusable way? If you do anything in a reusable way, you're 95% of the way to an ORM. Or do you just accept that you get back random dictionaries from the database and don't care about type-safety?

wswope · 14 days ago

You write INSERT and SELECT statements for the object types you want to persist.

What is your concern re: random types popping up? SQLite springs to mind as a prime offender due to not enforcing column types OOTB, but most dialects have rather strong typing.

If we’re talking about mapping UUIDs and datetimes from their DB representations to types defined by the language stdlib, that’s usually the responsibility of the DB driver, no?

wswope commented on EHRs: The hidden distraction in your doctor's office spectrum.ieee.org/electro... · Posted by u/pseudolus

UltraSane · a month ago

What is the alternative to EHR software? Thousands of pages of paper records that is impossible to rapidly search? Just being able to index and search health records is enough to justify the existence of EHR software.

wswope · a month ago

My ¢2 as someone who works in the space: EHRs are currently mandatory for compliance, reporting, and billing reasons — but completely unnecessary for the practice of medicine.

The first big step towards untangling the gordian knot in my book is pivoting the industry to a capitated payment model, so compensation doesn’t require tying everything back to CPT & ICD codes, or tracking super-anal quality metrics for CMS. Once you make that jump, it’s pretty easy to imagine a lightweight note-taking + file-hosting platform that lets providers document summary data on a patient profile wiki-style, and attach notes to the profile in any arbitrary format using customizable templates. (I’m basically picturing a mashup of Google Drive + Wiki.js + Obsidian features.)

Handling meds, orders, and referrals in a cross-platform way is starting to become a solved problem with FHIR. Tack on modular plugins for each of the above to the patient profile page, and you’ve reinvented the functionality of an EMR in a way that sucks far less and lets users get shit done.

wswope commented on Meta says it won't sign Europe AI agreement cnbc.com/2025/07/18/meta-... · Posted by u/rntn

rockemsockem · a month ago

Yeah it's kinda weird.

Feels like I need to go find a tech site full of people who actually like tech instead of hating it.

wswope · a month ago

Your opinions aren't the problem, and tech isn't the problem. It's entirely your bad-faith strawman arguments and trolling.

https://news.ycombinator.com/item?id=44609135

That feeling is correct: this site is better without you. Please put your money where your mouth is and leave.

wswope commented on How I Use Kagi flamedfury.com/posts/how-... · Posted by u/moebrowne

jwr · a month ago

This kind of whataboutism is what leads to the current sad state of the world. One can look at any moral choice issue, say "but what about… [insert something here]" and then proceed to ignore it and do nothing.

I choose to take moral stands. Yes, it might be insignificant in the grand scheme of things, but I still choose to do so.

Having read the (rather disappointing) responses: all of them create some sort of artificial construct and result in doing nothing. I cannot do nothing.

wswope · a month ago

You don’t have a leg to stand on when dismissing criticism as whataboutisms, chief.

“Kagi is superior product and a vital competitor to breaking the search oligopoly — but what about their loose and indirect association with the Russian economy?!”

wswope commented on Positive link between cannabis use and 'Major Adverse Cardiovascular Events' heart.bmj.com/content/ear... · Posted by u/vixen99

daeken · 2 months ago

He was recommended by my therapist. Essentially runs an all-inclusive, boutique medical service; expensive, but actually turned out to be cheaper than all the services I'd previously had to use, for the best care of my life. That said, he only sees a limited number of patients (actually just closed new memberships from the web, only accepting referrals until he hits his cap) and only in Georgia.

I imagine there are other boutique providers out there, but this has been a first for me and given me hope that healthcare might not be so goddamn awful for everyone eventually.

wswope · 2 months ago

Just to tail off this and explain the business model, searching for “direct primary care” is a good way to find this type of physician.

A lot of these smaller shops start under the “DPC” label to build up a client base, charging something like $75-150/mo for unlimited primary care services. When the practice starts to hit its limits, they close off new patient signups, and start offering “concierge” signups at ~4x the DPC rate. The concierge patients are basically the whales who make the business model profitable (and I don’t mean to use that label as a pejorative).

wswope commented on Denmark's Archaeology Experiment Is Paying Off in Gold and Knowledge scientificamerican.com/ar... · Posted by u/sohkamyung

Nursie · 2 months ago

Really? Amazing.

I loved time team back in the day and I’ve just started rewatching some of them (one of the streaming services has series 13-17 here in Aus).

Might not be the same without Tony, but I see he did pop in for a cameo…

wswope · 2 months ago

I think you’ll be pleasantly surprised: There was an awkward transition post-Tony, but the new hosts have finally hit their stride.

Natalie/Gus/Hilde are far more serene presences than Tony, but they let the rest of the cast shine through. Helen and Derek in particular are the standout presenters right now, and while they don’t have the same manic/ADHD vibe, they’re both passionate and curious in a way that reflects Tony’s style and keeps the narrative intriguing.

wswope commented on Curate your shell history esham.io/2025/05/shell-hi... · Posted by u/todsacerdoti

wswope · 3 months ago

Obligatory plug for Atuin, which is a Sqlite-based shell history tool. It logs shell commands alongside timestamps, the working directory, and the return value.

You can optionally sync your history to a server in encrypted form to keep a shared history across hosts. The server is extremely easy to self host.

As discussed in TFA, it’s easy to filter or scrub junk like `cd ~/Desktop` so it doesn’t pollute your history. You can also fuzzy search and toggle between commands run in your current session, commands run on your current host, commands run in your CWD, and commands run on all hosts.

It’s my single favorite piece of dev tooling, and has made my job + life far smoother and easier. Highly recommend.

https://atuin.sh/

wswope commented on Discord Unveiled: A Comprehensive Dataset of Public Communication (2015-2024) arxiv.org/abs/2502.00627... · Posted by u/leotravis10

chneu · 3 months ago

Discord is horrible for this kind of stuff. There's a reason that GitHub and other type of sites exist

Discord is walled and hard to search. If a channel or server closes then all that information is lost.

Tons of data will be lost to discord when it goes down.

Idk if you've ever tried to use discord for mods or other software but it sucks. It's confusing. Information isn't cataloged well. It's search sucks. It just isn't good for this kind of thing.

wswope · 3 months ago

Github is walled and hard to search now too. Not as bad as discord yet, but headed there.

wswope commented on A faster way to copy SQLite databases between computers alexwlchan.net/2025/copyi... · Posted by u/ingve

bambax · 4 months ago

> If it takes a long time to copy a database and it gets updated midway through, rsync may give me an invalid database file. The first half of the file is pre-update, the second half file is post-update, and they don’t match. When I try to open the database locally, I get an error

Of course! You can't copy the file of a running, active db receiving updates, that can only result in corruption.

For replicating sqlite databases safely there is

https://github.com/benbjohnson/litestream

wswope · 4 months ago

The built-in .backup command is also intended as an official tool for making “snapshotted” versions of a live db that can be copied around.