Questions tagged [stored-procedures]
The stored-procedures tag has no summary.
62 questions
0
votes
1
answer
540
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
1
vote
2
answers
93
views
How to write robust or alternative to TSQL data processing routines in SqlServer?
My company has a workflow that involves ingesting huge amounts of raw data from external sources into SqlServer and then interpreting and weaving that data into our own application tables. This ...
- 587
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
0
votes
1
answer
184
views
quality management on SQL stored procedures
I've always developed my own applications and use certain criteria to evaluate if the code is acceptable from a quality perspective. Now I've switched jobs and have to among other things maintain ...
- 9
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
0
votes
1
answer
171
views
Testing Stored procedure correctness
Suppose you have 2 stored procedure, let's say a GetProducts and a GetProductDetails.
Now, the GetProducts returns a list of products with a property that is "calculated" basing on additional ...
- 85
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
8
votes
3
answers
8k
views
DB Queries in code or use Stored Procedures
Some of my colleagues tells me that using stored procedures in the database adds to much business logic in the database, and that you should keep the data separate from logic. Other colleagues tells ...
- 390
-1
votes
1
answer
91
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
1
vote
2
answers
821
views
Optimal use of hibernate with mysql's stored procedures
I am working on a project (to use as a reference). The project uses mysql, hibernate and spring (REST) and is supposed to be a single microservice.
I have come to find out that limiting user/consumer ...
- 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 ...
1
vote
2
answers
2k
views
Encrypt data in code or stored procedures?
I'm working on a Web App where the data is quite sensitive and is required to be encrypted before it is stored in the database.
Now there are two ways through which I can achieve this:
Encrypt data ...
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 ...
1
vote
2
answers
1k
views
SQL-Style name of variables in a stored procedure
As seen in the main question. It is not a syntactic problem that I have, or
some error in the code. I would like to know what is the correct way to name the parameters variables in a stored procedure....
- 19
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