vjt | Better HN

vjt

28 karmaJoined March 13, 200913 submissions

Just another drop in the ocean.

Blabberings: http://sindro.me/.

[ my public key: https://keybase.io/vjt; my proof: https://keybase.io/vjt/sigs/C9oJJW0bFsZYR_Tb9mWMq--Fvt6IN0044sgZvoVZFYA ]

Recent submissions

Show HN: temporal extensions for PostgreSQL, with Active Record in mind (opens in new tab)

(github.com)GitHub

2vjt14y ago0

Ask HN: PG temporal schema using inheritance and the rule system

I have implemented a proof-of-concept of a SCD type 2 temporal database system (with valid-time only) using postgres' table inheritance, exclude constraints and the rule system.

I am planning to use this system as a backend for a set of Active Record classes (in a Ruby on Rails application).

The code and a quick discussion is here: https://gist.github.com/2563820

Which pitfalls am I overlooking?

Thanks,

~vjt

1vjt14y ago0