On: How many lines of code is Candy Japan?

[asimuvPR]

@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 → asimuvPR]

Well 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?

[maxmcd → brianwawok]

The 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

[brianwawok → maxmcd]

I don't think he has the scale to require NoSQL. Cloud SQL could host his data and his reporting in a single database.

[bemmu → brianwawok]

It wouldn't be impossible, but probably less work overall just to continue to write little Python scripts for my reporting purposes.

[asimuvPR → brianwawok]

Yes, good points.