skysight-inc/HackerNews huggingface dataset:
There are a lot of commercial solution that are geared towards reporting, from old-school Oracle, TeraData even SAS (would not recommend that one). Some options that came our recently when “Big Data” was a sentence people said: Hive, RedShift, S3, Cassandra. New players that abstract a lot of the problems from the others and add Machine-Learning capacities on top: Google BigQuery, Snowflake. There are non-tabular structure like the graph based ones, Neo4j e.g.: I’ve yet to find a business where that’s a viable option for analytics for the first five years but I like that those are bringing something new.

Most of those are great and work: they have connectors to whatever language or tool you want to use. The most promising tool you’ll need to handle most of the transformation is either AirFlow or preferably dbt. Those are is independent from the database, so don’t worry too much about the features that vendors tout. One key thing: monitor all the queries going to that database, find the expensive ones, those with suspicious patterns, etc.

Spin-up, response time can matter, but they are rarely a problem for most “slow” analytic use cases; for instance, Google BigQuery takes 10 seconds no matter what you query and it’s fine. On the other hand, concurrency has been an issue for me more than anything: all the analysts and managers trying to update their dashboards on Monday at 10 am.

You rapidly get to a point where prices are high and negotiated, so you want to think about your likely usage in the next years before you step into that meeting. Key decision: by default, prefer the tech that is closest to the rest of your stack because ingress is the easiest factor to predict.

Looker will be mentioned: it’s on top of all that, downstream from AirFlow/dbt.
Negative emotions, such as fear and guilt, can lead to procrastination
Covid-19 public dataset on BigQuery which is updated daily
The thing is, at least for now, they seem to be in line with other countries that took all the measures. Sweden has a very similar number of cases/deaths and population as Portugal which locked schools 3 weeks ago, and the rest of the country 2 weeks ago, but Sweden [1] had the initial reported cases many weeks before then Portugal [2] (for deaths [3]). (I couldn't find number of tests done in each country so that may be a variable there that may mess these values)

I guess the next couple weeks will show which approach is better.

[1] https://www.statista.com/statistics/1102203/cumulative-coron...
[2] https://www.statista.com/statistics/1107359/coronavirus[-cas...
[3] https://www.statista.com/statistics/1102203/cumulative-coron...
It's not that simple. People will accidentally set the switch to off and won't understand why their mic doesn't work anymore. At this point there is a good chance they will call support.

This also happend with the hardware wifi kill switches we used to have on notebooks.
I started a repo [1] that parses data for at least some of the national data tried. PRs welcome

[1] https://gitlab.com/pisquared/scrape_google_mobility
Why Amazon got out of the Apple App Store tax, and why other developers won’t
The article refers to it as "touch-based healing", and every picture of it bar one involves touching. Is the article wrong?

Wikipedia also claims it involves touch: "the only thing that distinguishes reiki from Therapeutic touch is that it [reiki] involves actual touch".
> there's no possible way that corporate tax avoidance would make a significant difference

Citation needed.
Every similarly "socialist" country that is taking a more aggressive approach disproves your point.
In my office I run lid closed because I have 3 nice large monitors and I don't really have room for a fourth. It's nicer to have three displays that match in size and resolution than 2+1 that doesn't.
You mean like New York with its 40+% taxes?
That is precisely the behaviour I see on my iPad Pro from 2018
I know a lot of people are speaking out of their ass about this virus thing but I do believe our temperature has been a bit too cold for it to spread from objects, clothing and skin so far.

Also we've had amazing weather.

This last weekend I was in a 40 person pile up on a walking bridge near the beach here. Because someone wanted to take a perfect Instagram picture with his three dogs in the middle of the bridge.

I do also believe this virus thing is going to blow up in our faces soon, in these two coming months when temperatures get closer to 10-12 C daily.

So in hindsight we shouldn't have gone into WFH mode until april-may. And in June I believe it's going to be real heavy.
Rocket Internet has sold all its shares in Jumia
Coronavirus: Google Releases Location Data to Help Authorities Check Lock-Downs
While I do love PostgreSQL (and PostGIS which is excellent at transforming, indexing and querying geographic content) - I feel like MSSQL should get a bit of a shout-out in relation to your comment on performance.

An experienced database developer with help from "SET STATISTICS IO ON"[1] and query plans[2] can achieve incredible MSSQL query optimization results.

PostgreSQL has good query plan output via the EXPLAIN[2] statement - but I haven't (yet?) seen PostgreSQL produce per-query IO statistics.

[1] - https://docs.microsoft.com/en-us/sql/t-sql/statements/set-st...

[2] - https://docs.microsoft.com/en-us/sql/relational-databases/pe...

[3] - https://www.postgresql.org/docs/current/sql-explain.html
Just to easily explain that mediasoup is not a replacement for Jitsi or Zoom, but a low level set of libraries for building build different kind of real-time applications, including multi-party videoconference apps (such as Jitsi or Zoom) and others completely different.
Also have a look at videos about Robert Hart, who passed away in 2000:

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

https://www.youtube.com/results?search_query=robert+hart+for...

He possibly was the pioneer of the 'forest garden' way of permaculture.

It's a pity when the more modern materials don't give the history or credit to the originators of these ideas.
It's still teeming with life. Antarctica has more than 400 known subglacial lakes, e.g. https://en.wikipedia.org/wiki/Lake_Vostok
> the crda regdb database […] It's encrypted

That's false. It's just a binary database file. See man 5 regulatory.db

$ hex /lib/firmware/regulatory.db | head -n 10
0000 52 47 44 42 00 00 00 14 30 30 03 61 41 44 03 c5 RGDB␀␀␀␔00␃aAD␃Å
0010 41 45 03 bb 41 46 03 cc 41 49 03 dd 41 4c 03 cc AE␃»AF␃ÌAI␃ÝAL␃Ì
0020 41 4d 03 a3 41 4e 03 cc 41 52 03 bb 41 53 03 79 AM␃£AN␃ÌAR␃»AS␃y
0030 41 54 03 e4 41 55 03 58 41 57 03 cc 41 5a 03 bf AT␃äAU␃XAW␃ÌAZ␃¿
0040 42 41 03 e4 42 42 03 f5 42 44 04 15 42 45 03 e4 BA␃äBB␃õBD␄␕BE␃ä
0050 42 46 03 bb 42 47 03 fd 42 48 03 a6 42 4c 03 cc BF␃»BG␃ýBH␃¦BL␃Ì
0060 42 4d 03 79 42 4e 03 da 42 4f 04 10 42 52 03 bb BM␃yBN␃ÚBO␄␐BR␃»
0070 42 53 04 05 42 54 03 cc 42 59 03 cc 42 5a 04 24 BS␄␅BT␃ÌBY␃ÌBZ␄$
0080 43 41 03 66 43 46 03 a9 43 48 03 98 43 49 03 bb CA␃fCF␃©CH␃�CI␃»
0090 43 4c 03 da 43 4e 03 f8 43 4f 03 bb 43 52 03 9f CL␃ÚCN␃øCO␃»CR␃�

The documentation talks about optionally signing the database with a key. You confuse things. A signature is not encryption.

> Android adoptable storage […] will encrypt without telling the user […] You can not get access to the decryption keys if you haven't rooted your phone. […] If you're having a failing sd card and want to do recovery on it, well too bad, it's now utterly impossible, even if you own the phone.

Works as designed? In this scenario, you're not the recipient of encrypted transmission, you're the adversary.

You should not be upset at encryption as a generic tool. You should be upset at the creators of this system that turns people who paid good money to own a mobile computer into dependent thralls: they cannot exercise the freedom to do with their property what they want. The answer to that injustice is not to abolish encryption, but to abolish the use of non-free software that enables the creation of such systems.

The predications from my previous post still stand.
No, but everyone is pretty sure it will be that size.

https://www.theverge.com/2020/4/2/21206497/iphone-se-9-name-...
IMO all similar countries will have lots of deaths and tragedies during this pandemic. It's a really tough virus.
Other Nordic countries such as Denmark, Norway, and Finland has more or less identical health-systems/tax-schemes and they have taken very different routes.
The demo is just a demo. mediasoup is a low level library (no UX into mediasoup). The online demo backend does not have any TURN server. It's obviously recommended to deploy a TURN server.
SQL Server can also do storage compression. I assume Oracle can too. It used to be that the commercial offerings had the most advanced features first and the OSS systems copied them later.
The Pandemic Is Turning the Natural World Upside Down
It's hilarious how there's so many sellers for that same damn Venus bust on Etsy.
Jitsi: Self-hosted, open-source, E2E video conferencing
Yeah but this isn't open source. It's proprietary with source available, despite what you claim in numerous places throughout this thread. You're building a proprietary product on top of an open source project. You also chose a name that creates the impression that you built the original open source project, which you don't appear to be contributing anything back to. Comparing yourselves to Red Hat has to be a joke, right?
> Simple views are easy enough to handle, but these functional style guis don't tend to deal with complex views very well.

Citation needed
Not shaking hands has been the norm for some weeks now in Sweden. I thought this was the case everywhere?
I once had a laptop with a manual switch for the wifi. Its sole purpose, as far as I could tell, was to get accidentally bumped and cause me to waste time figuring out why wifi wasn't working.
I just hope that their stupidity doesn't cost them their grandparents, majority of people with cancer/heart disease/etc.
Swedish are fine, positive, it will be a pitty.

Like on every pandemic, the game is over only when the cure/vaccine is distributed to the whole planet. Until then it is way to risky to relax.
I think just more effort went into drafting it. Every word conveys meaning, and the aim was to maximize the information conveyed per word.

Contrast to modern articles where journalists are told "You have 1 hour to write 500 words. Go!"
This virus has been circulating Europe for more than two months now and people keep parroting the same old "in two weeks time, expect 600K deaths because its exponential" line.

It's like some of you WANT this doomer scenario to play out. If anything, this crisis seems more like one of purpose than a sanitary one.

To everyone who's reading this: stay safe, spread positivity and most importantly find your purpose.

And to the Swedes: keep being awesome, I hope you come out of this stronger because we're definitely going to need new furniture when this whole thing blows over :)
SQLite now supports R*Trees for spatial queries.

https://sqlite.org/rtree.html
These articles always give a sense that it's business as usual in Sweden. It isn't. I have been working from home for three weeks now, but I have had to go into central Stockholm a couple of times, and it is almost eerily empty. Restaurants and cafés have a handful of clients, spread out in the corners, at peak lunch time when they would normally be crammed full. Shops are open, but the client-to-staff ratio is close to 1:1, and most have reduced their opening hours. Some article mentioned that cinemas are open. This is technically true -- they haven't been ordered to close -- but the big chain that runs most of them has shut those down on their own initiative.

I don't claim that the level of restrictions is optimal, or that tighter restrictions would not be beneficial, but business as usual it isn't.
Comparing the single-file efficiency of version control systems
You're really stretching with the word "obsession", not to mention being inflammatory. It's an abbreviation that happens to lose specificity (as you might expect of an abbreviation - therefore, one must depend on context). In addition, it's a gonna globally common abbreviation. I'm sure the relative commonness of "the US" is higher outside the US, but many people outside the US still call it America too.
If it was clear, after reading the headline I would not have assumed that QUIC was proposed to replace the internet protocol (IP) for the internet.

The title "QUIC -- Will it replace TCP?" would be accurate and correct and contains everything both necessary and sufficient to describe the article. Adding in unrelated extras, like QUIC replacing IP, conveys additional and incorrect information. It muddies what the article is about.

Calling out unclear and misleading communications is not being pedantic. Clarity is the most fundamental aspect of good and effective communications. The headline writer does not need an apologist, they need to expand their knowledge of the subject they are writing about.
SQL Server also has some parts of that. Will probably be expanded in the future.
Is the view logic running at every refresh? That would make it somewhat of an immediate mode UI.
That's true of every language. It's the software developers job to build the architecture.

I am an advocate for frameworks in commercial projects, for ease of knowledge sharing, speeding up onboarding and having a strong architectural philosophy built in. But we can't forget that we are the makers, we make the frameworks. React and friends are Javascript, anything they can do we can do too.

I am happy to use them for work. But I find all frontend frameworks too tooling heavy and full of arbitrary details you have to learn once and promptly forget. In my personal projects I have a simple architecture I use to organise my code in vanilla JS, no tooling and it's simplicity lends well to small projects sprinkled with only some dynamic UI.
Based on the linked page this functionality is separate from the security chip and a compromise of the security chip cannot disable it.
Not sure what strategy you tried to retrieve the data but I did this kind of stuff years ago with MSSQL even before it had geospatial types and it was fast.

If you have LAT/LON in the table as normal columns indexed you just query the bounding box of your radius so it can use the standard b-tree indexes then post filter to a circle cutting off the corners. Of curse you have to do some work to account for the curvature of the earth but this is pretty standard geospatial stuff.

If you have a DB with geospatial types and indexes like MSSQL 2008+, Oracle, PG etc then this becomes trivial as they can do this directly.
We do support TCP ICE candidates for long time:

https://mediasoup.org/documentation/v3/mediasoup/api/#WebRtc...

> TCP candidate so a TURN server isn't needed at all?

This is not true. A router may still block TCP traffic different than TLS or traffic that does not have destinatiuon port 80 or 443. So ICE TCP candidates do not avoid the need for a TURN server in certain cases.
The US and much of Europe is practicing extreme social distancing. I haven't had the opportunity to shake someone's hand in weeks due to the lockdown. In fact, I haven't touched someone that is not a part of my household in at least three weeks.

But Japan has been avoiding handshakes naturally since the start of the outbreak, which may have helped suppress transmission rates before they even knew the virus was spreading.
Oh, man, that shirtless guy. Thanks for putting that back into my mind!
Show HN: Crossnote – an interesting markdown note taking PWA
> I don't buy that.

Well now you have a control group to compare against.
Funny story: almost three years ago I got a second hand thinkPad T440. It came with a 240GB ssd. A second hand laptop with an used ssd inside.

At the time I didn't have much money so I just kept the drive and decide to possibly face the issue.

I still use it, of course (it's my personal laptop).

Some days ago I switched to root and noticed a dead.letter file in root's home directory.

I examined the file and it was an email dropped into the home directory by smartd, alerting me that my hard drive was near failure.

The funny thing is, that email was from February 2018. More than two years since that email, that drive is still working.
Speculation surrounds ACE inhibitors (ACEI), which are a type of high blood pressure medication, in that they may dampen your immune response to viruses over long time usage. The other speculation is that circulating amounts of ACE2 are increased by ACEI and SARS-Cov-2 specifically binds to ACE2. The confounding aspects are as you suggest that the overall health including kidney health are often poorer in people with hypertension.
Came here to read a psychology article..
"middle of the night here" is morning for most of Europe. Quite late in the morning, when people had time to work and maybe do an HN break. I've noticed that stories posted in the morning (for Europe) can get as much traction as other in the evening (american morning); especially if they touch to subjects we are quite sensitive to.

Did you do any study on HN stats and where its audience is coming from ?
I don’t doubt everything you’re saying, and that unscrupulous physicians are genuinely taking advantage of their patients. However, as someone with a family member who was recently diagnosed with a (largely untreatable) autoimmune disease, I want to explain why patients become so desperate that they’re willing to try anything. The basic problem here is that anyone who goes online and reads about their condition (eg PTLDS) will find ample scientific evidence that there’s a real condition there — however, a huge majority of medical practitioners aren’t as caught up on the research as their desperate patients, and will often express skepticism that the condition even exists. (Note that this is different from acknowledging the condition is real and being unable to offer a treatment.) This destroys credibility in the conservative medical establishment, and makes it much easier for charlatans to make inroads, simply by acting like they believe the patient. My point here is that a little empathy can go a long way to protecting patients from this outcome.
Escape from Tomorrow
Ok, before the party is over, checkout another test launch [0].
We really hope to grow a truly helpful community and will appreciate any feedback about the messaging on our website too! [1]

[0] https://www.patreon.com/boosthelp
[1] https://boost.help
Afaik the iPad pros from 2018+ are HDR, aren’t they?
In Hungary, the Coronavirus Is Just an Excuse
Location: Columbus, Ohio

Remote: Yes

Willing to Relocate: Not currently, but possibly next year.

Technologies: Ruby-on-Rails, React/Redux, HTML/CSS/HAML/SASS, Elixir / Phoenix

Resume/CV: https://www.adamalbrecht.com/resume

Email: adam.albrecht [at] gmail

• 10+ years of experience building complex business applications in Ruby-on-Rails, Javascript, React, HAML, SASS, Rspec, etc.

• I also have experience in Elixir and Phoenix

• I've helped start 2 successful SAAS businesses, one in healthcare and the other in legal tech. One was recently acquired while the other is a thriving business.
As family we had a pretty 'bad' flu in February here in Czechia. Correction, not a bad flu - but the worst ever. It matched most of the symptoms - including coming in 2 waves.

Youngest child went almost with no symptoms. The one with strongest immune system suffered a lot.

This was 3 weeks before first confirmed cases.
my thinkpad has a switch which amounts to a cover over the lens ... dunno why it'd need to be any more complicated that this.
Wasn't Boris Johnson dismissing that advice only a couple of weeks ago and shaking hands of people?
This is an opinon piece by Fredrik Erixon, who is not epidemiologist. The article claim that "We can expect our Covid-19 death figures to rise faster than our neighbours". This a statement by the author and is not supported by facts, references presented in the article.

It is also the author that claim that the strategy taken by the Swedish goverernment is about Swedish exceptionalism. Again this is not supported by facts, for example references to actual statements.
https://cdn3.vectorstock.com/i/1000x1000/55/37/comic-book-zo...
If you look at the trajectory of most popular languages they are incorporating more "PLT ideas". Lexical scope, type systems, etc.
I think a more fair assessment would be: "Google is tracking people's movements"
You can get metal mesh filters for AeroPress. My paper filters have been sitting there for years.
As far as I can find out, FaceTime is currently the only solution for "just works" (in the sense that your grandma could use it) videoconferencing that is e2e encrypted.
The problems in HTML component development are largely the same as in any other GUI - state management. I've run into plenty of UI state bugs across many, many applications using "typical native gui frameworks", both open-source and proprietary - I don't think it's a solved problem.
Your comment was far more informative than the article! Thank you.
This is not enough, the sane solution needs physical switches like the Lenovo T400 had for WiFi.

Where are the real laptops? I'm tired of the glossy short screens, lack of ethernet connections and crappy keyboards (this applies both to Lenovo and Apple).
The case with Sweden is that the central government ("regeringen") cannot order people around; it's explicitly forbidden in the Swedish constitution ("ministerstyre"). This is different from many other countries, like Norway and Denmark, and might explain why there's no big leader that has felt the pressure to make people stay home.
April astrology and numerology forecast/ Blog News
> I don't understand why you're downvoting me when you're ostensibly making the same point I was.

I didn't. I couldn't even if I wanted to, as I always create a new account once downvotes are unlocked as I don't like the temptation of destroying discussions for topics I don't agree with.
I thought this news was about mediasoup, not about WebRTC in general. Said that I agree that your scenario is valid without any media server.
True. It is definitely not business as usual. I haven’t been to the office for the last four weeks. I’ve only been to the supermarket one or two times during this period. And I won’t travel to my hometown to see my mom or grandma either until it is safe to do so. So business as usual it is definitely not.

[Edited to add/correct some more info.]
Show HN: Compress JPG, PNG, WEBP, SVG or GIF
The African countries yet to record coronavirus cases
Also Thinkpad laptops are starting to ship with a "think shutter" thing which is essentially a hardware switch for the webcam.
It's just meditation by doing.
it's sort of the low level live form is hacking the high level one. am i missing something?
Where I work, it defaults the webcam resolutions to 360p and we can only choose 720p for our 1080p hardware.

Anyway, my biggest concert is with lack of fluidity of slide/screen sharing.

It is not viable for presentations with animations or where the presenter needs to point with mouse/cursor to a specific point or area of the slide (for example, a point in a curve in a graph).

I work with this.

I'm struggling with this tools first hand.
My impression is there a lot of opinions here from people which is not using these tools.
Yeah I always thought the screen-size on my 5 was perfect, but a week after buying an XR I fully came around to living with a large phone. It really was just a massively better experience.

I would have bought an updated SE if they had been available at the time, but I don't regret the XR purchase.