Records: Python library for making raw SQL queries to Postgres databases

Re:Records: Python library for making raw SQL queries to Pos... by ForHackernews on Sunday February 07, 2016 @02:06PM (#11054228)

> Why would you want to switch databases when you deploy? That's asking for bugs that only get revealed in production.

Only if you deploy directly to production!

Any competent organization should have at least a staging environment (and probably some other pre-staging testing environments) where you deploy and run your full application stack, and only promoted verified builds to production after they pass QA on earlier environments.

[ Parent | on HN ]

Re:Records: Python library for making raw SQL queries to Pos... by ta0967 on Sunday February 07, 2016 @02:54PM (#11054492)

the top-level comment in this thread praises SQLAlchemy for being "cross-database, so you can use the same code with SQLite for development, and deploy to MySQL or Postgres.", and your parent just says that's a recipe for disaster.

[ Parent | on HN ]

Re:Records: Python library for making raw SQL queries to Pos... by ForHackernews on Sunday February 07, 2016 @03:52PM (#11054775)

It's pretty common to run SQLite on your local machine while developing. Apparently the parent is confused by reading "deploy" as "deploy directly to production".

[ Parent | on HN ]