Project

General

Profile

Actions

User story #202

closed

Store inventory revision in RDBMS

Added by François ARMAND about 14 years ago. Updated about 9 years ago.

Status:
Rejected
Priority:
4
Assignee:
-
Category:
Web - Nodes & inventories
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

Description

For now, LDIF's inventory revisions are stored in the FS, in a at most naive way.
Store them in PostgreSQL

Actions #1

Updated by François ARMAND about 14 years ago

Of course, we will have to be a little smart about how to store them.

Most of the time, new revision of an inventory will be >90% the same the previous one.
As we inherently deals with trees, that make us think to Zippers (i.e http://scienceblogs.com/goodmath/2010/01/zippers_making_functional_upda.php)

At least, we should tar ldif (I believe that PostreSQL is able to make that automatically), and to not copy diff when not updated (so, two table: one [server uuid ; datetime ; ldif id], and one other [ldif id, ldif content] so that several (server uuid, datetime) are allowed to point to the same ldif content)

Actions #2

Updated by François ARMAND over 13 years ago

  • Project changed from 2 to 20
Actions #3

Updated by François ARMAND over 12 years ago

  • Target version set to 24
Actions #4

Updated by Jonathan CLARKE almost 12 years ago

  • Target version changed from 24 to Ideas (not version specific)
Actions #5

Updated by François ARMAND over 9 years ago

Actually, we don't store inventory revision at all nowadays, and if we were starting to do so, we certainly won't do it in LDIF, nor in the database.

So closing that one as "you were relevant 5 years ago, not today"

Actions #6

Updated by François ARMAND over 9 years ago

  • Status changed from New to Rejected
Actions #7

Updated by Benoît PECCATTE about 9 years ago

  • Project changed from 20 to Rudder
  • Category set to Web - Nodes & inventories
Actions

Also available in: Atom PDF