skysight-inc/HackerNews huggingface dataset:
Disclosure: I work for Timescale, previously worked for Elastic

Pretty much any ETL tool you like could do this, as long as it speaks to elasticsearch and postgres.

Logstash (if you're using the ELK stack) can write to CSV or other formats as well as do any processing, but it doesn't have a JDBC output plugin, so you'd have to ingest with something else. Conversely, fluentd for example can output to Postgres, but doesn't have an elasticsearch input (at least that I could find), so you'd have to export from es with something else.

So it might be a couple of steps, though there are rich clients for most major programming languages for both elasticsearch and postgres. If your schema is fairly simple, this might not be too bad to roll your own.

That said, the hardest part is likely massaging your data, if your elasticserch schema is complex. Because you have to totally denormalize things for es (generally), you might have to unravel some of that going back into a relational database.
It's also interesting to note that the core editor component/library of VSCode (called Monaco) predates Atom. It was used in a variety of places in Azure even before Atom built Atom-shell/Electron, and got a lot of early stress testing in powering the Dev Tools source code views in IE as far back as at least IE 10, IIRC.
Top No Code/ Low Code AI Platforms
Kids love Manjaro these days.
> IIRC Django can also use SQLAlchemy

It's possible to use sqlalchemy with django, but you're basically on your own (don't expect to be able to use django-admin and other pluggable apps etc.)

> it didn't used to be very nice back in the day

Having used both django and sqlalchemy ORMs very heavily, I've got to say that django does what it does extremely well and intuitively. For what the vast majority of webapps need to do, the "obvious" way of constructing the query causes django to do more or less the right thing. sqlalchemy on the other hand I love for other reasons, but am frequently annoyed at how much faffing is required to do the simple things in a concise way.
I think there is a way to do it, that was the peeking I referred to. But it's not how it works out of the box.

I think the abstraction is somewhat useful if your GraphQL queries vary tremendously (one device asks for the user along with the ads, another device doesn't). Expand this out to a bunch of different data types and you'd find yourself writing a lot of variations of the queries. GraphQL with Data loader allows you to write these things exactly once albeit with potentially suboptimal queries.

All of that being said, we're finding that our queries vary very little and are somewhat questioning the value of data loaders and of GraphQL altogether in our case.
Zinc is the purported mechanism of action, but cells can't pick up enough on their own, so an ionophore like hydroxychloroquine might help get more into the cell.

One might ask pointed questions why the original formulation (zinc + ionophore) is so consistently absent from these studies. I don't care one way or the other about the drug, but why are studies widely promoted that are irrelevant to the question?
Yes, even the world of medicine And science is full of political BS.
Only if the entire company is remote. Otherwise you will always be the "remote guy".
MLOps for Visual Medium
-Reduced memory consumption of GitLab with Puma [1]

Puma reduces the memory footprint of GitLab by about 40% compared to Unicorn.

Considering one of the most frequent complains about Gitlab is memory usage. 40% is huge.

[1] https://about.gitlab.com/releases/2020/05/22/gitlab-13-0-rel...
Indeed. At this price, I'd think a beefy x86 or a totally Windows-proof POWER9 would make more sense.
For simple stuff it's not too different from intercooler, but I wanted to have the freedom to remove mistakes and ideas that didn't work out, so I chose to go with a new name.

Originally I chose kutty, which means, roughly, "sweet" in american slang, but that had too many other meanings, including a very unfortunate meaning in dutch slang.
I also doubt we'll see widespread food riots in the rich world. Our issues are mostly specific food scarcity due to supply chain issues and increases in food prices that likely won't be too painful for people who are still employed.
That said, I would say it's a near certainty in parts of the developing world, where a food supplies are more tight and food costs a much more significant part of the average person's budget.

See also:
https://en.wikipedia.org/wiki/2007%E2%80%9308_world_food_pri...
Last year I was preaching that if you can't develop in a submarine or a space station (or on the metro), from a fresh git clone to your next git push, then your development environment is broken and you should burn it to the ground and start over.

It'll be interesting to see how much power we developers will let Apple take from us before we jump the garden wall.
I mean, it's pretty clear that we are already living in such simulation, right?
Maybe not the best place to mention this, but there's something I don't like about links on this blog: there's no way to see if I already visited the link or not. It would easy I think to just change the color of the underline on a visited link.
Didn't intel also have a "lay off the bottom 2% yearly" culture? I recall reading about that years back.
Obviously I can't say that's impossible, it would just be... very weird, and would seem to contradict what Apple Developer Relations was saying on Apple's devrel forums as recently as this year.
This! times 100. It seems common that these ARM boards vendors are like "here is your pcie slot" and then fail to provide all the basic peripherals onboard that make mITX work on x86. Or for that matter just provide a couple slots on a mATX board.

AKA, if the board is missing something fundamental (like graphics, sata, or even USB!) then the board is useless for a lot of cases which require both the missing bits + some other PCIe board. Its the same thing with soldered on RAM, 4G should be enough for everyone!

Its quite silly in many regards too, since adding a few $$ to the BOM for a graphics chip/usb/networking/whatever to bring it up to feature parity with $120 boards from asus/etc never seems to cross their minds.
amznymous here

Thanks :)
Just get a proper antivirus and it will probably disable the built-in security suite for you
"Essentially, you lay off some of the people without the skills you need and who can’t be re-educated and you bring in people with certain skill sets".

So what's the criteria for who can't be "re-educated"? Too old?
I definitely think that the worst part about typing on a computer is how easy it makes it to not draft. I write about music on the side, and if I spend 15 minutes planning what I'm going to write prior to actually writing it (for a 500 word piece) then everything turns out much more cohesive at the end. I can pretty much type as fast as I can think, but my thoughts are pretty garbage unless I get a chance to organize them first.
When I switched, I just made the macbook not suspend on lid close, plugged it in and left it running 24/7. Then I just screen shared or ssh'd in in whenever I needed to do something iOS related.
It's Latin
I would like to see a tab in about:addons that shows how much data each addon has received and transmitted and to what names/ip's/ports. Could Firefox be modified to do something like this? Perhaps an extension of about:networking?
If you’re doing lithium.

With lead acid, you can get much, much better bang for your buck - as low as €85/kWh, no problem - and big OPzS cells will last for decades. I just put in 42kwh of storage last autumn for €6500. More like €155/kWh with vent caps, interconnects, longer life rather than the cheapest cells, etc.

If you’re purely doing grid storage, a 5kva inverter/charger would set you back €1800 or so - and that’s basically it.
Not if you don't have to use it for whatever reason. Personally I never learned the difference between am and pm before I got a job where I had to interact with people who used it. Still not sure if noon/midnight is 12am or 12 pm though ...
I agree, this is a fairly clear cut example.

But what do you do in situations that are closer to split on people agreeing what the right answer is, or there are 10 answers that could be relevant to the same percentages of people.

A query leading to the single relevant answer to the user 100% of the time is impossible.

There could be a mechanism for the system to get additional information when needed, but that also has some user experience issues.

These are all problems that are most likely solvable to a degree though.

On a side note, I also don't think Siri is very good compared to some of the other voice assistants.
But when I'm visiting a website, I am not a "store". These ports are on localhost, that's more like asking where is the sign saying that my bedroom door is not for you to try and open. However, I will tell you behind which door the bathroom is.
It depends on the trip/person but typically paranoia and panic attack type feelings. Toss in some bad/scary hallucinations as well.
Need private offices with UV-C lamps sterilizing the air going into each office.

Less sick days will pay for the private office floor space, plus productivity increases.
Once you have security engineers, security is no longer the responsibility of all engineers equally, and you've already lost at security.
> Linux was always a disaster in terms of user experience and isn't improving.

This as true today as saying java is slow. Why not just try? You might get pleasantly surprised.
Kind of an interesting natural experiment along the lines of What would happen if we effectively closed the border to illegal immigration and also did not also fix legal immigration somehow?
What a typical serverless architecture looks like in AWS
wallstreetbets in my HN? obligatory SPY 6/11 285c
There's a Woodland Hills in Utah and a Woodland Hills in California. If you ask Google what the weather is in Woodland Hills, it will ALWAYS give you the weather for California. Even if your current location is Woodland Hills, Utah and even if your address is set to Woodland Hills Utah in your Google account or Google home.
> This is a simple extension that offers some flavours people can use until HN implement a native one

Is this likely to happen?
> twitter client, torrent client and a dozen of other everyday apps

I don't install any of that in work machines, and I'd hope most devs don't either, specially if the company owns the device.

If you really need those, why cannot you use the browser?

> continuity and handoff

Why do you need that for development?

Even if your workflow requires it for some strange reason, why don't you use an alternative? There are plenty of ways to pass data between devices.
Making a copy of an example someone has publicly posted to help people and modifying that copy to properly integrate it isn’t “stealing”. It was offered freely and the original author isn’t deprived of the benefits of their original work.

This article just wants to sound edgy.
Outsourceable. Anyone can be re-educated.
I asked my dad, who programmed in C for work, to teach me how to program, but he was a bit too tired after work, and compilers weren't free back then. Instead he pointed me to QBasic, thinking I'd goof around with it for a little while and probably move on to the next thing. One day I pulled him in to show him a wireframe 3d graphics program I'd written, you could rotate simple models around, and he went "oh no, I'm so sorry, you've learned too much QBasic. I'll teach you C". I remember using GWBasic as well, but I don't think I made anything more than little Choose Your Own Adventure-type stories, i.e. a few if statements.
Now his team has a problem :)
> To the rest of the community outside of the OSI and FSF (which is 99%+ of the software community), this is a perfectly acceptable example of "open source"

Please review clause 2.1 (d) and section 2.2. The freedom to run your own modifications in production is not granted. This is a big deal, and rightly a deal-breaking omission for something to be acceptable as either open source or free (as in freedom).

> The Timescale license checks almost all the boxes ...

_Almost_ all, but not all. Some things work only when all of them work, like freedoms.
Public key encryption for pedestrians: RSA and OAEP padding with a real SSH key
Here is a community post on storing logs in TimescaleDB:

https://www.komu.engineer/blogs/timescaledb/timescaledb-for-...
Just get to the LTS release and stay there.
Makes sense.. especially if you're still hooked into iOS. I had already given up iPhone couple years earlier so was easier I imagine.

I just use messages.google.com and save it as an app shortcut, and Telegram native app, and both work well. And generally am fine with web apps if a native app doesn't look right. But finding the right native app for the desktop environment can be an issue. The GNOME skinned apps are pretty nice.

And Manjaro has the AUM for plenty of available tools and such. But that's more dev focused
"Too expensive to re-educate"
The Importance of Uncomputation
Along the same lines, I always laugh at announcers proclaiming the Super Bowl winners as the worlds best (or something along those lines).

I mean, it is true. But it still irks me for some reason.
Very messy internally, every team has their own.
As mentioned in a reply to a sibling, Xcode has been installed (for like five years) on this machine, and launching it doesn't help. The next step would be to compile and run an application with it, which I haven't bothered.
You don't let chess engines compete in the chess world championship for humans
cant do it on a 1070ti either, sadly. Its a samsung CRG9 and it is awesome.
Show HN: PiBar for macOS – Manage your Pi-hole(s) from your menu bar – FOSS
Interesting it’s possible that we have different priorities, but I’m not bothered by UI inconsistencies. I use chrome, office, adobe suite, a trading application, games, VSCode, they all have different interfaces that I know how to navigate. I agree that the settings can be tough. Half the time you are in “new” stuff and half the time you’re pulling up the screens from XP. I just google what I need to do though, and never have trouble getting it done.
> The Timescale license checks almost all the boxes of the OSI definition

By my reading, it fails most of the interesting ones, particularly points 1, 3, 4, 6, and 9, due to the field-of-use restrictions and the prohibition on distributing modified versions.
Why PHP developers should edit their files directly on the deployment server
This post is for php developers. And who use local servers like mysql and wamp to edit their backend code. Before uploading them to the deployment server.

The deployment server refers to the main server that powers your online website. It is not the server you use purposefully for debugging and nothing else.

I wrote this post because its good to see that, files behave in different ways on different servers.

Let's dive into the ways php files are different on both local and deployment servers.

CHECK YOUR FILE NAMES. Wrong file names still work on mysql server but do not work on deployment server. For example, on mysql, 'myfile.php' is the same as 'myFile.php'. so 'https://website.com/myFile.php' is the same as 'https://website.com/myfile.php'
But on the deployment server, or your website host server, 'myfile.php' is not the same as 'myFile.php'. So if the link 'https://website.com/myFile.php' works, then the link 'https://website.com/myfile.php' will not work and vice versa.

Therefore, after testing your files on the local server, be sure to check the file names again before uploading them onto the deployment server.

In order to avoid all this work, why don't you create and edit the files on the deployment server directly, so that you do know they work from the ground up.

This way, users can continue to access your website and your links while you edit them.
> Hasura tackles this by providing a model level authorization layer

Why does Hasura need to know about the authorization model? Graphql.org's best practices guide[1] says authorization should be in the business layer and should be a single source of truth. In other words, GraphQL responses should be going through the same authorization module as REST or RPC responses.

[1] https://graphql.org/learn/thinking-in-graphs/#business-logic...
Just because the study doesn't answer the questions you want doesn't mean its without credit.
It's important to keep in mind the study's limitations section, too:

"Our study has several limitations. The association of decreased survival with hydroxychloroquine or chloro-quine treatment regimens should be interpreted cautiously. Due to the observational study design, we cannot exclude the possibility of unmeasured con-founding factors, although we have reassuringly noted consistency between the primary analysis and the propensity score matched analyses. Nevertheless, a cause-and-effect relationship between drug therapy and survival should not be inferred. These data do not apply to the use of any treatment regimen used in the ambulatory, out-of-hospital setting. Randomised clinical trials will be required before any conclusion can be reached regarding benefit or harm of these agents in COVID-19 patients. We also note that although we evaluated the relationship of the drug treatment regimens with the occurrence of ventricular arrhyth-mias, we did not measure QT intervals, nor did we stratify the arrhythmia pattern (such as torsade de pointes). We also did not establish if the association of increased risk of in-hospital death with use of the drug regimens is linked directly to their cardiovascular risk, nor did we conduct a drug dose-response analysis of the observed risks. Even if these limitations suggest a conservative interpretation of the findings, we believe that the absence of any observed benefit could still represent a reasonable explanation.In summary, this multinational, observational, real-world study of patients with COVID-19 requiring hospitalisation found that the use of a regimen con-taining hydroxychloroquine or chloroquine (with or without a macrolide) was associated with no evidence of benefit, but instead was associated with an increase in the risk of ventricular arrhythmias and a greater hazard for in-hospital death with COVID-19. These findings suggest that these drug regimens should not be used outside of clinical trials and urgent confirmation from randomised clinical trials is needed."

Has anyone seen good randomized clinical trials yet?
I don't think anyone said worry about the economy was an abstract idea. It obviously has a very real effect on people and their health, it has been well studied. I was simply pointing out that what people will consider more significant in five years time (the effect of the pandemic itself or the subsequent harm to the economy due to the response) depends on who you ask. Furthermore, since we don't know the full extent of the pandemic or the ensuing economic impact it doesn't make sense to claim one way or the other right now.

Also, the Great Depression was one of many factors that led to the rise of the Nazis in Germany. The tensions that led to WW2 were brewing for before WW1 even started so don't try to claim that an economic depression caused all those deaths. There are far too many factors to make that claim.
Could the last one out of IBM please hit the lights?
I thought I remembered there being some bigger games, but looking at a list[1], they are all pretty indie, or at least small. Not sure I saw a AAA game on the list (which doesn't mean there aren't any, but they seem rare). The equivalent list for Unreal Engine[2] does contain quite a few big titles (along with a plethora of less well known ones).

I'm not sure if that's cause, effect or marketing. It could be that using Unreal Engine results in a smoother process and is more likely to result in a AAA target game being AAA. It could be that AAA studios area already predisposed to use Unreal Engine. It could be both. It could be that Unreal Engine is just better at marketing to larger studios given their pedigree.

1: https://en.wikipedia.org/wiki/List_of_Unity_games

2: https://en.wikipedia.org/wiki/List_of_Unreal_Engine_games
Could now be the time we reevaluate our idea of what is the minimum bar for the wellness of our citizens here in the US?

And if businesses can’t find summer works, should those businesses be reevaluating their model? Do those businesses have a right to exist going forward as before COVID19 or do the workers have a right to a better living?
amznymous here

you're 100% right
I started using a taught line hitch with cotton cord for hanging pictures.

The taut line hitch makes it easy to adjust the height without moving the nail and the cotton cord helps keep the taut line hitch from slipping (vs says monofilament).
this this this.

If you have to pay someone else for the k8 and cannot do some management yourself then stop. You do not need it to begin with.

Nothing against the original posters idea/company. Looks like a good idea to me.
Very very interested in this too. Sometimes called automated roll ups. I know Elasticsearch does this
Without risking some random Intel lawyer reprisal, it was often worse than that. At one point, Intel had the 'ranking and rating' that was once used at Microsoft. I think this is called 'forced ranking' today. My god.
There are many drugs that aren't "safe", but are yet better than any alternative (including doing nothing).
There are extensions that let you implement custom CSS("userstyle"), why not use those instead?
OTOH when Apple was a much smaller company the mac was much more important to them and it showed.

Maybe it's not related to revenue per se, but clearly since iOS became their main thing the Mac has suffered tremendously.
Direct and Indirect Realism
Being able to run arbitrary software on the hardware Apple has graciously lent me is an annoying level of power that I'm not fully comfortable with either. I'm liable to shoot my foot off if Apple the all-seeing doesn't save me from myself.
How far down the abstraction tree do you go before something is 'pure'? Programming on the whole is at a much higher abstraction level than ever.

Maybe what people are really looking for is simplicity, but this changes depending on the complexity of your project. Therefore the question becomes, "What is the best level of abstraction for this project?"

That changes every time you do something new.
It sounds a lot like the jackpot, as William Gibson calls it in Peripheral and Agency.
Is 5G Spelling Our Doom? How EM Waves Can Hurt
I agree with you, that was basically my point. At this point in time we don't know enough about how this will play out to make any claim about what was the more important aspect to consider: the effects on the economy or the effects on population-level health due to Covid-19.
Vector Calculus by Marsden is a very good book for getting a grasp of the meaning and application of basic concepts such as Poisson and Langrange equations, and Maxwell equations. You will see that in R^3 those concepts can be represented graphically.
As far as I can gather, that's not true and the soft tissue was in fact mineralized. Dinosaur "mummies" are fossils of mummies. This dinosaur 'mummy' is fairly unique insofar the soft tissue was mineralized without first being desiccated.

Chemical traces of things like pigmentation can remain in fossilized soft tissue, I suppose that counts as "original material", but this thing isn't made out of meat anymore.
Another slight modification to make this show the effect every time:

f=$(mktemp) && \
echo $'#!/bin/sh\necho Hello' > $f && \
chmod a+x $f && \
time $f && \
time $f && \
echo 'echo Hello2' >> $f && \
time $f

On my system:

Hello

real 0m0.131s
user 0m0.001s
sys 0m0.002s
Hello

real 0m0.004s
user 0m0.001s
sys 0m0.002s
Hello
Hello2

real 0m0.004s
user 0m0.001s
sys 0m0.002s