All Questions
Tagged with maintenance database
5 questions
0
votes
3
answers
595
views
How to safely shutdown API server?
We have an API server, which serves both of our web app and mobile app (both Android, IOS).
We have to shut down database servers sometimes for up-gradation or maintenance, so the site shows ...
- 875
4
votes
5
answers
1k
views
Should I refactor this database? How can I do it?
Firstly, some context.
I'm working in a project with more than 10 years of development and without any documentation. My task now is to create a comprehensive documentation for the database (it is a ...
- 171
3
votes
0
answers
177
views
Are there downsides to writing PDO/mysqli statements into my code directly vs using my own redirect wrapper methods?
TL;DR: To access DB functionality in my codebase I currently use a custom layer throughout the code. The layer needs an upgrade in order to begin accepting prepared statements, which it currently ...
- 8,257
52
votes
8
answers
59k
views
Should we ever delete data in a database?
I am new to databases and trying to understand the basic concepts. I have learned how to delete data in a database. But one of my friends told me that you should never delete data in a database. ...
user4124
5
votes
2
answers
722
views
GIS-based data visualization and maintenance tool
Background
Looking to leverage an existing GIS system for exploring organizational data.
Architecture
The following figure represents a high-level overview of the system's desired features:
The ...
- 743