skysight-inc/HackerNews huggingface dataset:
> for the first one, read my other comments, this is solved.

> The second one, you can start here https://www.pgadmin.org/docs/pgadmin4/4.13/debugger.html

I think Starter Kit and the pgAdmin debugger lack in convenience. If you write C# or node js code in your preferred editor, you can debug it there. You can debug your express routes, webapi or resteasy controllers in vscode/vs/eclipse/intellij without leaving the file you later commit to git.

Starter Kit and the pgAdmin debugger are fine tools, but they come nowhere close to how you work with a js, C#, java, python or whatever you like codebase.

The development workflow with stored procedures imho is broken, and I think that is one of the main reasons people do not use them much.
o1lab, FYI, I considered xmysql recently, for my needs it's not currently enough because I'd like to have access rights management. IMHO utilizing the DB users for that is ideal - authenticate the mysql Db users in your rest service session. (PostgREST seems to do this)
They can typically get a warrant for a blood draw, generally in less than 30 minutes.
I know it sounds snarky, and I am sorry (I even tried to apologize preventively, but I was in a hurry and this probably was taken as extra sarcasm on my part).

Still, my point stands: I am not sure if this is really a matter of “SOME people can’t do this”, I suspect it is the other way around: “SOME people can do this... because they are working on free software, on their own personal project, on programs or systems that do not have any TTM aspect”.

And it is not just a matter of "deadlines" either: if your code is part of some bigger system you may not have the chance to reimplement things from scratch not because you don't have time, but because you could impact someone else using your library/module/API.

In other words, this approach is eminently laudable, but in my experience does not scale in most cases.
The president is the commander in chief of the army. The DoD does in fact work for the president. This fact, which is not popular on hn is that the USA wouldn’t exist without the DoD. We’d all be speaking Chinese or Russian. The rest of the federal government wouldn’t exist without the DoD.

I don’t think the oath you quoted is much of an argument.
is this why I can hear my headphones click when browsing websites?
India is already at almost replacement population levels when you look at the data nationally.
Asking other people for project ideas is overrated
I had this idea about how it's more valuable to come up with your own problems to solve and things to do than relying on others (including online communities) for inspiration.

When you're getting inspiration from others you're most likely getting low hanging fruit that someone else would eventually come up with as well. Easily discoverable problems that there isn't much value in solving.

With so many of us around, the value isn't in solving problems anymore - it is in finding the right problems to solve.

Just a little ramble anyway! I don't see myself as an intellectual or anything, I just think this was an interesting thought and reminds me of some ideas Paul Graham has shared in his essays.

Here's the original Twitter thread: https://twitter.com/voxelbased/status/1191094172658421760
> offering that I had had a single drink an hour before

They teach them to multiple the number that people admit to by 2 or 3x.
To be clear, I didn't say "less than 1 out of every 100 lines", but in any case I don't consider yours to be a reasonable definition of "everywhere". Especially since such a low frequency doesn't support your claim that "you see runtime type errors too many times to count". Perhaps you're using libraries that are far, far below the ecosystem's average quality?
I’m not convinced that kindness beyond the normal expectations is something that you want your kids to aspire to. We’re living in an increasingly cut throat and polarized country and while it’s important to provide culture normative empathy in order to avoid being ostracized, going beyond that is likely to your own personal detriment. In the workplace the liars, cheaters and backstabers are the ones that get promoted so why not just skip to the end point and tell your kid that those are the behaviors that it’s ok to engage in these behaviors in order to be successful
Apples and oranges. If Trump were a woman, claiming that they experienced pregnancy discrimination in the past, and the official record contradicted that ... then yes, I would believe Trump.

Pregnancy discrimination, and discrimination against women in particular, has been so insidious and so pervasive for so many years, that the standard for proof has changed accordingly.

Apples and oranges, covered by a veneer of intellectualism and a subtle accusation of partisan bias. It’s pretty transparent trolling to be honest.
I wonder if we read the same article.
You can do that with row-level security. The PostgREST documentation has examples for that specific use case: https://postgrest.org/en/v6.0/auth.html#roles-for-each-web-u...
... and the amateur produces goods out of love that end up powering the internet
I have a mathematical model that would explain this behavior, but I have no idea how much it corresponds to reality.

Imagine that there is a psychological line that most bosses want to reach, for example "to become a millionaire". This desire is the same whether you live in a richer or poorer country, and whether you have twenty or two thousand employees. The word "millionaire" is simply a magical word which does not automatically adjust to e.g. "3.2-million-aire" just because you have more employees or live in a different country. Also, "millionaire" these days in Eastern Europe refers to million euro, just like in Western Europe, and not much different from million dollars in USA, i.e. it is country-independent.

Now if we assume that the million is a fixed psychological goal, this is easier to reach in a large company than in a small one. If you have two thousand employees, you need to make 500 euro per employee. If you are okay with becoming a millionaire in five years, that's 100 euro per employee per year, which is barely noticable. But if you have twenty employees, during five years it makes 10 000 euro per employee per year. They are going to feel that. (Also, the higher the costs and average salaries in a country, the less the employees will feel those 100 or 10 000 euro per year.)

According to this model, employees in small companies in Eastern Europe should be paid very little. But their bosses should still become rich.
Location: Berlin, Germany

Remote: Yes

Willing to relocate: No

Technologies: engineering management, starting engineering teams at startup, tech leadership. Focus: data processing, microservices. Scala, Python, Apache Spark, Kafka. SQL/NoSQL databases: Pg, Cassandra, Hive, HDFS, MongoDb.

Résumé/CV: https://www.linkedin.com/in/dvorobiov/

Email: 2belikespring #at# g mail.com

Looking for either a contract or fulltime.
Principal air routes in 1920 (map)
I couldn't stop thinking REST could be derived from sql..

Similarly after a week of vuejs I couldn't stop thinking redux/vuex should be an embedded sqlite ...
The perceived impact is much less noticeable than deaths. When the bodies pile up you invest in seatbelt regulations, and may even create jobs making them. What if there's no bodies to count?
I don't think we read the same article, assuming you have actually read it.
These days over 90% of traffic is encrypted so the amount of requests they can touch is pretty limited.
Underpaid and Overworked: Being an Animator in Japan [video]
Hmmm good question! I can't say for sure - I guess it was a bit of both.

In either case, I found it's faster to play around with changes in other approaches, though another way of phrasing that could be that it's easier to break things too :)
So what is the alternative that you propose?
Four Day Workweek Tech Jobs?
I'm interested in joining a tech company that is experimenting with a four day workweek. Do you know of any organizations running on a four day workweek or similarly structured schedules?

And, for larger discussion: do you think the four day workweek will become more prevalent in the tech sector?
Why not our information? Nationalise the New York Times!
Heck, most people in government simply don’t even understand the issue, let alone figuring out how to solve it.

AFAIK only one US 2020 presidential candidate atm is even talking about data rights.
between postgrest/postgraphile/hasura there are 30k stars, have all those ppl fallend for this "dumb" idea :)?

You say "expose db" and imply that one would directly give access to the core tables and in this way coupling the api to the data model (one should expose only views and stored procedures) and making the api inflexible.

Or are you saying this is insecure, and if so, can you describe how one would "break" this?
Sorry, changed headlines here have caught me, too. I understand.
This is completely false and trivially easy to check. Over the last year their subscriptions have been record high, they are profitable, and they are expanding. While I do not care for much of their new offerings (e.g. The Weekly or their magazine), the newspaper itself is still high quality.
I'm glad they will add the option, but considering their user base background it was really naive to don't foresee this was going to be detected and that it was going to be an issue.
The meaning of the title hasn't changed much though. Is it too much to expect people to read the article before making inflammatory MRA style comments? Looks like a common problem in this thread.
Author here. Just open sourcing my work for anyone interested.

Happy to answer any questions.

PS: I haven’t tested this on Windows.

Update: Had to shorten the title. Should be:

> Brute force image optimization; optimizes the compression using ML based metrics in a trial ’n error sorta manner.

Although this is something I developed myself so not really sure how best to concisely describe it.

Note that (given the "brute force" part) its gonna be slower than what you may be accustomed to. Although it shouldn’t be more than a few seconds for very high resolution images.
What are physical limitations? With phased aperture array we have 1) individual antennas 2) individual electronics for each antenna. Which of them is expensive?
This not a theoretical argument. Trump regularly makes stuff up on the fly when there are multiple records proving the opposite. The White House has to make up 'alternate facts' on a pretty much daily basis to keep up.

The results are always the same: his die-hard supports believe him, and reality is altered; his opponents point it out and wonder how anyone can think he's not maniacal; and the Republican party sighs and repeats the mantra "you dance with the one that brought you".
I have little faith in such avenues, given the strength of regulatory capture we're seeing across industry.
You can not make a computer lock written by the government and also auto-updateable by the government, that is then unpickable by the government.
> Considering that Hong Kong is at the top of that list, it tells me that maybe "economic freedom" is not necessarily the thing to optimize for.

It certainly seems like one of the dimensions to optimize for, considering that also ahead of the U.S. on that list are pretty great places like Canada, Australia, Ireland, and New Zealand. Also Singapore and Taiwan, places that went from poverty to prosperity in a couple of generations thanks to economic freedom.

> How is that odd? We have an economy driven heavily by consumption, a VAT would make everything more expensive and would be seen as a tax on the poor and middle class.

It's odd to say that something that has been universally adopted by the liberal democracies of every other OECD country is "unpopular."
Similarly, texting while driving has been found to be more dangerous than drunk driving.
And hanging out with convicted pedophiles...
"A place I worked at had a symlink pointing to the app directory"

This is the way to go. Have your root web directory be a symlink. EG. /var/www/app -> /code_[git_hash]/ You can whip through a thousand vms less than a second with this method. Connect, change the symlink. Other options: Pushing out a new code branch, reverting with git, launching new vms with reverted images, rsync'ing with overwriting -- is slower, and more dangerous with prod.

"For the database, during a migration"

There is no such thing as a database migration on prod. There is just adding columns. Code should work with new columns added at any point. Altering a column or dropping a column is extremely dangerous.
An AudioContext provides properties of your machine's audio stack to JavaScript as an API

https://developer.mozilla.org/en-US/docs/Web/API/AudioContex...

Everything is different for every version of firmware, hardware, driver revision, etc. it’s like enumerating fonts, it combined with other fingerprinting techniques provides a very unique snapshot of you.

Eff’s panapticlick provides an audio fingerprinting example. There exist plugins which will provide some entropy to your fingerprint which also changes over time. That helps a little, but any changes you make really makes you stick out like a sore thumb (your audioprofile becomes even more unique)
Hug of death by the looks of it. Maybe they need to quickly change their DNS entries to point to a better server :-)

Edit: https://outline.com/CrL5gf
> People rarely if ever get to ideas to solve problems or even to describing the underlying problem.

That's your job. Develop hypotheses about what the underlying problem is and ask them questions to try to falsify them. Develop hypotheses about solutions and build mockups or proofs-of-concept and have them try them out to falsify them.

No one will hand you a business idea on a platter. But problems to solve are the easiest thing to find in the world.
You clearly have not read the article, so I suggest doing so before making conclusions that are directly contradicted by the information presented.
El Al says goodbye to its 747 fleet with a sky art tribute
Sure, that's perfectly fine if it's for what amounts to entirely private development iterating on something nobody has ever seen.

In my experience my MVPs often end up in production and that utopia of iterating in isolation is fairly short-lived.
The chart shows at what time noon happens when you have a 24-hour clock calibrated to get it right on average. For example, a clock showing GMT assuming you’re in Greenwich.

If you add or subtract hours to your clock instead of keeping a 24 hours day length then yes, you will have jumps. But those jumps are caused by you playing with the clock, they are not real.

The fact that Daylight Savings Time exists doesn’t have anything to do that the duration of the day is sometimes a few seconds longer and sometimes a few seconds shorter than 24 hours.

If noon was always 24 hours after the previous one the line in that chart would be flat. With discontinuities if you want to include DST shifts in the chart, but I really don’t see the interest in doing so.

The rationale for applying DST has nothing to do with that variation, it would be just the same if the time from noon to noon was always 24 hours.
Guillermo Piñeda Morales reminds us we don’t need much to be our best [video]
No because they die of throat cancer at the same rate as women die of cervical cancer.
In that case, the use of the shared cache doesn’t reduce latency, so you’re giving up over a big part, arguably the majority, of the benefit of caching.

Where they come apart, I think it’s common to say latency is more important than bandwidth. It certainly is to me, though if you’re on a metered connection, you could certainly view things differently.
You might find CouchDB and PouchDB interesting then. CouchDB works over REST and there's a client-side version called PouchDB that you can selectively sync between.
Travel is, at least partially, transportation. But I'd add education.
It shouldn't be, but it's often good practice to quote whatever you're responding to.

People sometimes get hinky with the edit button, or mods change the title, sometimes even the swapping out an entirely different url...
What Makes a Good Relationship?
As someone who likes to crack jokes at the expense of goldbugs, Dalio saying to buy precious metals got my attention.
Could you point me to any sources where I can read more about this things, e.g. grants on "multi-language communication services" and such?

Not meaning to doubt you, but it all seems a little too good (or maybe bad) to be true, doesn't it?
That is all true but postgrest goes a step further then Dereks approach (where you need to basically write a lot of stored procedures) and gives the fronend access to safe subset of SQL, so that frontend is not strictly limited to the capabilites of the available procedures that live in the db (thus eliminating the need for most of them)
As the article fails to load at the current time from my location I suppose all I can put in is my thought on how many times I've seen my mobile phone browser asking for microphone permissions on news sites and wonder if some mobile browsers have wised up to this already and defer to the operating system?
I’m a bit upset the article didn’t go deeper on how ridiculous it is to test breath as a proxy for blood.

Not good enough for medical diagnosis/select treatment but somehow good enough to throw people in jail.

> Chemicals, including the ethanol in alcoholic drinks, absorb light to varying degrees.

I’d say they bend/refract light.
I have heard it and Eugene is just pointing out that in Russia they make the same distinction. So it’s nog a novel thing that the US makes that distinction.
The Pizza Crust Problem, or the Wrong Way to Find a SaaS Idea
Engineering AMD K8 Microcode Updates[2004]
"The three golden rules to ensure computer security are: do not own a computer; do not power it on; and do not use it" - Robert H. Morris
Wrong. Apple also sued Samsung for Android core features, but no infringement was found.

Microsoft was a tiny iceberg and exemplified what could have happened to Android. Samsung was reportedly paying close to $1B for a couple of years, until MS bought Nokia.

Google effectively neutered Apple's patent trolling operation by threatening to expose the troll's true motive, and prevented potential threat from Moto patent portfolio by preemptively purchasing it -- on the cheap.
It's up to nearly 40%.

https://www.axios.com/farmers-income-insurance-federal-aid-b...
Generations ago I would have agreed. Several generations of inaction have resulted in needing a less-than-two child rate.

Before the Haber-Bosch process, humans numbered about 2 billion. That process requires fossil fuels. With some efficiency gains we can probably double that number, but along with many other triangulation points, it seems only a substantially smaller number than today's would allow sustainable human society.

We can get there by lowering the birth rate or nature can do it for us, which would likely lower it well beyond.
AWT GUI Facade (8): Keyboard and Key Sequences – Design Patterns and Video Games
Why not canary releases? You can load balance for example 1% of the traffic to the new deployment and see if you experience any issues. If you do - you just change the loadbalancer to use the known good pods.
According to the tabloid Berliner Zeitung, the computers were taken off net at 11:35 on Tuesday (2019-10-29). The court asks its correspondence partners to "Please quarantine (...) the entire electronic mail traffic of the Appeals Court, which has been received since 16 September 2019. "

https://www.bz-berlin.de/berlin/tempelhof-schoeneberg/trojan...
"Productive" is code for obedience.

When ever someone talks about Productivity they are measuring how many people in the population are obedient and fit into domination based hierarchies. Those that don't throughout history are unproductive.

Now the problem is "Productivity" is stagnating since the 80's[1]. Why? Because most people learnt they don't like being obedient or dominated and there are better and newly available routes to meet ones needs and values. We don't need to prop up a Mark Zuckerberg or Ray Dalio or the Queen of England to live a decent life anymore. You can even do it without exploiting someone else.

[1] https://en.wikipedia.org/wiki/Workforce_productivity#/media/...
There is no avenue to escape the rich from creating profit at the expense of the masses. Digital privacy serves neither the government nor the wealthy executives helming these corporations so it will never happen. The public is apathetic and preoccupied with rising food and housing costs. The merits of digital privacy won’t fix any of this.
If you cover great distances per minute - say, 600 km/h airplane does 10 kilometers per minute, and 50 kilometers per 5 minutes - then you can live in a sparse (average 50 km between people) environment.
It would have been interested to see actual delay rather than qualitative results of the nature "<x>% wasn't in cache so this is horrible!". Admins and users don't care if it's in cache, they care what the impact to operations and load time is. https://www.dnsperf.com/dns-speed-benchmark says lookup times for my personal domain results in 20ms-40ms. Ironically the same dns test for 00f.net is taking 100ms-150ms.

99% of apps will gladly trade a 30ms increase in session start (assuming the browser's prefetcher hasn't already beaten them to it) to not have to worry about things taking an hour to change. Not all efficiency is about how technically slick something is.
Things to unlearn when learning Go
> What are you waiting for creating one?

Creating a journal is a tremendous task, and only highly respected researchers have any chance.

> if you really want it to exists it’s better not to wait for someone else to do it

Again, most people simply cannot create a credible journal. Let's be realistic here.
Typically yes. This pattern was more common prior to containers and I think built into Ruby's Capistrano. The main benefit is that rollbacks were _quick_ especially compared to kubernetes or ecs
Industry, crop burning and other agricultural land use for animal production has far bigger impact than fireworks for one day. The BBC are really ill informed to post this as something that is even noteworthy, fireworks do cause smoke, but the net effect on Delhi 365 days a year is nothing compared to everything else going on causing pollution.
Because some of us want our government not to protect our Food and Cars as well. Data is one area where humanity has made the fastest progress compared to Cars and Food.
Might have been reasonable at some point. Unfortunately, even if you don't own a computer, power it on or use it, you're still under computer-based surveillance.
Ok, I can maybe give you consumer products, but you could equally argue that they benefit as much from happy complacency as from despair.

Have any politicians in the West in the last three decades run successfully on a hard-environmentalism and anti-poverty campaign?

The crisis that's been political gold recently has been human migration, but it doesn't seem to me that the voters animated by that issue are feeling anxious and despondent. (Maybe they are, it's a little hard for me to relate to that mindset) They seem absolutely furious and enjoying their revanchist political power.
I don't think I have ever seen another Hacker News thread where half the commenters and the upvoters actually haven't read the article and are basing their comments on the title.
The article which explains how this vaccination results in a personal benefit for male patients? And so therefore we should vaccinate boys? Yes, I'd assume so.

The parent I'm replying to suggests it's appropriate to vaccinate boys in order to achieve herd immunity. Herd immunity is something public health officials are interested in, but as I explained ethically individual doctors are obliged to focus on the direct benefit to their patient. "Now you are less likely to get cancer" is a direct benefit, whereas "Now somebody else you may not even have met is less likely to get cancer" is pretty hazy.