jmgimeno

Couldn't finish it. I suppose it was not for me.

Maybe I'm wrong, but for this query:

SELECT * FROM benchmark_logs WHERE severity < 3 ORDER BY timestamp DESC LIMIT 10;

this index

CREATE INDEX ON benchmark_logs (severity, timestamp);

cannot be used as proposed: "Postgres can jump directly to the portion of the tree matching severity < 3 and then walk the timestamps in descending order to get the top K rows."

Postgres with this index can walk to a part of the tree with severity < 3, but timestamps are sorted only for the same severity.

A post discusses how Gittensor, a Bittensor subnetwork, uses cryptocurrency to incentivize open-source software contributions, attracting both senior and junior developers. The author observes that while this model promises a decentralized workforce, the influx of contributions, particularly from junior developers requiring significant review, may increase the maintenance burden on projects like sbt and raises questions about the sustainability of quality without overwhelming maintainers.

"The UNIX TimeSharing System", by Dennis M. Ritchie and Ken Thompson.

ZIO plans to streamline its ecosystem in 2025 by integrating core projects and focusing on enterprise stability.

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya and Boris Novikov Anna Bailliekova, published by Apress in 2021.

In this post, John de Goes discusses the issues standing in the way of Scala’s growth in industry, and share his thoughts about how we can all help.

> don't think progressing in mathematics is only for young people, fields medal winners are typically in their late 30s, early 40s.

Fields medal is for mathematicians under 40 years of age.

Yes, but you're relying on the undefined concept of context. How do you define context?

SOLID (or any set of design principles) are important in the sense that you should think twice when you don't obey them. So it is not necessary that they are strictly well defined: they are stopping points for thinking not for marking on a YES/NO list.