All Questions
3 questions
4
votes
2
answers
8k
views
Is it okay to keep open the MySQL database connection open through out the Application or open and close connection query-wise?
I'm developing a REST API using Nodejs along with MySQL as the database.Is it okay to keep open the MySQL database connection open through out the Application or open and close connection query-wise ? ...
1
vote
1
answer
818
views
Write complex query OR write simpler queries and combine the results in Backend service?
Take the following statement for example:
'Get results for ALL Active students of a Course'.
Naturally, this query has 2 parts,
Get all active students of the course.
Get results of those active ...
- 129
2
votes
1
answer
229
views
What is the best way to maintain synchronicity between a table that has a list of another table?
I used to do Java development and with JPA, I don't really have to worry about the synchronicity between a table and the lists it owns. For those who don't understand what I mean, here's an example.
...
- 29