skysight-inc/HackerNews huggingface dataset:
MySQL partitioning shines with one specific use-case: time-based data retention. e.g., by using RANGE partitioning over a temporal value, you can very efficiently drop large amounts of old data when no longer needed, and can automate this fairly easily.

For anything else, MySQL partitioning rule-of-thumb is you'll have a bad time, mainly for performance reasons.
the same thing as when it happens with your airline
The only interface that makes sense to me for this kind of application is something non-invasive and can be removed like headphones. Governments could still forcibly apply it to you under certain circumstances but you might be able to retain some semblance of privacy otherwise.
Yes, all of them should be protected by the US government so they cannot simply be sold to the highest bidder. Once these ancient trees are gone, they will never come back. The Parks Service seems to be able to keep these alive and in good shape for the benefit of all
Any interest in selling it? I’ve been curious about trying one, and I’ve also been trying to get better at reusing things, rather than buying new ones outright, so one with a sufficient layer of dust seems perfect.
I had the same experience, unfortunately - although I recognized early and returned it a few weeks after getting it. At the time the software was bad across the board: on device and off. But the clincher for me was the price of the device was as much as you'd spend on an iPad and it had no backlight. I'd go back to considering ReMarkable on next generation if they've learned from gen 1. My use case was 50% book reading and 50% note/idea pad. I didn't feel it excelled at either of those. And while I don't enjoy reading on a tablet the writing experience on the iPad with a tactile screen cover is actually very good. I realize many would disagree there and I'd agree with that without the screen cover. I hope ReMarkable keeps going though. In the end it seems like they've left the platform open enough compared to the locked down ecosystems. I refuse to buy any Amazon branded eReader because of how limited in use they are without the Bezos ecosystem.
These sites are all highly likely to be using something known as TLEs (two line element files) or "keps", which come from NORAD, based on radar observations, for their positional data.

https://www.celestrak.com/NORAD/documentation/tle-fmt.php

https://www.celestrak.com/NORAD/elements/

Anything using these TLEs should be identical.

For radio reception, if the problem wasn't pointing calibration, I suspect it was polarisation. There is ~3dB difference between 0 and 45 degrees, but ~25dB difference between 0 and 90 degrees. Therefore either use circularly polarised antennas (e.g. https://www.wimo.com/xquad-antennas_e.html) so you're never more than 45 degrees out, or if it's hand-held, simply twist the antenna for maximum signal strength. The polarisation will vary through the pass.

For some really crappy satellite positioning / radio software that everyone uses because no-one's written a better one yet, check out satpc32.
> Until my parents in law installed multiple Alexa microphones in their house

How are the privacy implications of Alexa microphones any different from those of smartphones (which contain microphones and voice assistant software, just like the Echo does)?
https://archive.is/pLA50
here's another close call which almost ended very badly:

https://en.m.wikipedia.org/wiki/1961_Goldsboro_B-52_crash

"He also said the size of each bomb was more than 250 times the destructive power of the Hiroshima bomb, large enough to create a 100% kill zone within a radius of 8.5 miles (13.7 km)."
There's so much wishing and hand waving based on ideology here that it honestly is annoying to read many articles.
Show HN: Thomas Edison and Bootstrapping
Back in the day my father was a service tech for NCR retail systems. For one of the lines they shipped out every system fully loaded with ram and disk - however how much their customers got to use depended on jumper configurations which the service techs would set and verify. I think IBM does the same thing with their mainframes - they ship out fully loaded but you can only use what you pay for, the rest is used as hot stand-by for hardware failures.
They were given a new random map every iteration of the game, at least in the second experiment.
Do you work for We Work?
Was thinking about that last line for last 12 hours. What does constitute an authentic experience these days?
Forgot to mention: cache misses can be more expensive than uncached accesses, so testing with caches off and then turning them on in production can be a disaster if you hit a cache-busting access pattern. Always run what you tested.
I really like this. There is only one thing that bothered me. I'd rather pass the job to the pool than pass the pool to the job... something like...

const existingBooks = await pool.exe(select("books", { authorId }));

or

const existingBooks = await pool(select("books", { authorId }));
The Thinking on Brain Games
This is the same guy that rescued the coyote pup a while back. I can't find the full video on his channel any more, but did find an 'archival copy':

https://www.youtube.com/watch?v=02m_oByCJ8A
iirc this incident is one of several captured in the book "Command and Control", awesome read.
I quoted the transcript verbatim. Then restated the quote. But I didn’t use the word “increase”.

I stand by my statement. If I’m wrong, please correct me without misrepresenting it.
A life ended too early. Thank you Aron for your inspiring work, love for the fans and being the great person you were.
To save you the google lookup, he played Nog the Ferengi in Star Trek: Deep Space Nine.
Kaibeezy linked to Greg Egan, who's one of my favorites in this area.

To my mind the latter is logically impossible. Subjective self-continuity is not intrinsic to the experience of consciousness, it is a conclusion we draw upon introspection, based on circumstantial evidence. Subjectively, all we ever have is a sequence of fleeting moments. We only have the "word" of our memory to trust that the Now Me is a descendant of Past Me. As soon as perfect replication is possible, the replicant and the original have exactly equivalent claims to identity in every sense that matters, just one will have a better claim to physical continuity. But physical continuity is not the most important aspect of identity, it's just our intuitions favor it so heavily because it has historically perfectly coincided with conscious identity.
Almost one in five men admits to having no close friends, a survey has found
I'm always a fan of the bringing together of the sophisticated and the profane. Thanks for sharing.
This is your video driver's fault not X's.
Looking over this stuff, I get an uneasy feeling. X was a brilliant solution to problems 35 years ago, where you barely had enough memory for a full frame buffer and the graphics model was primitive (no antialiasing or transparency). From what I've seen, Wayland is a good solution for the model maybe 15 years ago, where you're willing to accept the frame-and-a-half latency hit from having a compositor in the path.

Basically, my question is whether anybody is working on a solution for the hardware we have today, where there are hardware overlays, the GPU throughput is orders of magnitude higher than what's needed to composite a desktop, but we still care about memory bandwidth, largely because all of resolution, bit depth, and frame rate is still going up. And you really want to be able to schedule every pixel that gets presented with a high degree of timing accuracy.

I've become familiar with Windows, but feel like it's a bunch of hacks. They will promote a window to an overlay, but it's all a heuristic, and I'm pretty sure latency will stutter while it does the transition in and out. And the new flip-model stuff actually regresses the ability to do smooth window resizing.

I'm not even sure macOS is working on lowering latency. I haven't seen any mention from them of hardware overlays.

Most of the attention these days seems to be in the VR/AR space, where latency is obviously important, and there's more of a green field with respect to legacy compatibility, but I'd love to see this problem space actually solved on the desktop. Doing this right is not easy - it probably requires some form of soft real time discipline across the graphics stack (including GPU scheduling) so you can race the beam.
i would say an update to the std lib to bring LWT into the language. something as simple as reading a file without an external lib is verbose
I find it interesting, in fact blood can turn green as well, without being an alien:

https://en.wikipedia.org/wiki/Sulfhemoglobinemia

> Sulfhemoglobinemia is a rare condition in which there is excess sulfhemoglobin (SulfHb) in the blood. The pigment is a greenish derivative of hemoglobin which cannot be converted back to normal, functional hemoglobin. It causes cyanosis even at low blood levels.

>It is a rare blood condition that occurs when a sulfur atom is incorporated into the hemoglobin molecule. When hydrogen sulfide (H2S) (or sulfide ions) and ferric ions combine in the blood, the blood is incapable of carrying oxygen.
I'll take it off your hands if you want. Email me at gmail.
Been watching this dude since the beginning, he's like the Andrew Dice Clay of Botany. Knows his shit for sure.
> If you do not allow your neural state to be monitored and inspected in response to various stimuli you will be turned away at the border. Give it 5 years.

5 years?!

Not even 10. We are very far from that, even excluding practicality.
Oooooo, I think I'll throw a site up for submissions with that premise this week. Great idea!
I have bought both the Remarkable and all the Onyx Boox Max devices.

I ended up selling the Remarkable since I stopped using it after University.

For most textbooks a 13 inch e-reader is much better.
I sort of disagree with your main assertion. I do big data for a living and what I have seen is that our architecture is dictated to us from above for reasons of "fashion" not really for any reasons of practicality.

I'm actually looking for a different job for that reason.

We are required to used Java on K8s, Kafka & Cassandra for every single solution big or small because it is fashionable, not because it gets the job done well or for any other reason. I can even demonstrate how a couple of Python scripts and Pandas could do all the same work with far less overhead and achieve the same results. Crickets. Python is not sexy where I am, it is the language of peasants, apparently. Not sure what to make of it all, but that is my reality right now.

Also, I don't think you know anything at all about driving race cars. The driver has a tremendous amount of input into the car's setup because it's his life on the line out on the track. "Adapting to the situation" gets finishes, not wins.
>free market

just a nitpick but land ownership-based industries, in which you get a license from the government to own and lease out monopolies on land, are inherently far from free markets. ive always wondered if land ownership could be made to be more free market-like.
By value, and definitely onto better storage.
1TB is not enough for Internet Radio, it's not even enough for most podcasts.
Probably Osmo Wiio.
Top third of the screen is covered with a cookie warning, bottom third is warning me that I’ve read 1 of 3 free articles, when I scroll down to read this article they already count as read, there’s a big empty space, followed by a prompt to subscribe to some newsletter, followed by four lines of said article, which fade over into a button to actually read it - followed by an attempt to distract me with a different article.

I get the hint, you really don’t want me to read the article, so I won’t.
For Airbnb employees, dream turns into disillusionment
Don't forget when someone very confidently gives you the answer that is completely wrong.
Use what you're most comfort with, not what others are.

Postgres and MySQL (MariaDB/Percona) are both big players with a huge community.

Maybe consider to use Mariadb or Percona instead of MySQL to avoid oracle vendor lock in.
I thought there was a way to use a users quota instead of yours. But hopefully Google just comps you a quota increase.
I can't wait until I can browse the web on a device like this
This entirely depends on the domain and data model, and unless you need SQL - mongodb should be a consideration too.
Did you try downloading it by chance? I get 404 on that toolchain link...
What android tablet with a pen would you recommend?
That sounds absolutely horrible. The whole point of a book is it's finality. I don't want to have to pull a book as a site down every time I want to read a book. It sounds like this model is focused on some sort of DRM approach that has little to no usefulness for people who want to read a book.
No. MongoDB has a track record of losing data and not actually providing durability. It is considered a joke in the professional community.
Object recognition and swiping right on tinder
Too many Open Source developers discount the value of documentation. I all too often hear, "It's Open Source so the community should step up and write the documentation." To which I counter that the best person/people to at least start the documentation are the ones who build the product as they're the most knowledgeable about it. The community will gladly contribute. I personally believe that great documentation was a big reason for PHP's success in the early days.
How much cooperation is needed though? It seems to me that all that numpy pandas etc. need to do is maintain a stable API, which they already do AFAIK.
Two trends which I am familiar with are the excess development of South Florida and Harris County.

Both driven because the county government is funded by taxes on property rather than commerce.

To achieve growth in the bureaucracy, taxes have increased as fast as possible, and additional property developed at a growing rate in order to increase its taxable value.

In Florida it's lots of building only slightly above sea level so there's risk from the beginning, in Texas as more of the watershed/flood plain is paved neighborhoods that were not at risk before have become underwater estates.

>They need higher flood insurance premiums to discourage building.

We already have that. Just results in more people becoming uninsurable. Regulation would probably be better, but county governments are incentivizing toward developers who can afford to work around this type of discouragement anyway, which is one of the cases where it pays more than regulation. Now that the damage has been done, the most pro-development Harris County Judge of all is no longer in power, but there's still residual momentum, and it's a little too late. You should have seen it this week.

Looks like some "Real Estate" systems have been selling you false estate since the beginning. After all you can not disprove that the purpose of county government is corruption.

I can only imagine what would happen if you got unscrupulous developers mixed up with government like this on a larger scale.
In other words, you don't actually believe in free software. I recommend you read the definition of Free software [0].

> The freedom to run the program as you wish, for any purpose (freedom 0).

I think people slap on MIT/Apache license without thinking about it too much, and then get salty when people use that license as intended for profit. This is why proprietary licensing exists, this is why the GNU GPL (copyleft) licenses exist.

You cannot have your cake (free software) and want to eat it too (get paid when someone wants to use it for their profit).

[0]: https://www.gnu.org/philosophy/free-sw.en.html
I suppose the parent was referring to Medicaid.

As per Wikipedia [0]:
"Medicaid is the largest source of funding for medical and health-related services for people with low income in the United States, providing free health insurance to 74 million low-income and disabled people (23% of Americans) as of 2017"

So flat out lie?

[0] - https://en.wikipedia.org/wiki/Medicaid
Very cool!

How much trouble does Julia’s JIT compiler latency cause with this? With a big complex website does every button introduce compiler latency the first time it’s hit by a user?

And once you have a Julia session running and everything is fully compiled, how many users can one session support comfortably?
In my country it is not that common. Usually the companies that ask you to do them have a culture of well... nothing good. Even if I pass the test sometimes that just sets high expectations which I might not be able to meet (at least not in the first month of probation).

Don't get me wrong, I am not against such challenges, as they could be useful. It's just that my experiences with companies that do these have been bad.
Rudy Rucker discusses a project like this in the Lifebox, the Seashell, and the Soul.
Remarkable that someone has actually tried to do it.
Without "increase", Boz's statement can also be parsed as "how much privacy, safety and security we can tradeoff for the largest amount of money".
The OP said "absolute power" not "any power" so let's at least get that straight.

Nice goalpost moving, though.

And TBH, I don't know anyone who uses their current job as reference for the next job: probably wouldn't go over well. I still have people I last worked with 10 years ago using me as a reference.
To connect them, the entropy of a system (such as an ideal gas) can be computed as the logarithm of the number of equally probable microstates in your probability distribution for that system.

(You need to define a sensible measure, because the state variables are continuous, but that's not important).

You can express this in terms of the message length or number of bits of information you would need to gain about that container of ideal gas in order to narrow it down to a particular microstate.

It's no different than the entropy of, say, a password.

> There is no way to reduce the entropy of a totally random system by knowing more about it

There absolutely is! For example, Maxwell's demon. Maxwell's demon will fail to reduce system entropy if it doesn't know the microstate to begin with, but otherwise it can use its knowledge to reduce the entropy of a gas by separating its parts.

> unless your hypothesis is that true randomness doesn't exist in the universe

I do also subscribe to this hypothesis, that like entropy, randomness also only exists in our heads as a reflection of our lack of information about a system, and isn't a property of any system itself. But I don't think I need to rely on this assumption.
It's nice they have this freedom, but for a while now, it's been harder and harder to find a truly coherent album. Something that you can leave on and feels like a single piece of work.
Fujiwhara Effect
I really like the direct DB to filesystem mappings of the MyISAM engine in MySql. A database is simply a directory. A table is simply 3 files in that directory:

- One for the structure
- One for the data
- One for the indexes

You can simply copy a MyISAM database by copying the directory (while the MySql server is stopped).

MariaDB has forked the MyISAM engine and created the Aria engine. It is a crash safe version of MyISAM and is now their default engine for all system tables.

So in contrast to MySql, you can completely disable InnoDB in MariaDB. MySql does not support that anymore as their system tables are InnoDB.

Especially for non-concurrency workloads, MyISAM and Aria are super fast.

For these reasons, I really like MariaDB.
Ford may come before Tesla. They have a much more developed assembly process. https://electrek.co/2019/09/02/fordl-electric-f150-market-20...
I'd love a list of all the too-earlys ..
Entropy is maximized for an isolated system (constant energy), free energy is minimized for a system in thermal equilibrium with a heat bath (can exchange energy with the environment). Gibbs free energy is minimized at constant pression and temperature, Helmholtz free energy is minimized at constant volume and temperature.

If you put now the oil/water system into a isolated container the equilibrium state won't change substantially. It remains separated in two phases and that's now the maximum entropy state.
Thank you for taking the time to explain it to us!
The biggest social network uses MySQL because they already dumped so much engineering into it that changing is basically impractical. But it's mostly used as a key-value store backing a custom graph database.
Ask HN: MacBook Pro Display Adapter?
I just started working from home, and I'm having trouble figuring out how to use my macbook as a desktop with an external display. I tried asking about this on reddit, but didn't get much feedback. I know many people here use macbooks with external displays, so I thought I might be better suggestions here.

I have a 2017 13" macbook pro, so I have two usb-c ports to play with. I want to put an external monitor next to my laptop, so I have the laptop display and the monitor side by side. I also want to connect an external USB keyboard, and a USB mouse as well. I have this mokin hdmi/ usb adapter [0], and this one as well [1]. Both work great for running the display and the USB devices. The problem is, each one interferes significantly with the wifi signal reception. I have to constantly - like every two or three new tabs - toggle wifi off and on to reestablish an internet connection. I think this post describes the issue pretty well. (I'm having temporary luck covering the entire adapter with a piece of aluminum foil, but that's not a very appealing long-term solution.)

What are people using to connect to external monitors, and still have power and other usb devices? Are there better hubs that don't interfere with wifi? A couple people on reddit suggested the CalDigit TS3 Plus Dock [2]. I'll buy that if there's nothing better, but I was hoping to not have to spend quite that much just to get a display running.

[0] https://www.amazon.com/gp/product/B074J79WWJ/

[1] https://www.amazon.com/gp/product/B07NRLNTNC/

[2] https://www.apple.com/shop/product/HMX12ZM/A/caldigit-ts3-plus-dock
Great intro and overview: http://coding-geek.com/how-databases-work/

Great book: https://dataintensive.net/

Also great read and overview: http://www.redbook.io/

Great paper over-viewing the architecture of a DB: https://perspectives.mvdirona.com/content/binary/Architectur...

If you're looking into building your own database, there are some great open source projects you can reference here: https://github.com/danistefanovic/build-your-own-x#build-you...

If you want to actually dive into source code - SQLite is amazing. It has very clean and readable code, so I'd suggest using it as a reference as well: https://github.com/mackyle/sqlite
Everyone likes benefiting from Open Source until someone runs with their work and makes a profit.

My take from all of this is that people have no idea what they're doing when they license their work as Open Source.

The go-to process currently is to slap on the MIT license, call it a day, and then forget about it until they find out someone is massively profiting from it.
This article doesn’t really cover the main questions about recycling plastic, like does it have any negative impact on the environment when you throw away plastic.

The case for “no”: https://medium.com/@robertwiblin/what-you-think-about-landfi...
Career advice for a 22 yo from India?
Interests & life goals: Product Management, starting his own startup (or a profit making lifestyle business), reaching financial independence

Recently graduated from an Indian college with computer science degree.

Don't have too much savings but have strong experience under belt from working on several side-projects (with users) during college years.

What career advice would you give?
Also, would you suggest he look into moving and working in the West, (Germany or Canada) or stay in India?
Clickable links:

[0] https://www.amazon.com/gp/product/B074J79WWJ/

[1] https://www.amazon.com/gp/product/B07NRLNTNC/

[2] https://www.apple.com/shop/product/HMX12ZM/A/caldigit-ts3-pl...