Thesis is "crypto millionaires squeeze out other consumers from high demand goods, loss of crypto value reduces demand for those and thus benefits other consumers"
[This paper] show[s] that forecasters, on average, over-estimate treatment effects; however, the average forecast is quite predictive of the actual treatment effect.
When I was in Venture, I did a tonne of research into the Nix ecosystem.
Fast forward to now, a new hire at the startup I work at, on his own volition, implemented a Nix flake day one at the company. Within the week, a bunch of our engineers were using it.
Super cool to see, mainly because of the decreased frustration in setting up our dev environments.
One of the reasons we streaming ingests is because we often modify the schema of the data in stream. Usually to conform w ClickHouse best practices that aren't adhered to in the source data (restrictive types, denormalization, default not nullable, etc).
Author here—this article was meant to highlight how you can optimize writes to CH with streams.
If you want to directly insert data into ClickHouse with MooseStack, we have a direct insert method that allows you to use ClickHouse's bulkload methods.
Co-author here, we used Debezium here because it supports many different databases. Unfortunately, no sqlite support—my understanding is as an embedded db it lacks some of the prerequisites that Debezium relies on.
Have you run CDC from sqlite? would love to hear how you did it and to try build a demo with MooseStack
Author here: I wrote out some worked examples about how ClickHouse's table engines affect how CDC updates and deletes are treated (on initial write, and on merge), coming to the conclusion that the ReplacingMergeTree is the goldilocks table engine for most CDC use-cases.
> In early work, El-Badry developed a method for identifying binary stars in spectrographic datasets. More than half of stars exist in binary systems, but they are often too close together to be differentiated with available technology. El-Badry overcame this challenge through targeted statistical analysis of existing spectral data.
Another
> Porras-Kim selected fragmented objects of unknown origins from the storage shelves of the Fowler Museum at UCLA, whose collections span the arts and cultures of Africa, Asia, the Pacific, and the Indigenous Americas. Her resulting installation, entitled Reconstructions, brought together the artifacts with drawings and sculptures that prompted viewers to consider how the textile fragments, pottery shards, and other orphaned objects functioned and came to be acquired by the museum.
> The word foil comes from the old practice of backing gems with foil to make them shine more brightly.