Questions tagged [database-development]
The database-development tag has no summary.
109 questions
2 votes
1 answer
430 views
Does it make sense to use a graph database (Neo4j) for a diagramming app?
I am developing a diagramming application and want to optimize operations with the Nodes and Relations of the diagram. Currently, I am using a relational database with tables for diagrams and nodes. ...
- 29
0 votes
1 answer
590 views
Developing a database: How to keep track of log files
I am building a database, and have implemented a transaction log system to ensure that writes are atomic, idempotent & consistent. When a transaction is 'committed' it is appended to a log file ...
- 103
1 vote
1 answer
122 views
How do I store reported comments/photos in firestore?
I want to learn firestore and to this end I created small project which replicates instagram. Not all functionalities of course, just the very basics - photo sharing, comments and the possibility to ...
- 111
0 votes
0 answers
72 views
What is best approach to designing a local-to-cloud cloud-to-local Infrastructure?
I plan to have a cloud web application(CWA) and several local web application(LWA), let's assume 3 LWAs and 1 CWA. CWA === LWA. This web application would consist of a database server, file storage ...
- 109
1 vote
2 answers
198 views
When placing an order in a shop, should a snapshop be taken of the products in an order also?
...to prevent messing up with data updates, such as prices, titles, of the products that are placed in an order. Namely, a customer buys 3 items: for $5, $10 and $33 and pays for them. All is well. ...
- 31
2 votes
4 answers
1k views
What's the best way to save/track change requests on multiple objects in a database?
I have a schema containing contracts, sub-contracts, services offered by each of those, and sub-services. I also have an application that allows me to extend the duration of the contract and to modify ...
53 votes
8 answers
15k views
Is domain driven design an anti-SQL pattern?
I am diving in the domain driven design (DDD) and while I go more deeply in it there are some things that I don't get. As I understand it, a main point is to split the Domain Logic (Business Logic) ...
- 684
0 votes
2 answers
91 views
Will introducing a long standing Dev branch create unnecessary maintenance overhead?
I am seeing bad practices occurring in our version control where my colleagues are creating their own versioning system with stored procedures so that they can compare results before/after changes and ...
- 245