Common mistakes in PostgreSQL

Re:Common mistakes in PostgreSQL by radiowave on Friday May 03, 2019 @03:18PM (#19821399)

Nothing to do with object orientation. We just use a lot of views, both to abstract away common complex queries, and to allow external systems to interact with the data in a controlled way.

[ Parent | on HN ]

Re:Common mistakes in PostgreSQL by gigatexal on Saturday May 04, 2019 @02:12AM (#19824758)

That makes sense actually. But stored procedures could do that too?

[ Parent | on HN ]

Re:Common mistakes in PostgreSQL by radiowave on Saturday May 04, 2019 @05:22AM (#19825368)

Yes. I tend to treat procedural code as a last resort, because pure declarative SQL is so much easier to troubleshoot.

[ Parent | on HN ]

Re:Common mistakes in PostgreSQL by gigatexal on Saturday May 04, 2019 @01:57PM (#19828043)

I guess I use stored procedures differently. I rely on SQL queries not for loops if I can help it. Sometimes it can’t be avoided if you’re doing updates in chunks for example.

[ Parent | on HN ]