Re:Heroku Postgres: SQL Database-as-a-Service
by eftpotrm on Wednesday November 23, 2011 @06:07AM
(#3269624)
Not just Postgres; any database server in which you can do either stored procedures or submit arbitrary batches of SQL statements rather than just individual queries will let you do this. I routinely do in MS SQL Server, for example, and have worked on multiple projects where the ability to do this was utterly critical to overall performance.
To be perfectly honest, I'd consider any database server where I couldn't do this to be something of a toy because of the restrictions it places on overall app performance. It might be OK in SQLite or Access but a real database? Sorry, no, come back when you've finished the thing please.
Re:Heroku Postgres: SQL Database-as-a-Service
by einhverfr on Wednesday November 23, 2011 @01:39AM
(#3269074)
Indeed, you can do a fair amount of processing without even hitting stored procs in Pgsql. Plain SQL gives you tremendous power in Pg. I find stored procedures add useful semantic sugar around these, but especially with newer versions things like common table expressions, arrays of tuples, and the like, gives you tremendous power.
This is, naturally, very application-dependent.