Questions tagged [stored-procedures]
The stored-procedures tag has no summary.
62 questions
0 votes
1 answer
537 views
How can I trace back the original table of a column?
New to a software engeneer job and I am kinda blocked on the way to go with my new project To explain this in a scheme. I have a source of data in a custom app that is for most part of the time the ...
- 111
12 votes
5 answers
7k views
What is the best practice about microservice architecture for consuming many stored procedures in the same database?
I have to build a micro service for my company, the backend is an Oracle database, but the micro service must consume five (5) stored procedures that already exist in the database (as shown in the ...
- 139
3 votes
5 answers
8k views
How to do versioning for stored procedure?
Is there any way to create versioning for stored procedures? I have created an API which fetches data from a database using stored procedures. This API is being consumed from a mobile app. I released ...
- 177
1 vote
1 answer
298 views
Multiple stored procedures or 1 with parameter
I need some advice... I started working at a financial business world recently. Looks like the DB architect uses auto generate function to create stored procs. At the end, we have way too many procs ...
- 13
-1 votes
1 answer
90 views
Single Stored Procedure Per Table Update or Per Column Update
Let's say i have a table (in a large enterprise application) that has about 10 columns. I am limiting any consumer access to the table to only be possible by calling stored procedures. When it comes ...
- 9
3 votes
2 answers
5k views
DDD: should entity method use repository for stored procedures (not CRUD)?
Imagine you have a Vehicle entity in your domain model. Vehicle entity has Reserve method that put vehicle in "reserved" state and do another stuff. But Reserve method have to do some checking first ...
5 votes
3 answers
1k views
Stored procedures or ORM in web?
I am working in a Peruvian company that develops desktop accounting software(.net C#). We have many clients (companies) each customer can create several companies, in addition there is a new database ...
7 votes
1 answer
2k views
Determining the best way(s) of adding unit tests to a large project that makes good use of stored procedures
We work on a fairly large casino/gaming/wallet/lottery platform. It's a turn-key application that is currently in use by 4 clients, and soon to be much more. I've made some bullet points regarding the ...
- 269