KohoVolit.eu last week

Late last night Jaroslav has posted an update on the work of KohoVolit.eu team last week. It looks like they faced a new challenge related to historical data in their system:

“There is a whole field called temporal databases in the database theory about representing data varying in time with full history not only the current state.”

According to Jaroslav translations and free attributes used by the team, together with changes in MP’s data and requests became a new challenge:

“The main issue of this week was search for a reasonable trade-of between complexity of the database and comfort in access to the history. And how to put all things together. As a result I significantly altered the schema again. I believe it suits to our needs fine now. Besides, it was an interesting trip to PostgreSQL 9 features and learning how to fully exploit its capabilities.”