Re: [PERFORM] Should I generate strings in Postgres of Python?

2016-10-18 Thread Sam Gendler
This strikes me as something that shouldn't matter in the vast majority of applications. Putting a bunch of logic for rendering an application-specific format of your data in prepared statements or stored procedures in your database violates the separation of concerns that most folks like to mainta

[PERFORM] Should I generate strings in Postgres of Python?

2016-10-18 Thread Bobby Mozumder
How fast is Postgres's string concatenation in comparison to the various Python string concatenation? I'm using PREPARE statements for my SELECT queries for my web server. I'm wondering if I should just generate my JSON API (or even HTML) strings in Postgres directly, instead of in Python. Th