<< DatenBeschrieb | Index | >>
Export ChDe.xls and http://ch.oddb.org
The proposed architecture for comparing prices between ch.oddb.org and de.oddb.org is to create a standalone read-only service, which provides remote-access (from within the local network) to the data in ch.oddb.org in a separate process.
+--------------------------------------------+
| |
+-------------+ +------------------+ +---------------------+ +-------------+
| ch.oddb.org | | readonly-service |--| export-job chde.xls | | de.oddb.org |
+-------------+ +------------------+ +---------------------+ +-------------+
| | | |
+-----------------------------------+ +--------------------------------------+
| postgres db | | postgres db |
| "oddb_dot_org" | | "oddb" |
+-----------------------------------+ +--------------------------------------+
replacing the current architecture, which looks like this:
+------------------------------------------+
| |
+----------------+ +---------------------+ +-------------+
| ch.oddb.org |--| export-job chde.xls | | de.oddb.org |
+----------------+ +---------------------+ +-------------+
| | |
+----------------+ +--------------------------------------+
| postgres db | | postgres db |
| "oddb_dot_org" | | "oddb" |
+----------------+ +--------------------------------------+
Aus meiner Sicht haben wir zu keinem Zeitpunkt menschlich lesbare Daten - Excel ist binär, dann sind die Daten als (binäre) Ruby-Objekte im Memory, dann werden sie serialisiert und in die DB geschrieben - in binärer Form.
Marshalling and unmarshalling of Data can be found here: http://en.wikipedia.org/wiki/Serialization#Ruby