sirix

SirixDB is an an embeddable, bitemporal, append-only database system and event store, storing immutable lightweight snapshots. It keeps the full history of each resource. Every commit stores a space-efficient snapshot through structural sharing. It is log-structured and never overwrites data. SirixDB uses a novel page-level versioning approach. (by sirixdb)

Sirix Alternatives

Similar projects and alternatives to sirix

  1. Appwrite

    598 sirix VS Appwrite

    Build like a team of hundreds_

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. Pandas

    426 sirix VS Pandas

    Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more

  4. Ansible

    411 sirix VS Ansible

    Ansible is a radically simple IT automation platform that makes your applications and systems easier to deploy and maintain. Automate everything from code deployment to network configuration to cloud management, in a language that approaches plain English, using SSH, with no agents to install on remote systems. https://docs.ansible.com.

  5. jq

    306 sirix VS jq

    Discontinued Command-line JSON processor [Moved to: https://github.com/jqlang/jq] (by stedolan)

  6. nushell

    232 sirix VS nushell

    A new type of shell

  7. gron

    68 sirix VS gron

    Make JSON greppable!

  8. miller

    67 sirix VS miller

    Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

  9. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  10. sqlglot

    62 sirix VS sqlglot

    Python SQL Parser and Transpiler

  11. fx

    60 sirix VS fx

    Terminal JSON viewer & processor

  12. dasel

    46 sirix VS dasel

    Select, put and delete data from JSON, TOML, YAML, XML and CSV files with a single tool. Supports conversion between formats and can be used as a Go package.

  13. matplotlib

    39 sirix VS matplotlib

    matplotlib: plotting with Python

  14. brackit

    Query processor with proven optimizations, ready to use for your JSON store to query semi-structured data with JSONiq. Can also be used as an ad-hoc in-memory query processor.

  15. JRuby

    26 sirix VS JRuby

    JRuby, an implementation of Ruby on the JVM

  16. super

    16 sirix VS super

    An analytics database that puts JSON and relational tables on equal footing

  17. go-mysql-server

    A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.

  18. jfq

    21 sirix VS jfq

    JSONata on the command line

  19. keycloak-theme-sample

    Sample Keycloak Theme

  20. resuminator

    4 sirix VS resuminator

    Build beautiful single-page resumes; without the hassle! The easiest resume-builder out there with intuitive drag-n-drop & WYSIWYG editor

  21. keycloak-kafka

    Keycloak module to produce events to kafka

  22. CXXGraph

    Header-Only C++ Library for Graph Representation and Algorithms

  23. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better sirix alternative or higher similarity.

sirix discussion

Log in or Post with

sirix reviews and mentions

Posts with mentions or reviews of sirix. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-01-24.
  • Show HN: Integer Map Data Structure
    3 projects | news.ycombinator.com | 24 Jan 2024
    We're using a similar trie structure as the main document (node) index in SirixDB[1]. Lately, I got some inspiration for different page-sizes based on the ART and HAMT basically for the rightmost inner pages (as the node-IDs are generated by a simple sequence generator and thus also all inner pages (we call them IndirectPage) except for the rightmost are fully occupied (the tree height is adapted dynamically depending on the size of the stored data. Currently, always 1024 references are stored to indirect child pages, but I'll experiment with smaller sized, as the inner nodes are simply copied for each new revision, whereas the leaf pages storing the actual data are versioned themselfes with a novel sliding snapshot algorithm.

    You can simply compute from a unique nodeId each data is assigned (64bit) the page and reference to traverse on each level in the trie through some bit shifting.

    [1] https://github.com/sirixdb/sirix

  • Endatabas: A SQLite-inspired, SQL document database with full history
    3 projects | news.ycombinator.com | 1 Dec 2023
    I'm working on something similar for the JVM, however with no document semantics, but on a much more fine granular level.

    JSON is shredded during an initial import into a tree structure with fine granular nodes. Thus, an import can be done with very low memory consumption (permitted that auto-commit issues a sync to disk before RAM space is exceeded). Furthermore, it doesn't require a WAL for consistency. Instead the indexes are stored in a log-structure using a persistent tree (as in every commit creates a new tree root). A sliding snapshot algorithm makes sure, that only a fragment of a page has to be copied on a write.

    As thus, it's also a perfect candidate for an event store, storing both the (lightweight) snapshots and tracking the changes optionally.

    https://github.com/sirixdb/sirix

    The architecture is described over here:

    https://sirix.io/docs/concepts.html

    Furthermore I'm working on a tutorial for a local client usage (work in progress):

    https://sirix.io/docs/jsoniq-tutorial.html

    Kind regards

  • Show HN: Bitemporal, Binary JSON Based DBS and Event Store
    6 projects | news.ycombinator.com | 13 Nov 2023
    If anyone is up to building a new frontend, that would be awesome (of course, work could also be split between interested people) :-)

    https://github.com/sirixdb/sirix/issues/627

  • Show HN: Light implementation of Event Sourcing using PostgreSQL as event store
    9 projects | news.ycombinator.com | 31 Oct 2023
    I'm working on an append-only (immutable) (bi)temporal DBS[1] in my spare time, which transforms CRUD operations into an event store, automatically providing an audit log for each stored node, while the nodes are stored with immutable node-IDs, which never change. As the contents stored are based on a custom binary JSON format also a rolling hash can optionally be built, to check if a whole subtree has changed or not.

    The system uses persistent index data structures to share unchanged pages between revisions.

    The intermittant snapshots are omitted. Rather the snapshot is spread over several revisions, applying a sliding snapshot algorithm on the data pages (thus, avoiding write peaks, while at max a predefined number of page fragments has to be read in parallel to reconstruct a page in-memory).

    [1] https://sirix.io | https://sirix.io/docs/concepts.html

  • Show HN: Evolutionary (binary) JSON data store (full immutable revision history)
    3 projects | news.ycombinator.com | 21 Oct 2023
  • Evolutionary, JSON data store (keeping the full revision history)
    3 projects | news.ycombinator.com | 20 Oct 2023
  • Immutable Data
    2 projects | news.ycombinator.com | 26 Jun 2023
    You can use Datomic for instance (mentioned already in your article IIRC!?) or SirixDB[1] on sich I'm working in my spare time.

    The idea is an indexed append-only log-structure and to use a functional tree structure (sharing unchanged nodes between revisions) plus a novel algorithm to balance incremental and full dumps of database pages using a sliding window instead.

    [1] https://sirix.io | https://github.com/sirixdb/sirix

  • Java opensource projects that need help from community.
    13 projects | /r/java | 20 May 2023
    Append-only database system (based on a persistent inddx structure): https://github.com/sirixdb/sirix or a retargetable query compiler https://github.com/sirixdb/brackit
  • Looking to help out on some open source projects
    4 projects | /r/opensource | 17 Apr 2023
    You can work on a temporal data store called SirixDB: https://github.com/sirixdb/sirix
  • SirixDB - an embeddable, evolutionary database system
    2 projects | /r/java | 3 Apr 2023
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 24 Jun 2025
    InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now. Learn more →

Stats

Basic sirix repo stats
44
1,151
7.0
20 days ago

Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com

Did you know that Roff is
the 75th most popular programming language
based on number of references?