Lightnews — Scholar-powered news

Peter Zaitsev @peterzaitsev.bsky.social · Aug 15

Come be part of PG Armenia x Percona University in Yerevan on Thursday, August 28. We have an amazing speaker lineup. Meet people, trade ideas, and leave smarter. The event is free!!

Register:
percona.university/event/percon...

#PerconaUniversity #PGArmenia #OpenSource

1 3

Peter Zaitsev @peterzaitsev.bsky.social · Aug 14

Come to PG Armenia x Percona University in Yerevan on Aug 28 to hear Alexander Zaitsev on Building Real-Time Data Lake with ClickHouse and Altinity Antalya. Attendance is Free!

For registration and details: percona.university/event/percon...

#PerconaUniversity #PGArmenia #ClickHouse #OpenSource

1 4

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

Whatever it is Self Hosted, Community Hosted or something else there should not be a single choice provided by single monopoly-enterprise www.drewlyton.com/story/the-fu...

The Future is NOT Self-Hosted

Hey friends 👋, A few months ago, Amazon announced that Kindle users would no longer be able to download and back up their book libraries to their computers. Thankfully, I still have access to my libr...

www.drewlyton.com

2

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

Tabs vs Spaces - where do different languages stand xn--gckvb8fzb.com/tabs-vs-spac...

Tabs vs. Spaces: The War Is Over

The great indentation war is over and it seems like we have a clear winner.

xn--gckvb8fzb.com

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

Looking scale #prometheus consider VictoriaMetrics www.pingcap.com/blog/tidb-ob...

TiDB Observability: Moving from Prometheus to VictoriaMetrics

Explore why TiDB migrated to VictoriaMetrics for enhanced observability, better resource utilization, and faster query performance.

www.pingcap.com

1 4

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

Yeah, push of some vendors to use their app rather than having web site work really well on mobile is common idiallo.com/blog/dont-do...

Do not download the app, use the website

The 2010s was the Wild West of the mobile world. "Mobile-first" was the buzzword, much like "AI-first" is today. Every company, from the biggest social media giants to your local pizza parlor, seemed

idiallo.com

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

This is interesting - rethinking how processing works indeed can open new frontiers of efficiency morethanmoore.substack.com/p/efficient-...

Efficient Computer's Electron E1 CPU

100x More Efficient than Arm?

morethanmoore.substack.com

1

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

Interesting post on how ClickHouse deals with efficient updates which is classically not an easy problem for column store clickhouse.com/blog/updates...

How we built fast UPDATEs for the ClickHouse column store – Part 2: SQL-style UPDATEs

ClickHouse can do fast, declarative UPDATEs. Patch parts make it possible, with minimal I/O, instant query visibility, and high parallelism. This post breaks down the mechanics that make it all work.

clickhouse.com

1

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

Daniil Bazhenov from Percona shows how to install Coroot with #ArgoCD for awesome #observability percona.community/blog/2025/07...

GitOps Journey: Part 4 – Observability and Monitoring with Coroot in Kubernetes

Our PostgreSQL cluster is running, and the demo app is generating traffic — but we have no visibility into the health of the Kubernetes cluster, services, or applications. What happens when disk space...

percona.community

3

Peter Zaitsev @peterzaitsev.bsky.social · Jul 28

PogoCache positions itself as even faster Redis alternative and unlike Dragonfly comes with #opensource license github.com/tidwall/pogo... Anyone tried it yet ?

GitHub - tidwall/pogocache: Fast caching software with a focus on low latency and cpu efficiency.

Fast caching software with a focus on low latency and cpu efficiency. - tidwall/pogocache

github.com

1 2

Peter Zaitsev @peterzaitsev.bsky.social · Jul 25

AI Powered Root Cause Analyses (RCA) is all the rage those days, but how can it be architected ? Coroot founder Nikolay Sivko explains coroot.com/blog/anatomy...

Anatomy of AI-powered Root Cause Analysis

Explore the strengths and limitations of AI-powered root cause analysis in observability. Learn why combining complete telemetry with context-aware AI is the key to finding real answers

coroot.com

1

Peter Zaitsev @peterzaitsev.bsky.social · Jul 25

FerretDB gets more secure with HashiCorp #vault support blog.ferretdb.io/dynamic-data...

Dynamic Database Credentials with HashiCorp Vault and FerretDB | FerretDB Blog

Learn how to integrate HashiCorp Vault's database secrets engine with FerretDB to generate dynamic credentials for enhanced security and management.

blog.ferretdb.io

Peter Zaitsev @peterzaitsev.bsky.social · Jul 21

Interesting update on what has been going with Godot - #opensource Unity alternative www.gamesindustry.biz/two-years-af...

Two years after the Unity controversy, how are things going with Godot?

Two years ago, Unity's missteps prompted a wave of interest in the open-source Godot engine. Here's what happened next.

www.gamesindustry.biz

1 2

Peter Zaitsev @peterzaitsev.bsky.social · Jul 21

One of the classical tricks you can use for Clickhouse query optimization - keep the data which is often accessed together, located close signoz.io/blog/query-p...

How we made ClickHouse log queries 99.5% faster with resource fingerprinting

Learn how SigNoz achieved 99.5% query performance improvement using hierarchical resource fingerprinting for ClickHouse sparse indexing.

signoz.io

1

Peter Zaitsev @peterzaitsev.bsky.social · Jul 21

In the search for truly Open social media... techcrunch.com/2025/07/16/j...

Jack Dorsey pumps $10M into a nonprofit focused on open source social media | TechCrunch

Dorsey's initial investment has gotten the new nonprofit "andOtherStuff" up and running, and he worked on some of its initial iOS apps.

techcrunch.com

1

Peter Zaitsev @peterzaitsev.bsky.social · Jul 21

Interesting read. Not just about what tools may get wrong but about user expectations aicodinghorrors.com

AICodingHorrors | The price of AI-assisted coding, literally!

AI Coding Horrors is a growing collection of real-world disasters caused by AI-assisted coding tools like sky-high bills, leaked secrets, broken apps,..

aicodinghorrors.com

Peter Zaitsev @peterzaitsev.bsky.social · Jul 16

Nice to see Redka now allowing you to use PostgreSQL as a backend for Redis protocol antonz.org/redka/

Redka: Redis re-implemented with SQL

A Redis-compatible Go server/package with a Postgres or SQLite backend.

antonz.org

Peter Zaitsev @peterzaitsev.bsky.social · Jul 16

Yet another Analytical Databases benchmarks finds #clickhouse to be a leader
github.com/toddstoffel/...

GitHub - toddstoffel/analytics_benchmark: Benchmark suite for analytical DBs using real-world SQL queries, Docker-based automation, and reproducible tests. Tailored for comparing systems like Apache D...

Benchmark suite for analytical DBs using real-world SQL queries, Docker-based automation, and reproducible tests. Tailored for comparing systems like Apache Doris and ClickHouse with realistic data...

github.com

Peter Zaitsev @peterzaitsev.bsky.social · Jun 30

If you were curious what will happen to Percona XtraDB Cluster now MariaDB acquired Codership - Galera Cluster - you should no worry, development will continue

www.percona.com/blog/percona...
#percona #mysql

Percona XtraDB Cluster: Our Commitment to Open Source High Availability

Percona XtraDB Cluster uses an independent Galera version, ensuring ongoing open source innovation and high availability regardless of industry changes.

www.percona.com

Peter Zaitsev @peterzaitsev.bsky.social · Jun 30

Interesting discussion. I would not single out Microsoft here - any company has to comply with the laws of the country it is registered in. It looks like many Europeans are wondering to what extent US can be seen as country having fair and reasonable laws blog.miloslavhomer.cz/p/microsoft-...

Microsoft Dependency Has Risks

This is not an opinion, this is not an opinion... it's an opinion, isn't it?

blog.miloslavhomer.cz

Peter Zaitsev @peterzaitsev.bsky.social · Jun 24

What is your favorite example of "wrong way to use the database" www.luu.io/posts/2025-d...

Wrong ways to use the databases, when the pendulum swung too far | LUU.IO

www.luu.io

Peter Zaitsev @peterzaitsev.bsky.social · Jun 24

Yep, I often mention this growing difference between "corporate open source" and "community open source". Great to see more recognition about this difference, which I think is still understood by way to few #opensource utcc.utoronto.ca/~cks/space/b...

Chris's Wiki :: blog/tech/OpenSourceTwoWorlds

utcc.utoronto.ca

4

Peter Zaitsev @peterzaitsev.bsky.social · Jun 18

Security, Confidentiality, Compliance will be a big deal for LLMs, though other time I think it can be taught to follow rules better than humans www.theregister.com/2025/06/16/s...

LLM agents flunk CRM and confidentiality tasks

: 6-in-10 success rate for single-step tasks

www.theregister.com

Peter Zaitsev @peterzaitsev.bsky.social · Jun 18

Tembo Cloud is Sunsetting so customers need to move their workloads quickly. While I do not know if significant number of customers is impacted such announcements erode trust in small "indie" cloud offerings as they sunset abruptly tembo-io.notion.site/Tembo-Cloud-...

Tembo Cloud Migration Guide | Notion

Timeline

tembo-io.notion.site

Peter Zaitsev @peterzaitsev.bsky.social · Jun 16

Altinity, Inc. makes #iceberg and #parguet fast on #clickhouse
altinity.com/blog/the-fut...

The Future Has Arrived: Parquet on Iceberg Finally Outperforms MergeTree

Altinity's Project Antalya brings Iceberg support in ClickHouse to the next level - matching and in some cases outperforming MergeTree, while enabling cheap object storage and scalable, shared data sy...

altinity.com

2