loading...

Discussion on: Why Use PostgreSQL functions for your application development

Collapse
buinauskas profile image
Evaldas

So it makes very much sense to use Modern SQL, such as PostgreSQL implementation for your entire application backend logic.

Bold statement. We've currently got all the business logic in SQL and it's a nightmare.

Collapse
vbilopav profile image
vbilopav Author

Just imagine how it would be without it.

Collapse
emh333 profile image
Ethan Hampton

I agree with this. Currently I am trying to untangle an old .NET framework backend from an old Microsoft SQL server. There are a ton of stored procedures that the old code relied on for business logic, but there isn't an easy way to keep those version controlled or even know what code uses what stored procedures. As a result of the mayhem, all new SQL I write is version controlled in the source code and doesn't touch stored procedures. It just keeps things simpler because Visual Studio can tell me exactly how many references a string of SQL has and where they are (This seems clunky to me so I am trying to find a different place to store queries).

I think that there is a balance of what should be in SQL and what should be in another language. I like this article overall though because I think it is important not to ignore SQL and SQL functions are absolutely perfect for certain applications

Collapse
arunschirps profile image
Arun

There is a way to keep them version controlled. Visual Studio has SQL Database Project option.

Thread Thread
vbilopav profile image
vbilopav Author

Yeah, Visual Studio has SQL Database Project is very much underappreciated gem... wel, you just gave me an idea ;)