#bitemporal — Public Fediverse posts

Has anyone done #bitemporal stuff with postgres 16? I understand SQL:2011 support has landed in postgres 18 but I'm hesitant about upgrading (being very conservative). I'm aware of https://github.com/scalegenius/pg_bitemporal and https://github.com/xocolatl/periods but I'm no database expert and I feel like a baby engineer dipping my toes in. What do y'all recommend?

(I don't want to use #xtdb or #datomic because I know even less about these and I want to be able to maintain what I build)

🚀🎩 Behold the "revolutionary" 6NF File Format, claiming to be #bitemporal and sixth-normal-form inspired, yet somehow manages to make XBRL look user-friendly by comparison. 🤯 Forget nested objects and arrays, because parsing is so last decade—welcome to the future, where normalization is apparently just a myth. 🤡
https://habr.com/en/articles/942516/ #6NFFileFormat #dataNormalization #techTrends #HackerNews #userExperience #HackerNews #ngated

🤡 Oh joy, another "genius" trying to blend #SQLite and #Clojure for a #bitemporal #data system because clearly, the world can't get enough of DIY database hacks. 🚀 Pro-tip: If you need a dictionary to understand your own project, maybe it's time to reconsider your life's choices. 🙄
https://www.evalapply.org/posts/poor-mans-time-oriented-data-system/index.html #DIYdatabase #databasehacks #HackerNews #ngated

Poor man's bitemporal data system in SQLite and Clojure

https://www.evalapply.org/posts/poor-mans-time-oriented-data-system/index.html

#HackerNews #Poor #bitemporal #data #system #in #SQLite #and #Clojure #bitemporaldata #SQLite #Clojure #databasetechnology #softwaredevelopment #hackernews

⏱️ Poor man's bitemporal data system in SQLite and Clojure

https://www.evalapply.org/posts/poor-mans-time-oriented-data-system/index.html

#database #software #time #bitemporal #clojure #sqlite #analytics