skysight-inc/HackerNews huggingface dataset:
In the world of data analytics/BI are many people whose main job is writing SQL.
My back yard weather station picked up the shockwave here in the bay area: https://twitter.com/DavidCWG/status/1482451910154014720

I had no idea that was even possible. Crazy stuff.
I am using sway (similar to i3 but for wayland) and it is working flawless on an Lenovo X230 running FreeBSD 13. It seems biggest problem will be graphics driver for different hardware.
This whole "userland and kernel" thing sounds good, but in my BSD use, the trade-off is that most desktop app packages (and ports) get a whole lot less attention and are more buggy than those in Linux. I imagine it's not a problem for servers.
Samba 4.16.0rc1 Available for Download
You're confusing efficacy against severe disease, which this study proved, and efficacy against death, which this study did not prove.
Microsoft Flight Simulator! https://en.wikipedia.org/wiki/Microsoft_Flight_Simulator_1.0
> I think the way men are "meant" to have friendships [...] is to bond over shared initiatives, organizations, or projects.

I feel similarly, but I classify "life" as a project. And a very important one. I have friends with whom I can discuss various ways how to make our lives better (e.g. how to take care of health, how to learn, how to get rich, how to help others, how to live meaningfully).
> but the difficulty is adjusted based on demand

Only indirectly. More precisely the difficulty is based on supply of hashing power. If more people hash, the blocks will be minted faster and the difficulty will be adjusted higher at the next re-adjustment. It doesn't really matter if those blocks are actually full or empty, and in fact the system would continue to work if most of the blocks were empty and the trading happened off the chain in exchanges.

I say indirectly because the amount of hashing power on the chain at any given moment is driven by the expected reward per block minted. Nobody wants to run thirsty machines if the cost of electricity exceeds the expected rewards for successfully minting a block. So the number of machines online and is directly proportional to the value of bitcoin, which is driven by consumer demand.
Instead of tagging (which takes effort) you could also use a good search algorithm.
>... you need therapy...

Yep, this is clearly something that has an incredibly negative impact on this person's life, and they would definitely benefit from speaking with someone in great detail about this! It's very kind of you to recognize that and offer your advi-...

>Get over yourself.

... oh. Yikes.
"After 4.x FreeBSD Went Downhill"

This nostalgia is justified - see:

https://news.ycombinator.com/item?id=30063417
Here in California in the Sierra Nevada, a pressure variation was noticeable around 4am pacific.
Why avoid LVM?

If you could point me to a practical instruction on how to get it running I’d be very thankful! I’m sure I’m missing something basic - as is usual when struggling with UNIXes…
> 1.5M lines of code is not an init system, it is a time bomb... and with dodgy wiring.

https://news.ycombinator.com/item?id=21935186
That’s because Tokyo is not as dense, because he’s also huge by area.
That's a weird idea. While steady exploitation could be a price for other people's good lives, coups and civil wars are almost pure loss. This or that weapon merchant can make some money but it's peanuts compared to ordered economic activity.
while machines and apps are also typically soul-less, only lawyers will ever be able to take this to the level of art they do.
I'm quite opposed to the idea "from should be first".

I want to understand what exactly the query returns, not the implementation detail of the source of this data (that can later be changed).

Literally first example from page - I have no idea what is being returned:

from employees
filter country = "USA" # Each line transforms the previous result.
let gross_salary = salary + payroll_tax # This _adds_ a column / variable.
let gross_cost = gross_salary + benefits_cost # Variables can use other variables.
filter gross_cost > 0
aggregate by:[title, country] [ # `by` are the columns to group by.
average salary, # These are the calcs to run on the groups.
sum salary,
average gross_salary,
sum gross_salary,
average gross_cost,
sum gross_cost,
count,
]
sort sum_gross_cost # Uses the auto-generated column name.
filter count > 200
take 20

of course, similar things are happening to SQL too, with CTEs becoming more widespread and "real" list of the columns hidden somewhere inside, but it's still parseable
That’s still a drop in OTE over a year, especially for a company that pushes the “total compensation” message.
Probably not, they just optimize for looks and not use.
Cost, knowledge deficit of the designer &/or eng side, inertia.. there are a lot of reasons. Many html a11y features are as easy to implement as adding an attribute (but people are unaware) -- other things, like designing a product flow to be accessible, can't be fixed with engineering; they have to be redesigned.

My team at LinkedIn is trying to solve the eng side of this with a combination of automated tooling like linting & headless testing, reporting, etc., trying to make it as painless as possible for an engineer to fall into a pit of success re: a11y for web/mobile experiences.
What makes you believe that Mark "I can't believe those dumb fucks trust me" Zuckerberg doesn't have our best interests in mind?
Your point is well taken, but I doubt the casual reader would make the distinction that you do. And in regard to Covid deaths in the study, the people who ran it were well aware that the small number of deaths were not, by themselves, enough to establish efficacy. But in combination with the numbers for severe illness (2 in the vaccinated vs 106 for the placebo group) and everything we understood about how the disease kills, I would argue that the study does in fact overwhelmingly support the conclusion that the vaccine prevents death, just as we have since confirmed.
I did, I went from video games to software + physical engineering of theme park rides but with the pandemic, back to video games... I'd recommend schooling but like anything, you can probably do a lot without the degree as long as Professional Engineers are around to sign off on things.
Britain is 1.7 times larger: https://www.mylifeelsewhere.com/country-size-comparison/flor...)
I think these things scale sub-linearly
FBPurity (.com) seems to spend most of its time on that case. Works pretty well for months at a time, then FB changes something, and a new FBP update comes through a few days later.
The article notes that FreeBSD has over 26,000 pieces of software with a link, but that link just goes to a page that says "The latest Python updated failed. I intend to repair this post-BSDCan 2019 -- mcl"
I don't really know that there's much written about it. Lawyers tend to keep business models close to their chest and it was very much a learn by doing kind of thing.

When I took the job there was certainly a period of "mind blown" while I learned more and more about the industry but I had the perfect position to learn the industry.

For online advertising, all of the core skills about keyword bidding and targeting apply. Terrestrial marketing is vastly more effective in the legal space though and while more expensive (TV), billboard and radio/podcast pricing has come down significantly.

Really it's all about coming up with your own effective price model and making sure you can measure the effectiveness of your campaigns. Most law firms are vastly overspending compared to what they actually need to but they're spending in places that bring in so much money that they can literally throw money away at this. If you're data driven you can make a fortune here and there's tons of existing firms (and a small but growing group of marketing consultancies) to partner with if needed.

Having technical skills and a JD will make people want to work/partner with you.
> People in general are stupid.

Many people in the singular are brilliant. You are hand-waving away the fact that the most highly experienced and skilled developers in the world, have in the majority, chosen to develop their software using object-oriented programming. And that software is what we use the most every day.
Maybe it also does not make sense for NIH to have a PhD in philosophy (not medical doctor)
https://clinicalcenter.nih.gov/meet-our-doctors/cgrady.html

be the Chief of the Department of Bioethics approving questionable research such as sand flies eating live Beagles.
https://www.dailymail.co.uk/news/article-10130709/NIH-says-b...
'The NIH said that they did do leishmaniasis research on dogs in a laboratory in 2016, and in an enclosed open space in Tunisia, but not the research pictured.'
All the "advantages" of FreeBSD are really just personal preferences, and little more. E.g., FreeBSD jails are not a replacement for containerization in any way. The FreeBSD network stack is better? I'll bet you can talk to a Linux kernel expert who will explain why exactly the opposite is true. And things being "simpler" in *BSD? Simpler is not always better. SystemD may be somewhat over-engineered, but it's also powerful as hell and can do things the old rc.X system couldn't dream of doing.

There's nothing wrong with switching to another OS, but implying it's because the other OS is somehow empirically "better" is misguided.
Many residents of northern states despised the black population that they absorbed after the Civil War ended. It was essentially an economic refugee crisis for the working class there. The Cincinnati area was full of what amounted to German-Catholic draft-dodgers (from the 1848 wars) who helped slaves across the Ohio River because they were just as marginalized and figured they had nothing to lose by doing what their religion demanded.
Well I love being able to visualize gains and losses in our monthly budget, goals, and upcoming expenses. I too have tried so many options including apps that link directly into my bank / credit (wasn't crazy about that.... But needed to find a working solution). Finally after years what has worked and still is for us is a self hosted solution called Firefliii https://github.com/firefly-iii/firefly-iii

It takes some discipline to keep up with the flow but now that its part of my daily tasks it takes a few minutes a day before bed to do and it helps me keep an eye on where I'm spending. The one big thing is getting use to no more bi-weekly budgeting. Make it a one month budget and stick to it.

Best of luck to you and your family!
The underlying issue is that the cloud console is owned by a single product team, and THEY decide what gets exposed - not the underlying product teams for the individual services. At least that's the case for AWS.

The result is that you get a lowest common denominator type of dashboard. And hence a whole industry of providing just a prettier dashboard on top of AWS / GCP / Azure metrics.

Datadog started with a prettier dashboard for Cloudwatch data.

Cloudability started with a prettier dashboard for the Cost and Usage Report.

And also works the other way around. The individual product teams buy development environments to circumvent the console restrictions.

For example, a few years ago, the Redshift team purchased "DataRow".
I don't know where you're getting your information, all of Western news has agreed on approximately 100,000 until recent movements.
Being able to spin up an entire network of qemu+kvm VMs easily to do proper integration testing of my system configs was a revelation.
People like Putin, enjoy playing Risk the board game, in real life.

More people dead (civilians and soldiers from Ukraine) -- would just make Putin feel more proud and important himself. The opposite to how "normal" people's brains work.

(Some others here believing Russia feels "threatened" by the EU and Nato, fundamentally don't understand how people like Putin function. Such things are just what Putin says to mislead the masses. There's no noble or ethical reasons for what Putin is doing -- it's just a machiavellian person having fun, from his perspective. Or making himself less bored.)
You’re talking about the problem after the network has already reached consensus on a block.

Problem is, if you’re downloading new blocks from the blockchain, and you’re getting two sets of history, which one do you pick? With Git, it’s trivial to recreate history differently, albeit with different hashes. With crypto, you pick the chain with more resources put into its creation.

Otherwise, any random person can spin up a hundred Bitcoin nodes and start spoofing the latest transactions pretty easily.
Even historically, how much cutting-edge research for commercial tech has come from universities? I'd say government-backed labs, military and private corporations have all always had a greater impact.
Solid point about networking. No one really seems to dispute its presence there and rightly so it seems (again, I'm a programmer not an admin so my personal experience is limited).

> Many times you also need to think about what may not be the very best solution from a purely technical perspective but also what is the best from both a people and technical perspective.

This is huge when it comes to running the company's software imho. It's useless having the perfect solution if you can't get anyone to run it when "good enough" will have a plethora of folks ready and willing. Especially when it comes to managing the bus factor. When I asked the admin at my org about that, he explicitly said he didn't care about it (that's more an indictment of him than FreeBSD though).

Overall the human factor is something I've been trying to embrace more lately when it comes to work. For personal stuff though I'll be as esoteric as I like.

> the damn VM's are the only thing I run that does not properly report memory and CPU usage to VMware

Well that's just plain frustrating.
I used FreeBSD for many years (on servers) between 2001-2009. I also used it as a personal machine in the 90's. We used it for stability, at which it did well.The real problem was that everything was moving to Linux. The Linux kernel and community kept up with with bleeding edge hardware or software. Stability of Linux continued to improve and most people stopped compiling custom kernels anyway. I used to compile most user-space software too, and almost never do now. That largely negated the FreeBSD benefits.
Russian history is essentially a history of occupying and integrating bordering countries into the empire. That was the way to expand from several regions around Moscow to the empire's enormous pre-revolution territory in the beginning of XX century. You may google "Expansion of russian empire" maps to get an impression of this expansions.

Historically, most of multi-national empires in Europe (Austria-Hungary; Germans; Osmans) has fallen in the beginning of 20th century, but this one has mostly survived. Poland and Finland were lucky enough to separate, some other countries (Baltics, Ukraine) were less successful and got reintegrated into the new, totalitarian XX century edition of the empire.

It's natural that any neighbouring country not willing to become a playground for now less totalitarian but still oppressive and oligarch-run empire of Russian Federation would unite with anyone who could help, especially NATO. For example NATO and US could be the only reason for Estonia still being independent and successful just 100 km away from st. Peteresburg
Did they ever fix the need to disable SIP for nix to work on macOS? That made trying it out a nonstarter when I looked into it 2 or 3 years ago.
It's part of their compensation.

Their yearly bonuses are not predicated on how many days off they have taken, why would it be any different with stocks?
"How long until cloud providers are forced to scan block devices, so you can't even self-host a file erroneously flagged by the ML?"

If you are using a cloud provider you are not self-hosting.

Self hosting means you own the machine.
I doubt you will find a good answer here, you should probably ask local community in Berlin or find good startup lawyers

One thing, comming from Poland, that would actually be tax evasion here to incorporate in other country with no reason, so its not discussed here that often.
Because if a friend sends you a link to something like this, it's a good idea to be able to tell them that the reasoning in it is garbage, so they hopefully stop spreading it around.
I dont think they were making a moral judgement, just a realpolitik analysis.
You could fit any of the TOP500 machines into one of Facebook's datacenters, couldn't you? With room left over to spare?

It's not like Facebook had to go hollow out the Moon to make this.
I love quality language proposals like this. I'm not so much in data processing/bigdata, but have had to interact with SQL a lot.

This syntax is lovely! It's more intuitively readable (and SQL is not that bad in that regard).

My feedback:

1. Lower case, underscored everything makes the terms a bit hard to differentiate.
Maybe set some classes of symbols in CamelCase, or add a !@#$%& prefixes to them to make it more readable.

2. I dont like to use another language (SQL or PRSQL for that matter) to db interaction, I like to write the queries in the language that I'm using to develop in.
There are ORMs in this design space, but I'm a little fed up with them.
In Java there's jOOQ. Other less-OO-more-functional ORMs exist in Rust and Haskell land. These often have a code generation step, a library is generated that guarantees some type safety for a give schema version. Some are more SQL-like, some provide a different API.
PRQL is much more diverted from SQL than these, and for good reasons.
Maybe several languages could easily have libs like this building on top of JPQL?

3. You solution is a bit like GraphQL in some regards; where there is a tool needed to convert the query to SQL.
Tools like this exist, like Hasura and the likes. Hasura does a lot more. To me GraphQL has the huge advantage of serving a schema so that clients can be generated. I can interact with GraphQL in a type safe fashion from by generating a client in, say, Elm.
The generated client lib does not allow my to write syntax errors in my queries and ensures all type conversions are sound.
Maybe PRQL can also be a language like GraphQL in that regard, and provide a schema too.

4. JPQL.
It's close to SQL. It improves to SQL, but I never found it enough of an improvement to justify the cost. I think your proposal is better. But still I think JPQL deserves a mention as maybe one of the most widespread compile-to-SQL languages.
I Led the Revolution Against Journalistic Institutions. Time to Build Them Back
Depends on one's life, but there're lots and lots of repeated experiences available.

I go for a run on the same route every saturday. In summer I go for bicycle routes on same routes. Repeating such experiences opens up an entirely new layer. Observing the nature change over the yearly cycle as well as longer times changes is very different from just having one-off experiences when you can't compose them into a bigger picture.
But how do you translate that into (short term) OKRs and work that engineers can build a career upon as an achievement (for promotion)? I think there is a cultural mismatch between how engineers grow and what they work on at Google versus the quality of the search results. There seems to be very limit upside and huge potential downside to working on this at Google.

That said, I don't work for Google and my conjecture is based on the hand wavy details (from engineers that do/have) posted online.
Currently, there's 8.7k stars, 7.2k forks. And 2000+ maintainers have added themselves: https://repology.org/repository/nix_unstable

So, I would say a pretty large portion.

Also, the contribution model for nixpkgs is just opening a PR, so it's a fairly low (non-technical) barrier-to-entry for most contributors.
If only symlinks worked for every software / OS. On Windows at least, there are so many different way to link things (including "subst") that it's hard to get idea which one to use. (I do love symlinks, but having spent most of my time on Windows, there are some edge cases I've hit, for example some third_party software not following the symlink and simply failing to open the file..., and no that was not the old .lnk style link)
Exactly. Personal preference is all fine and good, and he's got a right to his own opinions, absolutely.

But to imply that these are empirical differences between FreeBSD and Linux, well, that's nonsense.
I don't recall that series having much in the way of hardware problems, excluding the goxlr and such because that's not part of the desktop.

If it was unclear that my sentence was in the scope of hardware, sorry.

I remember Luke saying multiple monitors broke at one point on his laptop, but that was a laptop.
I have not...if I weren't afraid of losing all my stuff I'd do it tonight...

Maybe I'll just back up to S3 or something. You have peeked my interest.
The thing with games is the networking costs are currently to high to stream in a practical sense. I've tried google stadia and xbox cloud play and they are both OK for single player if you can tolerate less than stellar graphics and lag spikes, but completely unusable for any multiplayer. Rubberbanding galore and I am on gigabit fiber. This technology requires telecom infrastructure overhaul to be successful and you can imagine how much inertia will be in place in that industry.
It might not be what the inventor imagined, but this is hardly an unexpected outcome. BTC in particular was doomed to either be a forgotten novelty, or the wild speculation instrument we see today. It doesn't really have a good mix of features for a usable currency, and its appeal as a currency is largely limited to those ideologically pre-disposed to value anti-inflation over other limitations.

The limited throughput of the blockchain was always going to be a particularly bad problem.
Surprising they are still flying the F-117 in limited numbers even after its official retirement. It is such a cool looking plane
It is a weird nickel-and-dime-ey policy to have though. Like, why specifically those two types of leave? Where does it end?! Why not pause vesting and raises while someone is on vacation? Why not pause raises and vesting on the weekends? I'd better stop before I give them any more ideas.
This story doesn't surprise me.

I was responsible for system security for one of our internal systems. I found a major vulnerability - SQL injection with full schema owner privileges on all our pages. So I went to the principle/dept head to see how they wanted to staff the remediation and which of the two proposals they wanted to go with.

I was told they have a near real-time backup system and it's only and internal system (that handles obscene amounts of money), so they didn't want to address this. I asked if we have any documentation about the restore process or how long it would take. Nope. Have they ever tested this restore process. Nope.

Goodbye! Posted to a different team very quickly.
And even earlier, 1979: https://en.wikipedia.org/wiki/Microsoft_Adventure
Jails are not a replacement for containers.
> With a CTE

The DB we use supports those, I just learned about them too late so keep forgetting they exist :(

> It would really help in SQL if you could refer to column aliases so you don't have to repeat the expression.

The DB we use supports that, so in your CTE you could write

AND gross_cost > 0

We do that all the time, which will be a pain now that we're migrating to a different DB server which doesn't.
Saturn's 'Death Star' moon could have a secret underground ocean
Even Soviet Union has directly bordered several NATO countries.
The Strengths and Weaknesses of Social Predictive Heuristics
Please note that this user is constantly shilling his app in the submissions he posts
Shocker lol.

Enjoy your steak.