skysight-inc/HackerNews huggingface dataset:
Pay attention to the rollout of antibody tests. When available, those will tell you whether your blood contains immunoglobulins targeting the virus, and thus whether you've had it.

If you have, consider also paying attention to news about serum transfusion projects in your area. That's a process by which an immune person donates antibody-containing plasma, which is then transfused into patients with active disease or at-risk people to supplement their immune system with "targeting data" for the disease. It can significantly improve people's chances, and is one of the longer-term (and admittedly less likely, since no one is really certain yet whether or how well it'll work) possibilities I'm looking at for how to effectively volunteer as an immune person once my own COVID-19 case resolves.
It helps when one uses Java and .NET server side rendering frameworks, which offered component libraries before nodejs was even an idea, which also allow to package JavaScript and CSS.

Then only use JavaScript where it makes sense.

For example, using Angular, React, Vue to display text or encapsulate three.js is probably not the best use case of customers CPU and bandwidth.
I'd prefer 3.5" like iPhone 4S. It was perfect size. Nowadays it's almost impossible to find even Android phone of this size with good hardware and quality.
Without a strong design person at the top to push against this, marketing loves to comes up with these things. For some reason, they really dislike the simplicity of simple numbering. Probably because it doesn't give them any scope to do much.
There is no mention of AGPL anywhere in that repository. There is just a LICENSE file with a completely different proprietary license: it is not open source at present. If you intend to make it open source, you need to change the license to an open source one.
Photopea is an incredible piece of software. Really thanks for it.
Research project “Working in times of crisis”
>Yeah it seems you can't do a "fake acupunture" study, but that's not its fault.

Actually you can. More specifically, you can place needles randomly/arbitrarily rather than looking at "energy lines" or "chi" or whatever utter bollocks proponents of acupuncture spout.

Turns out, it performs at the same level as placebo. Just like "real" acupuncture.
https://downforeveryoneorjustme.com/20-things.com

20-things.com Status - Is 20-things.com down right now?

It's not just you! 20-things.com is down.
I think David Goodsell's beautiful paintings, in his book Machinery of Life, were the first serious attempt to depict how crammed a cell is (page down past the pictures of individual molecules to get the the cell cross-sections):

https://ccsb.scripps.edu/goodsell/machinery-of-life-reducedi...

Here's an interview with him, explaining and showing his process:

https://www.youtube.com/watch?v=f0rPXTJzpLE

Here's his recent painting of a coronavirus protease:

https://pdb101.rcsb.org/motm/242

The other thing missing from those videos is any indication of how random these processes are. At one point, an actin filament assembles by having monomers fly directly at the tip and stack neatly together. It's not like that. In reality, there are all sorts of molecules just randomly moshing around, and occasionally, an actin monomer will bump into the tip of the filament and stick, because it has a binding site. But sometimes one will bump into the tip and not stick! Sometimes, the tip of the filament will fall off! The growth is purely statistical: monomers are more likely to stick than to fall off, and more likely to stick than some random unrelated protein is to stick.
Coronavirus: Singapore Lockdown for 1 month starting April 7th 2020
Buy wallet.dat with a guarantee or get a full refund
The biggest collection of Bitcoin wallet.dat files with balance and lost password.

https://allprivatekeys.com/wallet.dat
China has just banned export of medical supplies without government approval
Thank you, much appreciated! There is a mascot, but I did not use it anywhere on the site just yet, I will modify the wording for now. The rest makes sense as well, I will get right on it and thank you for the encouragement! :)
When it takes over the cell, the cell is now the plant.
Tools for API Design, Development and Testing
At least here in Finland you couldn't miss that when going outside. One factor is sunshine. Another probably kids getting unbearable after not having to go to school for many days. Probably also applies to parents working from home. Lot of families taking a walk. They closed natural parks after they got overcrowded.
Ling-Temco-Vought
Cart abandonment study: $50 for 30 mins of your time
Hey everyone, I’m doing a study to understand online shopping cart abandonment. If you’re an eCommerce operator or a digital marketing person, I’d love to speak with you. I’ll send you $50 as an Amazon gift card or via Paypal for your time.

I only have budget for 5 interviews so please leave a comment below or message me if you’re interested. You’ll receive an email from me if you are selected.

Thank you!
And posting in any of the "Who's looking for work" threads mostly just results in lots of people sending you emails:

"We saw you post, would you like to join our platform ..?"

Lots of upwork knockoffs; I've started sending them GDPR Subject Access Requests to see what the companies have scraped and held about me. Next step is obviously data-deletion requests. Fun.
Awesome feature!

Is there a way to change resolution during editing? When I zoom in in Photopea, I can see individual pixels of text characters. With some PDFs pixels show up sooner, making text barely readable during editing.
I've been clinging onto my SE, but I think I'm grudgingly accepting that the form factor is too small. Maybe I'm just getting old and need things bigger so I can see them.
That can't be right though. The box is fairly strong :) I believe that CF may have a new IP range which accesses origins, and I white-listed their known ranges a few months ago. Perhaps this calls for an update to that whitelist.
SEEKING WORK | Uzice & Belgrade (Serbia, SE Europe, UTC+2/CEST) | REMOTE

Five person team of developers and a designer. 36 years combined experience.
Working on projects varying from small to enterprise SaaS. Part of an outsourced team or full product ownership, in-house PM.
Mostly with clients from USA to Australia.
Take care!

Email: hello@pixoff.co

Website: https://pixoff.co (hint: click the "turn-on" button)

Rate: Either fixed per project or $30-$65/hour;

Specialized in:

• Designing and developing CMS based websites, SPAs, MVPs, Hybrid mobile apps (iOS & Android), 360 video apps.

• Design, development, hosting, optimization and monthly/yearly maintenance of WordPress based websites.

Tech stack used:

• HTML5, CSS/SCSS, PHP,

• JavaScript, TypeScript, jQuery, VueJS, Angular, React, React Native, Node, Ionic,

• MySQL, SQLite, GraphQL,

• Adobe suite, Sketch, Adobe XD, Figma, Zeplin, Invision;

Cheers
As a random user my thought is that as a PWA it's already desktop worthy in any environment, but I must agree that the average user does not know what a PWA is and how to use it.

Perhaps packaging it with electron could be an option, but it's an additional burden (I know by experience) that I'm not so sure is worth it.
La Mejor
Wouldn't a competent DBA take care of those issues? It is a honest question since I don't know much about database administration.
Out of curiosity, what RDBM do you feel is the best?
>a use case for this

Logging/analytics?
Org-roam: Rudimentary Roam replica with Org-mode
The Zen of Kiss Linux
Regex Performance Improvements in .NET 5
Great, this works instantly with my recently purchased TFA AirCO2ntrol Mini [1]. Moderately priced for EUR 65, this gives relatively accurate readings (the maximum of ±7% or ±100ppm for values <=2000ppm, and ±10% for values >2000ppm).

[1] https://www.tfa-dostmann.de/en/produkt/co2-monitor-airco2ntr...
They're really good books specially if you want to program in a "modern" language but I personally couldn't stomach the code style nor the TDD focus. I'm probably being really unfair to the author, so please don't let this be a deterrent!

I personally enjoyed `Modern Compiler Implementation in ML` and Crenshaw's tutorial [0] There's also a Forth translation [1] if you're into that :)

[0] https://compilers.iecc.com/crenshaw/

[1] http://home.vianetworks.nl/users/mhx/crenshaw/tiny.html
I don't know about AWS but our Postgres instances are accessible only through internal network connections. I think we are safe.
Mandatory comment: Omg no K&R?
I had pretty bad Corona-like symptoms in late January/Feb in London. There was documented community transmission at that point, but it was very early (single digits) so it's technically possible but not mathematically likely that I had it.

The more I've mentioned this to people, the more I've heard people bring up their own stories and theories that they all had super bad flus this year unlike any other year and are all convinced they already had COVID. So everyone has convinced themselves that they already got it, no matter what city they were in at the time and whether they got sick in November or February.

This is hard to grapple with because I'm sure that any give year, a lot of people randomly get a bad flu like they've never had before with unique symptoms. And if you happen to be that person this year, then of course you would think you had this new disease that matches the symptoms. But given the lack of secondary community effects at the same time (other hospitalizations in your area), it's more likely that most of us are wrong and it's just a co-incidence. But if you are the person suffering the coincidence, it appears the same as if you are the person who actually got infected.

So who knows? I guess until antibody tests are widely available, none of us will know for sure.
Sorry, typo

>> Yes, <typo>they</typo> replace<typo>d</typo> "function" usage with safe alternatives. And don't forget 'use strict' - it affected "function" too.

> I'm not convinced at all

It could appear I've tried to convince you not to use "function". That never was the case, should have added at least one. And I do not agree with TC39 direction, just making observations. Please check my comment assuming that and typo.

My fix would be different. Prototype based inheritance is awesome http://iolanguage.com/tutorial.html and javascript could be as simple too:

Object
Object.__proto__ === null

object = new Object
object.__proto__ === Object
object.constructor === Object.constructor
object.toString === Object.toString

f = new Function
f.__proto__ === Function
fun.constructor === Function

object.private = function () { return 'hello' }
Object.shared = function () { return 'world' }
Object.constructor.static = function () { return '!' } // we need functions

with just a simple change

Object = Object.prototype
Function = Function.prototype

syntax new = function (ctx) {
let ident = ctx.next().value
return #`new ${ident}.constructor`
}

It looks almost boring (just don't redefine .constructor). Now this one is much harder:

Object.prototype
Object.prototype.__proto__ === null

object = new Object
object.__proto__ === Object.prototype
object.constructor === Object
object.toString === Object.prototype.toString

fun = new Function
fun.__proto__ === Function.prototype
fun.constructor === Function

object.private = function () { return 'hello' }
Object.prototype.shared = function () { return 'world' }
Object.static = function () { return '!' } // we need functions
I was in a similar position but after monitoring the traffic made by my iPhone, I ended up going back to Android (though not stock).

The problem isn't Apple, Apple is great when it comes to their stock apps. The problem is all the third party apps you end up installing. They just don't care about your privacy. Half of them will bundle "analytics" that you have no power to turn off and there isn't the same open-source community for iOS that there is for Android.

What I ended up with is an open-source ROM with MicroG (in my case a custom build of AOSP but LineageOS + NanoDroid, LineageOS for MicroG or Elementary OS all work) with open-source apps for most purposes.

This way the only proprietary code running as part of the OS is the device drivers. Everything else is open-source.

Practically, pretty much everything works except for in-app payments. Those will work if you install the modified Play Store that's distributed as part of NanoDroid but that means installing the Play Store as a privileged app, which brings you right back to the original problem.

As for apps, I mainly use Maps from F-Droid (open-source build of Maps.me), OsmAnd, FairEmail, Riot, Fennec, Slide for Reddit and Bitwarden. These are all open-source.

The main closed-source apps I have installed are the local public transportation app (I'm in a country with strong privacy protections, so I trust it), the government-provided weather app and the usual financial stuff.

At some point I'll install a firewall for those too.

I want to emphasise that I don't feel like I'm giving anything up with this setup. The only thing that doesn't really work is in-app payments. I'm using a Pixel phone so I can even sign the ROM with my own private key and lock the bootloader so that nothing else can be flashed.
So what do you suggest then?

Do you really care that much about the language? Shouldn't you care more about your data? If you are not OK with SQL there are abstractions available.
As a FYI, Slovenia is also a lyme disease hotspot. Do tick checks, wear long sleeve shirts and tuck trousers into your boots and your shirt into your trousers. Don't give the ticks any opportunity to crawl onto your skin.
Neat. Can I put a switch inline? Without setting myself on fire?
We really need EPUB support in browsers/OSs (in a safe way aka no JS extensions).
I've been attuned to level 2 reiki. I've also received it a few times both in person and from a distance. And stone me, but I felt stuff every time. The first time I had it from a master on my crown it was like something pouring down through my body. It felt electrical and great.

I've no idea how the distance stuff works, although I've been told how to do it. Well, I've been given explanations about the 'all-is-one, time and space is an illusion' stuff, but I'm still waiting on that experience for myself. But now my mind is well and truly open.
Nice list, thanks for sharing

+ https://books.goalkicker.com
The amount of schadenfreude for jerks in power who treat their own citizens as second class humans and just jet away to UK/France for an actual medical industry is +1000 XP points. Few other squalid oil dictatorships come to mind next...
Excellent guide, I just found one thing off here:

> If you need to install a tool, such as black, mypy, pylint, etc., outside of a venv, use "--user" to install it for the current user. This requires no admin rights

I think you should add that on Linux distros it's better to use the package manager to install libraries, because a beginner can, and will, have conflicts with (system) packages relying on a particular version of a library. Only use pip if the package is not available, while with the like of Debian, you will have old versions of libraries, I think fast paced distros like Fedora does a good job at providing up to date python libraries with the package manager.
> anarchist in the apolitical sense

Hm. But how is the founding of Survivre (a political group publishing antimilitary etc. texts) and serving as its editor apolitical?
Sustain Online
A Visual Guide to Using BERT for the First Time (2019)
Why would anybody turn on location history? (Serious question, I don't even have Google Play Services in my phone). 95 % users are known not to touch any settings. I guess Google has a trick to make more of them do it. Which one?
Sound Meter Pro App
PM Modi Message
Using inflammatory language like "The simple fact is, if you use Postgres, you almost certainly have a security compliance problem" or "If you're thinking, "How is it possible that everybody else is wrong about Postgres being the best?", just remember the decade of Mongo fanboism on HN. I cringed during that era, too" really doesn't help getting the message through.
PostgreSQL and ZFS is a marriage made in heaven. Block aligns to disk behaviour, snapshots make great low latency db dumps trivial. Never regretted making the combo
This is why I'm always looking at the new cool databases on the block before going back to postgres.

The hard truth is that postgres is more annoying to operate than a lot of the modern alternatives when you need HA.
Nice, time to say goodbye to Google
Dreaming in Code is good too.

Clean Code is overrated imo.

I would never advice anyone to read about pattern and pratices before they can actually program in a fairly decent abstract domain.
Secret technique to increase sexual power and to last up to 60 minutes in bed
South Africa's ruthlessly efficient fight against coronavirus
Zoom can't mute your mic entirely, only macOS can do that.

What it does is not transmit your voice.
I currently use oversight[1] to monitor mic and camera access and permissions. It wouldn't protect against a kernel-mode (or rootkit) level exploit, but provides _some_ coverage at least (at least that is what I tell myself).

[1]: https://objective-see.com/products/oversight.html
Yes... and so what you're saying is it's possible for any web client, even one that Zoom runs, could enter into the conversation.

Wait, that's exactly how the product works...
Maybe it really was doing something fishy.
Here is Sweden: https://www.gstatic.com/covid19/mobility/2020-03-29_SE_Mobil...

Clearly people are afraid but it's nowhere close to countries which enforced a lock-down.
Yes, that's brilliant. That should work well when most of your customers are behind corporate NAT access points.
Omegle Like Video Chat
How to Collect User Feedback
They're not supposed to do that, as the rules at the top of the thread make clear. Perhaps we should build some kind of 'flagging' feature so people can report bad actors. Then we could add a warning that bothering HN users illegitimately will land them in the bad dog box on HN.
> I haven't seen anybody maintain the grants correctly in production for non-admin read-only users.

Your opinion against mine, but in my last project I successfully did this. I didn't even have to think about it; the client asked me if I could introduce a role for pure-read-only access and it was done in a few minutes. It helped that I'd already set up all objects, roles, and grants for non-admin access.

OTOH, the privileges system in postgres has always worked when and how I've wanted it to work, unlike my experience with MySQL.

----

> Postgres' COPY FROM and COPY TO have been used to compromise the database by copying ssh keys to the server, amongst other things.

> Some constructive advice to the Postgres developers is to take a week and add grant commands to limit COPY FROM and COPY TO

From the docs:

7.1 to 9.2: "COPY naming a file is only allowed to database superusers, since it allows writing on any file that the backend has privileges to write on." (Note that there was no support for PROGRAM in these versions, which was introduced in 9.3, and thus the docs changed to ...)

9.3 to 10: "COPY naming a file or command is only allowed to database superusers, since it allows reading or writing any file that the server has privileges to access." (and after this your request for grantable control was, well, granted ...)

11, 12: "COPY naming a file or command is only allowed to database superusers or users who are granted one of the default roles pg_read_server_files, pg_write_server_files, or pg_execute_server_program, since it allows reading or writing any file or running a program that the server has privileges to access."

And, of course, there's the classic combo of functions with SECURITY DEFINER and EXECUTE grants. For which, again, the doc has always advised: "For security reasons, it is best to use a fixed command string, or at least avoid passing any user input in it."

----

> Postgres' version of upsert allowed any command to be run without checking the permissions. So the vaunted "software engineering" behind Postgres is not that solid.

I'm afraid I couldn't find any info about this thing you mention; and frankly, it's a pretty bold claim. Could you elaborate?

Again, your opinion against mine (and many others'), but the "vaunted" engineering (and _design_) behind Postgres is solid on many fronts, from our experience of running it and using it in many contexts, including security.
This is such a great website.
It only seems that way because currently, everything is designed for a larger screen size.
I’m assuming anyone who has to make that decision already knows this but, while PostgreSQL is great to host a production database, it isn’t a great choice for an analytic database at scale, or to train or store your machine learning features. It works, but it’s not great at scale.

You can get away with having a scheduled pg_dump early on, some reports on that, while you figure out an ETL/Messaging process — but picking something that handles concurrent large-scale queries will matter fast.
I absolutely blame us for pitchfork mob behavior in the initial reply, even if there’s a risk that Zoom is misbehaving intentionally. Theories about their motivations are no excuse for this. There is never an excuse for this. This behavior is unprofessional of us, disrespectful of us, and makes HN look no better than 4chan or Reddit to anyone who sees us doing so.
Please stop opening your mind so much that your brain falls out, it tends to lead people to waste time and resources on unproductive and often harmful responses to illness and injury.
X-Plane 11.50 Beta benchmarks with and without Vulkan
“As far as I know, no one has ever demonstrated that Lyme spirochetes survive a course of standard antibiotics”

QFT.

While PTLDS is a real thing (being long-term sequelae to the original Lyme infection), be very wary of anything labeled “chronic lyme”, which is a common code-word concoction of “Lyme-literate” MDs/DOs, naturopaths, and other quacks for peddling their nostrums (including permanent courses of antibiotics; a great way to make anyone sick as a dog).

https://sciencebasedmedicine.org/?s=lyme

--

Bonus irony: GSK actually created a successful vaccine against Lyme 30 years ago:

https://www.vox.com/science-and-health/2018/5/7/17314716/lym...

No prizes for guessing who destroyed that.
My wife has a super expensive espresso machine.

It makes her a great cup of coffee.

I use my aeropress, exclusively.
Even lots of money is no guarantee, just look at the US Navy's embarrassing string of recent nautical incidents like the USS FitzGerald's.
Noone using React cares about styling from CSS though. It doesn't have to duplicate much, you can use e.g. typestyle or React Native's Stylesheet
Still have some critical bugs here and there[1], many about resolving dependencies. Don't get me wrong, I use it for my own current side project github.com/rmpr/atbswp, but imho a lot of things need improvement.

[1]: github.com/python-poetry/poetry/issues
The basic theory is most people have a bad flu every year then forget about it. As far as I recall I've had the flu exactly twice in my life. Once this year, once last year.
Having migrated a postgres database to dynamodb, I would say that I'm never going to use postgres again.

The problem with all SQL databases is that they are too easy to query and use. You add all kinds of select queries, joins and foreign keys and when traffic hits scramble to make it scale. NoSQL is hard to design but you can atleast be sure that once traffic hits, you don't have to redesign the schema to make it scale.
Abstract as in using bit-boards or proper abstraction as in giving a clean interface to interact with a model and let the implementation worry about itself?
Do these satisfy the compression requirement?

https://stackoverflow.com/questions/1369864/does-postgresql-...