skysight-inc/HackerNews huggingface dataset:
Who _are_ you?

Now, don't take this personally; there's just not many people that I know that could out-smart plain old dishwashing on such a fundamental philosophical level. I'd love to know what's your background and how you learned think in this way — and I'm asking mostly because I could use some of this way of thinking in my life as well.

I am what most people would call a "productive person" — I'm at one of the best universities in my country, have top grades, have a part-time position in a pretty good research facility, and I'm also slowly chipping away at my startup idea.

Sometimes I'm all happy about this, but other times I see that there's not much time for being "myself" between all these activities. Now, please, bear with me — it's hard to put it in words.

Often I ask myself whether I actually care about these activities, or whether I do them just because it is easier to fill my free time with all sorts of different things and delegate the question of „what should I do next” to external factors. The fact that I don't really care for good grades but at the same time act as if I did care, for example, made me wonder whether the values I have been raised with are really _my_ values, or whether I follow and fulfil them just due to some kind inertia mixed with inability to find my own values. And I’m sure that not only my cowardice and the imprinted values are at fault — the western culture is surely doing its part as well.

But don't get me wrong — I enjoy being the best, I enjoy programming (@ the startup) and the hard work (@ the facility). I just don't know whether it's me enjoying the stuff or some frankenstein of my parents' values and general cultural views occupying the space inside my head... I’m not exactly unhappy, I’m just not sure whether I’m taking the right path here, that is to say „my path” [1]. I think that learning how to think about things on a fundamental level, as you did, could help me in my case as well.

[1] A little side note: From the practical point of view, being raised to be "the best" has its warts — e.g. when your entire self-worth depends on external measures of "bestness" and crowds of people that praise you for your brilliance. So, even though I'm not unhappy, I foresee that I certainly will be at some point in the future if I don't rethink my values and a big chunk of my life — so I might as well start right now.

[2]: In case this is too OT for HN, I'd be happy to chat at wybitul [at-sign] evzen [dot-sign] dev.
A phone without updates becomes insecure.
I’m disappointed to see that this website only gives you two options, “read the privacy policy” and “agree.” It does not list out each use of cookies and data collection and allow individually opting out of each use case, which is what most sites do and what I believe GDPR requires a business to support.

If the only way to make the large banner go away is to click “I agree” then you are actively harming your users and at the very least should be ashamed of yourself.
I see a lot of these things and I don't understand them. I've done too much ETL so I'm not naive. Now either 1) people are making a mountain out of a molehill (not saying that's happening here, but in other cases I think so) 2) there's something my experience of ETL hasn't taught me or 3) these tools are specialised for niches. This one talks about 'large datasets' but I don't know how large that is.

Some questions then

> Often it’s important to see how data changes between every iteration, and particularly useful if you have 1M+ rows and 100+ columns where “SELECT *” becomes useless.

select is fine for diffing. You just do an either-way except , something like

(
select f1, f2, f3 ... f100
from t1
except
select f1, f2, f3 ... f100
from t2
)
union
(
select f1, f2, f3 ... f100
from t2
except
select f1, f2, f3 ... f100
from t1
)

used this and it's fine on many rows (millions is fine but I do recommend and index and a DB with a halfway decent optimiser).

> (2)

Interesting. OK.

> (3) Data transfer validation: moving large volumes of data between databases is error-prone

Really? I never had a problem. What is 'large'? what problems have you seen? There are easy solutions with checksums, error correction (comes free with networks) or round-tripping, is that a problem?

Edit, just done that with mssql tables, 8 cols, 38 bytes per row, ~776,000 rows (identical but for one row), diff as above takes 2 seconds without an index (with PK it takes 5 seconds. Sigh. Well done MS). The single row discrepancy shows up fine. Totally trivial to extend it to 100 columns (did that too in previous job).
I've never used mac os, but definitely get you on sane defaults. From what I could tell, the few linux desktops that were actually meant to be used with their defaults and not customized immediately were the ones on elementary OS and Gnome, and they've actually gotten pretty nice and consistent in their design, and pretty good about spacing.
That's not supposed to be surprising, it's the fact most pulse OX meters are known to not work well for darker skin and it simply wasn't fixed.
Well, it certainly seems like you care, so which is it? Do you care or not care?
It very well could be less of a problem than roundup, but at the same time it's good for everyone I think, that we turn off the lights at night. If only to see the stars.
1) Trim what you can

2) Dig up what you can

3) See if you can find a syringe so that you can actually inject vinegar directly into whatever is left. Apply as close to the root as possible.
I installed a couple of new sticks of RAM in the Spring.

In terms of security updates for motherboards and other hardware, they're very rare. For my phones/tablets, some are literally pinned to ~Android 6, with just oodles of known security holes.
Classic Google.
Divorce Laws and Family Distress [pdf]
Using your phone's camera is niche? I don't know about you but I easily take a dozen photos a day, between SC and work documents and social photos.. honestly the quality of a phone's camera hardware and software is the defining factor for buying a phone for me.
I appreciate the feedback! I definitely think adding some examples to the homepage is a good feature.

This idea was something we, a group of college students, felt was missing from our social interactions. I agree, it's a bit clunky to set this up mid conversation.

I, personally, find that this works really well with existing friends or when forming new friends online through things like Instagram or Tinder.

To your point, we're always looking to expand our use cases and reduce the first time friction.
I like Terra, and I have played with it, but I have not found a use for it to push me to really explore it. I'd love to hear from anyone using Terra for cool projects. I had watched a talk about MAD-X [0] that I found very interesting, but it is specifically for particle accelerator design in physics [1].

[0] https://mediastream.cern.ch/MediaArchive/Video/Public2/weble...

[1] https://mad.web.cern.ch/mad/
I doubt it, given that Burst does optimizations, with a constrained C# subset tailored for replacing lower Unity layers previously written in C++, and is already being used in production.

CoreRT is still a preview tech that has to deal with the full capabilities of .NET Framework, including VB.NET, C#, F# and C++/CLI as generators of MSIL bytecode.
SEEKING WORK | Boulder, Colorado | Remote OK

Technologies: JavaScript/ES6, SASS/CSS, React, Gatsby, WordPress, Figma, Sketch, jQuery, User Interfaces, Git/GitHub, Web Application Development

Résumé/CV: Available on request.

Email: tuckertriggs(at)gmail.com

Website: https://tuckertriggs.com

LinkedIn: https://linkedin.com/in/tuckertriggs

Github: https://github.com/tuckpuck

Full-stack developer (front-end focused) specializing in using Javascript, React, and various other tools to build modern websites and web applications. I have a versatile skill set and strong communication skills. Looking for contract work.
Show HN: Avatarz – A Library of 3D Avatars
Of course, but there are many situations in which one must deal with the input one is given.
Two separate things. The tolerance for blood oxygen is centered around sensor readings from white skin. Which is a bias.
Yes, I certainly don't remember my high school textbook mentioning anything about how America's CIA-led foreign policy should be considered explicitly "amoral." Even here you get the usual spook dissembling from Miles Copeland -- it's plainly immoral.
Well, we really are in many parts of the world due to Climate Change. If it keeps getting worse, it's always unusual compared to the past...
Win-win situation for American socialists: increase number of state-dependent businesses and create more unemployment to increase the number of state-dependent voters.

If you like your gold now, you'll love it when Biden & Co get their hands behind the wheel!
A crash course on hacking satellites
You can't just go out and start an ISP.

That's like saying I can go out and start my own bank or make my own payment processor.
It is only for European users
I saw a different study that said on Twitter right-leaning accounts also follow the left-leaning accounts, while left-leaning accounts do not follow the right-leaning accounts.

This matches my experience in the bay area and progressive social media circles where one group has a trend of immediately blocking someone that isn't using the verbatim party line talking points. A "with us or against us" mentality, whether you are actually on the other side of the aisle or not.
Agreed. I have a hunch that any solution to this problem will look similar to https://github.com/simonw/datasette if it develops. Tied together with https://supabase.io/ and you've built a versatile, powerful, open data collaboration engine.
This is what happens on explicit import, but, formatting is per-cell, not per-column. "General" is the format for "idk, guess" - it stays General after a transform, it's not converted.
> There is no way to map all Py3 features back into Py2 so 3to2 would be a broken mess that only supported a subset of the language.

Oh but there is. If you can map them to bytecode, you can map them to Python 2, which is a fully capable language. It won't be a one-to-one map, but that's also not required.
I'm an xoogler who has only owned Google Nexus and Pixel phones until recently when I switched to iPhone. The primary reason I switched was the limited support window that Google has for its phones.
This happened to me! Someone sent me a spreadsheet where OCT4 was changed to "October 4"
Were you using the phone each day to battery 0% straight? Did you consider getting the battery replaced? Those performance issues are completely explainable by the battery age + performance throttling for aged batteries, if you were a 100->0% without any charge during the day kind of user over the course of 1.5 years.
Yeah, and if there was a real pressing need to get an more accurate number, you would get an arterial blood gas.

Pulse oximetry is for monitoring change. When a critical value is needed for medical intervention, such as a decision to put in a breathing tube, tests like arterial blood gas has are used.
Integrated finance and e-commerce platform launch
How does this work for usb typec? When I plug in my power cable will my computer shutdown?
Cars have headlights.
"Myself and Mr Y are currently relying on our savings, Mr X I think gets income from his other projects."

" it's me and Mr Y doing most of the work at the moment."

It is just a matter of time before things crash. Extreme Red Flags here. Mr X seems like the type of person who knows what he is doing so it is unlikely he will change and only focus on this specific project. You need to either get more equity or get out fast before burning more savings.
> If nothing decomposed, the earth would pile up kilometers-deep with the bodies of animals and plants

Hem, not. Much more probably some animal would eat this corpses. Not to mention that life beings are lets say between 60% to 99% water and dried corpses would not take so much space. It is a suggestive idea, but is also wrong.
> It was quite literally making random combinations of various trigonometric functions, absolute value, logarithms, polynomials, exponents, etc. into equations that were like a whole page long and just wiggling them around.

Technically, we call that a "neural network". Or "AI".
Desktops and laptops are commodity hardware with standardized drivers and interfaces. Phones are secretive buggy hardware running secretive buggy binary blobs. It's difficult to get manufacturers to upstream anything or even give you any information at all about their hardware, and it's a herculean task to work around all the firmware oddities to upgrade devices yourself.
I'm not the person you replied to but I've used hackintoshes since the Snow Leopard days. Generally if you set it up properly as was described at the beginning of this thread minor updates will work fine without any user input. Some major updates will be the same, with others you might end up needing to change some kexts to fix audio or wifi but it'll generally boot. With major updates that change a lot you might be better off backing up your data and doing a fresh install.

So far all versions have become hackable (generally in a matter of days or weeks) but with Apple's transition to their own silicon I imagine the last version they put out that supports x86_64 will be the final hackintoshable build.
We were able to do that for an alley light here in small-town Minnesota USA.
Hopefully they'll actually support motion aiming like on the switch this generation. It makes it a loooot more bearable. A lot of the waggle games on the wii have just burned people's expectations for motion controls, but if you try it with a ps4 or steam controller on pc you'll notice it's much more mouse-like than on just 2 sticks.
Perhaps in theory, however, this administration has constantly given itself more and more power while the president's party mates in congress stood by and did nothing to check it. Yes, very recently, SCOTUS has checked the president's power a bit, but tying this stuff up in Federal Courts is, at best, a waste of tax payer money.

Luckily, elections are coming up in November.
Or just use OpenSilver, thanks WebAssembly.

https://opensilver.net/
Why should I, as a power company, be forced to pass through power that is used to support people who I think don't vote according to my political party?

You can always start your own power company if you fancy the other political party.
Apple considers a product "vintage" five years and "obsolete" seven years after the last one is sold: https://support.apple.com/en-us/HT201624
I agree, you shouldn't try to get someone's attention before typing a complete thought. But it's the original attention-seeking message that's the problem, not the complete thought. Maybe what I'm saying is that we use Slack at work almost completely asynchronously?

https://www.nohello.com/

This same coworker will also "formulate his response quicker" without letting you finish what you're saying in person, too. Then he'll interrupt you to go on some tangentially related rant, and won't stop unless you interrupt him back or he's repeated all the points of his rant three times. So maybe he's just bad at this in general, and it only happens to manifest as too many notification pings in threads and DMs on slack, when they're not really the core problem here.
Correct. It's fairly easy to know whether the dosage you are taking is working, since you can check levels. 8000 units is a really high dose, one that I have never had to give. The article suggests that 98% of people require that much to get to normal levels, which is almost laughable.
My understanding is that these are not legal in most first world countries anymore -- I know they are banned in Canada and parts of Europe at least.

It sounds like Germany is already on their way to banning glyphosate[0]

0: https://www.theguardian.com/environment/2019/sep/04/germany-...
Title seems to be clickbait, from the article:

> This feature is only supported on select Samsung Galaxy devices and allows Android to stream apps to your Windows 10 devices.
On specs the Pixel 3a is a no-brainer for me as my Nokia 6.1 is getting long in the tooth however the Nokia has been such a hassle-less little phone and is tough enough to have survived 7000 miles on a motorbike without a mark that I'll likely buy another of whatever their current model is.

Also AndroidOne so I'm still getting updates for it which is the longest after purchase that's ever happened on an android handset.

At least I would except the Nokia 6.1 does literally everything I need out of a phone still so I'll likely wait another year at least.
off-the-record (not written, not cited, but available in personal discussions).
Last year, I was on a Zoom call where I shared my screen, and several web developers asked if I "seriously still use Firefox" as if I was stuck in 2005.
total freedom is indistinguishable from anarchy. civilization developed laws for a reason.

why can't you just punch anyone in the face?

why can't you set the forest on fire?

why can't you buy living people?

don't get me wrong, all these things you list are IMHO very bad and shouldn't be on the internet, but let's create institutions that have the right tools to filter them (these tools include new laws). ISPs have the right tools to forward packets.
My co-founder and I started Imagine Financial to solve exactly this problem. We are coming out of stealth and addressing the problem of interchange head-on. We believe interchange is an unnecessary excessive tax, and we are offering an alternative to all US merchants.

This is an incredibly hard problem, we are learning and don't have all the answers, but it's about time someone tried to disrupt it. Businesses and consumers are suffering, and they should not be charged in this way. Our network is rolling out over the next few weeks and would love to gather feedback from those who want to get involved in changing this industry!

http://www.gotimagine.com/merchants

Feel free to reach out to community@gotimagine.com to get involved.
It's possible to have a nice launch at HN, but whether or not that's going to translate into much value is another question. If you have a really great product that everyone just loves, and it's free (or free to try), and it's built for viral growth - then getting to the top spot at HN might jump start things for you.

But to anyone who doesn't manage to get any traction on HN or PH, I wouldn't worry about it too much - it's one of those things that's nice if it happens but you shouldn't be counting on it in your business plan.
>Different languages/compilers have different levels of variable bits.

No that's the point! Exact same environment same binary, that's reproducibility.
Thank you!

We are [almost] DB-agnostic (as long as there is SQL interface and JOINs are supported) and have been adding support for particular DBs based on the interest from our users. SQL Server & Azure SQL areon the roadmap, please let us know if you have a use case in mind to pilot Datafold on them.
This seems like an odd thing to say about a company that was caught purposefully slowing down older models
Doesn't all Android smartphone manufactures, discontinue their older flagship when newer ones when they arrive? At least Pixel 4 will receive updates ~ for next 3 years, can't say the same for other manufacturers except maybe for OnePlus.

But should we accept this as a consumer? I don't think so, with current hardware, the 3 year limit is artificial and just part of forced obsolescence. More over, an utter disregard for environment; smartphone recycling is unheard of in several markets where these flagships are going to be sold.

Alternatives?

[1] Smartphone manufacturer who cares for people and planet - https://www.fairphone.com/en/

[2] 10 Year smartphone OS - https://postmarketos.org/.

[3] Smartphone with user replaceable parts - https://www.pine64.org/pinephone/

[4] Privacy focussed Linux phone - https://puri.sm/products/librem-5/

[5] Alternate privacy focused android OS with longer support - https://e.foundation/

[6] If you like Sony devices - https://shop.jolla.com/

P.S. I haven't included LineageOS, GrapheneOS and other aftermarket android firmwares as although what they do is commendable, once the manufacturer stops updating the device, the binary blobs remain outdated with the old kernel, even though Android itself gets updated via these projects unlike the other projects I have mentioned above.
I think it's safe to compare across companies for this, because everyone is just laser-cutting 3M vinyl sheets.
I wondered why that has been happening to me too, all techcrunch URLs redirect to advertising.com/* and then stop (extentions / pihole blocking the domain, I guess).

Why would any self-respecting website redirect everyone through a domain called advertising.com on each visit? Who thought that was a great idea?
Better Product Positioning: Systems over Statements
just an FYI: the first key in the search command shows up as an empty key on Windows (chrome). So it almost looks like you should hit Space + K even though I see its actually Control + K.
If those records could have an arbitrary/large number of fields, that would suffice for our foreseeable needs. We're at ~6,000 individual entries at the moment and do not expect a 10x jump at this time. Our efforts now center on updates to and removals from our public map.

Airtable-wise, I'm parroting our devs on the subject. We had perpetual/nascent plans for an Airtable migration (and did so when FindTheMakers came to life) which have been tabled for now. We believe we'll make it to sunset on Sheets, but just barely.
Get your google location history. On an android phone is can be gigabytes. Just one user.
My Pixel 2 XL had heating issue. The battery couldn't last much at the end. I couldn't use it as GPS anymore (plugged or not) because it was over heating. I have a Pixel 4... still get warning about heat when using it as GPS once in a while ( I have the phone in the A/C vents so it has no reason to get that warm).
Digital photography: news and testing, normal visitors are probably all on newer browsers, but during workdays, we get up to 3% IE11 visitors, this falls to under 1 on weekends.
Oh yeah I totally understand why it is what it is. But I like being able to choose a configuration combination that releases me from the rules.
Demand for crypto bent the demand curve at a time when GPU manufacturers needed cash and an optimistic outlook to tell investors.

The astonishing thing was the long life of the 10-series; if the 10-series was an airplane it would be the 737. Hardware innovation has usually gone faster with GPUs, but the long life of the 10-series realized that performance because software had a chance to catch up.
Great, how do you set a custom column format in a CSV file?
Show HN: Arkade (0.6.0) Adds Open Service Mesh and updates linkerd2
oppo and vivo comes to mind. They both owned by BBK Electronics
Early Android devices had removable batteries and most of the popular ones had custom ROMs that extended support for way beyond OEM updates.

The irony is that early Android phones were built to last, but quickly got obsoleted by more recent models. Now, progress is much slower, but the thing that kept devices alive (removable batteries and community ROMs) are dying. Real obsolescence is replaced by planned obsolescence.
I've been very happy with GeForce Now on my MBP (I run Apex regularly). Wired connection, stable upstream connection, etc are a must, but other than that, there's not much downside.
Clover also doesn’t get as tall as grass, which obviates the need for mowing the lawn. And the rabbits quite like it.
That "custom-patched kernel with a bizarre build process" is a self-inflicted wound on the part of both Google and the carriers. It could have been corrected years ago.
Horror Films Where Actors Were Intentionally Harmed
If those rods were attached together like a comb, it would be much faster