skysight-inc/HackerNews huggingface dataset:
The primary issue I have seen with stored procedures is how you update them. I would be curious how they manage that.

Generally when releasing new code you want to do a gradual release so that a bad release is mitigated. It would be possible by creating multiple functions during the migration and somehow dispatching between them in PostgREST but I would be interested to see what they do.

The other obvious concern is scaling which was only briefly mentioned. In general the database is the hardest component of a stack to scale, and if you start doing it do more of the computation you are just adding more load. Not to mention that you may have trouble scaling CPU+RAM+Disk separately with them all being on a single machine.
Indeed, for reference my understanding is that street cocaine usually sells for £50-£100/gram in the UK, and that this is usually cut with other substances. Whereas in Colombia you can get what people tell me is much purer cocaine for £3/gram.

A LOT of that £2.7bn is in smuggling costs.
Why not just pull out the Ark and let the lightning zap all the Nazis? What an inane article. The Dept of Agriculture building in Washington is also ringed with swastikas and lo and behold, demons have not sprung from the earth.

People, its a plus sign with some bent edges. Try to restrain yourselves.

Imagine how badly this guy will freak out when he discovers there used to be a show called Hogan's Heroes...a comedy...about Nazis!!! People who fought in WW2 could laugh at it but apparently young liberals in 2020 are far more put off than people who actually witnessed the conflict.
> on the basis of made-up anecdata

And you're now accusing them of having made stuff up? How is that any better? Isn't the left all about respecting peoples subjective life experiences?
When was google EVER the hero?
Arm A – CAB LA (as an intramuscular injection every 8 weeks) and daily oral TDF/FTC placebo.
Arm B – Daily oral TDF/FTC and intramuscular CAB LA placebo every 8 weeks.

Taking an oral medication + injection every 8 weeks looks a little bit too hard to follow to me for preventing HIV acquisition. I'm more optimistic for HIV vaccines on the long term, though right now it's not the highest priority for the 2 mRNA vaccine winners. BioNTech has HIV vaccine in preclicical stage though: https://biontech.de/science/pipeline
> "A kWh from a wind turbine is absolutely not equal to a kWh from a coal/gas/nuclear/hydro plant due to the fact that the capacity factor for a typical wind turbine is around 20-30%."

No, a kWh of energy produced by a wind turbine absolutely is equal to a kWh produced by any other means.

You'd be correct to say that a kW of capacity is not equal. (ie: a 1 GW wind farm may not produce as much energy as a 1 GW nuclear plant, but 1 GWh of energy is 1 GWh of energy, no matter what source produces it).

For what it's worth, UK off-shore wind farms currently have load factors of between 39 and 47%, and these are predicted to exceed 50% by 2035. Source: https://renews.biz/55349/uk-offshore-wind-load-factors-to-ex...
If by "inept, pathetic handling of the pandemic" you mean the cover-up or data fudging accusations, I highly recommend the four part series in Quillette that examines the merit of these charges:

https://quillette.com/category/covid-19/china-syndrome-serie...

Here's the Twitter thread where the author introduced the series and gave some helpful backgrounds:

https://twitter.com/phl43/status/1298053847844368386

As he says:

"Again, I know that many of you are skeptical, but this essay has required a ridiculous amount of work and I'm really confident about the conclusions I reach, so I hope you will read it with an open-mind. I will post the other parts in this thread as they are published."

The author also has very helpful comments on the recent CNN leak

https://mobile.twitter.com/phl43/status/1333563577324761091
You can say about coal mine owners what you want, but at least they didn't have a habit of firing their canaries.
You’re mixing the general and the specific. Specifically yes, you don’t have to work for Amazon, but in general yes you are in fact forced to work or die in a capitalist system. In some situations Amazon may be the only viable employer.
It's still there!

https://ticalc.org/
Freedom from US foreign meddling?

That sounds unlikely
Going off of memory, happy to be corrected.

So something like pbkdf2 is intended to be "CPU hard" ie: it bottlenecks you on CPU. Then people started using GPUs for pbkdf2.

So we got bcrypt, which is CPU hard and uses enough memory that a GPU stops being particularly practical.

And then people build ASICs to bruteforce bcrypt faster. So we got scrypt and argon2, which are memory hard.

But the thing is that even PBKDF2 is pretty good. You can always just bump up the iteration count for PBKDF2 to increase security. I use a combination of PBKDF2 and bcrypt myself (pbkdf2 on the frontend, bcrypt on the backend).
I'm sure I have things disabled in some particular way that SA site devs haven't envisioned, but it's annoying to click through the "Cookie Settings" modal that obscures half the page every time I open a new SA page. Probably the cookie that stores this decision could be classified as "strictly necessary"...
URL-safe base64 is part of the spec: https://tools.ietf.org/html/rfc4648#section-5

If you're using Java, it's right in the standard library:

`Base64.getUrlEncoder().withoutPadding().encode(value)`
> ...did you find out that nuclear-powered ships are actually cheaper...

Heck no. As a new tech platform without volume production, they'll be wildly more expensive until the vessel fabricators and ship operators hit that growth knee where experience and volume combine to deliver innovations and cost scaling of their sourcing where the savings stack up. Except in this case the savings have to come from automating the regulatory compliance and operational security of the power plants, both challenging problem spaces.

This is why I specifically pointed out subsidization of those areas to even out the playing field, like the tax subsidies for renewable power. It is a decades-long play for power if someone makes it a national priority. The US has possibly the most advanced ocean-going nuclear vessel tech base, has a best-in-world operational excellence in rail freight, and arguably one of the best freight logistics industries and infrastructure in the world. The US could have dominated the world through its own OBOR on a global scale in a similar way China is trying to dominate as a mercantilist superpower, through effectively owning commercial sector logistical network effects. But trying to convince the DoD and Congress the trillions that would take over decades means convincing them that is effectively what one part of soft power projection-oriented next generation war in the information age looks like. There are any number of other competing theories about next-gen war with much better-funded research and adherents out there, so it's a non-starter.

The US let a significant fraction of its manufacturing and shipping infrastructure comparatively atrophy over the past few decades, so as long as it has to retool with more automation and physical infrastructure to catch up with the leaders, it might as well implement leaps of efficiency over the current state of the art like using gantry cranes to mass-lift entire multiple layers of containers [1] in a single lift cycle. The load/unload/downtime/travel-time components all need lots more operational automation and innovation for nuclear commercial ships for automated regulatory compliance to be feasible, but many developed nations (especially US and China) have the tech base to combine in novel ways to deliver.

[1] https://supplychaingamechanger.com/is-there-a-faster-way-to-...
I think this is legally the case in most places, but IMO it is extremely unfair to give ownership acting through the corporate entity the same rights as employees, which are actual people.
The one problem this technique has is that data and software normally have two very different speed and correctness requirements. That means that data and software should evolve following different procedures, what heavily implies that you want different people working at them, or at least you want people to look at them at different times.

For that, you really want independent access controls and CI tooling.

Of course, you can't separate much if you are a 1 or 2 people team at early stages of some project. And it may help you move faster.

But:

> "Rebuilding the database is as simple as executing one line bash loop (I do it every few minutes)"

This denounces a very development-centric worldview where operations and maintenance don't even appear. You can never rebuild a database, and starting with the delusion that you will harm you on the future.
There's one modern Common Lisp project I'm excited about:

https://github.com/atlas-engineer/nyxt

It's a web-browser heavily inspired by Emacs. It uses WebKitGTK+ as a backend, and they also have CL bindings for QtWebEngine, which uses code from Chromium, though I don't know if they have any plans to eventually support that as an alternate backend for Nyxt.
What perspective regarding the future of AI does the Heritage Foundation bring that another organization could not bring? they're not exactly experts in artificial intelligence. Or cybernetics. Or ethics.

> ideological flex

I'm not sure why you say that. the Googlers I corresponded with at the time had some serious questions about how this seemed to operate in contradiction to the company's goals. and if I recall correctly, the company was undergoing management shake up at the time, so I don't think it was an unfounded concern.
Anything outside of what they consider to be their norm is special treatment. There aren't enough lower level people who ask to see employment agreements ahead of time.
>Does re-balancing create a taxable event?

if the rebalancing involves selling something, then yes you have to pay capital gains on it. The only way to avoid this is wrapping your trading activity in a ETF.
Can I ask a quick question - do you have familiarity with corporate treasury type activity at businesses and SAAS businesses?

The volume of businesses that will be interested in this is going to be high. Your accounting platform would LOVE to be able to add banking features. Your expense management platform would LOVE to have direct integrated debit cards and cash management for you (and their customers will love it). Your education institutions would love to have their stored value / payment flows made more efficient (huge numbers of changing students with onsite and offsite dining, stipends, reimbursements etc etc with lots of lost cards and more).

In most cases, business do a POOR job of KYC when onboarding payment recipients.

My guess is stripes default flow to onboard hairstylists and dog walkers will be stronger, and repeat bad actors will be more easily identified by them then whatever your existing corporate treasury process is (usually upload an ACH file with some very minimum checks based on a webapp onboarding).Stripes model for KYC / onboarding will be API driven almost certainly, that's going to be part of the value add without question. Emailing PDF's back and forth is not scalable for onboarding with KYC frankly (and not always that secure).

In more specialized cases, the person building on top of the treasury function, if required by their business / license etc, would need to do additional bookkeeping / KYC as necessary. That's how it always is. For example, many states require a money transmitter license. Transferwise could do the recordkeeping and validation around transfers at whatever additional level needed to be able to offer their product in those states, which may include things like finding out source of funds. So if you are operating a money transfer business, yes, you either may not be allowed on stripe, or you may get asked what is going on.

The other thing is, for many transfers "on platform" its going to be VERY clear what is going on. Stripe will have metadata access on the API side it looks like. They can review what is happening for reasonableness. And they already play in a pretty large space, I would be surprised if a lot of use cases exceeded their capacity and am sure MANY use cases would be within capacity.
TheWrap reports in this article some independently verified claims as well.
Everlywell raises $175M to expand virtual care options, at-home health testing
"Here's $15 an hour...take it or leave, no one is forcing you" blah blah. It doesn't work that way in modern states. If you cannot afford to feed, shelter and educate your kids, that will fall unto others (Govt) since we've come a long way since Sparta.

Also, Amazon is closing stores left and right and turning maybe millions of small businesses into $15 an hour temporary jobs. The government has every right to get involved.
You are crazy for not buying a house in 2007. I can't think of a better investment to have right now than a house purchased in 2007...
Simpleshow video maker integrated into MS Teams
Why were they filming?
As in why was the drone in place and looking at a close-up of the cable?
Great question - what the team does at Tuple is great but we have a slightly different take that goes beyond formal pair programming:

1. With CoScreen, more than one user can share their windows with each other at the same time, side by side on the same share desktop - not just one.

2. Up to 12 participants can interact with any shared window using mouse & keyboard across multiple users.

3. You can even copy & paste code between windows shared by different users.

4. We are about to launch our Windows beta so users that aren't on macOS will be able to pair/team program too (and e.g. simultaneously share & interact with macOS AND Windows windows).
Bitcoin, and to a slightly lesser extent Ethereum, are schelling points for crypto. There are good reasons for this. Both bitcoin and ethereum created something new and interesting. In a world where you are trying to pick the coin that everyone else is going to pick, which one will you pick? The Nth of its kind, or the one that created the kind to begin with? That’s why they account for a huge majority of total value of all crypto currencies.

Edit: obviously this is an oversimplification and there are other factors like quality of governance, quality of the underlying tech, and so on. But I believe the above is the crucial factor.
I tried using DuckDB in a recent project. In their Python API, it had trouble correctly handling binary blob inserts. I really should have started poking at the code and tried to submit a patch, but I also realized I'd probably need to write my own schema migration layer (I'm use to yoyo-migrations for sqlite3).

I ended up back on sqlite3. It seemed cool though; might pick it up again for a future project.
I'm old enough to have been a timesharing programmer (when a 32k->64k working memory increase seemed like limitless abundance).

The company I worked for offered very expensive timesharing by the hour. Clients used an "Englishy" interpreted language to do economic forecasts, and client staff often programmed their own procedures.

My boss came to me one day to request that I speed up something a client had developed themselves, because it had become too expensive for them to run, and they were ready to bolt.

I had no desire to understand what their code did, and so treated the code mostly like a blackbox, and my job as speeding things up while leaving the transformation of inputs to particular outputs intact.

I had enough experience to know what the low hanging fruit were and went after those in the code. A day's work or so, and we got a 50-90% speed-up, enough to satisfy the client. I still don't really know what the code did. But I enjoyed the effort.
Not in democracies. It does make it somewhat harder though.
https://twitter.com/timnitGebru/status/1334343577044979712

> I said here are the conditions. If you can meet them great I’ll take my name off this paper, if not then I can work on a last date. Then she sent an email to my direct reports saying she has accepted my resignation. So that is google for you folks. You saw it happen right here.
do you have any (not too legal\dry) background reading on this? I'm not in the USA, so I might have let my biases lead me in what to believe.
"We'll do whatever we like, and you're not allowed to do anything, except as required by applicable law".
Yeah, I'm far from an expert on rendering and latency, but presumably game developers put a ton of effort into ensuring that the pixels are pushed with as little input latency as possible. This may not have been a priority for Microsoft in their terminal.
"Associate" has a specific definition here that's a little narrower than normal conversation. It refers to being a member of a group, not just being connected to it in some way. The CEO is free to not join the union if they don't want to. They can also quit if they don't want to deal with it at all.
> IPv6 is actually easier but it requires learning about a new Layer 2/3 set of protocols.

Exactly! It's simple to understand if you throw away the decades of cruft that has accumulated in IPv4.

ARP is a mess, half the specification is vague and everybody just does whatever they want. NDP is amazingly intuitive and sensible, but you have to stop thinking of it in terms of ARP.
I paid $47 for this vitamin D test (via blood draw): https://www.lifeextension.com/lab-testing/itemlc081950/vitam...
You get a doctor's prescription (from a Florida doctor, good for anywhere in the country) and instructions to go to your nearest Labcorp for a blood draw. So make sure you have a Labcorp near you.

Here are a few alternatives you can look into, mentioned in this discussion: https://news.ycombinator.com/item?id=15868143

[0]: https://www.privatemdlabs.com

[1]: http://www.directlabs.com/

[2]: https://www.walkinlab.com/

[3]: https://www.health-tests-direct.com/

[4]: https://www.personalabs.com/
> Cannabis is legal

It's technically illegal by law, it's just condoned/tolerated under certain regulations. There have been plans to make it fully legal, but it's not really going anywhere if I'm not mistaken.
i can't wait either. gas leaf blowers are technically illegal in LA, but yardworkers still use them all over the place without concern. they're loud, but more gravely, emit noxious pollution. all the more, it's not much more work or time to sweep or rake whatever it is they're (more rigorously) blowing up into the air and our lungs.
HP's early graphing calculators definitely had very high latency. But they dealt with it properly, which PC's don't. An HP-48 series calculator will buffer dozens of keypresses, and handle them in-order as if the UI had been instantly responsive. So you don't actually have to wait for a menu or dialog box to be drawn to the screen—if you've learned the necessary input sequence to perform the task you want, you can enter it at full speed. The keyboards were also very high quality with great tactile feedback, so you didn't need visual feedback on the screen to know your key press had been registered.
For the first 80% of a game, Unity feels great. It becomes a pain during the 2nd 80%.
> What sales, they hardly had any stock available.

Out of curiosity, are you trying to buy a chip, or a system?

If the latter, is it possible that it's a problem with PC makers not assembling enough AMD systems, rather than AMD not making enough chips?

I'm asking because for a long time Intel would have deals where they'd give PC manufacturers a hefty discount if AMD were less than 10% of their sales; such that the only way for AMD to make it worthwhile for HP / Dell / whoever to make more than 10% AMD systems would be to pay them to put their chips in machines (negative costs). They were taken to court over it and punished, but that doesn't mean they aren't doing it again.

Particularly as apparently they're still saying what they did wasn't wrong in the first place:

https://www.pcgamer.com/intel-is-still-fighting-a-10-year-ol...

EDIT: What's with the downvotes? Intel did a pretty despicable thing to AMD; it's documented in a court case. And they're still fighting to say that what they did was fine. I think people deserve to know about that kind of behavior, and I don't think it's unreasonable to ask if it's still going on.
Investing is buying things that gain value over time.

Bitcoin was originally worthless, now it's ~19k a coin. Anybody that bought or mined a large amount of coins back in the day and held on to them, is now rich, so a pretty good investment. The same forces that acted on bitcoin and brought it from worthless to 19k are still acting on it now.

Doesn't seem like it's very difficult to understand why bitcoin is considered an investment vehicle.

There are certainly good arguments for why may or may not be a poor investment vehicle or not the right one for a particular strategy, but arguments of whether it is one are moot.
No I've done the same slowmo recording test, and it was not there.

Also V-Sync is off now.

AMD even has an "anti lag" feature which apparently does nothing.

Edit: I have a Ryzen CPU, I've expected the full AMD system to work together better.
There's a few cryptocurrency index funds already, where the fund itself is completely automated and shares of the index are tokens on an ethereum contract. So you buy in with ethereum, then can liquidate you shares back to ethereum whenever you want. Still relies on a real-world organization, but pretty cool.

https://crypto20.com/en/
Related: https://sive.rs/pg
People in this thread seem to think it is some law of physics that the US gets to "allow" policies in other countries.

We "allow" policy and action by other sovereigns to the extent that we have the ability to enforce our will upon them. Just because we have had this ability to varying extents over the last 50 -70 years, does not mean we have the exact same capabilities right now.

US GDP is declining as a share of world GDP. US in no longer the biggest importer of commodities like we were for most of the time that we were "allowing" policies in other countries, and our international alliances are substantially more fractured then they were over most of that period.

The fact that the US has had an outlier position in terms of Geopolitical influence for the last half century is not a guarantee of this being true in the future.
This NLRB complaint was discussed yesterday: https://news.ycombinator.com/item?id=25278781. The document is here: https://cdn.vox-cdn.com/uploads/chorus_asset/file/22140676/C...

These threads from a year ago are related:

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

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

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

https://news.ycombinator.com/item?id=21960921
Anybody could create a new protocol that competes with IP (many did). So that part of your argument doesn't hold.

The reason that IP addresses are scarce is not because it's not possible to invent a new protocol, but because everyone else uses IP so only IP addresses are useful.

Spectrum might initially appear to be fundamentally scarce, but even then, people can invent other ways to communicate (and they did! copper wires! IP!).

These are all examples of networks - their value is proportional to their popularity. So yes, anybody can create a new cryptocurrency, but currencies are mainly valuable because of who you can use them with. Dollars are valuable because so many people accept them!

So if one cryptocurrency really gains traction, it will be hard for any other cryptocurrency to compete unless it offers something fundamentally new and different.
Sure, but this ignores the fact that App Store apps are reviewed, and Websites are not.

That’s critical to why one is trusted more than the other.

As to the Facebook SDK, yes that’s a problem, but it just proves the point - Apple is in fact continuing to tighten restrictions on what Facebook can do to invade your privacy via their app.

This is only possible because it’s an App and not a website.