tgindex
FirebirdSQL

Channel for Firebird SQL users and developers

Последний пост
10 авг.
Последнее чтение
15 авг.
Постов за неделю
0
Всего постов
20
Тип
открытый
Язык
und
В каталоге с
13 авг.
Подписчики
688
+1 за 3 дн.
Сутки
0
0,00%
Неделя
 
Месяц
 
Просмотров на пост
918
20 постов
Вовлечённость
133,4%
к подписчикам
Постов в день
0,0
всего 20
Упоминаний
1
каналов
Охват размещения
оценка
1/24сутки в ленте
400
1/48двое суток
458
1/72трое суток
494

Оценка по просмотрам недавних постов: пост набирает почти всё за первые сутки.

Посты

  • Firebird high-level native client for React Native Android (Embedded) https://github.com/asfernandes/react-native-firebird/tree/main/react-native-firebird

  • FBSimCity v0.6.0 — the replication district The explorable city of Firebird internals now has a replication quarter. Firebird has no write-ahead log to ship, so its replication is logical: as each transaction commits, the changes themselves are journalled…

  • Electric Firebird: the Firebird database engine compiled to WebAssembly, with a live browser demo Electric Firebird (mariuz/electric-firebird on GitHub) compiles the Firebird database engine to WebAssembly, following the same approach PGlite took for PostgreSQL. It ships two backends: a native Node.js implementation (via the Firebird Embedded Server) and a WASM build that runs entirely in the browser, persisting data to IndexedDB. Supports parameterized queries, transactions, typed values, and cross-tab safety. Apache-2.0, still under active development. GitHub: https://github.com/mariuz/electric-firebird Live demo (runs entirely client-side, nothing uploaded): https://mariuz.github.io/electric-firebird/ Feedback and testing very welcome!

  • FBSimCity v0.6.0 — the replication district The explorable city of Firebird internals now has a replication quarter. Firebird has no write-ahead log to ship, so its replication is logical: as each transaction commits, the changes themselves are journalled into segments, sealed, and replayed on the replica in commit order. Three buildings: • Journal Yard — where commits are journalled. If the segments cannot be shipped, they stack up here visibly. • Replicator — asynchronous ships at its own pace and the replica trails, so commits never wait. Synchronous makes the commit itself wait for the replica. • Replica Database — a second database, drawn as its own excavation, replaying the journal in commit order. Set the replica slow and watch lag build, or unreachable and watch the segments pile up: https://mariuz.github.io/FBSimCity/?scenario=replicalag&warp=55&panel=journal The behaviour I was most careful to get right: a synchronous replica that dies hangs commits. It does not quietly fall back to asynchronous, because silently downgrading would mean claiming a durability guarantee the configuration no longer has. There is also a fourth operator decision: the replica is gone and its journal segments are filling the same volume the database writes to. Stop replication and discard the backlog, and the replica needs a fresh restore rather than a resume. Keep journalling, and you are betting free space against its return. City: https://mariuz.github.io/FBSimCity/ Release notes: https://github.com/mariuz/FBSimCity/releases/tag/v0.6.0 Still a model for intuition, not an emulator. Corrections very welcome, particularly on the replication mechanics — I modeled those from the documentation rather than the engine source.

  • cl-firebird v1.0.0 released — a pure Common Lisp driver for Firebird 3.0/4.0/5.0/6.0 with full 1:1 feature parity with node-firebird. No libfbclient, no FFI — it speaks the Firebird wire protocol directly over TCP (up to protocol 20) and runs on SBCL, CCL, and other ANSI CL implementations. Includes connection URIs, thread-safe connection pooling, named placeholders, custom type parsers (type-cast), streaming cursors, batch execution, Firebird 6.0 tablespaces/schemas, database events (POST_EVENT), a Service Manager API, and a 66-check test suite run in CI against Firebird 3.0 through 6.0-snapshot. GitHub: https://github.com/mariuz/cl-firebird Release: https://github.com/mariuz/cl-firebird/releases/tag/v1.0.0 Full announcement with code examples: https://mapopa.blogspot.com/2026/07/announcing-cl-firebird-v100-pure-common.html

  • FBSimCity — an explorable city that shows how Firebird actually works https://mariuz.github.io/FBSimCity/ An interactive visualization of Firebird internals: an isometric city where every building is a subsystem from the classic "Conceptual Architecture for Firebird" paper (Chan & Yashkir), and queries commute through the pipeline as glowing particles — REMOTE harbor, Y-valve, DSQL, JRD, with the lock manager tower alongside. The parts that are distinctly Firebird: • Multi-generational architecture — an UPDATE never overwrites a row, it stacks a new version. Click a tower to see the chain with the transaction that wrote each version, marked reachable or garbage. • The OIT — garbage collection can only remove versions older than the Oldest Interesting Transaction. Switch on a forgotten transaction and watch cleanup stall while the towers redden. • gbak pins the OIT too — a logical backup reads through a snapshot transaction, so a nightly backup of a busy database holds back GC for its whole run. Nightly backup and mysterious bloat are often the same story. • No WAL — careful write ordering instead. nbackup locks the file and diverts writes into the difference file, which you can watch fill and merge back. Guided tour, step-by-step query trace, scenario presets, and a data-page anatomy diagram. Runs in the browser, no install. Source: https://github.com/mariuz/FBSimCity (MIT, plain HTML/JS, no build step)

  • node-firebird v2.6.0 - v2.14.0: roadmap complete, issue tracker at zero Eight releases in under a week for the pure-JavaScript Node.js driver: Firebird 6.0 Protocol 20 support, the sporadic Srp auth failure fixed, single-byte codepage support (WIN125x, ISO8859_x, KOI8, DOS866), Firebird 4 batch API bulk inserts, multi-host pooling (poolCluster) for replica setups, and more. All 47 open issues closed. https://mapopa.blogspot.com/2026/07/node-firebird-catches-up-roadmap.html

  • FlameRobin Release 26.7.7 - Milestone Release https://github.com/mariuz/flamerobin/releases/tag/v26.7.7

  • 8 июл.1 036155

    IBPhoenix is pleased to announce the release of a new free ebook: Practical Firebird Performance Diagnostics: A Structured Approach Unlike traditional performance tuning guides, this ebook focuses on the reasoning behind successful diagnostics. It introduces a structured framework that helps Firebird professionals move from observed symptoms to defensible explanations by classifying problems, selecting appropriate investigation strategies, interpreting evidence correctly, and using diagnostic tools with purpose. The book covers the complete diagnostic process, from understanding why investigations fail to interpreting monitoring tables, trace sessions, profiler output, gstat reports, operating system metrics, and modern hardware behavior in the context of Firebird performance. Whether you’re a database administrator, developer, consultant, or support engineer, this ebook provides a practical methodology for approaching complex performance problems with greater confidence and consistency. The book is available for free from IBPhoenix store. Happy reading!

  • 1 июн.1 27372

    Release 2.7.10 of ibx4Lazarus https://github.com/MWASoftware/ibx4lazarus/releases/tag/R2-7-10

  • 7 мая1 62451

    https://firebirdsql.org/en/news/new-firebird-docker-images-and-update-for-1-step-firebird-linux-installation-scripts

  • 7 мая1 41862

    Release 2.7.9 of IBX for Lazarus https://github.com/MWASoftware/ibx4lazarus/releases/tag/R2-7-9

  • 28 апр.1 401111

    New Firebird Docker Images : The Official firebirdsql/firebird Docker images have just shipped a major overhaul. https://groups.google.com/g/firebird-general/c/5gPXXp7m1aM

  • 26 апр.1 26872

    Flamerobin 26.4.0 This update focuses heavily on UI responsiveness, workflow automation, and a significant expansion for macOS users. Key improvements include better handling of large datasets and several quality-of-life enhancements for database registration and management. Switched to Year.Month.Version releases https://github.com/mariuz/flamerobin/releases/tag/26.4.0

  • 24 апр.1 21053

    Pre-release Firebird Docker Images -- Now with Firebird 6 Snapshot (For testing Not Production) https://groups.google.com/g/firebird-general/c/KefyO0KWKE4

  • 24 апр.1 20852

    FlameRobin 0.9.16 released focuses on: modernizing CI/build tooling (Linux + macOS), fixing compiler/linker issues (notably around newer wxWidgets/Clang), improving packaging (Flatpak), and delivering a substantial set of Firebird metadata/DDL extraction and SQL editor correctness improvements—especially for newer Firebird versions. https://github.com/mariuz/flamerobin/releases/tag/0.9.16

  • 17 апр.1 02391

    New releases, update asap! https://firebirdsql.org/en/news/firebird-5-0-4-4-0-7-and-3-0-14-sub-releases-are-available

  • Important Firebird releases are coming, stay tuned!

  • 16 апр.1 08741

    We’re happy to share the Firebird ODBC Driver v3.5.0-rc1 release candidate, published on April 11, 2026. This RC focuses on improved Windows/ARM64 support, modernized build and CI tooling, installer updates, and a number of compatibility and correctness fixes. https://www.firebirdnews.org/firebird-odbc-driver-v3-5-0-rc1-release-candidate-is-out/

  • 1 апр.1 27475

    PSFirebird - A PowerShell module for managing Firebird database environments, databases, and utilities on Windows and Linux. https://github.com/fdcastel/PSFirebird