skysight-inc/HackerNews huggingface dataset:
Nice work, thank you for sharing!

Great job on the 386 theme.

Documentation is understandable and easy to dive into.

Great design, and rather complete feature-set.

TOML looks like a great format, too.
Connect using Unix sockets. It is just shared memory so you have zero connection overhead.
For example, connecting through sockets to pgBouncer saves 50% CPU.

Unfortunately there are some kernel tuneables (buffer sizes) which you have to set at compile time to support massive data transfers on sockets.

Obviously this only works if you are on the same machine and if you connect directly to Postgres this way, it will happily spawn a process for every query :(.
Great to see Antonin and others working on this! I did some work on some pieces of this (along with many others), and I gave a talk about an earlier prototype of the undo log machinery and how it fits at PGCon 2019 (which now seems like a whole lifetime ago!). Slides and recording here in case the background is interesting:

https://speakerdeck.com/macdice/transactions-in-postgresql-a...
I'd say just by using YAML this already loses out to the posted project :)
Leveraged ETFs returns diverge rapidly from the package of equity + margin loan since the former rebalance daily.

Leveraged ETFs are almost never appropriate except to monetize a very short term view.
I fucking hate the modern Internet. Everybody takes and nobody gives. We've regressed from the 90's/00's.

These platforms only care about lock-in. Spotify doesn't really add anything. The only convenience over Winamp is social sharing.

All of the platforms are catered to mass audiences anyway and suck for power users. They only want to extract money and are doing it the easiest way possible. Customers that don't complain about lack of features.

I posit that nobody in any of these orgs deeply cares about music.
Large steel bridge construction involves much hand labor. Here's a big job in China.[1] If you're not seeing the foundation work or crane work, it may look like it's all hand labor. Large bridges are custom-designed prefabs. Somewhere else, there's a factory making the parts.

[1] https://youtu.be/kJ1ciG7IjKA
This seems to perpetuate the assumption that existence without productivity is equivalent to failure. You are arguing that every square inch of land and human meat has to be constantly productive and efficient. I think the goal for humanity should be enjoyment of life. If we go wholly into other energy production methods (nuclear with battery and aquatic storage, and a sprinkling of solar to power A/C) we can get out of the rat race of mandatory productivity from every living molecule.
Tracking exactly what individual db entries ran and didn't run when there's one of these "serverless" "painless" interruptions to an ETL, ensures that you have an endless number of ever-changing status columns and re-run processes.

Are you really sure that it all re-ran? No. You have to query your latest batch - which means you have to have arbitrary boundaries for when failures might have occurred like say, last 24 hours. If was a weekend, just query the whole database looking for any entry that's missing the "final" status success. Try not to run anything while you're doing this, unless your system is tolerant to the DB being locked for a full-table scan.

This is all very fragile and change-averse. Who would choose to run an ETL like this? I have worked for large companies who all end up with this rickety system. Every one, every time. God forbid you want to run tests with a mock set of serverless AWS services.
My typical American diet induced whiplash when the first ingredient in your “oatmeal breakfast” was a pound of chicken thighs.

This isn’t a complaint at all - it just made me very aware of my own dietary assumptions.

It sounds very good.
Don't buy an iPhone if you want to be able to make these kinds of decisions for yourself...?
Love this Matt, thanks for posting. Any shortcuts into the beta for HN? :)
Yup, I don't understand this. Vegetative propagation is cloning.
I don't see anything in the Gateway docs that make it look like anything but DNS service: https://developers.cloudflare.com/gateway/about

Can you point to something more?
I assume I'm being downvoted because JS is essentially mandatory on the modern web since the popularity of client-side rendering has risen amongst web developers, who are a significant proportion of the HN membership.

Or perhaps I was downvoted for promoting easy ways of getting around poorly implemented paywalls.

OTOH, perhaps the downvotes were because of the shortness of my reply.
Here's my experience. Until you have the luxury to pursue any side project you want, I found that side project that scratch your itch on your main job work best. You have fun with problem solving at your own pace, and also make your work life continuously a little better(because you know where your itch at, and since no one cares, so you do it yourself)

At the end of the day, you ship something useful and practical and learn something new along the way. Ain't that count?

Unless your side project = side business, now that'll be another beast.

Even something you do out of love that doesn't involve money making, you still have to think about it, find time to do it and when you can't(mostly because your main job took all your time) you will feel guilty and depressed. And the cycle continue.... seriously, I think it's worse than having no side project.
I dunno, it was a pretty enlightening experience, learning how to struggle, learning how to be humble about sucking at something that for me till then was super basic (as an adult, so I could really savor the feeling -- I had learned to touch-type at age six). If you don't forget qwerty, it's not an annoyance to use someone else's keyboard. And having someone else be annoyed when they use my keyboard is a feature =).

The only time it was mildly annoying was when I started dating someone and asked to use her laptop, and I suddenly found I couldn't type. It turned out that she had ALSO learned dvorak in college. When I realized what was going on it was all good.
99.99% of the websites out there don't need 99.99% uptime (from a business point of view)
> no soon-to-be-Nobel-laureate wants to find out in some news article

I understand saying that's a problem, but realistically, that's a problem very few people would be unhappy to have. Yes, it could be horribly inconvenient to stumble through a bunch of congratulatory communications before you could confirm you've actually won, but compared to wining a Nobel, it's a trifle.
As someone who absolutely loves the ability to use (the misleadingly-named) ridesharing, I absolutely hate what the legions of fare-seeking Ubers and Lyfts have done to traffic in SF (well, pre-pandemic).

My completely-without-evidence theory is that there is some amount by which we can cut the allowed number of rideshare cars on the road at any time, and while wait times to get a vehicle might increase, the overall time will be the same or less because transit time will be reduced with less congestion.
I really like Chalice for serverless Python projects.
What makes tubers special in this context?
The other convenience Spotify over Winamp is that you don’t have to find and download MP3s, you can just type something in and 99% of the time just start playing it immediately...
> The only convenience over Winamp is social sharing.

Spotify also lets you stream any kind of music, anywhere. It's a nifty feature that some people find useful.
It doesn't actually scale to 0. The scale to 0 argument is actually just accounting trickery. Servers are still waiting around burning cycles doing nothing waiting to run a serverless function. All that has changed is that Amazon has spread the cost of low utilization across all customers. Which gets baked into your cost as well.
Thanks, that sounds really interesting. I hope this sort of thing takes off amongst musicians.
Particularly once you get past a certain age being dependent on the friend in your group with a car to go away for weekends starts to get old and hard.
Wrong. There's about a 70-80% risk reduction for injury: https://pubmed.ncbi.nlm.nih.gov/15094411/
They have shut down BLM pages? BLM irrefutably spreads hate, especially towards cops, even black cops, and their actions have gotten lots of cops killed. Many of them openly spread racial hate directed towards whites including the Dallas BLM shooter who killed 5 cops and said he wanted to kill white people and white cops in particular.

If they shut down a vague classification of people like holocaust deniers, which is like shutting down flat earthers, then clearly they should shut down an organized hate group.
But how many hours/days/years did it take you to learn how all the parts move before you became capable of setting something like that up within a few hours?

Anecdotally, stories of businesses abandoning entire cloud automation projects because they wasted weeks and never had anything to show from it don't seem unusual, so evidently a considerable amount of knowledge and skill is required to get value out of these tools.
This sounds really good. I kind of want to try it but maybe a vegetarian/vegan style instead. Thanks for sharing!
Interesting Next Big Things in Big Data and AI
"A nineteen year-old... has no feel on his pulse for those tragedies of adult life that economists call scarcity and choice."

I think this says a lot about what kind of teenager gets into an economics program, or at least the author's perception of them.
There is also the random negative event problem.

Not owning a car and taking uber everywhere seemed okay when living in a dense city, until covid happened and Uber all but ceased operations for a while.

The small condo in the city was a great choice when you went out most nights and worked at the office but it sucked terribly when circumstances changed and everyone was home all the time.

The main blockers for me are transaction costs - sure I can rent a car when I want to drive to the mountains but the amount of extra time and effort required means I’d probably not bother.

To be clear: it can work - I lived in central London and never bothered to own a car but, well, I don’t now because even something trivial like carrying around three car seats every time I wanted to take an uber would be so cumbersome I’d never do it.
I don't know, it sounds like you've just implemented all of those things n+1 times.
I didn't include a source because there probably isn't one. But he def told this story. I was there in person at a google off-site keynote
I would limit the amount of domains for the personal license to 3. There is not enough value added between the personal and company pricing. Leaving money on the table.

Also, monthly pricing for self-hosted is sort of strange. Really consider switching to annual license pricing ONLY. This will be good for you as it will reduce monthly churn.
Basically nothing I have ever used had 99.99% uptime except maybe the phone and emergency services. Why do you need this level of uptime unless life and limb depends on you?

My bank has regular scheduled downtime, Steam/Dota has regular downtime, entire Microsoft datacenters had issues and had around a day of downtime, Lime, Uber, my mobile carrier - all had downtime or bugs or glitches that were equivalent to downtime.

If you really need crazy uptime, then you must make sure you have no bugs, because bugs cause more downtime than any hardware failures.

That means an approach to software development that isn't relying on flavour of the month js library.
Looks interesting, this domain has a lot of players such as Google's coin-or so some quick description of its advantages or a benchmark would promote it better.
Yeah at least for Watson!! Ew.
That reminds me, I had a Spotify subscription because I needed to tune out coworkers at work. Now that Im working at home I don’t need it...but first I have to save my playlists.
Real estate agent here... in my market there are a number of mid-century homes that have the very square look of a manufactured home. Even looking vaguely like a manufactured home is enough to keep people away from them. My own observations are that newer pre-fab / manufactured can be very well built. We have a lot of people coming here looking for rural retreats - truth is, if you are way off the grid, a manufactured home may be a very good option for you as it may be difficult to convince a builder to work on your custom build project if it's going to be a long commute for them.

So what I'm saying is - there's a mental block for people in accepting these houses that has noting to do with reality and everything to do with perception.
This appears to be the (confusing/dark pattern-esque) setting for opting out of "Enhanced Relevant Advertising":

Allow Use of Information:[No] Restrict User:[Yes]
I think people are using the word in different ways. The person you are responding to is using it as a description of the current state.
they are actually some of the very few on campus parking spots. Almost everyone else parks on the periphery of the campus.
I'm near enough to SJC that usually I hear most of the landing flights (unless the runway is reversed on those funny wind days.) Your comment made me think about the last time I actually heard an aircraft landing, and it made me think that the aircraft have also gotten quieter while landing. It certainly seems to me that even when they fly overheard now, they're somewhat quieter. My only guess is that the planes are flying lighter, and thus can run their engines a little bit slower and thus reduce the noise?
Ask HN: How did you land a functional programming job
I'd love to use a functional language for work. I don't think I'll truly master functional programing until I do it full time. All the jobs I see looking for functional programmers appear to be looking for experts. I've 8 years as a generalist web programmer.

If you are now a full time functional programmer, how did you get there?
Big discussion 3 days ago: https://news.ycombinator.com/item?id=24735414
I didn't know that about seatbelts. All these years of careful driving have been wasted on me.
If you're interested in wild harvesting (particularly in the west coast) I'd suggest following Pascal Baudar. He's like a walking encyclopedia. His latest post is coincidentally on acorn harvesting and references the processing: https://www.instagram.com/p/CGKrQpgpPL0/?igshid=3l7xo1q06yaz
Looks neat, but as someone else mentioned having the option to use a stand alone account would be even better. I will never personally use sites that require Oauth to make accounts, and I suspect others may feel the same way.
>than the rights of individuals to grow food.

Is it really a tragedy that your average home gardener can't grow cotton candy grapes after he bought some from the grocery store? It's already pretty hard to do that, given that many (most?) of the commercial varieties are hybrids, so you can't really reuse the seeds to begin with.
Two things:

1. At 6% women—and, therefore, 94% men—I would say the winners' pool is egregiously sexist.

2. An "old boys' club" is an idiomatic expression referring to exclusive, undemocratic and even unmeritocratic social circles. Not, necessarily, literal "boys."

So, in light of those two premises, I don't feel your objections carry any legitimate weight.
Why incur the cost of printing this on the package? It’s a trivial expense. But agricultural margins aren’t that wide.
> The government’s resistance to ridesharing is incredibly annoying.

To be fair, the government’s resistance to the rule of law, international promises or basic human rights is incredibly annoying too, so at least they are being consistent.
Can you let me know where you saw this article mentioned recently? I saw it on my twitter TL today but I'm scratching my head as to who it was that posted it. Thanks!
Somewhat related, http://server-sky.com/ proposes putting servers in orbit. Would make a nice adjutant to the mega constellation projects going on
It's called lutris. I play games on linux and Lutris does all the heavy lifting for me.
> 4. Not everything needs to be a minimalistic sleek Webapp. All of this depends on who your target audience is and on which level they want to deal with the problem. A minimalistic UI isn't automatically more or less powerful than a complex one if it combines well with other tools. To make every part combine well with the other parts to get out more than the sum of the parts is worth it, but find the right degree of minimalism vs complexity.

It doesn't have to be sleak but minimalist ! = sleak. A UX designer makes things minimalist while a UI designer makes them sleak.

A minimalist UI is a strong sign that care was put into abstracting away unnecessary and complex features that most users do not need - which is the job of a UX designer.
If efficiency is the goal, it's better to spend time optimizing your ability to use advanced text editing features. Simultaneously modifying multiple lines at once, block based editing / copy+pasting, regexes, etc. I'd imagine the amount of time I'm actually typing is well under 1% of my time as an engineer.
Why Snowflake may be the hottest tech IPO of 2020
Yeah, that was my first reaction to that bit. Most of my friends would feel uncomfortable about me paying for a hotel room for them, and that would make me feel uncomfortable.

I agree on the larger AirBnB option; I think that's a great way to keep everyone together and (both physically and emotionally) comfortable.
If it is that hard, why is any restriction needed?
Kind of like build time. Even with only a small fraction of time spent compiling, it can distract you and make it less enjoyable to code vs. seeing your changes instantly.
> than deal with lawsuits/enforcement of growing food.

Is there a reason why food should be treated differently than any other manufacturing process, which is also patentable? Or are you against patents in general?
We already have that. It's called minimig. It is a free and open hardware reimplementation of Amiga as HDL, originally shipped with its own open-hardware board which used a real m68k chip.

Its current incarnation uses the tg68k open m68k CPU, and supports the original chipset as well as AGA.

It runs well on miSTer[0] boards and the open FPGA stack friendly ULX3S[1].

[0]: https://github.com/MiSTer-devel/Main_MiSTer/wiki

[1]: https://www.crowdsupply.com/radiona/ulx3s
I am okay with Git the CLI being for power users as long as awesome UX developers create excellent user interfaces around it. There are great Git GUIs out there for those that need them, and many of them handle the core workflow (clone, pull and rebase, checkout, commit, push) really well.

In fact, once I learned how Git works under the hood, the commands made a lot more sense. Perhaps the problem of distributed version control is just inherently complex?
They are good for message queue handlers.

But not good for production REST API endpoints in my experience. In the context of AWS Lambda, you are talking a 29 second timeout in API Gateway. API Gateway is fairly expensive. Also, is connection pooling a solved problem?

Many times you can do better with an EC2 instance running PM2 and Express, or whatever. Like, what does Serverless Framework do locally anyway? Express? Why not just run Express?
> However, if it was such a rare thing, what are the odds that someone like me would exist?

Someone wins the lottery every week. What are the odds of winning the lottery? Is playing the lottery a good strategy to make money?
I believe this is only for serious road traffic accidents. Continue wearing your vest if you believe it will stop drunks wandering under your wheels etc.

This study is about the “number of bicycle and motorized vehicle collisions” reported in such a way as to be collated by the Italian government’s National Statistics department.

None of my bike crashes, thankfully, have been sufficiently hairy as to require they be reported to the authorities. They would never have made it into a government database.
It would be nice if someone made a machine that would run all three of those discrete, generalized computing tasks on a single general purpose "thing". That way, you could infinitely scale your work up or down within available memory based on what needed to be done. It would even intelligently free something from memory if it wasn't being used.

Servers.
Oddly enough I was worried about the same working from the office with its wonderful open office layout.
Ask HN: Best HVAC system for a new house?
I know nothing about building houses. I've never even bought a house. However, we bought some land, got an architect to draft up some custom plans, now we're in the bidding phase.

What sorts of HVAC systems are out there and as a nerd/engineer, should I want a completely analog system or 'state of the art' HVAC system or something in between?

Besides the usual, I'd like as much fine grained control over different parts of the house, at the very least control separately the temperatures in the basement, 1st and 2nd floor.
Google's Stadia is a lot of "Linux-Based Gaming Devices."

The value proposition (to Google) is obvious: not having to pay for thousands of Windows licenses, and reducing the number of OS kernels in Google's cloud infrastructure.

If you consider Android as "Linux-Based" then that's billions of "Linux-Based Gaming Devices."
Anecdotically, QWERTY also seems to be sort of arranged in alphabetical order but with certain keys moved here and there — for exemple, the middle row is:

A .. D . F G H . J K L

(dots indicating the missing letters.)

Then it goes down for the M N from right to left, up for O P, then the top row is:

Q R . T U

And the bottom row is, from right to left:

V . X . Z

And then the rest.
If it's a government project, the employment may actually be the real goal, less so than the bridge.
_ Should they have the freedom to decide they don't like my forum and kick me off?_

I would say the opposite: No. While it might be _legal_ for them to kick me off, I don't think a private company should decide what I say on their platform. For example, should my ISP block websites of competing ISPs if they so choose? What about posting on Facebook that Comcast sucks, should I get my internet disabled for that?
Censoring urban dictionary would seem to completely contradict its purpose at its most fundamental level.
Oh, I get the bad guy is hosed, but what about the wildfire propagation? Sued unto the n'th generation? How long does the gene continue to be bound by patent law, once its propagating freely?
Nobody trusts polls as completely accurate, predictions are always fudged to take into account such things.

Now, Trump had a very healthy margin in the electoral college which might make it seem like an easy prediction, but he only hit 46.1% of the popular vote. Hillary on the other hand only hit 48.2% which shows 5.7% of the population was willing to go 3rd party for whatever reason.

In the end it’s never a single issue, Hillary supporters stayed home on Election Day in part because she was predicated to win. That’s the kind of issue that makes predictions so difficult. It’s rarely a question of undecided voters, but rather who is willing to show up to vote. Something as simple as a little rain can swing elections.
>The difference between patenting a chemical compound is a patentable compound is probably not producing itself naturally without constant human intervention.

So your argument is that if something can self-replicate, it shouldn't be able to be patented? Let's say we invent self-replicating nanobots in the future, should that be not patentable?
Plant patents like this have been around since 1930. It's old and established law.