skysight-inc/HackerNews huggingface dataset:
Font Flipper is a free web app to preview Google Fonts on top of your own custom designs, without having to download the fonts first.

We are featured on Product Hunt today! Would love if you guys could check us out!
Hoping there will be a thought leader who will show us how to conduct code review, review, review.
I think it’s a Lobster installation, a copy of the old Joel on Software board.
Absolutely. I think it's a fundamental fact of human psychology that we are attuned to subconsciously figure out the underlying rules behind a system and then plan and act based those rules, meaning that a system that does in fact follow fundamental rules is both predictable and a pleasure to use - that's probably partly why systemic games are so enjoyable. With the corollary that systems without an underlying and consistent ruleset are harder to understand, provide less venue for the user to produce innovative use cases, and seem to come (at least for me) with an unconscious sense of unease with using them. It's like UX but at a more fundamental level.
Anycast still has enough problems, that it's a miracle some are using it more or less successfully. It's not like pure DNS-based routing, where you can throw a bunch of cheap dedicated or virtual servers at it in various countries, measure dns/http latencies in the browser and then just choose lowest latency nodes for IPs, subnets.
>driving at 38 in a 30 automatically makes someone a "shitty driver"

In the parallel universe where all speed limits were set by the highway engineers instead of the people who scream "think of the children" loudly enough you could at least make that argument.

In our universe I think claiming that doing 38 in a 30 with no consideration of context makes someone a shitty driver is pretty laughable and in the same category as "weed is bad because it's illegal."

>Of course getting these drivers off the road would be a case of funding police properly (so they can be around to witness these things happening) instead of the easy option of sticking speed cameras everywhere.

One of these costs money and is set up and administrated by the local government. One of this will be set up for the local government by a private company in exchange for a cut of the profits. Which do you think the government will do?
Probabilistic Programming with Programmable Inference [pdf]
An Ultimate Guide on How to Hack Facebook Ads Performance in 2018
10 Agiles to Griffindor!
> But just out of random curiosity, what's the advantage of using OpenWRT?

I can't remember the exact reason, maybe it was because then the "bootloader" is completely decoupled from the main OS which makes upgrading kernels etc easier. It was about 5 years ago I set it up.

I should add, all the Debian initramfs work has been contributed by various people over the years - full credit to people such as the Debian maintainers, currently Guilhem Moulin.
> As a European, I've always wondered (with a certain hint of jealousy, I might add) at the USA's absolute freedom of speech.

The USA does not have absolute freedom of speech, it recognizes free speech as a fundamental right which means speech restrictions are evaluated under the “strict scrutiny” test.

> At the same time, it's now companies that are very American, both by origin and by culture, that are (letting themselves be pressured into) censuring speech more than has ever been seen in the modern West.

First, this is factually inaccurate: private parties throughout the West have controlled what speech they will choose to repeat, convey, relay, and associate themselves with under standards much more restrictive than those being applied by the controversial platforms today, which are controversial precisely because of how much extreme speech they choose to relay on their platform.

But, second, there is no paradox between the US’s strong notion of free speech and US private entities being selective about speech they will participate in: the strong free speech protection in the US has always included protecting the right of private actors to choose what speech they will participate in, not merely as a legal principle but as an essential theoretical underpinning of the right.
This looks great, but I couldn't get through the first question on aggregate functions. Are there any SQL books/tutorials that go over things like this?

A lot of material I've seen has been like the classic image of "How to draw an owl. First draw two circles, then draw the rest of the owl", where they tell you the super basic stuff, then assume you know everything.
The laws have be setup so, all the value is trapped in the giant network companies. No liability for content. No portability requirements(you can port your phone number, but not your data or messaging addresses). Rent seeking is blocked for utilities, so they don't capture it from google, facebook etc..
Limited as in slow?
I should add that this "overhead" is, IMO, a good bit of the reason why other "professional" industries are so intractable to cost reductions, so long term the "professionalization" of programmers is probably bad for non-programmers (i.e. almost everyone) in the same way that the high cost of lawyer time is a disaster for ordinary people seeking justice (i.e. almost everyone), and the high cost of doctor time is a disaster for sick people (i.e. almost everyone).

For example, rarely does a firm just "hire" a lawyer and tell him what to do: they have to at least play along with the fiction that they are "junior partners" in a "partnership". They have professional obligations (to the Bar, for example) that are outside their employment obligations. It's not unreasonably for there to be more "overhead" positions for a practice than there are lawyers, because his time is to incredibly valuable that it makes economic sense for him to hire several paralegals and a secretary, not counting the "junior partners" that are employees in all but name. If lawyers were cheap (i.e. there was no cartel and fewer barriers to practice), the practice of law would look much different, and vice versa.
More links:

https://wiki.ubuntu.com/SecurityTeam/KnowledgeBase/L1TF

https://www.kernel.org/doc/html/latest/admin-guide/l1tf.html
Indeed. I must not have expressed myself very well, as people downthread still seem to think I'm advocating against opening things up.

Things will open themselves up regardless, and that's fine.

But it's also true that it's really nice there today. I'd recommend going to check it out while there's still time.
What do you mean by, 'extremely sophisticated surveillance equipment'?

Are we talking about smoke detectors, meters for water/electricity usage, or do you mean things like audio/video capture of your activities throughout the room? I definitely expect there to be equipment to determine if you've been smoking in your room (how else would they know) or doing something to destroy the room.

Who has access to this sort of thing? I imagine there'd be leaks if the regular security guards had access to this, so I'm guessing it must go to some LEO HQ.
Background, Taxonomy for Secure Enclaves and Intel SGX Architecture (2017) [pdf]
Software costing a few hundreds of dollars frequently provides tens of thousands of dollars of value.

This is quite similar to "free" (as in beer, let us not go down that tedious path). Say it only provides thousands of dollars of value and it's still pretty similar.
New Zealand bans foreigners from buying property
Yesterday's discussion on the paper itself is here: https://news.ycombinator.com/item?id=17753614

I've got a more detailed comment on that page, but, in a nutshell, I don't think one can reasonably extrapolate these results to a business setting.

I'll go a step further here and say that I see this Science Daily article as a great example of questionable science journalism. Critical details left unmentioned, wild extrapolations, all that fun stuff.
Good job, authors of the game 0 A.D
Sorry, yes, you have a point there. I missed that.
Chinese Cops Now Spying on American Soil
British Airways asked customers to post personal info on Twitter because of GDPR
It is an impression easily taken from your comment. Just because we have the "privilege" (often considered a loaded word, I know, but applicable here, IMHO) to visit a place like Cuba and enjoy its disconnectedness, the audacity it takes to desire to force that on a country of people that has never had any other choice is repugnant to me.

"it shouldn't change because I had a good time there" feels pretty slimy

Yes, technological progress/development will potentially bring what you consider downsides with it, which might be the crux of your point, but that's being unable to see the forest for the trees, IMHO
Games companies often had what they called "feelies": my copy of Ultima 7 came with a cloth map of Britannia and a small black "moonstone".

You didn't have this for business software, but you did need something to keep the disks in. I think the largest such thing I saw was 100+ floppy disks; here's Raymond Chen on floppy installs of Windows: https://blogs.msdn.microsoft.com/oldnewthing/20050819-10/?p=...
There's a whole categories of analysis queries that are really easy to write with window functions and very annoying to write without. They help eliminate nested subqueries and self joins. This should make SQLlite a better choice for data analysis and reporting.
It is hard to say what is really going on, but I can tell you the best way I've found to remember things. It isn't really easy and I too fall out of the habit, but it should be a goal.

1) Read the chapter before your professor lectures on it.

2) During lecture stay engaged. Ask questions. Expand on things that you were confused about. You're there to learn. The professor is there to teach. You aren't taking up any one else's time. And HAND WRITE NOTES. Don't just copy either, explain, reword. Make it YOURS. This is much easier to do if you aren't seeing the material for the first time.

3) Before you go to bed, reread that chapter/section.

4) A week later reread it again.

5) A month later, again.

By this time it should be in your long term memory (if not before). It is extremely important to be engaged. If you aren't engaged then nothing will stick. You're telling your brain it isn't important. And if you don't have repetition then you're reinforcing this behavior. Studying is a skill, and not an easy one. I've seen a lot of dumb people get high quality degrees and be very successful. The difference is that they have to work a little harder. And don't forget that people frequently under play (and over play) how much studying they do. No one is really honest about it.
Holy hell are you angry at nothing.

Big whoop you’re good at pushing hard to build software.

Wake up; it’ll be obsolete in 5 years, unlike a tunnel or bridge

You’re comparing apples and oranges and peddling some crazy emotional rhetoric

Who are you to make suggest others have to jump so high?

I’ve built homes, it was a summer job in high school 3 years in a row. Framing, plumbing, wiring.

I started writing code professionally after that last summer, in 1996. The required mindset is vastly different.

Mr chip on his shoulder is scolding someone else for not carrying a big enough chip.
I don't think it's a silly objection, but I feel it's too abstract, ignoring certain practical realities that aren't really attempting to do what you say "pull the public sphere under one's own roof". This feels like some kind of "plato's world of forms" type analysis of something that's more simple and practical than anything else and is motivated more by convenience and thrift more than something like an "impoverished world-view". Your comments feel to me a bit like you are looking down on the parochial plebs for their simple pleasures.
You mean, in many cases, the people that wrote the Alien and Sedition Acts?

Yeah, I'm pretty sure they weren't free speech absolutists.
This capture my view as well. In the past decade few of the projects I worked on were mechanical. New languages/frameworks lead to new classes of problems and much of the overtime is troubleshooting and working around those. Some time is saved by experience but not as much as I'd like.
There's working to live, and living to work - it sounds like you've been focused on the latter, as opposed to the former. If you're focused on the latter, your relative happiness will be directly connected to the success of your work.

If however, you can change the mentality to working to live - you have other options for success, and happiness. Success might come from anywhere between things like taking a walk daily, or even hearing a piece of music that day that sets the tone.

Try working to live, and let a little bit go every day. Pick one thing to enjoy that day, whether it's a cup of coffee, a book, or X. One glimmer of happiness begets the next one - it's really the first 90 days affect, applied to mental health.
There's a definition of bullshit given in the paper. It does not relate to whether the statement is true or false (indeed quite the converse, it relating to an absence of concern with truth) and it does relate to whether the statement consistently has an unambiguous meaning.

Consider that you understood the statement without complaint of ambiguity, enough to question the truth of the assertion and discuss that with other people without your having to impart your own meaning that you construct. And consider the gyrations and gymnastics that people are applying in this very discussion to impart their own meanings to the other statements that are without consistent unambiguous meaning.
There's also a dedicated site: https://foreshadowattack.eu/
Nazis and whack job conspiracy theorists.
Software Engineering at Google [pdf] (2017)
Article is from 2013. But yes, of course Microsoft is going to be a hugely corporate environment where people want attention by their superiors, want nice careers, and probably don't spend weekends polishing some code so it runs fun and looks pretty. Most large companies are like that.

Open source is a different culture where you care about those things. I think Visual Studio Code is pretty nice though and it's still not filled with Microsoft logotypes and commercial marketing messages, so they have that going for them. :)
One piece of feedback I have is to be careful with tagging. What is physics to a biologist [1] is probably not physics to a physicist. If you want communities to build around this hub, then you need to be careful about flooding a small community with unrelated topics because a larger community is more active on the internet.

This looks neat otherwise and I joined.

[1] https://paperkast.com/s/mbiq74/maximum_entropy_model_for_pre...
We have a pretty good CI setup for our iOS apps using (shockingly) Microsoft's TFS. Not sure about any other cloud providers, but I was surprised by how easy it was to get working on a MS product.
How to create 3D Web product configurators
“Pista ng Pelikulang Pilipino 2”
The box designs were driven more by attracting attention from retail customers in physical stores than by perception of value. Just like cereal boxes.

The user manuals were absolutely necessary for complex software. Most users had only a single low resolution monitor back then so online documentation had poor UX.
I think the idea is that the fixed cost of failed software is (largely) sunk.

You can sell a big industrial motor or fork lift that might be part of the fixed costs of running a small factory.
You don't have to understand how an economy works to participate in it. It helps, for sure, but it isn't required. Trial and error goes a long way. A lot of companies will go out of business because they are doing something that doesn't work, but some will chance upon something that works.
TL;DR: Actually, read this longer thing:

https://smile.amazon.com/Capitalism-without-Capital-Intangib...
I think you associate life with work too much. You should probably take a vacation, and get a hard look at yourself what you want to achieve in life.

The way I understand it is you want to be recognized for the work you put in, but shit happens. You want stuff done, but others don't see the same way. You might just not be seeing things from their perspective. You seem to have a very opinionated view of what your life should be. Maybe these opinionated views stem from what others, (friends family coworkers, society etc) expect.

What are your expectations? I wouldn't be surprised if you are having an identity crisis right now either or some form of delusions of grandeur. A company at the end of the day is just a company. Its not your sole identity and being.

If you walk in a room full of random people, and the first thing you introduce about yourself is how you work for XYZ company and only talk about all the great things at XYZ, then this is a pretty good indicator. Think FORD (Family, occupation, recreation, dreams). You only seem to be talking about occupation nothing else, thats 1/4 of what defines you

Related article I wrote in this hackernews post about lack of motivation

https://news.ycombinator.com/item?id=17695868

and knowledge worth knowing

https://news.ycombinator.com/item?id=17740743
Nobody will die if your webpage doesn't render but software is used in safety critical environments too.
These factors don't need to be explicitly discounted because they are far too small to matter. The number of people covered by various private group health insurance in India is something like 100 million, so it's just a 10% difference when we're talking about order-of-magnitude differences. Yes, not all 1.3 billion are poor and depend on government health insurance, but the numbers are so outrageously off that it doesn't work for 1.3 billion people; doesn't work for 1.0 billion people, doesn't work for 0.8 billion people (who are currently uncovered by other gov't subsidies including RSBY). Unless you're arguing that it applies to a tiny, tiny fraction of Indias population, the math doesn't work out, either the cost estimate or the benefits will be entirely different.
Try Joe Celko's book "SQL for Smarties" or ...

https://www.red-gate.com/simple-talk/sql/t-sql-programming/w...
Programmers ARE a spoiled and privileged class because you’re not breaking your body the same way to survive as carpenter

And that field is also pushing safety and mental health way more than it used to

To suggest there’s an equivalence to their effort and struggle as a manual laborer is self-aggrandizing nonsense itself
Well all games used to come as a CD in a box, simply because it wasn't viable to download them from the internet. I still remember the amazing box for GTA:SA that came with a large map and a little booklet to introduce you to the game.
Pyperclip, a cool Python clipboard module
I'm not saying reduce the body count, I'm saying don't specialize. If you have three managers, have them do everything, don't fire two of them and give the third one the work of the other two.

If you still disagree then I think we have different intuitions about the difficulty of wearing different hats in management positions. This is somehow analogous to the split on full-stack vs. specialized development. Interestingly, full-stack teams have been heads and shoulders above in quality in my experience.
> Your comments feel to me a bit like you are looking down on the parochial plebs for their simple pleasures.

No, no, no! The plebs will live happier and more fulfilling lives if they meet their friends at the bar for a pint (and stop pursuing the illusory control of their very-own basement bar). [0] This is about looking up, not down!

[0] By the way, I'm just the kind of guy to want to build his own basement bar. These are message-board musings, not cultural edicts.
David Brin wrote "The Transparent Society" in 1998. Most all of what he said was incredibly prescient. He certainly understood that dangers of the one-sided panopticon.

Unfortunately, I gave away my copy of that book to a CEO while working for a company that built police car cameras and was trying to go into the mass transit market. That CEO was a complete asshat when it came to privacy, a total "if you have nothing to hide..." type of mentality. He also didn't return my book. Maybe he read it, though. Maybe it had some tiny, lasting impact on his ideas.
> The baker won his case at the SCOTUS.

For overt bias-in-process reasons related to the state administrative adjudication of his particular case, not because the result otherwise would have violated his rights.
Understanding Neural Arithmetic Logic Units
Terrible idea. The $6000 should instead be a percentage of your income (above a certain point, like poverty)... i.e.: ($60,000 - $12,000) * 0.05
In theory this should be possible on Google Cloud using nested virtualization or EC2 bare metal...
Unfortunately AMD is not doing well in the server market at the moment (last time I looked into it)
You're right, it should work!

When you wrote "backfill the remaining rows incrementally", did you mean having some background process or thread that reads a batch of rows from the old table (for example a few thousands of row), then inserts them in the new table, then commits, and keep doing this until all rows are copied? This way, other writers will be blocked only for the duration of each incremental transaction and will have an opportunity to lock the database for themselves between two batches?

Do you have experience doing this on production servers?
This case only really applies in situations where speed limits aren't well established. I will admit that I was talking from the perspective of a country where you are tested on common speed limits before you are allowed to drive, and which has extensive signage indicating allowed speed limits. In such a situation people are only "unaware" in the sense that they are knowingly breaking the law, but not thinking they are going to get caught.
Humiliated is what you say when you want to say "made fun of" but you want the humorist to be penalized for making the joke.
The CERN cost is just a few billion. The only things we take apart that have budgets measured in trillions are middle eastern countries.
What If English Were Phonetically Consistent? [video]
"Well all games used to come as a CD in a box, simply because it wasn't viable to download them from the internet."

Was this not the reason software was distributed in CDs? I can understand MSFT/Apple using that packaging for customer experience.
In my opinion, the street cameras are totalitarian. Look how China is utilizing mass surveillance and then ask yourself are the alleged reductions in street crime worth the massive harm done to an open society? The first stages all seem so benevolent, then you turn around and in a couple of years you have a government that completely turns on its people and murders them wholesale the way China is doing right now. It's evil and it is sick. We might better just have the street crime.
The Plastics That Surround Us May Contribute to Obesity and Diabetes
Thanks so much for your responses! Well, there is a section that asks about anything else we should tell or that they should know. I feel as though they would find out any way and it is always good to be straightforward.
It will with time, once they have a stronger middle class with a better purchasing power.
Why nobody have build a YouTube for podcast yet?
I wonder why there is not a good platform for creators and listeners of podcasts with a ad system similar to youtube where the owner of the podcast can make money with the same podcast for a forever.
At the time of Windows 98 you probably wouldn't have wanted to download the damn thing.
If you are of a younger generation, you may not believe it, but many of us in those days made do with something called dial-up connections to the internet.
I well remember downloading the StarOffice - precursor to LibreOffice - suite in the days before it was taken over by Sun, meaning 1999 at the latest. Took a little over five hours, and was done at night when rates were lower. I actually stayed up, nursing the process along. And afterwards guarded the downloaded installation file, almost with my life, although it took up an inordinate amount of precious storage space. It was 50MB and a bit, you see.