skysight-inc/HackerNews huggingface dataset:
It's not about hyperscale, it's about time to market.

Traditional corporate datacenters were dogshit when it came to provisioning new resources for business capabilities.

In today's world, we need the ability to spin up and down deployments very quickly. We don't need huge numbers of resources, just fast response.
Can you please add a pricing page to your website? Also, can one run these tests with an api key on ci/cd?
It may be flawed, it may be old, but it clearly continues to be sufficiently expressive and useful.

Every time someone tries to replace it, it eventually comes back again. Just look at the recent NoSQL and Big Data craze, and then how we're today with a miriad of SQL engines.
Yes. It's good enough, I guess.

I think, a VM approach would have been a bit more flexible.
California doesn't revolve around tech workers alone.

Of course there's no progressive utopia. That's what utopia means: "no place". But California is incredibly progressive compared to other states in the US.

BTW, here's another piece on progressive hypocrisy: https://www.youtube.com/watch?v=hNDgcjVGHIw
I know space is at a premium on a space craft. But wouldn't it still be simpler just to have a sleepingbag that rotates around a center by the upper torso? Seems overengineered to sleep in a vacumbag.
What's your connection to Holo? You seem to mention them a lot.
When my partner and I first meet we were both senior engineers at larger SF tech companies. Three years later she is a principle engineer and I stayed a senior engineer. She and I agree that everything past a senior engineer is political. She is much better and handling the complex social dynamics of the management class. It's kinda a game of finding the least common denominator that works best by not pissing off people and making everyone maximally happy. That often means the decisions you make you know are not the most optimal, but the most politically optimal. Just our observations.
This is a neat idea, but I think the site is a bit too barebones for people to want to trust with their data.
How is that anti-business?
I'd agree with this. I've met many people who have identities and can get along with people just fine. However, when we identify as enemies of other people, things tend to go a bit haywire.
Dynamic Frequency Selection
Thanks! Clearly my HN markdown game could use some tightening. It looked good on entry…
What Makes It Hard to Control Inflation
I've mentioned it before and will again: AWS spent a decade openly and privately advertising how much "cheaper" the cloud was. How economies of sclae meant you'd save boatloads of money. Except, it was never true. You will potentially save money if you're just starting out and have no idea if your idea will be successful. A massive capital outlay is difficult and stupid at that point. You will also potentially save money if the tool you use to make money is something you can easily scale up and down, and actually DOES scale up and down. IE: I host a fantasy football stats app and every Monday night, Thursday night, and all day Sunday I've got millions of users, and thousands the rest of the week.

If you don't meet those criteria, unless you are absolutely horrible at negotiating with your vendors, you aren't saving money going into the cloud. I don't care that "datacenters are expensive to build". If you are large enough to need to build your own datacenter instead of renting floorspace for pennies on the dollar from Switch or Equinix (although Equinix is kind of pricey) or Windstream or insert provider - then the datacenter is a rounding error in your 10-year IT budget.

The problem is "I moved company XYZ to the cloud" is now a requirement for an IT exec to show up to the country club on Saturday. So whether it makes any fiscal sense at all, the board wants to know "what our cloud plans are" and most execs are more than happy to oblige in order to pad that resume. In my experience, most of them leave long before the bill comes due, and people start asking why the IT budget quadrupled in 3 years. The best part is, most of these companies can't pass along that increased cost to end-customers like a Netflix can because they aren't actually making money on the apps they're hosting in the cloud, those are all internal business facing apps.
Why security again? Fresh air would do it. People being afraid constantly are in need of some serious punching, they can be afraid of that for all I care. Policies of the last decades were constantly focused to cater to schizophrenic needs.

Security isn't advocating something positive since it implies that you would need it.
The American dream.
Thought the exact same thing. Karma's a bitch...
The cynicism we see is a product more of the boredom of an upbringing in white suburban affluence. Some peoples’ lives in the past half-century were devoid of the struggles of other times and places. Lacking any contrast for anchoring, that homogeneity is interpreted as “everything is terrible” rather than “everything is fine”. Throw in a bit of aimless masculinity or status anxiety, and people start believing a bit of paintball-but-with-real-guns could fill that craving that’s been bothering them.

Others express their total disdain of even the concept of trust by jumping on the cryptocurrency bandwagon, or by believing TOR can do more for them than robust civil rights legislation. It’s all just aspects of the same sentiment, which is why there’s so much overlap.
Honestly "big companies, banks, governments" do sound like the usual suspects for writing programs insecurely to me (I work for one of those).
Gartner: Apple should quit the hardware business (2006)
Scale (of your application) is usually not the reason to use clouds.

Agility, flexibility, security, global deployments, and consolidated billing and operations are far more important.
The Snapdragon 8 Gen 1 Performance Preview: Sizing Up Cortex-X2
MySQL/MariaDB certainly permits their use in GROUP BY, HAVING and ORDER BY.
I don't think this geopolitical perspective constitutes xenophobia. Do you really?
The pandemic ended for most people months ago, for me personally it ended the moment I was vaccinated.
As a South African. I am wondering what this guy is on about?
all signs point to far higher infectiousness, which means more infected. if the rate of hospitalizations per infection stay the same, absolute hospitalizations will rise according to the total infection numbers plus a higher rate of vaccinated patients due to the lowered effectiveness.

we had to to relocate patients to hospitals in other states only a few days ago because some of them were already completely at or over capacity. i fear that with omikron the numbers will rise to a level where there just isn't enough capacity, and in that case the survival rate of (potential) ICU patients will drop from 50% to ... well. what do you think happens if you send an ICU patient home?

> And you say extended lockdowns for the unvaxed have failed because they 'cheated' without mention that being vaccinated does not a) stop you getting covid or b) prevent you spreading it.

it's true that being vaccinated doesn't stop you getting covid, but it reduces the chance of getting it greatly. it also doesn't prevent you spreading it, but the window of you being infectious is smaller and you'll just a lot less infectious if you're not infected yourself due to the vaccine.

> Most of your points here are rote repetition of the media talking points

well, they're the talking points of scientists i trust on this issue. i perceive his talking points as rote repetition of media talking points too, just from right wing/denier media.

> Aren't they vaxed, therefore not concerned?

all the vaccine does is lowering the risk! it doesn't make the unvaxxed immune. nobody denies that. the vaccination is just one action of many. a powerful one though.

ireland has high rates of vaccination and few deaths. austria has comparably low rates of vaccination and many more of deaths. it's not that complicated! vaccination never would have been made mandatory if people would have gone on their own, but since the right started to radicalize and mobilize people this chance is lost forever.
Good post, and an important concept to understand.

Will crypto- upset this effect, or will it devolve into the same model? Isn’t it the case that NFT’s seem to have a few big winners, and the rest are in the noise?
I see you would like a recipe for developers?

https://wikidiff.com/spam/spam

https://www.codegrepper.com/code-examples/python/frameworks/...

EDIT2: replaced statement of fact about WHERE/HAVING with this message.
Just when I thought the antiquated concept of tipping couldn't get any worse. Where there's a bill, there's a tip to pay.
The money is not the issue. Cost is not the same as value.
Issue #3: DotNet (.NET) & JavaScript (JS)
This. Turn the "cloud is somebody else's computer" on its head and own part that computer.

Why not "own" AWS, GCP, Azure etc.? Because you can't. They are part of conglomerates that come with a moral baggage that is too heavy for some.

ps. No "hyperscaling" ability required. The idea that business activity is either complete dominance or death is part of that unfit-for-purpose mentality.
Best Email Marketing Services upon 2022
It's a lot easier to check if something is a prime than to factor it.
US tipping culture is just awful. For anyone that comes with „yeah but you can show appreciation towards the servers“. When was the last time you tipped your plumber, mechanic, cashier, programmer, nurse or lawyer?
Stavanger Declaration Concerning the Future of Reading (2018) [pdf]
I'd definitely recommend https://staffeng.com/ for anyone who's making the transition from senior to staff+. I found it invaluable when I made that transition.
Firefox seems to be a really second class citizen across all of Microsoft's web properties. Stuff just randomly breaks, or isn't implemented, and the solution is to use Chrome or Edge.
Can confirm. Was a developer for 20 years, got an MBA 20 years ago and have been dismayed by the quality of Gartner reports. Worthless for anyone with experience, and dangerous when used to guide the non-technologist. (Yes, I've been developing for 40+ years.)
Why Technical Analysis is 100% bullshit (2015)
I'm not sure why it was downvoted, because dang posted very similar advice in the past. (Perhaps the tone is a little aggressive?)
> You can't exclude rows from aggregation with HAVING.

In theory¹ a DB that supports skip-scanning could use feedback from some HAVING clauses to short-circuit such a scan significantly, for instance if HAVING COUNT(*)<4 is present and a fourth row for that grouping comes up it can discard the row and skip to the next value. This would likely only be useful for indexes containing large numbers of the same few values though.

[1] I'm not aware of any engine that does this. It might be that the time cost of assessing if the optimisation is worthwhile² far outways the sum benefit over time of the saving when it is actually found to be worthwhile.

[2] Similarly, writing+testing+maintaining the code to do so might not be good use of dev time compared to other improvements
I think this is nuts. First you need tips to survive if you work in restaurants because the owners pay too little, then the owners take the tips and distribute them around. What's the next level? Make tipping mandatory? May as well put it in the price.

Just ban tipping and pay the employees a fair wage. Will be better and less stressful for all parties. Customers, employees and owners.
>I'm still absolutely blown away we tolerate an industry model with uncapped cost

Try reading the contract you have to sign before receiving medical care :)
Thanks a lot. Love watching things like that to relax.
A lot of those feel like they're automatically generated. Highly formulaic structure, repetitive, borderline nonsense parroting of the "common wisdom". If they're actually written by humans, I feel sorry for them.
> SQL ANSI nulls alone are a good-enough reason to toss it. Any language where "x = x" commonly returns an object that is treated as falsey is broken.

Nah. One of the most common uses of null is to communicate missing values in the sense of "this entity has this attribute but we don't know what its value is". This is a fundamental feature needed in data management.

So say you've got data on two balls A and B. You don't know what the color of either ball is. Is color(A) = color(B)? What's the best answer to this question?

Obviously it's "we don't know", and the value we use to communicate "we don't know" is null.

SQL nulls aren't broken. They're just a third option outside of True/False that needs its own handling, because reality is complicated.

PS: Contrary to popular opinion in certain coding circles, floating point arithmetic isn't broken either. It's a beautiful, delicate tool that works the way it does because it must in order to support its use cases (e.g. numerical linear algebra and representing continuous physical quantities). If it doesn't work exactly the way you want, you may need a couple guardrails or a different system like fixed point arithmetic.
Show HN: A simple hand drawn HTML/CSS theme
I lived several years in down town Oslo, and it had both universal healthcare and lots of visible homelessness.

(although it seems to have gotten slightly better over the past 5-6 years)
Bitcoin has only been around for 12 years, and went from 0 to 69k dollars. How has it been in a recession for the last 12 years?
I think GP is correct when he says "every time somebody tries to replace it they throw the baby out with the bathwater and throw out the relational theory too".

However, I would add that SQL is a very strong local optimum: a "good" language that keeps the good parts would be insufficiently different from actual SQL to convince anybody to switch.

Also people forget that querying is only half of the equation, there's DDL too.
>The National Science Foundation and National Institutes of Health do allow professors to be part of foreign talent programs, but require they disclose it.

So the issue is not the country (China) or the fact that he joined a foreign program. The issue is the nondisclosure.

From my first quoted example, the tone implies that the issue is China itself which is where I got that impression.
Exactly! This is the one reason I refuse to use AWS and am constantly surprised so many people are willing to have this risk on them. I'd rather get a VPS with DigitalOcean and know that they cannot charge me tens of thousands if somebody hacks my account.
I'm interested to see it, but I have to verify for Google sh1t. Do you have it online somewhere else? Is it a self-built TEG?
That depends on how noticed it gets. My company makes embedded systems that in some failure cases can kill - we have a history of losing large lawsuits over the base 70 years (before computers of course). As such we have a powerful safety review system in place because million dollar lawsuits make CEOs care - it isn't perfect but there are a lot of things that we don't do that our customers would love.
Clarisights | Chief Architect, Principal Engineer, Devops Lead, Engineering Manager | Bangalore / Remote(India)

We, at Clarisights, are bringing a paradigm shift in how business users draw insights from data coming from 100s of different data sources. We have very large enterprise customers across the globe and are well funded by the world's leading VC firms. We are loved by the likes of Uber, Delivery Hero, About You etc who have had deeply technical large engg teams even before they switched to Clarisights.

In the process of building Clarisights, we are solving some incredibly hard engg challenges through the whole stack ranging from scalability and design challenges in frontend to building large scale distributed systems in data engineering and infrastructure to diving deep inside databases and even building our own distributed HTAP database. If you love building deeply technical products from ground up, Clarisights is the place for you.

What are we building?: https://clarisights.notion.site/What-are-we-building-e370143...

Engg Philosophy and Challenges: https://clarisights.notion.site/Engineering-Philosophy-and-C...

Recent funding round led by Sequoia: https://blog.clarisights.com/series-a

Checkout what to expect at Clarisights and open positions: https://clarisights.com/careers

Simply drop an email at hiring@clarisights.com to get in touch.
Ya girl JK filed a report against a woman who happened to have the same last name as one of her characters so yeah.

https://mobile.twitter.com/gothspiderbitch/status/1467693856...
Until this year I used a 2009 Macbook Pro. I finally switched to Thinkpad because I wanted to use an OS that gets security updates. It's not miserable at all if you have sufficient RAM.
Awesome-Rl-for-Cybersecurity
Well, except for Microsoft.
Hi, the pricing is tricky part in any startup. We have some smaller plans and bigger plans. It really depends on what your needs are.

Absolutely, integrating with CI/CD is super easy. We have some integrations already with major CI/CD pipelines. You can find it right here after signing up: https://app.preflight.com/account/integrations
> Others have mentioned a car-centric culture, but there are plenty of cars in Paris too, it just seems bigger. I wonder if I can back this supposition up with actual street measurements.

I suspect you won't be able to back this up with actual street measurements and that they just make better use of the available space. We give a lot of space over to cars in the US.
Postgres reference SELECTed aliases in ORDER BY/GROUP BY clauses, but _not_ in HAVING:

test=# create table event (who text not null,
test(# what text not null,
test(# at timestamptz not null default now());
CREATE TABLE
test=# insert into event (who, what)
test-# values ('Bob', 'sent a message'),
test-# ('Alice', 'received a message'),
test-# ('Alice', 'sent a message receipt'),
test-# ('Bob', 'received the message receipt'),
test-# ('Bob', 'waited patiently for a response'),
test-# ('Bob', 'worried whether his message had been well-received'),
test-# ('Bob', 'paced'),
test-# ('Alice', 'forgot to reply for two weeks'),
test-# ('Bob', 'began to panic'),
test-# ('Bob', 'fled the country for Moldova in a fit of panic'),
test-# ('Alice', 'finally remembered to reply'),
test-# ('Bob', 'never got it');
INSERT 0 12
test=# select who as "The poor sod",
test-# count(what) as "Events"
test-# from event
test-# group by "The poor sod"
test-# order by "Events" desc;
The poor sod | Events
--------------+--------
Bob | 8
Alice | 4
(2 rows)
> Akash Network leverages 85% of underutilized cloud capacity in 8.4 million global data centers, enabling anyone to buy and sell cloud computing. [0]

How do you even begin to operate a consistent security model across "8.4 million global data centers"?

> Auditors on the Akash Network review cloud providers and digitally sign the provider on-chain with their certificate. If you only accept bids from audited providers this means you are trusting the Auditor/Provider not just a Provider. [1]

For a business at scale, I don't see this being solid contractual ground. Now I have to trust Auditors to continuously vet Providers? Simply too tenuous for my comfort.

[0] https://akash.network/about#vision

[1] https://docs.akash.network/glossary/security
I don't think HAVING is strictly needed, but you need to use a sub-query.

SELECT x ... HAVING y => SELECT * FROM (x ...) t WHERE y
> "describing an event or person negatively without indicating next steps to fix the problem"

That's an absurd restriction.

1) Complaining does not require people to have the expertise to provide a solution. You can complain about a painful tooth and the dentist will handle that.

2) Complaining has social value, especially in democracies. It created social movements that pushed for political change.
On a previous job we had a huge GPU server on prem because we wanted to use it for deep learning.

It would have been much, much cheaper to rent gpu in the cloud and when we knew _something_ about our workload we could buy an on prem and maybe rent extra if needed.

But we weren’t cleared for cloud.

Regarding in-house expertise: I think most companies would like to have in house expertise but they can’t hire the expertise they need so they use consultants.
Cost is a key component of value though.
No, if you click the link, the headline reads "customer service organizations." Submitter seems to have taken some liberties by omitting that part.
> you shouldn’t be giving them a gift

I hate buying birthday and christmas gifts, and I don't expect to receive them either. I don't have space in my small flat for stuff that doesn't earn the space it occupies, and I assume my relatives don't either.

My policy is to buy presents for people when I find something that I think they'd want. I usually check with them first, so that I'm getting the correct style or model. This process isn't synchronised with any anniversaries, except that if it's near an anniversary, a date-adjustment might occur. For an occasion for which some kind of gift would be expected (e.g. 21st, birth, retirement), if I don't find the right thing, they get cash.

I prefer not to give cash ("it's the thought that counts", and giving cash doesn't involve a lot of thought), and in practice I only give cash to my grown-up kids, who understand how I operate. The hardest target is small kids, who enjoy unwrapping things and enjoying them immediately. I've given cash to my toddler granddaughters too, though (via the investment fund their parents operate); but not on their birthdays.

My late father didn't want people to give him "hard" gifts - stuff that he had to keep somewhere, or worse: put on display to prove he appreciated it. He preferred gifts of food, or other stuff that could be consumed fairly quickly. I'm the same, and I treat others as I would like to be treated myself. I have enough stuff (but I'm running low on caviar).

I think a random, well-targeted, gift on a non-anniversary, coming out of blue sky, is much more exciting than yet another plastic birthday present, arriving on the same day as all the other anniversary presents, that will last a couple of weeks before going to landfill.

I often forget my own birthday. I'm fine with a Happy Birthday phone-call - or none. If someone needs an anniversary gift, for whatever reason, I visit a few card shops, and choose a really snazzy, expensive one. Some of my rels are still displaying fancy commercial cards I sent them ten years ago; I'm still displaying a hand-made card drawn by my 2-year-old granddaughter.

My christmas-card list is zero lines long.
> get rid of the extra “REPL” panel for good. Why do you need it if you can see your results inline?

But I do not want them inline. I want to use the REPL as a _interactive_ REPL, where I can write my code and later copy that to the file. That's actually one of the reasons I still use Emacs: Common Lisp with Sly and Clojurescript with Cider.