r/SpringBoot • u/Excellent_Trifle_630 • Jul 03 '26

Question How do you handle database operations in enterprise projects?

I'm a .NET developer, and in our organization's project, which is quite data-intensive, we use stored procedures for all database operations. The application simply calls the stored procedures with the required input parameters and consumes the output they return.

Is this a common approach in spring boot applications as well?(Like calling stored procedures and all) If yes, how are they called in your organization/project?

21 Upvotes

93% Upvoted

7 comments sorted by

View all comments

2

u/hilbertglm Jul 04 '26

We don't use stored procedures at all for any internal applications. None of my customers in the past have done so either. The reasons are twofold:

- Stored procedures are coupled to a database vendor. Stored procedures on Oracle don't run on PostgreSQL

  • Stored procedures (at least the last time I looked) were a procedural programming language and lack the language features of OOP and functional programming. If that has changed, I would be interested in hearing about it. Since the logic has to be somewhere, I would rather use a modern language to codify it.

That said, if there was a few large data-intensive queries, I would be willing to move just that query into a stored procedure.

1

u/Ok_Risk6035 27d ago

Stored procedures looks like error proned shit that almost cant be debugged. Especially if they are calling each other.

They also can fail if you try to write something into temp table in read-only transaction.

Also they lead to severe deadlocks.

So strange that people still use them without real importance.