skysight-inc/HackerNews huggingface dataset:
Search is unusable on ProtonMail because they can't decrypt your emails to search through them. I've raised this issue with them and they responded that the (current) solution is to use a local mail client to download all your emails and search them using your client.
Hi there! I'm a product manager on our payment methods team at Stripe. We're working on a beta to bring EU payment methods to Australian-domiciled customers. They're both cheaper than cards, and have significant conversion uplift. Mind emailing me at sophies@stripe.com?
Both. YC batches are littered with companies that disappeared. That's not a criticism of YC, that's reality.
There's probably a chance of you being retaliated against or going to jail yourself, depending on how you're doing the snooping.
the #1 reason i think about leaving is due to the interviews as well (also not formally trained). im about 6 years in and its just getting worse and worse. the thought of spending my free time studying for interviews is so miserable. on top of that, i realized recently i have a lot of childhood trauma and interviews are very triggering due to the often combative, critical nature.

it's kinda depressing in a way, because coding was at first, something that pulled me out of the slump i was in due to a shitty upbringing. i really like writing code, but the industry sure does know how to suck all the fun out of it.
It's nothing too complicated but not going into details since half the people reading this are in San Francisco competing with me for delivery slots.
Overall, it's a solid solution. Some hiccups:
- It's common for new investors to ask about pro rata ahead of writing a term sheet (can impact the investment case/deal).
- Especially in difficult times, new investors might invest under the condition that existing investors do their pro rata.
That reminded me of an Army recruiter well known for his “tactics”. People close describes him as a “Car salesman “. Apparently, is very good at making sure the candidate doesn’t change his/her mind.
> How does it do that?

If I remove my laptop battery, I know no one can tap into my hardware covertly. E.g. turn on the microphone, enable bluetooth hardware to see who I'm near, enable 3G/4G hardware to track which cell towers I'm near, etc.

I'd gladly deal with a battery cover on my MacBook in exchange for definite privacy. Better yet, remove the battery from inside the laptop entirely and can plug one in via USB-C port as needed.
But then you'd get sick of making such shitty pots, if you liked pottery as an art form enough to want to learn it, and you'd start trying to make better ones because just passing the bar probably wouldn't be enough for your sense of aesthetics/craftsmanship (or maybe it would, and then you would have learned something as well)
People seem addicted to comparing numbers at a point in time and drawing conclusions, not considering whether they are changing at different rates, not to mention the derivative of the rate of change.

Why would the ratio of, say, cases in NY vs Oklahoma vs. Japan stay constant? Just because? Clean living?

I don't have expertise or authoritative predictions, I'm just saying that graphs are all over the place and practically everywhere has historical data with a different shape, and the end state/equilibrium is not know, except apparently, tentatively, for China and South Korea.
It’s a good point. Maybe I just really miss the little green or orange light on the MagSafe chargers. Then it was just a case of picking up the laptop and going, now I have to open it, give it a second to refresh its status, just to check. I’ve left the house a couple times with a dead laptop since getting the newer machine. Sorry for conflating two issues because I still wouldn’t know if the battery is full or not just from the different port.
> How do you correlate those errors at the application level? If only 1% of sproc calls are the new sproc, any elevated error rates in the application will be hard to see over typical noise.

By using the DBs error reporting features to report back errors to the application, including information about which ultimate implementation was handling the request.
PKB
How to Switch Away from Gmail
I discovered kanboard after several years working as a scrum master. Simple, robust, flexible and free is a good combination. I use kanboard every day for both personal and work.
You could leverage a partnership with @routefusion to solve this. We would help you move that money back to SGD super quickly, and at a great price. We are actually in partnership with company in SG called CardUp, if you have ever heard of them :)

Shoot me an email if you would like to chat more!

colton@routefusion.co
developer.routefusion.co
I am actually surprised they were doing this at all.

They have no obligation to support the startup beyond the initial 7% investment more so for the Series A. Companies who can't stand on their own two feet and raise money on their own simply don't deserve to survive.

I actually wish YC would take it a step further and offer an option where they don't invest any money at all. You participate in the accelerator, have access to their resources, are part of the alumni but simply don't accept the $150k and 7% equity dilution.
Show HN: Zealchain – cryptocurrency and alternate DNS root for the marginalized
Link: https://zealchain.com

I've been working on Zealchain for the past 3 months and I've finally gotten to the point where I want to share it.

I created Zealchain not only so that poor folks can lift themselves up, but also so that marginalized communities can share wealth within the community.

Zealchain consists of two products: ZEAL, the cryptocurrency, and ZNET, the Zealchain network.

You can buy ZEAL at https://altmarkets.io/trading/zealbtc. Alternatively, you can mine ZEAL with the wallet downloadable at the site (or use other mining software).

ZNET can be thought of an alternate Internet. It is, technically, called an alternate DNS root. Essentially, sites on ZNET can only be accessed with the ZNET chrome extension.

Registering a domain name on ZNET costs anywhere between 20 and 50 ZEAL, depending on your TLD.

All sites registered on ZNET are included in the ZNET directory. Through this directory, individuals and companies can find and support businesses from marginalized communities.

ZEAL code: https://github.com/mikejohnsonjr/zeal

ZNET chrome extension code: https://github.com/mikejohnsonjr/znet_chrome

The code for the registrar and alternate DNS root are proprietary.

I'll be open sourcing payments with ZEAL soon.

Please check it out and let me know what you think!

P.S. I am unemployed and am looking for remote work. Please send any leads you have!
I think you need to have some measure of what size of pledge makes sense for survival of a business. $1000 donated to a local restaurant won't help them survive, is that's all they got - and donors pledge is really wasted.
IIRC Outlook did the right thing by replying in ciphertext, but it also did the unhelpful thing of attaching the plaintext in a separate MIME part
Still competitive with "sending husband out to get groceries"
Did you try VictoriaMetrics for time series data? It easily handles 2 trillion plus rows (20000 times more than TimescaleDB in your setup) on a single node [1].

[1] https://github.com/VictoriaMetrics/VictoriaMetrics/wiki/Case...
TIL that Volkswagen make sausages as well as cars
BERT is trained on unsupervised data. It's not the same kind of model the article talks about.
Top Travel Spots in 2020
I've had good success with the Upright GO.

It's a little device that you stick on your upper back and connect to your phone via Bluetooth. It detects when you're slouching and buzzes your back with a slight vibration to remind you to sit up straight.

https://www.amazon.com/dp/B0747YHYZF/
> SQL is designed for rows of flat data.

That is no longer exclusively the case. SQL is used in plenty of places to query nested and semi-structured data. In fact I use it on a daily basis. Eg: avro data in/from Kafka, "json" data from MongoDB.
I believe YC is still taking an initial stake of 7%, the 4% corresponds to pro ratas and follow on deals. I think the article just messed that up
Virological assessment of hospitalized patients with Covid-2019 [pdf]
I must admit, I get this feeling from using the product over the last 2 years. I moved us over from Jenkins to CircleCI and while on the whole it was positive, we’ve had a lot of issues and the product has failed to live up to some of the promises made in our trial period.

We basically just hit hard edges and missing features very quickly, and what’s there is good, but not great.

Each bit of the product feels good, but it feels like there’s a lack of direction, product thinking, understanding users, or something at a fundamental level that is causing friction.

I have a friend who worked there a few years ago and from her experience it sounds like there are some good engineers, but some careless decisions being made.
Not sure what there is to complain about here. There's a checkbox to turn it off if you don't like it, and anyway it's designed to adapt to how you use your laptop.
investors have relationships with YC that might lead to information about intentions leaking. So not a perfect solution?
Sure, but those projects can also trivially set up logging with their own bots and in their own clients, with better control of what is logged, when, why, and how those logs are shared. This service appears to have logged fewer than 100 channels. This wasn't an aggregate logger and anyway aggregate logging probably isn't permissible anyway due to GDPR.
I completely agree. But I am curious as to why the economy only allows a certain number of winners. As in, why do 90% fail?

Additionally, if you fund 100% of companies equally, if 1 becomes FB and 99 become nothing, dont the winnings from FB pay for the losses of the 99?
It's not clear to me that asymtomatic doesn't mean immune. If the primary symptoms are due to over-replication of the virus and not fighting it enough resulting in cell death in lungs and other airways, then asymptomatic infection indicates the immune system is fighting it enough to fend it off.

Now, this rests on symptoms being directly caused by higher virus cell counts rather than toxic byproduct cascades of some sort. I'm not sure that's true
I get it. Everyone wants to find some meaning and importance to justify what's going on.

Tons of jobs and wealth are being destroyed, governments are issuing tons of debt and expanding the money supply, people need to believe they're saving millions of lives.
<body align="center"> is not supported in my FireFox 75 on Mac
I have the same machine and I used this option with volta - it was the most reliable in turning down the heat while keeping the system stable but at the same time it made the system considerably slower even in day to day tasks (with just a few of background build watchers and server + a YT video on the second screen the RubyMine become unresponsive regularly)
Possibly dumb question, how do we know someone with antibodies was exposed? The whole idea of vaccination is based on multiple things producing the same antibodies, so isn't it plausible there could be related viruses or genetic factors or something that would lead to antibodies for some people that hadn't been exposed?
YC is a for profit entity. Why would they offer a free cup of coffee much less access to the resources and network if they aren't getting anything out of it? I like YC and enjoy HN, but the altruism comes after the profit (as it should).
What!? Query Language is such a loose definition that graphQL certainly meets it.
The problem here is that everyone will know if YC will follow up or not during the process.

Investing is game of information. If an investor can’t figure out who else will be on the cap table, they have much bigger problem.

The way it is going to go down is that investor during meeting will ask if founders think YC is in that round. If founders say something along the lines of YC decides after term sheet, it basically means no.

In the end
, the overall result is that less YC companies will raise, but the good once still will, but it was always the case.
Looks good! However, I don't want to use dropbox... any plans for supporting other data sources?
Using GitHub Teams to Manage SSH Access
Especially these days where the sophistication and progress of companies look to be on a different level as each year passes.

I know talking to pre-seed and seed investors that they expect you to have enough data to be able to quantify whether people really love your product.

At that point you basically have customers and traction and so $150k for 7% looks like a major negative than a positive.
Of course, look up PTSD. This has been recognized for at least a century.

Your other shock comment approximating the use of the N-word was harmful too. Why actively work to harm members of this community?
I like the way you think. You should write a blog!
There's a difference if the client developers can register stored procedures. Typically, you can't do that with RPC, and it's a big value-add of GraphQL.

If that happens, then SQL and GraphQL look a lot alike. SQL would be more powerful, which also means that it'd probably be somewhat harder to implement, though there are so many SQL engines existing. I can't imagine people implementing from scratch.

I can't wait for Hasura SQL-to-GraphQL-to-SQL.
I've worked in exception based code bases such as Python (Twisted specifically) and Go. Unlike many, I've used both in the same organization working on similar problems for nearly a decade while the scale of number of engineers working in the code and the number of requests it serves have gone up considerably. Hundreds of contributors. Billions of daily requests.

I humbly suggest that indexing on the lack of exceptions as a quality measure is a poorly lacking criteria. Ditching exceptions in Twisted Python and porting code to Go has created vastly more readable, maintainable, and performant code in multiple cases for us.
Love the landing page - simple and to the point!
Hey HN. I switched away from Gmail a couple years ago (after a decade on it), and the switch wasn't nearly as painful as I anticipated, thanks in particular to two things, that I think a lot of people don't realize:

- When you remove Gmail from your Google Account, you'll be able to keep your Google Account, using your new email address as your Google ID. This means you can continue to use Google Docs, etc.

- Your Gmail address remains yours, and you can reactivate it at any time.

I've commented about my experience switching away from Gmail a couple times, so I decided to write a quick post about it. Nothing groundbreaking here, but hopefully it's helpful to a few folks.
Does this include elevated temperature?
>or maybe banks colluding to protect their interests?

Mostly banks and retailers colluding together to use a cheap domestic-only POS-only scheme (think Przelewy24, but offline or LINK but at POS).
How does this work for complex queries with sub-queries, LEFT OUTER JOINs, LATERAL JOINs, aggregation (DISTINCT/GROUP BY), window functions, CTEs, RECURSIVE CTEs?

I've a radically different approach: can the queries in question as VIEWs, materialize them, use triggers to update materializations where you can write those triggers easily and the updates are quick, or schedule an update where they're not.

If your RDBMS is very good about pushing WHERE constraints into VIEWs, and depending on how complex a VIEW query is, you might be able to make the update automatic by just querying the materialization's underlying VIEW with appropriate WHERE constraints from the ROWs being INSERTed/UPDATEd/DELETEd. You can tell which VIEWs might suitable for this by checking that the TABLE whose row the trigger is running for is a "top-level" table source for the VIEW's query: meaning a table source that's either the left side of a top-level LEFT JOIN, or either side of an INNER JOIN. If you can run a query on the VIEW with a timeout then you can just do that in the trigger and mark the materialization as needing an update if the query is too slow. Lastly, a scheduled or NOTIFYed job can run to perform any slower updates to a materialization.
How Much Traffic Do U Need to Make $100
Ask HN: Will the software industry come out of Covid-19 stronger or weaker?
Will the software industry be weaker or stronger 12-18 months?
for something like this I would feel that the two relevant dates are when the facts happened and when the act of writing is set.

As in if you are writing about a trip in 2002 and the page is written as if you wrote it soon after the trip then the date of publishing is not really essential (in terms of semantic html I think it would still be good etiquette to have is "somewhere" on the page, like in a footer, tagged as such, same thing for a "last updated" date)

In this case I would say that is would be nice as a reader if I can understand what the date mean and if it was backdated or not.
$150k for startup/living expenses for 3 months and 7% if they succeed.

$150k in the grand scheme of things isn't much: YC knows you'll raise a lot more and much faster right after demo day if you need to.
1) It has nothing to do with the economy and everything to do with whether people love your product and you have product-market fit. Getting to that point takes time and mostly companies run out of money before they get there.

2) Yes that is how VC works.
You look at measured draws for the relevant workloads. Anandtech has a good intro to the various states that an Intel CPU can be in here: https://www.anandtech.com/show/13544/why-intel-processors-dr...

For Intel specifically the TDP is what you need to dissipate to sustain the base frequency. If you want to run beyond base frequency (the "all core turbo"), then you need to handle more. How much more isn't officially documented, nor are the turbo charts either annoyingly (aka, this: https://en.wikichip.org/wiki/intel/core_i9/i9-9900k#Frequenc... )

So for a 9900K looking the official numbers are 95W for 3.6GHz of all core load. But it'll turbo with all cores loaded up to 4.7GHz, for which you'll need some amount of cooling. How much? Well more than 95W that's for sure, but that's all you really officially know. So then you look at reviews and you find that under full load the 9900K pulls down ~170W if it's not hitting thermal limits: https://images.anandtech.com/graphs/graph14605/111362.png
Introduction to Decentralized Finance (DeFi)
Yes and No. Yes, if the top 10% of households is called "working class".

If a cop and nurse family is the representative of working class, yes, use the people in the service sector (restaurants, gig workers, contractors, etc) to bail out the govt fat cats.
>Probably a cultural thing.

Associating Mastercard and Visa to credit and not debit as well.
Reminds me of how they changed Finder in Mac OS X Snow Leopard (10.6) to report disk capacity in base-10 bytes instead of base-2 bytes.
What's New for Windows 10 Insider Preview Builds (20H1)
Not exactly arguing against your point, but there are distributed SQL engines that can run against multiple data-sources... Presto comes to mind.

https://prestodb.io/
Already pushed WARC files into the Archive for Wayback ingestion.
Jobs was better on privacy than most. People wanted to take user data silently and Jobs’ objection is the source of asking for permissions. Apple’s premium feel relies on that walled garden approach.
All your assumptions are wrong. Please read the other comments here or at least the readme of the repository. I will happily answer all ongoing questions you have afterwards.
I've had good results embedding a query language into the "query" component of URLs for RESTful GET requests. So something like:

https://example.com/messages?posted-2020-01-01/content~Bob

would compile to SQL like

select *
from messages
where posted < '2020-01-01' or content like '%Bob%'

It's a little bit constrained by the the characters that can appear unescaped in the query component of a URL, which is why it uses '-' instead of '<' for less-than and '/' for 'or'. But there are enough characters to allow a range of operators, and parenthesis is allowed for grouping. Also it's a super set of the usual way that browsers encode forms, so that '=' and '&' work the way you'd expect.

It works pretty well!
I have one of these for work and it's the first Macbook I have used

I have never experienced this behavior on any other laptop I have ever used. When I ran into this for the first time, I was completely appalled, it is a horrible user experience
Simple JavaScript state and undo/redo management
But that does not matter - YC will always be assumed to know something extra than other investors. They will have seen something at the weekly dinner, whatever.

So YC's decisions will impact meaningfully on the ability to raise subsequent rounds.

That probably was true for series B anyway, but now its true at the priced seed round.

I get it - its silly to throw gobs of money at companies that will fold next week, especially if you know they will. But ...
0x8BADF00D, one of your comments was flagged, probably because you used an obscure English word that people usually assume is racist, but is in fact not.

Though your tone isn't helping you.

Everyone else:

https://en.wikipedia.org/wiki/Controversies_about_the_word_n...
I'm using gotest for testing, my testing is really primitive right now, no mocking frameworks. The only non-standard library I'm using is gorilla/mux for routing. Go feels a little verbose and restrictive coming from Python, but after being acclimated, I love it. It's extremely productive, performance is nice, deployment is so easy. The pain points for me were understanding the package system and structuring my project, which I worked through eventually.
You don't need a CA for PGP/GPG. In fact, it is generally advisable to never trust a CA for public keys. However, it is common to utilize the fingerprint to verify the key from a public server that has been provided by the user. Ideally though, you'd never trust an email provider to maintain a CA of keys that you'd actually use to send a confidential message.
I like the quit romantic explanation best, that debt in Germany has a moral component. "Debt" and "guilt" are nearly the same word, so taking on debt is a topic of moral philosophy: It's a sin ;-)
Are you really suggesting there's no criticism of the film on the internet? The film has a 59% on Rotten Tomatoes with plenty of criticism available there.

Personally, I watched it for the first time about a week ago, and was hoping for a movie that was primarily about a virus outbreak. Which it was, for the first hour or so. After that it became a generic (and comically over-dramatic) 90s action movie about the military being bad or something. I wouldn't say it's unwatchable, and it's definitely helped by its all-star cast, but I would agree that if you want to watch a movie about a virus outbreak, you're better off watching Contagion.
I should have clarified. I meant an option where they take some fraction of 7%. Not sure whether this is necessarily a great deal for YC or not. Depends how cheaply they can raise the $150k they need for each company in each batch.

I just know for many startups like mine $150k is basically worthless. It's not enough to hire and you just stay somewhere cheaper and commute into YC for the program.
Some samsung tablets (and phones, I think?) have an option that does this - it remaps 80% so it appears as 100% and won't charge past it. Nice way to improve battery health for a device that spends a good chunk of every day plugged in.

A fun side effect of this is that the tablet can boot while at '0%' battery, and then it will automatically shut off a little bit later to avoid dipping below the safe range - presumably '0%' is actually like 10% or so.