525 karma · joined September 10, 2010
Columnar databases are very good at compressing time series data which often has runs of repeating values that can be run length encoded, repeating deltas (store the delta not the full value), or common strings that can be dictionary encoded. So you can persist a lot of raw data with quite good compression and fast-scannability. Most commercial TSDBs are now backed by column stores. And several now tier with local SSDs for hot data and S3 for colder data.
If that's still too much data to store, you have to start throwing some away. Both sampling and materializing aggregates (and discarding the raw data) are popular techniques and can both be very reasonable trade offs.
We've created a very nasty internet - one that isn't safe for the old or the young - and without the law enforcement or age boundaries that we use in the physical world to keep our public spaces suitable for the broader population.
https://www.amazon.com/Power-Babel-Natural-History-Language/...
https://www.houstonpublicmedia.org/articles/technology/2024/...
I've wished for this in multiple open-source oriented companies.
Find My Feature from apple.com:
> Activation Lock is designed to prevent anyone else from using or selling your device. When you enable Find My on your device, Activation Lock is turned on automatically.
> Your Apple ID and password will then be required in order to erase or reactivate it. And if someone is able to erase your device, the Hello screen will show that it’s locked, locatable, and still belongs to you.
https://www.legislature.mi.gov/documents/2021-2022/billanaly...
> A Critical Industry Program grant in the amount of $600 million for the creation of up to 4,000 jobs related to the Orion Township and Ultium projects; > An 18-year Renewable Energy Renaissance Zone which will require a minimum investment of $1.5 billion with the potential for up to $2.5 billion, estimated to be worth $158 million; > A Strategic Site Readiness Program grant in the amount of $66.1 million awarded to the Lansing Economic Area Partnership (LEAP) for public infrastructure and utility upgrades.
The grant legislation: https://www.legislature.mi.gov/documents/2021-2022/billanaly...
It certainly sounds like the grant portion was state tax money paid to GM. I wonder under what requirements.
The tax abatement is essentially shifting some of the tax base from corporations to individuals. Some of whom can pay those rates when they next find work.
I think the size and heterogeneity of the US is under-appreciated.
Canada is a 1/10th the population of the US. Europeans are more likely to identify as Germans, Italians, etc. and see to their national interests before those of the EU as a whole.
The US is the 3rd most populous country after China, India - ahead of Pakistan, Indonesia, Nigeria, Brazil... And the 4th largest by landmass after Russia, Canada, and China.
The text of (this portion) of the law is:
> Classroom instruction by school personnel or third parties on sexual orientation or gender identity may not occur in kindergarten through grade 3 or in a manner that is not age-appropriate or developmentally appropriate for students in accordance with state standards.
It says very clearly that a instruction about gender identity MAY NOT OCCUR before grade 4 - and after that must occur in accordance with state standards and to a vague standard of "appropriateness".
The law makes it illegal for a young child with gay parents to draw a family picture and discuss it in classroom.
Zoom includes network, compute, video, voice, recording, recording-storage, transcription, mobile clients, telecom/phone-in, meeting controls, webinar controls, in app messaging, presumably global data centers, calendars, whiteboards, 3rd party app integrations for calendars and schedule, zoom-rooms/hardware, "zoom apps" - 3rd party application integration, bot integration, and a whole enterprise VOIP business on top of it all.
They do - almost all databases will offer change data capture integration either via making the write ahead log readable or by suggesting triggers, like the article.
If you wanted to read the deletion journal in another system (maybe because of transaction rate), you might prefer CDC to Triggers. For example: https://www.postgresql.org/docs/current/logical-replication-...