Hacker News Reader

I think it really depends on the project. Stored procs are really nice for a lot of different use-cases, but one major downside is that they can be challenging to version control.

Storing this sort of stuff outside of the database with the Python project itself would make version control trivially easy.

View on HN

Why are stored procs hard to version control?

They're just text in a text file.

Almost, but not exactly. If you import a Python file you get exactly what's in that file. A stored proc is not tied to a file- you can change the file and forget to update the proc, or change the proc without updating the file.

That's true. I've never attempted to keep procs in VC, but I think it would be pretty easy if you wanted to.

Reply on news.ycombinator.com