skysight-inc/HackerNews huggingface dataset:
> Secondly, almost all data is useless in its raw form. The analysts had to perform ELT jobs on their data in the warehouse to clean, dedupe, aggregate, and project their business rules on that data. These functions often require the database to scan over historical data to produce the new materializations of that data.

The point of Materialize, from my understanding, is that you don't put things into the data warehouse and then, as a separate step, run these enrichment/reporting jobs on it.

Instead, you register persistent, stateful enrichment "streaming jobs" (i.e. incrementally-materialized views) into the data warehouse; and then, when data comes into a table upstream of these views, it gets streamed into and through the related job to incrementally populate the matview.

I believe you end up with a consistent MVCC snapshot between the source data and its dependent inc-matviews, where you can never see new source data and old derived data in the same query; sort of as if the inc-matview were being updated by a synchronous ON INSERT trigger on the original raw-data ingest transaction. (Or—closer analogy—sort of like the raw table has a computed-expression index visible as a standalone relation.)

Also, the job itself is written as a regular OLAP query over a fixed-snapshot dataset, as a data-scientist would expect; but this gets compiled by the query planner into a continuous CTE/window query sorta thing, that spits out running totals/averages/etc. as it gets fed incremental row-batches—but only at the granularity that consumers are demanding from it, either by directly querying the inc-matview, or by sourcing it in their own streaming jobs. Which, of course, you do by just using a regular OLAP query on inc-matview X in your definition of inc-matview Y.

> I would love to hear the use cases that your customers have that made Materialize a good fit!

We haven't used Materialize yet, but it's a very promising fit for our use-case: high-level financial-instrument analytics on blockchain data. We need to take realtime-ish batches of raw transaction data and extract, in est, arbitrarily-formatted logs from arbitrary program-runs embedded in the transaction data (using heavy OLAP queries); recognize patterns in those that correspond to abstract financial events (more heavy OLAP queries); enrich those pattern-events with things like fiscal unit conversions; and then emit the enriched events as, among other things, realtime notifications, while also ending up with a data warehouse populated with both the high- and low-level events, amenable to arbitrary further OLAP querying by data scientists.
A user below, hkt, has a comment complaining about the culture at the Home Office. It has been modded down, and fairly so, as this comment is not helpful in its current form. Nevertheless I feel it has an important point, so allow me to talk about the Home Office, which, after all, is the reason this 101-year-old was filing paperwork to begin with.

The Home Office presently maintains a "hostile environment" policy. Wikipedia summarizes its goal: "to make staying in the United Kingdom as difficult as possible for people without leave to remain". Here are some examples of how this works in practice.

Once upon a time the BBC did a little investigative journalism and discovered that some international students were faking their English proficiency exams (the TOEIC). The Home Office, quite reasonably, said that they'd do something about it. What they ended up doing specifically was make the environment as hostile as possible; they:

- looked at 58,458 test results

- declared that 34,000 of them were obviously definitely cheaters

- declared that 22,600 of them were probably cheaters

- declared only about 2000 as probably legit

- sent letters to the 34,000 students denouncing them as frauds and demanding they leave the country

Needless to say these numbers are completely bunk. Nevertheless thousands of the students were scared away, or detained, or deported.

Here is some coverage of the Toeic scandal: https://www.theguardian.com/uk-news/2019/apr/27/home-office-...

An astute reader will note that the coverage I have specifically linked describes this as potentially "bigger than Windrush", a separate scandal in which refugees were admitted to the UK, decades later various records of their admission destroyed, and then the government demanded they demonstrate evidence they were allowed to be present in the country.

https://en.wikipedia.org/wiki/Windrush_scandal

Now, personal anecdote time: I got a job in London the same day they voted for Brexit. I later found out that as family of a European citizen, the form to get a proper residence card was 97+ pages. This is basically as a way to make the environment more hostile. (Rather than deal with that and the economic uncertainties of Brexit, including its impact on the tech sector and general political uncertainty from subsequent governments, I instead moved to New York and literally doubled my salary, thanks in no small part to the low pound).

In summary: This particular story is just the latest insult in a parade of injuries. Fear not, though! The behavior of the Home Office has not gone unnoticed. For instance, the USCIS has recently been taking a page from the same book:

https://www.washingtonpost.com/opinions/the-trump-administra...

> The American Immigration Lawyers Association has collected [over 140] examples of allegedly "incomplete" forms: an 8-year-old child who listed "none" for employment history but left the dates of employment field blank. An applicant who entered names of three siblings, but the form has spaces for four.

Further links (with only minimal libertarian commentary) at
https://reason.com/2020/02/14/how-the-government-is-using-no...

Thank you for your time.
This reminds me of a fast.ai video where they use Excel for a CNN.
Isn't BigQuery real-time as well? For me, the wow factor is that you can host this yourself.
I remember at some point seeing an interview with someone that was involved with the design of the A-10 Warthog and he described it as something like a gun wrapped in an airplane. Unsurprisingly this site mentions attempts to replace the A-10 Warthogs big gun.
> One example that comes to mind was that spreadsheets are just memory mapped files and the layout of the file on disk is identical to the data structures in memory. This allows them eschew translation to a data interchange format. So they got performance at the cost of interoperability, which is probably what's hampering open office & friends.

That improves save/restore performance, but in and of itself doesn't do much about execution performance of macros.
I think it is also generational. We now have in the workplace a few generations of workers who grew up being told their opinions mattered and that speaking up is a virtue. I don't think it is necessarily a bad thing.

Us old-timers were taught the opposite, your opinions don't matter much, no one will listen to you until you prove yourself, etc.

So I think the generational shift has something to do with it.

I also think labor organizers are exuberant because they finally have a way to build a wedge between highly-paid employees who were formerly resistant to unionizing and their management.
Is this purely an aesthetic thing or is it an actual structural problem that has an appreciable effect on the day to day operation or reliability of the car.

Or is your argument more that if they can't fix the 'easy' things then that is an indication of more systemic problems with the integrity of the car
Skynet is built on top of the Sia decentralized cloud storage platform (https://sia.tech). Sia uses a blockchain to facilitate cryptocurrency transactions and store file contracts (which are like cryptographic SLAs between users), and is very similar to Bitcoin in architecture.

Anyone can operate a Skynet Webportal (the server), and Webportals can choose how they'd like to monetize – for example, they can run ads.

You can also run your own Skynet Portal by downloading Sia v1.4.3, released today. It costs about $10/mo to run a Portal because you have to form file contracts with a few hundred storage providers on the network. But then you do not have to go through a Webportal middleman.

Disclaimer: I work on the Sia/Skynet team.
True ... but there are thousands of us that sail (sailed) small yachts which have a more limited range if they have radar at all (power consumption and antenna height cause certain restrictions). AIS on the other hand works great and also integrates with chart plotters for collision alarm with relatively small amounts of power. Small yacht sailors generally assume that cargo vessels will NOT try to avoid them, so having the ship continue on its (drifting) course wouldn't be too surprising.
Just a shoutout to Rachel Andrew, the co-founder of Perch, member of the CSSWG and imo the Champion of CSS Grid.

https://rachelandrew.co.uk/
Found the video: https://youtu.be/gbceqO8PpBg
Forestry.io is a headless CMS that is backed by Git. It is made for Static Site generators and the content is still kept in your repository.
Not sure why you are being down voted, this is essentially how Spotify's shuffle works. At least, if you MITM the official client and load a large playlist/context you'll only see a small window worth of tracks being loaded. And you won't see any request from the client when you then shuffle that playlist, it's done locally.

This may, of course, have changed. My experiments while (badly) implementing librespot's shuffle functionality were a few years ago now.
I never understood why governments don't require companies to put down cleanup expenses upfront or purchase insurance or similar so they can't externalize these costs. Same with virtually any commercial building, etc.
“A career in software is one of the most pampered and lucrative ones I can think of.”

Yeah, when you are in the top 5%. I’m not sure you realize just how shit most tech jobs are. Not everyone gets $300k a year in stock. Most people get nothing.

You don’t want it because you are in the top decile. That’s the same reason that everyone who is in the top decile of anything doesn’t want change. This is for the 90%, not for you. You shouldn’t empathize. You should oppose this because it will ultimately hurt you.
> With explosions taking place virtually, how much harder will it be for weapons scientists to confront the destructive power of their work and its ethical implications?

What exactly is her hoped response, once a physicist realizes by watching a live atomic bomb explosion, that these things actually hurt? They'll quit working there? That didn't occur with the first few generations of bomb physicists. Enough stuck around to produce bomb after bomb, both here and abroad.

If anyone needs to learn this lesson, it's the proliferators -- except they'd just be overjoyed at the fearsome might, not terrified. Tehran and Pyongyang won't be deterred by feeling the dreadful rumble of a live test. (I'd pay to watch one, though.)

There may be dark side effects of virtualization, but this article's premise is weak.
I love it. Use it for client work to this day.
And instead of correcting the actual issue - fining the companies for collusion and enforcing consent decrees - unions are the answer?
If $8/week is something that affects your decisions, you might benefit from unionizing for higher pay. ;)

If you want to play the tax game, let's talk about reimbursing large purchases like a vehicle, personal laptop that you aren't monitoring, education costs, or housing. There isn't a situation where I'm going to care about snacks.
> Would it be fair to say this is a more OLAP-oriented approach to what KSqlDB (not KSql, but https://ksqldb.io/) does?

I'm not sure I'd say it's "more OLAP." ksqlDB is about as OLAP as it gets, considering it doesn't support any sort of transactions or consistency. We think Materialize is quite a bit more powerful than what ksqlDB offers, thanks to the underlying technologies (timely/differential). For example, our joins are proper SQL joins, and don't require you to reason about the complicated and confusing difference between a stream and a table (https://docs.ksqldb.io/en/latest/developer-guide/joins/join-...). We also have preliminary support for maintaining the consistency properties of upstream OLTP data sources, and we'll be rolling out a more complete story here shortly.

> Seems that it's perhaps lacking the richness of how ksqldb uses Kafka Connectors (sinks and sources), but I don't see any reason you couldn't use Materialize in conjunction with ksqldb.

Is there something in particular about ksqlDB connectors that we don't seem to support? Our CREATE SOURCE command is quite powerful: https://materialize.io/docs/sql/create-source/.

> What connectors (sinks and sources) do you have or plan to develop? Seems like it's mostly Kafka in and out at the moment.

We already support file sources in a variety of formats, and support for Amazon Kinesis is on the short-term roadmap: https://github.com/MaterializeInc/materialize/issues/1239.

Are there other connector types you'd like to see?

> Can I snapshot and resume from the stream? Or do I need to rehydrate to re-establish state?

At the moment you can't snapshot and resume, but support for this is planned.
> You have to earn $15k/year to qualify for the lowest tier health plan. At the minimum rate you quoted, that's about 12 weeks of work.

That's work on a set. 12 weeks/year on a set is a huge number. To get to that point, one probably spent 2x the time on non-paid activities such as pounding pavement going on castings and auditions.

> That's still better money than waiting tables. About 2x California minimum wage.

Exactly! So the great achievement of the union is non-full time at 2x minimum wage with benefits tied to ~ 3 months of days on set.

That would be a massive downgrade for tech workers who are full time, at 4x - 10x the minimum wage. Options and RSUs would definitely go bye-bye.

> Even guest stars that speak one or 2 lines in a single episode of a long-running show will get something. I don't know the sums involved - maybe it's grocery money, for someone with that small of a part.

The best thing to be is an extra who said something on camera, because that automatically upgrades one to a principal by burning an exmeption.

Yes, everyone gets paid residuals but it is all based on the total units and total pay and who gets more units.
From TFA:

So what's the story behind this mysterious ship without a crew?

This is actually the meaning of the term "ghost ship".
Ah the stupid idea may not be where I assumed it was, then...
Kinda agree. I use Airtable as the CMS for my personal website, and it's actually pretty quick to whip up pages with Gatsby (or whatever floats your boat in terms of SSG), then throw it onto some hosting and tada!

I even made some webhooks so I can trigger rebuilds from within Airtable, so when I change stuff I don't need to worry about going to the host and manually clicking rebuild.
The 0.8% of ECC 384bits is interesting, I thought 256 bit ECC was the only one with any real client support.
Let me know when you can accept USD and I'll be your first (small) donor!
if you want to unionize go ahead, i'm not though. I believe a lot of tech works would prefer not to be union and have to deal with all the BS plus dues. I can negotiate on my own pretty well so knock yourself out but i won't be signing up.
The impression I have is that Microsoft let the patent expire at the basic 7 year mark (~2014) as they deemed their UX R&D investment had given them enough lead over competitors in the Office suite space (the primary applications that required a paid license and were not allowed the free license). Around that time Microsoft added Ribbons to Win32 and WPF as freely available controls with no additional license. Fluent Design also seems working to add Ribbon controls to all UI control toolkits with no mention of licensing or patent rights (and seems to be working to move even Office to shared controls).
Top Cannabis Brands of 2020
Exactly, the last two year survival of control group may be artificially enhanced because the ones that were going to die were already dead in the first three.
There are a couple of pictures of Don Eyles and his colleagues from that period at the bottom of this page on Don's web site:

https://doneyles.com/LM/Tales.html

It looks like in those days, having long hair was what made you a "weird-looking freak".
I don't know if it's the same bug but I've certainly seen a similar bug (weird glitches in display that disappear when you scroll) on Fedora with AMD graphics (open source amdgpu driver, X), running Firefox nightly. One screen only..
A few years ago a customer reported a bug in my software which only happened with a specific 3D scene, on specific GPUs (my desktop rendered that scene fine), and was only happening rarely. That’s how I have learned about that GPU synchronization issue across graphics APIs which may cause incomplete renders.
this smells like an attempt to update the CAS concept; kind of like an AC-130 that's more survivable or expendable with less risk to a live pilot.

That being said, I'd have expected them to make something like a Reaper with guns instead of AGMs. I'm just not sure why they are describing it as a "missile with guns" vs a "drone with guns"
I can understand that AMD and Nvidia have spent a ton of time and money developing their drivers and that ML/GPGPU performance and features are highly competitive.

But embedded GPUs are so fucking obnoxious. There’s about a million of them and they pretty much all have proprietary binary blobs. Pretty worrying for something that could potentially allow any device to be remotely compromised via some malicious webGL or something. Good luck getting the manufacturer to continue supporting it 3 years from now though
This has saved me many hours of searching for LaTeX symbols when I was in University.
> 1. Why do tech workers need a union?

1. Fight ageism (every 20 year old today will grow up someday)

2. Fight open office layout (my opinion, may not be shared by everyone)

3. Fight for equal pay, discriminations of various sorts

4. Fight for reasonable share in success and against the massive differential between CxO and others' pay

5. Resist outsourcing where it makes sense

....... the list goes on ....
For Example (2013)
New Inexpensive Robots Find Leaks from Inside Pipes
For future reference, being fired because of performance or incompetency is unlikely to be a valid "for cause" firing that disqualifies one from unemployment benefits. If a person is fired because the employer claims they suck at the job (whether its true or not), they still get unemployment.

Your mileage may vary depending on local laws or recent changes to employment law.
So there's no value in the ship itself that makes the salvage a profitable operation?
Why do large scale businesses need Website development – Adlibweb
I thought I was the only one seeing this... they claim it's only windows 10, but I'm also seeing it on a 2012 macbook pro i5 intel graphics 3000. Not very often, but enough to be very annoyed and concerned by it.

My fear is some other program is gaining access to portions of the screen or video memory to scrape for banking information using ocr or something like that. Sometimes the glitches will be filled with upside down and stretched/keystone shifted versions of an area of a rendered page from a different tab. The keystone shift triggers my off-by-1 memory allocation bug sense... But it might be some other driver issue or exploit causing that on purpose somehow (like rowhammer). I fear this is going to take years to track down.
Everything that is patented is already fully disclosed to the public. It's a requirement of getting a patent. Keeping drivers closed-source is more likely to be due to the presence of trade secrets or that the code includes licensed bits that the manufacturer doesn't have the right to disclose the source code to.
Send an email asking them which drug they recommend. Then go see a lawyer with the printout.
Philip Guo wrote a great post several years ago under the title "Helping my students overcome command-line bullshittery"[1] that seemed to get somewhat mixed but mostly positive reception. Much of the negative reception seemed to be chained to sophomoric arguments originating from folks stuck in the second panel of the glowing brain meme who wrongly thought of Guo being stuck in the first.

The real truth behind the mess we're in[2] is that there is a ubiquitous, universal runtime that almost every computer comes equipped with, and the problem lies with the folks responsible for those ecosystems who either don't see these things as problems, or somehow believe that what the future somehow holds is native support for R/Python/what-have-you in the browser.

Tooling is a massive problem, though, and one that the browser vendors themselves don't seem to care to get right. (Although there is the Iodide project, in part supported by Mozilla.) And it really doesn't help that the browser realm has come to be conflated with the NodeJS community because they share a common language.

I've written a fairly thoughtful post[3] before, tying these two topics together:

> After finding out where to download the SDK and then doing exactly that, you might then spend anywhere from a few seconds or minutes to what might turn out to be a few days wrestling with it before it's set up for your use. [...]

> the question is whether it's possible to contrive a system (a term I'll use to loosely refer to something involving a language, an environment, and a set of practices) built around the core value that zero-cost setup is important

1. http://pgbovine.net/command-line-bullshittery.htm

2. https://www.youtube.com/watch?v=lKXe3HUG2l4

3. https://www.colbyrussell.com/2019/03/06/how-to-displace-java...
It might make the cost of doing / entering business too high, to the point where things can't actually proceed.
Congrats on launching!

How does this compare to something like OpenPhone (https://www.openphone.co/)?
I worked on a farm in the former West Germany (BRD), before the re-unification, not far over the border from East Germany (DDR). The proprietor's family was leasing the historic farmstead. His family's original farm had been just over the border in the DDR, and of course appropriated by the government. At the point they learned the American occupiers were withdrawing and they would be in the Russian occupation zone, they high-tailed it into the American occupation zone.

They visited me in America a couple years after The Wall fell, and he told me the rest of the story. Apparently his father's initial plan was to stick it out and see how things unfolded, but first they buried the family silver in the forest. He was in his early teens and supplied the teenage labor.

When they could return after the wall fell, he remembered roughly where the hoard should be. It took him a couple days with a metal detector, but they found it. He was very lucky because it was very near where the DDR had done trenching for the boarder hazards employed all along the east/west border. Some of the pieces were in very bad shape after 45 years underground, but most of it could be restored.
Samsung offers at-home Galaxy S20 trials to mitigate impact of coronavirus
I was just thinking that static site generators would deserve their own awesome list, and there we go. Someone already made one.

https://github.com/myles/awesome-static-generators
Which of the two probably depends on the particular situation, as it often is in technology.

Supposedly there was a time period where the Android team was considering .NET/C# instead of Java. In the short term their choice of Java was best for them but in the long run it led to things like the Oracle lawsuit and its threat of changing copyright law forever in a bad way - so it's interesting to consider what an alternate timeline would look like.

IE6 was amazing at the time compared to its competitors, but then it quickly became a hindrance - a good example of how the situation can flip the moment the ecosystem changes.
'New' African Nissan NP300 Crash Test with Used Navara Has Horrible Outcome