All Questions
Tagged with database-design design-patterns
78
questions
-1
votes
1
answer
153
views
Would it be a good design to have multiple repositories for one entity?
I am working on a project. I have designed the codebase all the way from the scratch. Basic thing is the project is divided in individual modules. The modules represent one complete part of a business ...
2
votes
2
answers
240
views
How to design fault-tolerant distributed "all-or-nothing" system?
I have a system where Client(C) sends request to Server(S0). S0 then sends the response back to Client that "request received" and closes the connection. C can regularly poll S0 to check on ...
1
vote
3
answers
1k
views
Storing count of child rows in parent table
I have two tables, parent and child. Parents can "have" multiple children—in our case they are related through a third table, parent_child_mapping rather than the child storing its parent id ...
1
vote
0
answers
431
views
Design MySQL database to store user workout data for Workout App
I am building a fitness app and I'm trying to figure out the optimal way to store the data is a MySQL database.
I would like to have specific programs (for example, 'get jacked'), I would like a users ...
-2
votes
2
answers
202
views
How can we implement an incremental naming system?
Just like how Mac or Windows gives incremental names to new folders, how can we implement such a system in a database?
Let's say I have currently 3 folders (default names) i.e., "untitled folder&...
0
votes
1
answer
181
views
Best practice or patterns to couple complex custom objects to custom logic
In many project that grow more complex at a certain moment business rule editors, workflow editors, custom taxonomies and such enter the arena.
In all of these a coupling is made between a complex ...
-1
votes
1
answer
694
views
Design pattern to sync local databases with the cloud [closed]
I would like to find the best way to solve the following problem:
I need a database for a software. The software needs to use the data to populate the UI and allow the user to interact with them (edit,...
2
votes
1
answer
681
views
What would the database schema look like for a Entity Component System architecture of web app?
I found previous SE questions like this.
I'm familiar with the typical RDBMS backed MVC web app framework. To illustrate what I am thinking of, let's use the examples of Bunny and Carrot from this [...
1
vote
1
answer
450
views
What design pattern to implement notifications for a .NET application?
I have an ASP .NET web application dashboard that is used to send notifications to several .NET desktop clients. The current implementation is that the web app writes the new notification to a ...
-4
votes
1
answer
332
views
Design a login system
I have a task of designing login system with the requirement below:
If the user login over three times, lock account for the first 5 minutes. The next failed 3 times login-in will lock the user ...
0
votes
1
answer
64
views
Pipeline's outputted data mirroring pipeline's architecture
I'm building a pipeline that scrapes data on entities, to keep things generic, let's call them Widgets. Data on Widgets is currently unorganized and spread across various sources, including source ...
0
votes
1
answer
616
views
How does a database update trigger a notification to application layer?
Application component 1(ap1) record/insert/update a new state in graph database(neo4j)
For every new state change in the database, application component 2(ap2) needs to be informed/notified that a new ...
-4
votes
1
answer
97
views
Name of design pattern where type and instance classes are mirrored
I have used this design pattern in several entity-component designs. Now I want to introduce it to my team:
It concerns a type-of relationship, where the instance structure and the type structure are ...
-2
votes
2
answers
131
views
Dependency of program code on specific database values
I have two approaches to solving a problem but I don't know which one is better.
I will give a simplified example.
First approach
The database will look like this:
color |
--------
FFFFFF |
0000FF ...
-2
votes
1
answer
736
views
Adding unstructured data to a relational database (PostgreSQL)
I'm building a project and I only know the MERN stack. Everywhere I see the general consensus is that Mongo is not good and should only be used in very specific use cases. More importantly, I also ...