c-cube (u/c-cube) - Readit News

c-cube commented on SQLite JSON at full index speed using generated columns dbpro.app/blog/sqlite-jso... · Posted by u/upmostly

eliasdejong · 11 days ago

It is also possible to encode JSON documents directly as a serialized B-tree. Then you can construct iterators on it directly, and query internal fields at indexed speeds. It is still a serialized document (possible to send over a network), though now you don't need to do any parsing, since the document itself is already indexed. It is called the Lite³ format.

Disclaimer: I am working on this.

https://github.com/fastserial/lite3

c-cube · 8 days ago

It's a bit unfortunate that [1] doesn't seem to mention Fleece[2], since Fleece is an already existing, solid format with very similar properties (JSON-compatible data format, uses offsets for sharing, allows for cheap updates, and uses binary search on arrays to achieve O(ln n) lookups in large tables or arrays, etc.)

[1]: https://lite3.io/design_and_limitations.html#autotoc_md31 [2]: https://github.com/couchbase/fleece/

c-cube commented on Why I stopped using JSON for my APIs aloisdeniel.com/blog/bett... · Posted by u/barremian

morshu9001 · 22 days ago

Protos are great. Last time I did a small project in NodeJS, I set up a server that defines the entire API in a .proto and serves each endpoint as either proto or json, depending on the content header. Even if the clients want to use json, at least I can define the whole API in proto spec instead of something like Swagger.

So my question is, why didn't Google just provide that as a library? The setup wasn't hard but wasn't trivial either, and had several "wrong" ways to set up the proto side. They also bait most people with gRPC, which is its own separate annoying thing that requires HTTP/2, which even Google's own cloud products don't support well (e.g App Engine).

P.S. Text proto is also the best static config language. More readable than JSON, less error-prone than YAML, more structure than both.

c-cube · 22 days ago

That's what Twirp (https://github.com/twitchtv/twirp) is about. Protobuf or JSON, over any HTTP, with a simple URL schema. It's fairly simple.

c-cube commented on Rust compiler performance kobzol.github.io/rust/rus... · Posted by u/mellosouls

jtrueb · 6 months ago

A true champion

> when I started contributing to Rust back in 2021, my primary interest was compiler performance. So I started doing some optimization work. Then I noticed that the compiler benchmark suite could use some maintenance, so I started working on that. Then I noticed that we don’t compile the compiler itself with as many optimizations as we could, so I started working on adding support for LTO/PGO/BOLT, which further led to improving our CI infrastructure. Then I noticed that we wait quite a long time for our CI workflows, and started optimizing them. Then I started running the Rust Annual Survey, then our GSoC program, then improving our bots, then…

c-cube · 6 months ago

I'm worried this person is going to experience a Yak overflow, honestly.

c-cube commented on A look at the creative process behind Bluey and Cocomelon (2024) readtrung.com/p/why-i-lov... · Posted by u/gmays

ashton314 · 9 months ago

Bluey is next-level. S-tier television. It’s wholesome, calm, and entertaining. Episodes like Camping, Baby Race, Cricket, and Onesies are all emotional sucker-punches to the adults watching. (My pet theory, which my wife first suggested: Camping is essentially the Star Trek TNG episode Darmok.)

c-cube · 9 months ago

So many little things for parents. Your list is good. I was also struck by "early baby", for example, for subtext children will only get when they re-watch in 20 years.

c-cube commented on Why aren't we losing our minds over the plastic in our brains? scientificamerican.com/ar... · Posted by u/mikhael

Ekaros · 10 months ago

So what is the alternative for tires that does not use plastics? Or only use some natural compounds that do not act like microplastics.

c-cube · 10 months ago

Lighters cars, electric bikes, more trains on steel tracks...

c-cube commented on AI is stifling new tech adoption? vale.rocks/posts/ai-is-st... · Posted by u/kiyanwang

Workaccount2 · 10 months ago

In some sense I am hopeful that AI will be able to just write everything directly in binary. Everything written ideally, with no abstraction, fluff or bumpers for human brains. Computers don't talk in any high level programming language, they talk in binary. If anything we should probably be focusing LLMs on getting good at that.

I can only imagine that the amount of energy wasted on CPU cycles from layers of bloated programming languages makes stuff like bitcoin mining look like a rounding error.

c-cube · 10 months ago

So you can't even debug or check the LLM's output for correctness? Good luck with that.

If anything, the best use for LLMs is to produce code in very strong languages like Lean, where correctness of the code can be established. Just trusting machine code output would be irresponsible.

c-cube commented on The year I didn't survive bessstillman.substack.com... · Posted by u/LaurenSerino

throwaway356356 · 10 months ago

Throwaway: when my daughter was 4, she took a bath. My wife was in the living room doing laundry, literally 5 steps away. At that point, my daughter had just finished swimming class 3 months before. I was at work. When she called "mum!", my wife said: "Coming" and folded one final shirt. When she then entered the bathroom, my daughter floated in the tub, face down. No breathing, no sign of life anymore. My wife revived here on the floor of our living room while calling 911 and crying for help.

She had a simple fever cramp (her second) in the tub and nearly drowned because of it.

This was roughly a year ago. I remember walking out of the building at work in trance, looking for a cab, after I got the call, thinking my daughter was dead. She was back to normal (apart from the nasty infection that lead to the fever cramp) on the next day. Buy my wife and I have never been the same since. I entered the apartment 2 days later, and the tub was still filled with water and some of my daughters hair, and there was blood on the living room floor because the medics gave her sedatives and she kicked against the syringe. While cleaning my daughter's blood from the floor, I got the distinct feeling that she really died and that I was just in a very long dream in which she survived, and that I would wake up very soon to a world of sorrow. That feeling has never left me. It may explain why most things now feel completely irrelevant to me, including work.

We quickly bought a house 6 months later and left the apartment. I now realize that this was mostly motivated by the fact that we couldn't stand the look of the bathtub anymore. It was also because we simply weren't afraid anymore of the debt, of the additional work, of moving. Fear is something that only remains a numb feeling after such an experience.

She is 5 now. The worst part is that she fully remembers. A few weeks ago, she freely and cheerfully explained in daycare that she once was bathing and then cried "mum" and then "fell asleep under water". At dinner a few months ago, she also explained that to us and then laughed and mentioned that "mum must've thought I am a mermaid" and happily continued eating. It crushes me just thinking of it.

If my wife had folded 2 or 3 shirts before entering the bathroom, my daughter would be dead now. If my daughter hadn't yelled "mum!" the second the fever cramp started, of if she would've yelled it under water, she would also be dead now. In this probabilistic decision tree, the leaf where my daughter survives has a probability that is negligibly small. To my very great surprise, I have found that this inevitably leads to religion. I have never been religious before, but I have indeed found great relief in prayer and sitting around in empty churches.

Life to us is now nothing but walking on a thin crust of ice, which spans over an infinite hell of fire, horror and torture. At any time, without warning, the ice may break.

c-cube · 10 months ago

Thank you for sharing. What a terrifying experience. I hope you get some help to deal with the trauma.

c-cube commented on Teen on Musk's DOGE team graduated from 'The Com' krebsonsecurity.com/2025/... · Posted by u/mmsc

vntok · 10 months ago

Finland for example: https://www.vero.fi/en/About-us/finnish-tax-administration/d...

> Individual income tax information for 2023 was released on 7 November 2024. Public information can be browsed on tax office workstations and requested by telephone: How to search the public information on income taxes and real estate taxes

> The following data is included in the public information on individual income taxes:

> name, year of birth, county earned income subject to state taxation

> capital income subject to state taxation, income subject to municipal taxation, income tax, municipal tax

> imposed taxes and charges in total, amount of back taxes or tax refunds

c-cube · 10 months ago

Thank you, not surprising it's the nordic countries. I can't imagine this in the US but I'm glad to learn some places pull it off.

c-cube commented on Teen on Musk's DOGE team graduated from 'The Com' krebsonsecurity.com/2025/... · Posted by u/mmsc

frankharv · 10 months ago

I totally agree. Sunshine is the best disinfectant.

It seems our Continuing Resolution method of funding the government is a failure.

Sorta like cost plus last year.

c-cube · 10 months ago

Where do you see sunshine? Are the "audits" public at all? It's indistinguishable from just having Musk kill every agency he dislikes with no further proof, while siphoning data to some unspecified server. The timeline also hints at no serious audit taking place.

c-cube commented on Teen on Musk's DOGE team graduated from 'The Com' krebsonsecurity.com/2025/... · Posted by u/mmsc

timewizard · 10 months ago

Tax data is not particularly sensitive and several nations just publish it. Even in the US many forms of non-individual tax filings are public by default. The results of audits /are/ highly sensitive but there's no reason to hold those on computer systems for longer than 5 years after the audit.

I think the medical industry can easily be regulated without the government having access to my actual medical file. They regulate cars without having any idea how I drive mine. They regulate planes without sitting on the flight deck themselves.

It's like we know how to build good businesses, good databases, have solid user control practices, but then we give the government a pass because it's imagined to be "really hard." It's laughable.

c-cube · 10 months ago

Can you point to a country that publicly releases everybody's tax returns, as a policy? I know some countries that release elected officials' returns, but not those of common people.