Clojurians Log v2
Clojure programming
Channels
Apps
datahike
erre lin 2025-08-26T13:24:07.799599Z
Hi all I have a question regarding db tables: Is it recommended and a common practice that only one table is created with various schemas? It seems if Iām going to use several tables I need to maintain a db connection for each table. Which sounds not a good idea. What would you suggest for completely unrelated data: Multiple tables (with multiple conns) or one table for everything?
timo 2025-08-27T09:53:23.393469Z
ššÆ
2025-08-26T19:23:34.802629Z
generally Datomic-likes, including Datahike, store all the data for some system in one connection. there's no "tables" in this model - every entity is a sibling of every other entity in that database. (Datahike can use SQL tables under the hood to store a database, but that's just plumbing.)
2025-08-26T19:28:37.638399Z
in SQL, customers, orders and inventory items are all stored in separate tables. in Datahike, they're all entities in one DB, and the only way to tell which is which is based on what attributes an entity has.
if it has :customer/name and so on, then it's a customer.
erre lin 2025-08-27T01:45:50.958139Z
Thank you Braden. Now I see the whole picture more clearly. š