skysight-inc/HackerNews huggingface dataset:
> Incremental View Maintenance

It’s nice to have that as an automatic feature rather than something that you have to create for yourself with stored procedures (doing e.g. dynamic programming in the DB), but a matview is still a matview — it’s a real table taking up space on disk and getting replicated through the WAL.

The thing Materialize gives you is the same thing you get from Apache Beam nee Google Cloud Dataflow at cluster scale, or from Elixir’s Flow / Java’s Akka Streams at the in-process scale on the business layer. Namely, the ability to have one stream node in a flow digraph that feeds N outputs that consume it at different rates, and to keep just enough of the intermediate stream node materialized in a buffer to keep all those readers served. Or: like the kind of ACK-truncated buffer that serves a Kafka/Redis Streams consumer group, but with all the stages in the same address-space without serialization+remoting overhead in-between.

This “garbage-collected buffered materialization” is a very important property, if your A query returns a million A IDs, and you’re doing a LEFT JOIN from Bs to As that’s dropping most of the As because they don’t have a related B. You don’t want to be holding onto — and replicating! — a thousand concurrent-request copies of that million A ID list. (The million A IDs are also why you’re doing CTEs in your B/C queries in the first place. With a small list of A IDs, it’d be sensible to just round-trip the A ID list to the client, getting sent back as IN (VALUES ...) bind-params for the B/C queries. But 1. naively, those million IDs become a million bind-params, and that’s stupid, slow, and actually impossible [PG only accepts 65K bind-params per statement!]; and 2. trying to pass the fetched list as an A.id[] and using <@ will deoptimize the search.)

The closest thing PG has is the ability to BEGIN a transaction; create a TEMPORARY table for that transaction; SELECT INTO the temporary table the result of a query; and then use that temporary table to run two queries. Which you have to do in PL/pgSQL (losing the benefits of “whole program” query-plan optimization you get from CTE queries); and then you still have to do something at the end to get your two queries' differently-shaped outputs back to the user. (For example, encoding every row into JSONB with an explicit embedded row-type-tag, and then double-decoding at the receiver; materializing the results of the queries into two more UNLOGGED [but not TEMPORARY] tables, fetching the results from them in two more queries, and then dropping them; etc.)
The tyranny of choice.

Have you ever heard of the indie mubi?

https://mubi.com/
Are you sure you don’t adjust the rates depending how you’re flying? The PID tune can be objectively good or bad, and is highly dependent on your specific hardware setup. It controls how stable the drone is, you wouldn’t want to change your PIDs based on flying style as you would just be making it fly worse. For different flying styles you adjust your rates depending on how smooth/snappy you want it to feel and the desired deg/s of rotation.
AFAIK nobody knows. A lot of things changed at the same time.
I know people who use XCode through accessibility on Macs, and tell me it works well. Site, some things (3d graphics) are going to be hard to ever make accessable, but what exists is fairly good, if you just standard widgets. Blind people are using Macs and iPhones, and finding them highly effective.

I suspect most Devs would never link up and keep up to date an alternative accessibility interface. Also there is a lot of benefit to the accessable and standard interface being close, to make it easy to cooperate.
Haven't used Magit w/ emacs but have been using a library inspired by in for the last year or so: https://github.com/jreybert/vimagit

not sure how it compares feature wise but I've found it extremely helpful.
> The most commonly disabled security header was CSP

Good. It drives me crazy how many user agents modify our site somehow, immediately footgun themselves by honoring the CSP, and then send us a report about it.

Fully disabling the CSP is reckless overkill but they should indeed be modifying it.
Sure, but that's true of all people in any country at any point in history. When we say something like, "they cannot even face that," we're either talking about the portion of the population that pays attention to and discusses national issues or we're not talking about anybody at all, pretty much by definition.
What is "actual" Europe? Who gets to decide?

Consider Russia: are they, or are they not "European"? Is the Orthodox Church European?

That you think the answer is so simple, or that anyone who thinks differently is "nobody" is part of why it is so unsettled.
In the USA, they came down hard of torrents.

My neighbor got busted a few years back by Xfinity, and it was a big deal.
ST3 Update now is ST4
Study Shows Transformers Possess the Compositionality Power
The sample project is 100Gb... I think I am going to need a new hard drive.
I don't mind product placement where it's credibly part of the artistic vision of the director - the classic examples here from my point of view include the Atari placement in Blade Runner.

The things that stick out like a sore thumb are where there's an element that has clearly been scripted by the advertiser to inject into a script.

Like: we're in a police procedural TV show and the detective's interactions with the GPS/entertainment system on vehicle Brand X suddenly become a focal point of dialog or the scene.

That stuff's just obnoxious.
Feels a bit too 1984 to me…
In Spanish, we have two different versions of "to be": 'ser' is for defining what something is (I am a human), and 'estar' is for temporary states of being (I am sad). I do find it strange that English assigns the two meanings to one word.
I would recommend you to try lazygit[0] but it's independent terminal tool not tied to neovim

For Neovim Git Plugins ,see [1]

[0]:https://github.com/jesseduffield/lazygit

[1]:https://github.com/rockerBOO/awesome-neovim#git
No!

On the contrary: stop trying to use the law for everything!

Such strategy works a million times better than the horror of copyright law.

The companies should be free to do it, and it's awful that someone wants to involve the force of the state to stop them from doing so, instead of seeing it as a way to get rid of the burden of copyright law to society.
People don't read as much anymore, so I think books are safe for now.
I wonder if / how this sort of thing might be implemented in video games (like classic micro console releases or video game remasters).
Hello. The code realle sucks, but idea is great.
You know, after I posted I noticed there was a "next" button and started using it (I thought it was GitHub only). You pretty much captured a lot of the tradeoffs. Very nicely, might I add: the UI/UX funneling is clever! I'm off to cram a step function into my flight controller... :)
David Lynch on contemporary product placement, 14 years ago: https://www.youtube.com/watch?v=F4wh_mc8hRE
An especially key part was the way denialism cut against economy measures: the average vehicle sold in the United States today has mileage which is substantially worse than you saw in the 1980s because there's been a multi-decade push towards much heavier vehicles with sportier engines, special subsidies for trucks and SUVs, successful attempts to exempt various industries from stricter emissions controls, etc.

Had CO2 emissions been taken seriously — and given that successful predictions of the problem go back over a century we had plenty of time to plan — we could have bought additional decades to work on alternatives by continuing improvements in efficiency. Procrastinating means that we'll see more disruptive changes and worse climate impacts.
Coming back after a long hiatus. I beat the game! No spoilers here. I just wanted to say you did a great job and this was a great first stab at design. I felt like you thought through some of the interactions and tried to hone a bit of a custom experience. Your design was noticed and appreciated!
the last 10% takes 90% of the time
A possible and troubling outcome of this may be that "controversial" scenes are removed from classic films entirely, because advertisers don't want to be associated with them. We've already seen disclaimers added to movies that are "problematic" like Gone with the Wind or Breakfast at Tiffany's.

When push comes to shove, will Media Co. turn down millions from Coke just to keep a 30-second scene in a film? I'm not optimistic.
Study finds the more frequently we recall a memory, the faster it fades away
> Better stuff gets made in this kind of ecosystem

too bad it's not about making better stuff but more profit.

it's like the market has been distorted out of its ability to better reward better stuff.
Another scifi fan. Good choices.
The point is not that it gives you perfect protection or even n95 protection. It does give you more protection than maskless. Also the lower the viral load you're exposed to, the longer your body has to prepare. How the disease progresses is dosage dependant.

A low enough load is like a natural vaccination. You don't get sick, but you get some immunity. A high enough load and you can get the sickness very severely. It's a gradient, and masks help put you lower on that gradient than otherwise.
Time is limited.
The Ministry of Truth would have had a field day with modern tech.
> The author mentions higher dpi displays, so maybe this is null and void now. Is 96 dpi still what we should use for the average user?

My 15" laptop I'm typing this now at 1920x1080 is ~150 DPI. The same resolution at 22" (a normal screen size) is 100 DPI. The author talks about 100 DPI for "the cheap Dell monitor I’m typing this" and 115 DPI for their laptop. So DPI hasn't improved all that much it seems, at least for computer screens.

Looking at the stats for my weblog, about 40% use a low-DPI (<150 DPI) screen. The rest are >HD or mobile. This is heavily skewed towards programmer/IT people, who probably have better screens than average.

So personally, I'd say that designing for 96 DPI is still a good default.
I've been using Neovim for a while now and it's amazing. I love the effort and thought that has gone into the project. The plugin manager is such a treat to use. Anyone who used to use vim or found it lacking or difficult to setup, I urge to give Neovim a try. Thanks to everyone involved in the project.
That is not my understanding.

https://www.dw.com/en/the-opaque-financing-of-germanys-churc...
I have a hard time believing that that was the average monthly cost of a cable subscription. Mine was never more than $30-40 when I needed cable for the internet.
Speedy Doge disagrees.
Artifact was a good card game only killed by really dumb marketing and monetization decisions.

Half-Life Alyx is almost universally hailed as the best VR game and as good if not better than the previous Half-Life games.

That being said, you're right about them neglecting a lot of their IP. Specifically a TF3 might be really cool to see, along with more love for Counter-Strike.
AFAIK Neovim 0.5 uses tree-sitter. Is there any effort to integrate tree-sitter with Emacs in an easy way?
Very cool! http://psdoom.sourceforge.net/ is worth a mention as well where you shoot demons to kill your processes.
> I'm actually more interested in watching old black and white movies that are "free to air" in my country

My experience has been that old (black and white or otherwise) movies are hard to find now. Especially if you just want to watch it once and don't want to buy an old DVD or VHS.
I'm just now seeing this reply, but I'm not sure how you interpreted this:

>The Trump administration was wholly ineffective at stopping it, but it's not like decisive action in the US would have stopped it from spreading elsewhere.

As me blaming Trump for the virus affecting the whole world. The Trump administration was responsible for keeping the virus from spreading within the US and they failed to control it.
> A top-tier scientist from the 19th century may well have pronounced just about all of today's digital devices impossible science fiction. "Billions of calculations per second in something in your pocket that runs on a battery?"

Heck, actual science fiction authors in the mid-20th century got that wrong. Asimov, for example, while he had autonomous robots walking around, limited mobile computing devices (installed in anything smaller than a spaceship) to calculators and dumb terminals. Output was often limited to ALL CAPS printed on a slip or strip of paper (again, despite robots able to communicate verbally).
I'm in need of a platform I can point to for my business and businesses I partner with. So if I can't reliably use Stripe without looking over my shoulder, who should I turn to? Square is not the solution I'm looking for, as they seem to cater to POS.
Only some movies and shows on Amazon Prime Video are actually "included with Prime". The rest you have to pay for individually.

Their Music service is similar. As a Prime member, you have access to a portion of their music catalog. If you want access to everything, you have to pay for it.
Really? Got busted a number of time in France and in the US and nothing ever happened and I just kept torrenting.
> Methuselah show[s] that any hard bound was clearly violated...

Not quite. Methuselah died in the Flood, and it was only _after_ the flood when God decreed that humans' lifespan would be limited to 120 years.
How long until product placement creeps into everyday speech?

https://www.newyorker.com/humor/daily-shouts/l-p-d-libertari...

>“Subway™ Eat Fresh and Freeze, Scumbag!®” I yelled.
Electron Spin Resonance – Building the Hardware
> Burning fossil fuels is bad.

I would say that like many things in life, it's a tradeoff. There're costs and benefits to using these things. Talking about one side but not the other doesn't make sense.

Quick personal example - I lived through energy shortages as a kid in the Soviet Union. Situations where there was no heat in the winter and/or no fuel for cars and public transport.

From pure fossil fuel consumption standpoint, these were great times, as we weren't using any. From a quality and sustainability of human life, these were terrible times.

At the very least "burning fossil fuels is bad" is a statement of privilege. A person who's cold or unable to travel or get necessities delivered would never say this.

None of this is to say that we shouldn't move towards primarily nuclear in the long term - we should but we need to talk about this in a mature way.
Why quit emacs when evil-mode exists?

Fast startup times are solved by never quitting emacs :) Really, emacsclient starts nearly instantly, and all the heavy stuff like language servers and emacs proper just run in server mode.

(Disclaimer: I know enough vi and often use it.)
I use nvim in the terminal and gvim/macvim on the desktop. I don't like how the nvim community seems to be throwing themselves wholeheartedly into lua and lua-only plugins (vimscript plugins are better because they work with both vim and neovim). Switching to init.lua also means losing all compatibility with vim, and I cannot fathom why people would want to do that considering that there is nothing that init.vim cannot already do.

I also don't like how there looks to be an upcoming split in the plugin community when Vimscript 9 releases and the neovim community will ignore it while plugin authors in the vim camp (e.g tpope) may start moving their plugins over to it.

That said, the built-in LSP for nvim is very good thing and I plan to migrate away from the node-dependent coc.nvim once nvim 0.5 releases.
This time last year asking if the virus came from a lab leak would get you labeled a racist conspiracy nut and get you deplatformed by the big players in SV. Now Dr. Fauci is openly discussing this "racist conspiracy theory". Should he be deplatformed and lose his job for being racist?
I agree with the sentiment. That's always the environmental challenge. Who's going to enforce/stop/change any of it?

The most likely answer, rooted in reason, logic and an understanding of human nature, is: absolutely nobody is going to stop any of it in a way that is going to matter.

We've far since crossed the point of no return. You can take all emissions to zero in the developed world and it won't matter at all now, it won't stop anything. It's game over.

If the climate change experts are correct about how it all works, then the house is going to burn down and nothing can or will stop it, realistically. And that's a super simple - hilariously easy - extrapolation just based on one nation's hyper expanding greenhouse gas emissions alone.

It won't stop the virtue signalers however; virtue signaling is all they really have. When the plan is to not actually do anything about what's happening, then the comfort remaining is to virtue signal while you watch it all burn, because it makes one feel better.
Andrew Lee is the co-founder of one of the biggest VPNs, which he sold for $95 Million. After that he was involved in the mobile app of Mt Gox (the now defunct bitcoin exchange)

He was also declared crown prince of Korea by a member of royalty (no, Korea doesn't have Emperors anymore, it's meaningless for practical purposes).
I remember seeing ads for this in Popular Science or something when I was a kid. I thought it would be fun to try.
Plex gets you part of the way, but for not-tech-savvy people, what you probably really want is a Plex Share, as that will keep you from needing to manage any of the media. You'll have to figure out how to adjust some settings on any TV streaming in 4k for most Shares, but it's not terrible to set up. There's a subreddit for it: https://www.reddit.com/r/plexshares/
You may also use vs code with neovim integration[0].

[0] https://github.com/asvetliakov/vscode-neovim
USB-C power upgrade delivers 240W for gaming laptops and other devices
Squeezing all the juice out of a genre or subgenre is what Hollywood is best at. If you didn't like cowboy movies you were avoiding like 60% of all movies and tv shows made from the birth of cinema until the 70's. I think we're seeing the same thing w comic book movies. In other words they'll peter out, but probably after all of us are dead.
I wouldn't expect you to hold your breath for a few hours, but if you waited you woul dhave discovered that he did agree that his actions undermined public confidence and apologised calling it a “terrible, terrible, terrible mistake”, .
Infuriating that this was allowed to go through. Hoping the antitrust probe concludes quickly.
The network operators are calling project owners "brainwashed" in the #freenode-services channel.

I think they are at the moment following titanic all the way to the bottom.

Edit with full quote:

> 14:44:44 lionman@ : LeShadow: We dont support adverts/invites/spam for networks we don't affiliate that force users to move even they want to stay with freenode. The users have been forced by many people and ops (brainwashed), even they didn't want to.
There is also the Aya Neo[0], the One Xplayer[1], and even the (now quite old) Razer Edge[2].

[0] https://www.ayaneo.com/aya-neo

[1] https://www.indiegogo.com/projects/onexplayer-best-performin...

[2] https://www2.razer.com/gaming-systems/razer-edge
What to expect from your emotion recognition software Part 2
That isn’t however the reason it is designated a Royal company.

https://en.wikipedia.org/wiki/Koninklijk
Perfect. His take on watching movies on your phone is great too:

https://www.youtube.com/watch?v=wKiIroiCvZ0
French YouTube influencer 'offered cash to spread vaccine disinformation'
If you take some time to plan it out and pay attention to thermals, you can absolutely make a relatively unassuming Micro-ATX build nowadays, and just have a sleek small(er) black box sitting there.
Every time we mandate that some product can't be produced in the West, China gladly fills the gap, burning huge amounts of brown coal in the process. Why do you think they have a global monopoly on solar cell and lithium battery production? They are incredibly energy-intensive processes.

It would be like, in your analogy, somehow by putting out your own fire, someone else's house started burning.
Which of those aren't already internalized?
> how expense it would be

Apparently the insider moniker for the show is, “The Expense.”
"Modern C" now effectively includes __attribute__((cleanup)), in as much as it's widely used by large free software projects and supported in both GCC and Clang.
"As a call to your conscience, even if you don't directly participate in those activities (in for the money), would you be ok knowing that you are complicit?"

By that reasoning anyone that uses paper money is complicit in cocaine use, because a 2009 study showed that between 85% and 95% of all US paper bills have cocaine on them, in some states averaging as high as 20 nanograms on individual low-denomination bills (it takes 150 nanograms in your system to test positive for cocaine).

Almost any technology, including Tide Pods, can be used in the argument anyone that uses and supports a technology for legal uses is complicit in illegal uses of that technology, rendering the argument meaningless. You may use Peer-to-Peer technology, does that mean you support piracy?

Many seem to me to be attacking BitCoin and other cryptocurrencies in total rather than attacking the aspects they hate. For example, anonymity is not innately tied to cryptocurrency, just tied to most of the current implementations.
That is just not true , at least in the US. Minorities and immigrants are treated considerably worst in rural areas than in the cities. I get some people want to live in the country. As I said , most people like to interact with other human beings, outside the Sunday church gathering. Being from a rural town in the US doesn't make an outsider in any city, I would say the other way around is correct, the city is big enough you can find a bar where your country fellas go, people who "hate the city", what really hate is diversity, competition and civility(with exceptions). In the other hand, a family of asian immigrants, for example, will have a hard time, in a white evangelical small town anywhere in the US.
I believe this holds true for all platforms (profit motive will beat any altruism in the long run). All platforms are "mice" (or will become mice, given sufficient time and pressure).

Building on top of any platform should trigger your "I'm making a tradeoff" spider sense. It's pretty obvious that using Stripe is net positive for any small company starting up right now. In 5 yrs, ehen that startup is doing $100M/yr in sales, the net gain of using Stripe is less obvious. But would the startup have been able to grow to $100M/yr without sending payment links or invoices via Stripe? ¯\_(ツ)_/¯
Clearly there are non-computing use-cases for 240W devices that would benefit from being charged. What about power tools, or high-end game consoles?
I use emacs with evil-mode, and I don't have a problem with startup time (and that's without emacsclient, which I always found too annoying to deal with).

My issue is I don't really like emacs' mode of operating, and even with evil-mode it still seeps through.

I also don't like lisp.
$5 to rent a movie seems a bargain compared with times past.
There's running out of beds, and then there is running out of ITU beds when you have already stopped elective treatments and converted a large proportion of your general wards to ITU
We're talking about space here. Minimal living conditions absolutely can't be made for pennies, and introduce enormous risks of destruction even without any human inside. And the energy requirements...
The thing is, Vimscript sucks. Using a more mainstream language would be great for a modern advanced editor.

Vim has a ton of Vimscript plugins but I wonder how long it will take the Neovim community to replicate most of their functionality in Lua. I'd guess that not that long.
I can't remember which book, but I'm pretty sure Phillip K. Dick incorporated this somewhere too.
“We're not trying to build AI that uses physical features to deny claims”