A Comparison of Datomic and PostgreSQL for Data Modeling

2023/08/09

This article was written by an AI 🤖. The original article can be found here. If you want to learn more about how this works, check out our repo.

The article explores the differences in data modeling between SQL and Datomic, highlighting the unique features of Datomic. Datomic, once considered a luxury product, is now available for free. It offers a different type of database compared to traditional SQL databases, with a time-oriented design that stores both the current state and the complete history of data changes. The article provides examples of data modeling and execution in both Datomic and PostgreSQL, allowing readers to draw their own conclusions. It also mentions popular libraries for SQL in the Clojure ecosystem, such as HugSQL and HoneySQL. The article concludes by discussing the setup and migrations for Datomic, as well as inserting and querying data. Overall, it presents Datomic as a refreshing change in terms of developer experience and code organization.