skysight-inc/HackerNews huggingface dataset:
"Selection" in the relational algebra is actually everything that comes after the WHERE clause. SQL confuses people here because "SELECT" seems to imply "select these columns" when in fact that is technically called "projection."

The "Selection" is the set of predicates that restrict the resulting relation. Projection is choosing which tuples ("columns") to use in it.

The relational algebra has no "tables", this is, again, a SQL thing. It has relations (sets of sets) and operations on them. In SQL "tables" are one kind of relation, and views are another.
... or you could just use an "Oh By" code.[1]

No app, no reader, and you can just chalk/write/scratch it anywhere you like.

This message, for instance, is at: 0xH6VYP7 [2]

[1] https://0x.co/

[2] https://0x.co/H6VYP7
Unvalidated auto-update really is an anti-pattern. Giving arbitrary third parties the power to install and run software on your system in perpetuity is a massive attack vector. Most software doesn't represent a large active and ongoing attack surface that auto-updates would be a net positive.
Makes me think about how some live events will sell tables to groups of people. Imagine attending a live concert with your own private table. Maybe not as fun but who knows?
I suspect it won't really hit until the changes that enable direct DOM access, and things that make dynamic languages easier to implement in WASM. These things: https://github.com/WebAssembly/proposals/issues/16
>> But most of the awful SQL I’ve seen over my career hasn’t come from poor mastery of SQL, it’s come from poorly normalized schemas. If you have a properly normalized schema, then you can do a huge amount with very simple SQL. When it’s poorly normalized, you end up with all sorts of strange and inefficient design patterns in your SQL.

This is the crucial insight that has made tons of money for me over the last 3 decades. I have all these trite HHOS jokes about it, like telling people denormalizing from a schema not in a normal form is actually the process of "abnormalization". And then there's generic EAVil, where there's nothing that can't be stored, not that nothing really ever means something, heheh.

For every well designed and useful schema I've seen, there were 999 awful ones. For example a physical data model where the query writer has to use string manipulation for joins is going to result in all kinds of suckage. The developer will conclude NoSql is a perfectly reasonable alternative. Even though a modern RDBMS provides all sorts of nifty features to identify and correct such issues ex-post-facto.

For a relational model to work well there must be an a priori data design performed with significant discipline. This seems like too much like Big Design Up Front for the average developer or technical manager to stomach these days. It is true that a well-designed data collection system will have a simpler data design more amenable to a distributed NoSQL system and will support emergent schema and relations which may be divined via machine learning. It will also make Big Ball Of Mud more convenient to implement, but that's a posteriori observation, heheh, like that damned halting problem...
Make vs Code
OK, let's play this game: You are now fully in control of Mozilla - projects, finances, it's all on you. How would you turn Firefox into a browser with significant market share in an increasingly mobile world where two competitors control default applications and most users newer change any defaults?
It’s demo day everyday like kindergarten.
DDG, Yahoo, Bing, are all valid alternatives. Why does Google get screwed after the enormous investment they made (with time and money) to index pages on the internet?
Answer A: For a joke it doesn't matter.

Answer B: By that logic it is "without writing any code"

But yes, the example is nice and it's not a production line, probably not even copyrightable.
Yes, two of them instead of a single one. Promise kept!
I just use uBlock Origin to clean up websites I visit of their trending sections, recommendation sections, comment sections. Sometimes I get rid of links that I might mindlessly click, like the whole top bar of reddit.com.

For example, these filters work really well on youtube.com

youtube.com##.ytp-pause-overlay

youtube.com##.ytp-suggestion-set

youtube.com##.ytp-endscreen-content

youtube.com###related
Funny enough the headline now reads "Dwarf planet Ceres ..."
Or all the impacts down the line. If they decided to basically seize Google, they would be telling investors that long term investment doesn’t work as the government will come along and ruin it.

Watch as companies like Google rapidly stop any innovation spending and become high dividend stocks built only to pump out cash.
Katlib – Kotlin extensions functions library
I have written a QR encoder in Lua and documented it a bit. Perhaps this goes into the direction?

http://speedata.github.io/luaqrcode/docs/qrencode.html
Collection of Kotlin extension functions gathered through 3 years of server side Kotlin development.
Retail Chains Abandon Manhattan: ‘It’s Unsustainable’
you can disable scripts even with ublock, so I don't understand why people still keep noscript
I signed up on day 1 and have really liked it. Works much better than the other vpn software I've had. And having it on Android too had been great
Other than 10% of the globe unable to run wasm, what accessibility concerns come to mind here? Are there any that wouldn't also apply to a SPA that uses JS to manage the DOM?
It implements the same Java specification as every other Java implementation. It's a conforming implementation.

How can an extra implementation of exactly the same standard possibly be a bad thing? This is what we want isn't it? Multiple implementations innovating to improve while keeping to the same spec? So if you don't want to pay for Graal EE it doesn't matter because your code still runs everywhere, and because CE is as good as OpenJDK you're no worse off in any case.

Or are you saying they're going to break the spec? Well that's just a baseless speculation so not useful to talk about in my opinion.

We're really lucky that Oracle are investing so much money on pushing the limit of Java performance, and that they make the vast majority of it open source. Few companies have the money and institutional knowledge to do this.
tabtab
I agree that the browser side is not doing very well in terms of market share, but I don't see any evidence that Mozilla has been or is able to make a successful product that isn't firefox. Sure, they made quite a few different things but they have not show any ability to really get them any traction. They wouldn't really be in this situation if they did.
I was just thinking about you the other day!

Thanks for posting OS to twitter back then because if you hadn’t I probably would not have kept it up. But seeing how viral it went showed how much general interest there was. Took a while to find the right audience though I’m the architecture and design community. Funny how you had the most followers back then!
Since calling syscalls directly instead of through the wrapper dll is unsupported, I wouldn't be surprised if MS prevented syscalls from outside the expected libraries at some point.

OpenBSD already does this to improve security: https://marc.info/?l=openbsd-tech&m=157488907117170&w=2
People were already worried about cache effects of transition of pointers from 32 to 64 bit, and this doubles the size again to 128 bits. Performance implications are as of yet unknown, but I wouldn't get surprised if it gets shown that a managed environment (.net, jvm) outperforms c/c++ code adapted to cheri. JVM already does pointer compression.
+1 for bitwarden. Of all the things not to trust closed source software with, passwords are the main one
The last thing I want is for government to become even more involved with managing what information I receive or how I receive it. We need less of that, not more.

Also, please use competitors such as DuckDuckGo. It's not hard, and they're not bad. It's unconscionable to me that we would resort to government force before taking the obvious step of just not interacting with Google.
SQL's fundamental misstep was to try to present the relational model in a form they thought was more comprehensible by a) using an "English-like" language and b) renaming core relational concepts (relation -> table/view, tuple -> column, etc.) It has only muddied the waters and led to all sorts of misunderstandings and complaints ("but my data isn't tabular!")

The "English-like" syntax means that what is actually happening is obscured (so many misunderstandings of what "selection" is, for example), and it means that composing multiple operations gets very awkward and hard to read and in fact many things that the relational algebra itself permits are not really expressable.

And renaming core concepts means people means people get confused. They don't understand what the "relation" in relational is, and think it's about relationships. They think SQL is all about tables, when tables are just one way of representing predicates. Etc. etc.

The relational model is a very elegant method for presenting facts about the world and then the relational algebra is a nice functional programming style system for slicing and dicing those facts into information in basically arbitrary and recomposable ways.

SQL has obscured that. It's awful.
It's the year 2020 and I'm still out here writing JSP, PL/SQL, and VB6 lmfao
I grew up where a nike missile base was built on federal prison land. When I was 10, the base was shut down and the prison took over the buildings, for administrative use. Different agencies occasionally showed up for various kinds of training.

Nights and weekend it was all empty except for the occasional patrol truck. That left lots of time for nosing around & sometimes finding cool stuff. Dodging Deputy Dawg was a bonus round (Except for that one time with dogs. Where did they freaking get dogs?).

Another bonus was the occasional home visit by an FBI agent (only ever one). I think they spooked me more than police detectives ever did, even tho the agents were probably just tapping my shoulder.

Note: Here, "It was a different time" meant I didn't get life-changing punishments/black-marks for my age-impaired ambitions.
The one extension I cannot live without is hover zoom+. Hover over any thumbnail (for a customizable amount of time) and it loads the full size image on top. When people see me using it with google images, they always ask how I did that.

https://chrome.google.com/webstore/detail/hover-zoom%20/pccc...
Scarcity creates an illusion of value "at rest". Currencies aren't very useful "at rest", though. (As entertaining as it is to imagine to go diving into a Bank Vault Scrooge McDuck-style, it isn't very practical in reality.) It's in how they flow that inter-personal value happens. I feel like one of these days we'll truly discover an economic calculus based on the second and third derivatives of "value", and maybe scarcity is holding us back. (I often use an electrical circuit analogy. Our conception of wealth is "instantaneous voltage", and while high potential voltage sometimes has its uses in some types of circuits, it's the wattage/amperage that does real work over time.)
Lies about Logs (2017)
I just posted a link[0] with some of Friedman's response to what's going on. TLDR: aside from Belarus' geopolitical importance and predicament, it sounds like what's going on is largely a matter of speculation, though the events of the last decade read in light of geopolitical realities seem to suggest Russian involvement.

[0] https://news.ycombinator.com/item?id=24121275
All architectural glass should be tempered, by safety codes. This is to avoid the problem of non-tempered (annealed) glass only breaking into a few large pieces, creating heavy sheets that will give someone deep lacerations. When you see a window instantaneously shatter into many tiny pieces, that is tempered glass. The energetic breaking of tempered glass still creates a lot of splinters though.
Interesting theoretical case study, but moot point. America is a business, not a country. Will never happen in our lifetimes.
Data Science and the Art of Storytelling
The Debian Foundation also doesn't have to compete against Google on a product that costs millions of dollars to build and maintain, and that Google throws billions at in marketing.
What happens when the company goes out of business?

What happens when you try requesting random short URLs to peep on other people's texts?
I'll add that to the list. I'm currently still in the building phase but tax implications will be something to consider.
you're comparing $lookup, an operator that nosql isn't designed for to a join, an operator sql was designed for
Jeff Atwood on Learning to Code
Incorrect: Nearly all business ventures must use Google. If you do not, you do not exist. Doesn't matter if you're a website or a restaurant. No Google presence, no business. Go run ads for your startup on Bing and see where that gets you.

Also, try to be a user on the Internet without using reCAPTCHA...

In increasingly more school districts you have to either give Google your kids' data and a Chromebook account or you have to homeschool, Google Classroom is often mandatory, as it is here.

Again, there are some local areas where one ISP or another might have a monopoly, but it isn't even remotely comparable to what Google is.
> Which is in fact something they tried a while back for mobile, and it didn't go so well.

A fork of it (KaiOS) is currently more popular than iOS in India.

I'd argue that their PWA-focused OS was just a few years ahead of its time.
https://foundation.mozilla.org/en/initiatives/
That is a for-profit goal when profit is the sole motivation

Mozilla while it has a For-Profit Corporation, is still at its core a Non-Profit, they need to keep true to that mission
Preview's signature import via WebCam makes it even easier.

I'd never heard of Xournal, thanks!
You know what’s even more interesting? Using a low level language for no obvious performance reasons in the browser (as in, what performance critical thing are you solving?).

I just remember having to do a lot of my college classes in C++, where some of our basic programs needed variables to be constantly cast into another type just to do something with it. I remember, man, I cannot wait to have to deal with this when I parse json data from an api request, bring it on.

I am JS developer, and apparently I love Rust.
Unregulated?! IMO they are heavily regulated. I can understand believing that they are under regulated, but they are hardly unregulated.

E.g.
https://www.fdic.gov/regulations/laws/rules/6500-2260.html
https://www.creditcards.com/credit-card-news/help/card-act-1...
https://blog.payjunction.com/credit-card-processing-regulato...
Think twice before using Tuples
Yeah, I was just trying to politely point out that this article is dumb and the author fails to make their case.

Take the example of the basketball dribbling video. The insinuation is that Google serves YouTube results because Google is biased; it owns YouTube. The claim is that Google should mix in results from Vimeo. This supposes that there are worthwhile results on Vimeo, that Google can index them, and that people want to see them. The refutation of this bias claim is pretty easy. If you do the same search on Bing, you get the exact same results, all from YouTube. So whatever causes these results to be 100% YouTube, it cannot be explained by Google's bias.

The second flaw in the argument is the idea, which all SEO people hold dear, that a search engine exists to serve the content providers, and that they somehow owe a debt to middlemen. This is not the case. The search engine serves the querier. When I search for airfares from New York to San Francisco, it makes sense that a search engine serves the underlying data about the flights and their prices. Air travel is provided by airlines, not by Expedia. Travelocity, Orbitz, and Kayak are not naturally occurring "organic results", they are grifting middlemen who use dark patterns to chisel a few dollars out of people who just want to fly.
The story behind Google Books: Torching the Modern-Day Library of Alexandria (2017)
No, it is evidence of Google taking steady marketshare away from FF through underhanded tactics such as a basically unlimited advertising budget. You simply can not fight such a war and win, you can only lose gracefully.

Rust is not a product. And for Mozilla it was a huge distraction, one they could ill afford.

So my point stands: this is a rearguard action. Eventually they will lose, accelerating that is in nobody's interest.
Apple can't really compete with Chrome. They have walled off one little walled garden (iOS) that Chrome isn't allowed to enter, but everywhere that Chrome is allowed, it is crushing Safari.
Could you share your selectrum/ivy/helm config or give me some tips? That's one part of Emacs config, in particular, that gives me the willies -- I can't figure out if I'm supposed to choose between ivy and helm or use them together or even really what the differences are between the two. I haven't even heard of selectrum, lol.

That's one of the hardest parts of trying to config Emacs in general -- so many packages and they all seem to do the same thing and I think I need just one but sometimes people have like, all of them installed. It's confusing!
It's definitely a questionable business model, whose obvious problems are underscored by the fact the Google doesn't allow you to do it with some some entities. In other scenarios, it's a borderline protection racket.

For example, you can't use ads to squat on search terms for government agencies. I haven't tested it extensively, but I'm pretty sure even searches for things that are outsourced to third parties still land on the .gov page. Search for "<state> state park reservations" and you'll usually see only organic results, with the .gov as the top result. The actual provider (Reserve America in many states) is below the .gov in most cases. Sometimes (most notably california), the provider is the top organic result.

In most verticals, you'd see a wall of bullshit ads for affiliates to the reservation provider.
It would be trivial for the admin to say that Apple only has to block wechat from the US app store, and trivial for Apple to implement it. There's little to gain from blocking wechat in china, so I don't think they will cut in their own flesh.

Unless there are ways (via VPN etc) to temporarily switch a phone to the Chinese appstore and install wechat for a US phone this way.
I would argue we should regulate the internet as a utility first.
If people know when the money will expire, they'll accept it at a lower and lower value as it approaches its expiration. Money that will expire tomorrow will be worthless. I think a better way would be to continually reduce all (digital) accounts by some rate. Say you want 1% depreciation per year. At the end of the year, every bank account balance is multiplied by x0.99. The "money" evaporates equally for everyone at the same time. In any case though, while technocrats might like the sound of all of this, the plebs (aka those of us without political power) are likely to be less enthusiastic.
> I'll take a politician over a predator company any time!

I don't understand this take. You can use DuckDuckGo right now, without having to invoke a predator politician.
> 1. There needs to be guidelines for what Google can and can't do with search.

Again that's vague. And once there are such guidelines who enforces them? Will it be law applicable to all companies? Will there be a special govt office enforcing this? What kind of punishments? Fines?

> 2. YouTube should possibly be broken out as a separate company and it shouldn't get favorable placement and treatment in search results

Who and how will determine if treatment is favorable? Auditing code and internal comms for signs for favoritism? Otherwise if you can go only by appearances then how do you keep this system fair to the companies subject to this scrutiny?

> 3. Businesses need to have more control over how their businesses appear when users search for them directly

Again how do you codify this into law?
How is the power management aspect of running Mac OS? That's the only complaint I have (using windows) on my X1 carbon compared to my old macbook pro.
Hyperinflation almost lost the Revolutionary War
I recently deleted all of my extension off all three browsers (Chrome, Firefox, and Safari). The ad blocking on Firefox is almost as good as Ublock Origin. I found privacy badger to be largely useless.

The only thing I miss is lastpass, but I've gotten used to having it run as a desktop app.

Containers in Firefox were nice, but I've also gotten used to switching accounts.

The fact that extensions get 100% access to everything on your page (including password forms) is just a no-go for me. I have to draw the line somewhere.
There is no "public" here. There is only "government". It might do a better job than Google at this. It might not.
The history curriculum in the UK is really all kinds of useless. It's not that it overlooks the Empire. When I was at high school it had nothing to say on anything international at all beyond World War 1 and 2. You could graduate high school having no idea whatsoever about the forces that shaped the 20th century. Stalin? Mao? JFK? The Apollo Programme? The Great Depression? None of it was mentioned.

I had history classes for years but the only stuff I remember is trivia about the industrial revolution. We were made to memorise vast quantities of detail on things like the exact dates of various Mines Acts (safety for coal miners), who invented some kinds of obsolete farming equipment, etc. There was a lot on medieval agricultural practices as well. It went far too deep on things that impart no wisdom or generalised lessons for the modern world.

There was also a lot of stuff on World War 1 and World War 2. Important, yes, but also incredibly well covered by popular culture.

I suspect the curriculum was designed to be as boring and non-controversial as possible, which is a pity. The only reason to study history is to learn lessons from it, which must inevitably mean drawing conclusions from the events of the past. Attempting to avoid that ends up reducing history to a list of kings and dates.

If I could rewrite the history curriculum, I'd give it a major renewed focus on both the British Empire and also the full history of the 20th century. It would be shallow but broad. And it would include the chaotic state of Britain between 1945 and 1990. Of course the reason it's not taught is that many teachers have very strong ideological views of their own on, in particular, Margaret Thatcher.
Shopify and the Hard Thing About Easy Things
> they gained market-share by competing and beating another direct competitor

Microsoft wasn't really interested in the web, and let IE stagnate for years. Google makes an enormous amount of money through the web, and consequently puts a lot of resources into developing Chrome.
You might be interested in this line of reasoning, why finding life on Mars might in fact be counter to the long-term survival of humans.

https://www.nickbostrom.com/extraterrestrial.pdf
Except for scientific publishing, where LaTeX is king.
> jOOQ and SQLAlchemy are libraries

While it is true, they are specifically embedded DSLs, which is exactly what you said you needed. Having a (query) language (a DSL) that is not composed by string concatenation. Embedded DSL solve exactly that problem and they are usually just translations from some DSL into concrete syntax in some programming language, ideally supporting type correctness and preventing syntax errors, etc..

And what you "wish for" is, again, just an embedded DSL, you only wish for you constructors/functions to be native instead of some import/module.
Looking at the linked demo site[0] the wasm file is 476kb (133kb compressed with brotli).

[0] https://rustmart-yew.netlify.app/
Context: Russian Mercs in Belarus: https://www.aljazeera.com/news/2020/07/belarus-arrests-dozen...