Hacker GitHub

← All repos

sirixdb/sirix

View on GitHub ↗ ★ 1,221 Java

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.

56 mentions on Hacker News by 9 people: 15 stories, 41 comments · first 2013-06-18 · latest 2026-07-15

Mentions per year 56 mentions · busiest year 2022 (15)
20082026
AllStoriesComments NewestTopOldest
  1. …instances, so the allocation rate was really high for parallel transactions. https://sirix.io | https://github.com/sirixdb/sirix | http://brackit.io
    comment by lichtenberger · 2025-07-01 · in Ask HN: What Are You Working On? (June 2025)
  2. …(64bit) the page and reference to traverse on each level in the trie through some bit shifting. [1] https://github.com/sirixdb/sirix
    comment by lichtenberger · 2024-01-25 · in Show HN: Integer Map Data Structure
  3. Have a look into my DB project: https://sirix.io | https://github.com/sirixdb/sirix https://sirix.io/docs/concepts.html and in progress tutorial https://sirix.io/docs/jsoniq-tutorial.html may be especially helpful. It basically turns…
    comment by lichtenberger · 2023-12-15 · in Database Fundamentals
  4. …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…
    comment by lichtenberger · 2023-12-01 · in Endatabas: A SQLite-inspired, SQL document database with full history
  5. …frontend, that would be awesome (of course, work could also be split between interested people) :-) https://github.com/sirixdb/sirix/issues/627
    comment by lichtenberger · 2023-11-14 · in Show HN: SirixDB – Bitemporal binary JSON database system and event store
  6. …It was stylized 'S' to look like a space-time light cone (or rotated infinity) . [0] https://github.com/sirixdb/sirix/pull/105
    comment by karmakaze · 2023-11-14 · in Show HN: SirixDB – Bitemporal binary JSON database system and event store
  7. Can someone (an admin) maybe add the direct link to https://github.com/sirixdb/sirix in the URL field. Totally forgot, that it's possible to add both a text and a URL ;)
    comment by lichtenberger · 2023-11-13 · in Show HN: SirixDB – Bitemporal binary JSON database system and event store
  8. …today. Good luck with the project, hope it will be (even more?) successful! [1] https://sirix.io | https://github.com/sirixdb/sirix [2] https://sirix.io/docs/concepts.html [3] https://colab.research.google.com/drive/1NNn1nwSbK6hAekzo1Yb...…
    comment by BozeWolf · 2023-11-13 · in Show HN: SirixDB – Bitemporal binary JSON database system and event store
  9. …number of page fragments has to be read in parallel to reconstruct a page in-memory). [1] https://github.com/sirixdb/sirix | https://sirix.io | https://sirix.io/docs/concepts.html
    comment by lichtenberger · 2023-10-31 · in Show HN: Light implementation of Event Sourcing using PostgreSQL as event store
  10. …incremental and full dumps of database pages using a sliding window instead. [1] https://sirix.io | https://github.com/sirixdb/sirix
    comment by lichtenberger · 2023-06-26 · in Immutable Data (2015)
  11. …:-) Kind regards Johannes [1] https://github.com/JohannesLichtenberger/master-thesis/blob/... [2] https://github.com/sirixdb/sirix [3] https://github.com/sirixdb/sirix/tree/master/bundles/sirix-c... [4]…
    comment by lichtenberger · 2022-07-30 · in Semantic Diff for SQL
  12. …plus nodes which fall out of the sliding window (therefore it needs a fast random-read drive). [1] https://github.com/sirixdb/sirix
    comment by lichtenberger · 2022-06-23 · in Dolt is Git for Data
  13. …and serialized during a commit, admittedly for large JSON instances (a few Gb and much more). [1] https://github.com/sirixdb/sirix
    comment by lichtenberger · 2022-05-10 · in What Is JSON Patch?
  14. …By revision number: jn:doc('mycol.jn','mydoc.jn',5) And a view of an outdated frontend: https://github.com/sirixdb/sirix/raw/master/Screenshot%20fro...
    comment by lichtenberger · 2022-04-26 · in Zq: An easier and faster alternative to jq
  15. This is precisely what https://github.com/sirixdb/sirix does. A resource in a database is stored in a huge persistent structure of index pages. The main index is a trie, which indexes revision numbers. The leaf nodes of this trie are…
    comment by lichtenberger · 2022-03-10 · in Postgres Auditing in 150 lines of SQL
  16. As posted in another comment that's basically what https://github.com/sirixdb/sirix supports along with easily reconstructing former revisions of a JSON document (or any node therein), sophisticated secondary (also versioned) indexes,…
    comment by lichtenberger · 2022-03-09 · in Postgres Auditing in 150 lines of SQL
  17. …they are furthermore compressed and in the future might be encrypted. [1] https://sirix.io | https://github.com/sirixdb/sirix
    comment by lichtenberger · 2022-03-09 · in Postgres Auditing in 150 lines of SQL
  18. …approaches, of course). Kind regards Johannes [1] http://brackit.io [2] https://sirix.io | https://github.com/sirixdb/sirix [3] https://colab.research.google.com/drive/19eC-UfJVm_gCjY--koO ...
    comment by lichtenberger · 2022-03-04 · in Show HN: Brackit – Separating Key Concerns in JSON Query Processing
  19. …approaches, of course). Kind regards Johannes [1] http://brackit.io [2] https://sirix.io | https://github.com/sirixdb/sirix [3] https://colab.research.google.com/drive/19eC-UfJVm_gCjY--koO ...
    comment by lichtenberger · 2022-03-03 · in Brackit – An alternative to JQ and JMESPath to query JSON
  20. …of course). Kind regards Johannes [1] https://github.com/sirixdb/brackit [2] https://sirix.io | https://github.com/sirixdb/sirix [3] https://colab.research.google.com/drive/19eC-UfJVm_gCjY--koO...
    comment by lichtenberger · 2022-03-02 · in Brackit: A retargetable JSONiq query engine
  21. …a better price in comparison to DRAM and SSDs than Intel Optane DC PMEM current price range. [1] https://github.com/sirixdb/sirix
    comment by lichtenberger · 2022-01-12 · in UltraRAM: 'Universal Memory' That Brings RAM-Like Speed to Non-Volatile Storage
  22. …we don't need a seperate transaction log despite an in memory cache for the single read-write trx. https://github.com/sirixdb/sirix and a query processor called Brackit for document stores based on a JSONiq like query language:…
    comment by lichtenberger · 2022-01-12 · in UltraRAM: 'Universal Memory' That Brings RAM-Like Speed to Non-Volatile Storage
  23. …all kinds of temporal query enhancements (point in time queries, time travel queries...): https://github.com/sirixdb/sirix The query engine used is developed here (core implemented by Sebastian Bächle and his tudents). Ideally the backend…
    comment by lichtenberger · 2021-11-09 · in JSONiq: JSON Query Language
  24. …come of the project. I wish the project would get some users though, that would be exciting :). https://github.com/sirixdb/sirix
    comment by foolswisdom · 2021-02-02 · in Ask HN: What is your “I don't care if this succeeds” project?
  25. …and put a lot of energy and work into a project I began to love during my time at the university: https://github.com/sirixdb/sirix I've spent so much of my spare time working on the project with some gaps since 2012 (and before under a…
    comment by lichtenberger · 2020-10-03 · in The open source paradox
  26. If you encounter spelling errors or grammatical issues, please help fixing on https://github.com/sirixdb/sirix and https://sirix.io :-) I'm no native english speaker, so I'd be very happy if people fix stuff.
    comment by lichtenberger · 2020-10-03 · in Hacktoberfest Is Now Opt-In
  27. …plus a simple cache at some point with hot data from several page fragments at least is orthogonal: https://github.com/sirixdb/sirix | https://sirix.io
    comment by lichtenberger · 2020-08-31 · in We Replaced an SSD with Storage Class Memory
  28. …give it a try :-) Any help is more than welcome. Kind regards Johannes [1] https://sirix.io and https://github.com/sirixdb/sirix
    comment by lichtenberger · 2020-06-12 · in Crux: Open-source document database with bi-temporal graph queries
  29. …types - How to best make use of modern hardware as byte-addressable NVM [1] https://sirix.io or https://github.com/sirixdb/sirix
    comment by lichtenberger · 2020-01-29 · in Ask HN: What interesting problems are you working on?
  30. …give it a try :-) Any help is more than welcome. Kind regards Johannes [1] https://sirix.io and https://github.com/sirixdb/sirix
    comment by lichtenberger · 2020-01-26 · in Umbra: an ACID-compliant database built for in-memory analytics speed
  31. …stored and kept up to date for each record/node It's already implemented in https://sirix.io / https://github.com/sirixdb/sirix I'm working on getting it stable, but help from you, the Open Source community is always needed :-)
    comment by lichtenberger · 2019-12-09 · in Show HN: Version Control for Databases
  32. …revision n. I think that way you can also version the whole database easily. https://sirix.io / https://github.com/sirixdb/sirix
    comment by lichtenberger · 2019-12-09 · in Show HN: Version Control for Databases
  33. …with keyed tries. This opens up a lot of opportunities for analysing data and its history. [1] https://github.com/sirixdb/sirix
    comment by lichtenberger · 2019-11-12 · in When your data doesn’t fit in memory: the basic techniques
  34. …just the starting point (but everything should at least work already) :-) [1] https://sirix.io and https://github.com/sirixdb/sirix [2] http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/publicatio...
    comment by lichtenberger · 2019-09-25 · in Launch HN: Quilt (YC W16) – A versioned data portal for S3
  35. …needs to be swapped atomically for consistency). For the interested reader: https://sirix.io and https://github.com/sirixdb/sirix
    comment by lichtenberger · 2019-09-24 · in Launch HN: Quilt (YC W16) – A versioned data portal for S3
  36. …think I'll use it. That said, I'm always looking for users and contributors to https://sirix.io/ or https://github.com/sirixdb/sirix . That would be super awesome, but I'm sure you have your own ideas already for using BookKeeper. I'm…
    comment by lichtenberger · 2019-09-23 · in Building a Relational Database Using Kafka
  37. Hi all, if anyone is interested, the implementation is available as Open Source software: https://github.com/sirixdb/sirix I recently wrote quiet some documentation at https://sirix.io regarding use cases, the APIs, put up a community…
    comment by lichtenberger · 2019-04-26 · in Evolutionary Tree-Structured Storage (2014) [pdf]
  38. …welcome. I'll happily answer any questions you might have. kind regards Johannes https://sirix.io https://github.com/sirixdb/sirix
    comment by lichtenberger · 2019-04-24 · in ShowHN: Query the past, do audits, compare JSON/XML;lessons learned from ZFS/Git
  39. …any questions you might have. Happy easter everyone :-) kind regards Johannes https://sirix.io https://github.com/sirixdb/sirix
    comment by lichtenberger · 2019-04-20 · in Show HN: Sirix.io – versions XML/JSON efficiently and allows time-travel queries
  40. Has anyone an idea, why Travis doesn't build with Java11 because of Mockito and how to fix it? https://github.com/sirixdb/sirix/issues/59 I've mentioned, that I guess it's a transitive dependency and has to do with the order the…
    comment by lichtenberger · 2018-12-29 · in Show HN: SirixDB – versioning through efficient snapshotting
  41. …run -t -i -p 9443:9443 sirixdb/sirix`. Any help is greatly appreciated :-) The Dockerfile used: https://github.com/sirixdb/sirix/blob/master/bundles/sirix-r...
    comment by lichtenberger · 2018-12-27 · in Show HN: SirixDB – Storing and Querying of Temporal Data (Java and Open Source)