All Questions
Tagged with database-design database-development
38
questions
1
vote
1
answer
88
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. ...
- 19
0
votes
1
answer
333
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
158
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
107
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
132
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
1
vote
2
answers
165
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
865
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 ...
52
votes
8
answers
14k
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) ...
- 674
1
vote
1
answer
690
views
Best way to model pricelist per customer for products in webshop
I am making a b2b-webshop system that will have multiple customers. Each customer will have a separate active pricelist which contains the products that they can buy and the prices that applies for ...
- 139
-1
votes
2
answers
85
views
The challenges of removing/modifying entries from a database located in persistent storage
I'm implementing my own simple database with disk storage, and I'm not sure how to go about modifying and deleting entries.
The problem is that as you delete a record from arbitrary position within ...
- 284
0
votes
3
answers
314
views
How to associate one type with another in multiple contexts?
An application has types Game (and other business units) and Message.
(Message is not a simple class with text, but a composition of a variable number of blocks like texts, images, and videos).
...
- 41
1
vote
1
answer
57
views
Imagers for a product in Internet Store -- one to many or many to many?
I'm creating a database schema for a internet store and I wonder how to better create the tables "images" and "products". A simpler way will be to have it as one_to_many, that is:
images(....., ...
- 19
-7
votes
1
answer
657
views
Where should I store data related to UI/presentation?
Say, I have a table Categories. On a page I have a header and for each category the colour of a header varies.
A colour is of the presentation level and I've heard that what's related to the UI/...
- 75
-1
votes
2
answers
63
views
A single field or 2 fields for "description" and "content" of Article?
Say, I want to create a db schema for a blog. So far I've used 2 separate fields for "description" and "content" of Article. But I've seen a lot that usually only a single is used for both. The "...
- 75