twitter-scale-mastodon VS xtdb

I get what they're trying to do but I'm not sure this [0] syntax is the answer.

[0] https://github.com/redplanetlabs/twitter-scale-mastodon/blob...

As best I can tell the Rama-awesomesauce is down in the backend modules, e.g. https://github.com/redplanetlabs/twitter-scale-mastodon/blob...

and the rest of the commentary I'll keep to my damn self

GitHub link: https://github.com/redplanetlabs/twitter-scale-mastodon

Their announcement email reads...

> We've open-sourced our Twitter-scale Mastodon implementation on our Github. The implementation is 10k lines of code, which is 100x less code than Twitter wrote to build and scale their original consumer product, which was extremely similar. This repository can easily be adapted to make any Twitter-like social network.

> The project README includes instructions for running an instance locally on your machine, which is easy to do. To help with understanding the codebase, we've left many comments throughout the code.

> Finally, our blog post from two weeks ago is a deep-dive exploration of how this codebase works

https://blog.redplanetlabs.com/2023/08/15/how-we-reduced-the...

Previous discussion: https://news.ycombinator.com/item?id=37137110

There's also this "Introducing Rama" video: https://www.youtube.com/watch?v=jcvxGvzjLHg

Would love to see something similar for XTDB - https://xtdb.com/

You don't necessarily need to embed it into the programming language itself to get a ton of value. XTDB (https://github.com/xtdb/xtdb) offer a Clojure, Java and HTTP API for interacting with the database, which is bitemporal and lets you query the database for a specific point in time for example.

XTDB is a bitemporal and dynamic relational database for SQL and Datalog, written in Clojure. The Python application I work on uses XTDB for its bitemporal and schema-less nature. There were a few Python clients that looked unmaintained and lacked some features we needed, so I tried to build something that would have fit our own requirements in hindsight. This includes:

it's bitemporal, will be SQL-compatible, and also has another query-language - XTQL :

https://github.com/xtdb/xtdb/tree/2.x/dev/xtql

You can also consider other durable Datalog options like datahike or datalevin which can work either as lib (SQLite style) or in a client-server setup; if you want to play with bi-temporality XTDB is a rock solid option with very good support and documentation.

You could look into http://xtdb.com/ if you want an open source alternative

XTDB, or Cross-Time Database, is a distributed and transactional database system designed to handle complex and changing data with ease. It is based on a bitemporal model, which allows for the tracking of both the valid time and transaction time of data, enabling powerful and flexible querying capabilities. With XTDB, developers can work with immutable data structures, which simplifies development and improves reliability. Its graph query language, Datalog, provides a powerful and expressive way to navigate relationships within the data.