wswope

16 ms·

181.
by wswope 4y ago
What did you do to avoid implicit locking, and what sort of isolation level were you using? Without more information about your setup, the advisory locking sounds like dead weight.
182.
by wswope 4y ago
Since I haven’t seen anyone else mention this bit of context elsewhere in the thread: Penrose gets a bit of side-eye in the physics community because of his metaphysical beliefs on consciousness. (Specifically, that quantum effects in tubul
183.
by wswope 4y ago
> If you’re familiar with Python packaging and installation, and just want to know what tools are currently recommended, then here it is. https://packaging.python.org/en/latest/guides/tool-recommend...
184.
by wswope 4y ago
As a fellow evangelist of the SQL + Pandas hybrid workflow, I’m a happy camper with Pandas’ built-in read_sql_query and to_sql. Only big pain points are having to ship around boilerplate to construct SQLAlchemy create_engine URIs, and the p
185.
by wswope 4y ago
Yes, thank you for speaking up to defend Apple’s prerogatives here. No one should have to suffer through the ( checks notes ) privacy violations and grueling six-year implementation timeline of adding a date picker input to their browser.
186.
by wswope 4y ago
DPC is just concierge-lite; the difference basically comes down to the head count that the provider wants for their practice. A lot of docs do DPC for a while to build up a client base, then exit to concierge, keeping a third of their previ
187.
by wswope 4y ago
Did you mean to respond here? This is a nonsequitor from the GP I was responding to. Regardless: If your question is "how can I ensure technical end-users have the same set of python packages as I do for the code they run using standar
188.
by wswope 4y ago
It is silly. You put together a three-line bash script to activate the venv, run a pip install, and call your program. The Python docs do cover this topic, and do so rather well: https://packaging.python.org/en/latest&#
189.
by wswope 4y ago
Markus Winand's "Use The Index, Luke" site is the classic reference. It covers most of the major DBs, but also gets into PG specifics. https://use-the-index-luke.com/sql/explain-plan/postgresql/
190.
by wswope 4y ago
Just to throw out a possible next step to put pressure on the payors: consider reaching out to the CMS technology ombudsman to ask if you can CC him on a round of follow-up inquiry emails. His nominal role is to assist with Medicare-related
191.
by wswope 4y ago
Or ChaosDB: https://chaosdb.wiz.io/
192.
by wswope 4y ago
I canceled my sub months ago after getting completely fed up with the Linux CLI client spamming ad-like output trying to push some new feature after running any sort of command. Definitely coulda come up with a bash alias to scrub it out, b
193.
by wswope 4y ago
I suspect the person you're responding to was just throwing that out carotid dissection as an example; the general risk factor with BJJ is vessel wall injury (which dissection is a subset of). Blood clots from vessel trauma in peripher
194.
by wswope 4y ago
Yeah, fully agreed with the overall thesis. Postgres is quite capable straight out of the box. I really like the idea of TOAST compression as an archival format too for big aggregates - I’ll have to check out the performance of a (grouping_
195.
by wswope 4y ago
I’m surprised by that 40x - I remember benchmarking TOAST compression and being very underwhelmed by the savings (I believe it took me from ~60GB to ~20GB). What sorta impact does that schema have on insert performance? I would expect the D
196.
by wswope 4y ago
The true killer feature in my book is the compression: I get ~93% for my largest datasets, which makes disk space requirements far more sane and dramatically speeds big analytical queries. You’re right that if you have a small (<1GB) tab
197.
by wswope 4y ago
Yeah, it’s a legit concern (even if low probability). An easy workaround is setting up a $5/mo VPS to act as a bastion host and relaying all your traffic through that.
198.
by wswope 4y ago
The docs strongly advise against this: https://docs.docker.com/network/iptables/
199.
by wswope 4y ago
Enthalpy of solution + first law of thermodynamics. Salt dissolved in water is in a very "stable", low-energy state, and getting it out necessarily requires a lot of energy input.
200.
by wswope 4y ago
What sorta gp/hr are you making while flipping with your tool?
201.
by wswope 4y ago
The term of art for dating based on soil layers is called stratigraphy, and doesn’t necessarily require radiocarbon dating. E.g. if you find a layer of silty sediment with clamshells widely dispersed, on a site you know was a lakebed that d
202.
by wswope 4y ago
That helps clarify a lot, thank you. To answer your question: yes, it does stop mortality. The general cause of death from opioid overdose is respiratory suppression when the brainstem is too “sedated” to continue sending signals to the res
203.
by wswope 4y ago
Can you elaborate on your point of confusion? The mechanism of action was explained in the article.
204.
by wswope 4y ago
Extremely subjective personal take: it’s the walled garden. The Wolfram ecosystem’s cash cow has always been academia. WA/Mathematica are great tools for what they are, but they’re not exactly open or hacker-friendly, nor is there much
205.
by wswope 4y ago
I think the language is more of a feature than a detriment: much like Excel, it’s able to get non-programmers to do programming without realizing it. Both tools have a low barrier to entry and a relatively gradual learning curve. All you ha
206.
by wswope 4y ago
I’ve never worked anywhere it wasn’t taken extremely seriously either, but I think this is the big news story that HHS is responding to: https://themarkup.org/privacy/2022/12/13/out-of-control-doze... . C
207.
by wswope 4y ago
Speaking as a professional data yeeter who has been bit by weird driver issues in the past, I’ll go against the grain to say that I found this really helpful as a checklist to pattern match against when troubleshooting, even without calling
208.
by wswope 4y ago
And that definitive edition is listed as gold on ProtonDB.
209.
by wswope 4y ago
Sounds like you’re talking about Medicare rates. A lot of hospitals and payors use them as the basis for their price lists, but unless you’re an actual Medicare patient it’s probably not what you’re actually paying. This data is collected f
210.
by wswope 4y ago
The details depend heavily on what specific database you’re working with, but in broad strokes, you’ll want to know: indices, query plans, when and where to cache expensive computations, every f—- word of your DB manual’s chapter on concurr

More ›