5 ms·
@OP Why not dump the data into postgres rather than code the schema and transactions? I had a similar issue and postgres was a godsend.
by asimuvPR 10y ago
@OP Why not dump the data into postgres rather than code the schema and transactions? I had a similar issue and postgres was a godsend.
- brianwawok 10y agoWell he is on google cloud, which when he wrote it he used the best option. Google cloud now has cloud sql, which would likely be much better. But then he needs to code, test, and migrate.. perhaps not worth it?
- asimuvPR 10y agoYes, good points.
- bemmu 10y agoIt wouldn't be impossible, but probably less work overall just to continue to write little Python scripts for my reporting purposes.
- maxmcd 10y agoThe parent is likely referring to dumping the GAE Datastore data into a Postgres instance for reporting and other analysis. Not swapping out the primary datastore for the app. This comment elsewhere in this thread explains the strategy nicely: https://news.ycombinator.com/item?id=12613223 https://news.ycombinator.com/item?id=12613223
- brianwawok 10y agoI don't think he has the scale to require NoSQL. Cloud SQL could host his data and his reporting in a single database.