FOSS relational database with SQL and revision management to online store
I am looking for a piece of software, or combination of pieces of software, to replace Google Docs spreadsheets for certain use cases. The solution should possess the following advantages of Google Docs spreadsheets while also overcoming the following disdvantages of Google Docs spreadsheets:
Advantages
Every modification made is saved to a revision history, allowing those modifications to be compared and, if desired, rolled back (similar to the Time Machine-like AutoSave feature in Mac OS X Lion).
That revision history is stored online, so it can be accessed from any internet connected PC by anyone with appropriate software and credentials.
Capable of containing several tables ("sheets") and functions for querying/filtering the data therein.
Disadvantages
No SQL.
Closed source.
Cannot be self-hosted.
The solution I'm thinking of trying first is to use SQLite locally on a Mac OS X desktop, plus some kind of script that will recognise every command issued to SQLite that modifies the database or its contents and that commits the result, as an SQL dump, to a Git repository, with the command as the commit message, and then pushes the commit to a remote Git repository.
So my question is: has this been done before? If so, by whom (and where can I download the code)?
Alternatively, is there another, simpler way?
I am looking for a piece of software, or combination of pieces of software, to replace Google Docs spreadsheets for certain use cases. The solution should possess the following advantages of Google Docs spreadsheets while also overcoming the following disdvantages of Google Docs spreadsheets:
Advantages
Every modification made is saved to a revision history, allowing those modifications to be compared and, if desired, rolled back (similar to the Time Machine-like AutoSave feature in Mac OS X Lion).
That revision history is stored online, so it can be accessed from any internet connected PC by anyone with appropriate software and credentials.
Capable of containing several tables ("sheets") and functions for querying/filtering the data therein.
Disadvantages
No SQL.
Closed source.
Cannot be self-hosted.
The solution I'm thinking of trying first is to use SQLite locally on a Mac OS X desktop, plus some kind of script that will recognise every command issued to SQLite that modifies the database or its contents and that commits the result, as an SQL dump, to a Git repository, with the command as the commit message, and then pushes the commit to a remote Git repository.
So my question is: has this been done before? If so, by whom (and where can I download the code)?
Alternatively, is there another, simpler way?
No comments:
Post a Comment