Openfire 5.1.0 is out - our first feature release in nearly a year!

The highlights: SASL channel binding (with thanks to @nlnet for their support 💕), a round of crypto hardening, an O(n²) bug that was causing 2-hour startup times on large deployments (now seconds), Java 25, and new first-class support for #MariaDB, #Firebird and #CockroachDB.

Read all about this release in our blogpost! https://discourse.igniterealtime.org/t/openfire-5-1-0-release/96495

#XMPP #OpenSource #Java

Openfire 5.1.0 Release

The Ignite Realtime community is pleased to announce the release of Openfire 5.1.0, the latest version of our open-source XMPP real-time communication server! Since the 5.0.0 release, now over 11 months ago, we’ve kept the 5.0.x branch stable and maintained, but have also been working on the next set of bigger changes. With this release, those have (finally - sorry for the wait!) been made available. If you’ve been following along in the chat or forums you might have seen pieces of it being put...

Ignite Realtime Community Forums

Another PR to OSS merged 🥹 - CockroachDB

https://ikristina.github.io/blog/cockroachdb_pr

#open-source #cockroachdb #go #sql

Another PR to OSS merged 🥹 - CockroachDB

My second contribution to open source - a fix for a bug in CockroachDB's PL/pgSQL UDF support.

Threads of Thought
How MVCC Works and Why Databases Use It

Multi-version concurrency control lets readers and writers proceed without blocking each other. A breakdown of the core mechanics, and how PostgreSQL, CockroachDB, and MySQL InnoDB implement them.

Threads of Thought

#Directus layers a blazingly fast #NodeJS API on top of any existing SQL database. No schema changes needed, works with what you already have.

🗄️ Database Freedom:
#PostgreSQL, #MySQL, #SQLite, #MariaDB, MS-SQL, #CockroachDB & #OracleDB — you choose, Directus connects.

🎨 No-Code Admin Dashboard
Built with #VueJS, intuitive and secure. Non-technical users can manage content without any training required.

🔌 Fully Extensible & White-Label Ready

We are exploring support for #MariaDB, #Firebird and #CockroachDB in Openfire. This includes early pull requests and discussion of trade-offs, maintenance cost and real-world demand.

We would love community input before proceeding further.

Is this valuable, or more trouble than it is worth?

#Openfire #XMPP #databases

https://discourse.igniterealtime.org/t/experimenting-with-mariadb-firebird-and-cockroachdb-support-in-openfire/96434

Experimenting with MariaDB, Firebird and CockroachDB Support in Openfire

I have recently started experimenting with adding support for three additional databases in Openfire: MariaDB, Firebird and CockroachDB. This work is still exploratory. Before committing to this direction, I would like to get a better understanding of whether this is actually valuable to the Openfire community. I have prepared initial pull requests for each database: MariaDB: https://github.com/igniterealtime/Openfire/pull/3240 (OF-3239 in our issue tracker) Firebird: https://github.com/igni...

Ignite Realtime Community Forums
The Multi-Raft Architecture

The Raft consensus protocol is widely adopted for building fault-tolerant distributed systems. It ensures that even if a node crashes or becomes unreachable, the cluster agrees on a single consistent state. However, single-group Raft does not scale well.

Threads of Thought
Runtime Choices in Distributed Systems

The Raft algorithm is language-agnostic, but the runtime underneath it is not. GC pauses, CPU scheduling, and memory models shape which implementation strategies are even possible.

Threads of Thought
🌘 不可穿越:利用列級別安全性的精細訪問控制
➤ 提升資料安全,簡化多租戶架構與區域限制
https://www.cockroachlabs.com/blog/fine-grained-access-control-row-level-security/
本文介紹了 CockroachDB 25.2 版本推出的列級別安全性 (Row-Level Security, RLS) 功能。RLS 允許開發者和運營者在資料庫層面直接定義和強制執行基於使用者角色或屬性的數據訪問策略,從而提高數據安全性和合規性,並簡化應用程式的複雜性。文章深入探討了 RLS 在多租戶和多區域部署情境下的應用,以及它如何透過共享表格和精細策略有效管理數據訪問權限,並提升資源利用率。
+ 這篇文章清楚地解釋了列級別安全性的概念以及它如何解決實際的資料安全問題,對於需要管理敏感數據的企業來說很有幫助。
+ 範例程式碼說明非常清晰,讓我對 RLS 在 CockroachDB 中的應用有了更深入的瞭解。
#數據安全 #資料庫 #CockroachDB
You Shall Not Pass: Fine Grained Access Control with Row Level Security

Discover how CockroachDB’s new Row-Level Security feature enables fine-grained access control, helping enterprises secure data, simplify apps, and meet compliance needs.

🐓 #CockroachDB, the #database that’s as resilient as its namesake, now lets you micromanage #row-level #access because table-level paranoia just isn’t enough. 🎭 You can now play a game of who-can-see-which-row with fine-grained precision—because who doesn’t love spending their time configuring a labyrinth of data permissions? 💼🔒
https://www.cockroachlabs.com/blog/fine-grained-access-control-row-level-security/ #security #datapermissions #micromanagement #HackerNews #ngated
You Shall Not Pass: Fine Grained Access Control with Row Level Security

Discover how CockroachDB’s new Row-Level Security feature enables fine-grained access control, helping enterprises secure data, simplify apps, and meet compliance needs.

You Shall Not Pass: Fine Grained Access Control with Row Level Security

Discover how CockroachDB’s new Row-Level Security feature enables fine-grained access control, helping enterprises secure data, simplify apps, and meet compliance needs.