Questions tagged [database-development]
The database-development tag has no summary.
109 questions
2
votes
1
answer
437
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
1
vote
1
answer
334
views
An effective database migration pattern for many instances of the same app over a long period of time
How do you handle migrations to your database after a long period of time?
I'm using fluent migrator, and after some months or years, the number of migrations could be (and has been in previous ...
- 144
0
votes
1
answer
597
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
-2
votes
2
answers
190
views
Database Structure for The Best Efficiency
I want a database table that can hold all of the group chat messages from all of the group chats.
The max amount of users per group chat would be 20.
The max amount of group chats per user would 25-...
- 39
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
-1
votes
1
answer
143
views
As a client; how to present database needs to perspective designers?
[I am preparing to solicit proposals for database/project management software design. I know that the quality of the final product will depend on how clearly and completely I can organize and explain ...
- 27
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
6
votes
2
answers
366
views
How do services distribute their servers around the globe while maintaining their whole dataset intact?
I've always been curious on how services such as google/youtube have multiple datacenters across the globe to serve requests faster to users while keeping their whole dataset structure intact. There ...
- 251
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
-1
votes
4
answers
489
views
Proper development workflow for fullstack app with multiple developers?
Say that I am developing a web application that has the following structure:
An SPA web frontend (angular in my case)
Postgresql database with:
A bunch of initial data in CSV's and JSON's that need to ...
- 288
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 ...
0
votes
1
answer
2k
views
ER Diagram in Barker Notation
I engineered an ERD diagram using Barker's notation.
The problem was to make a database for system of water pipes where one node is connected to another using a section (pipe), each node can have ...
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
4
votes
1
answer
600
views
How to ease the pain of lack of diffs when using database migrations?
The pain that I've often felt when creating database migration files, is best described in this Speakerdeck: Sane Database Change Management with Sqitch.
Paste entire function to new "up" script
...
0
votes
2
answers
92
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