Questions tagged [database-design]
For questions about structuring the data within a database. How to lay out tables, whether to use a relational DB or not, etc.
1,325
questions
1
vote
2
answers
65
views
How to design user-defined ordering of items?
I've got a site (here) that lets users publish labs. I'm looking at adding a feature where users can customise the order that their labs appear in. To be clear, I mean that they can manually control ...
- 1,665
1
vote
2
answers
101
views
Linking records through multiple tables?
I'm writing a game server. Similar to the Sims. Players can own furniture items they purchase from the catalog. There can also be rooms. Players can be in a room. A room can have furniture items of ...
- 167
2
votes
1
answer
148
views
What is an optimal system design for tracking product views per user that is scalable?
I have a web application that contains products and users. There are 10,000+ products and 100,000+ users to give a sense of the scale that's required.
For some application specific reasons, I need to ...
- 29
1
vote
1
answer
85
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
2
votes
1
answer
180
views
Designing a flexible and comprehensive restaurant menu database schema?
I am working on developing a MySQL database schema for a restaurant menu system inspired by platforms like DoorDash, UberEats, and Yelp. My aim is to design a schema that is flexible and can handle ...
- 145
0
votes
2
answers
191
views
Advice for database design and approach
I ask this to learn from experienced DB designers/architects. I need a high-level overview, I'm not interested in the specific tools for now. Rather, I'd like opinions on how you would approach this ...
- 41
-1
votes
1
answer
50
views
Ensuring unique indexes on nosql datastores [closed]
I am building a User Service. User would be able to register with emailId or phone no. Upon successful registration, they can choose a username (which should be unique)
It is easy to do on SQL ...
- 134
-1
votes
2
answers
102
views
Best Practices for Storing Operational Hours Extending Past Midnight in MySQL
I'm building a PHP application to manage business operating hours, including cases where the closing time extends past midnight. I'm considering various ways to store these hours in MySQL and need ...
- 145
-1
votes
1
answer
140
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 ...
0
votes
0
answers
39
views
Need advice on approaches to saving data
The following code(JSFiddle here) is a grid-based code where I'm performing the following steps:
I’m moving blue boxes from left to right (on the grid) after clicking Move Text Content! button. Here ...
- 151
0
votes
1
answer
62
views
Database Modeling for Application with Many Integrations
I’m working on an application that requires many 3rd-party integrations. I’m using Postgres to store these API responses but am having trouble for a number of reasons.
These objects are frequently ...
- 109
0
votes
1
answer
49
views
Where to store config when using a external binary in a web service?
I'm making a vpn service that can be controlled through admin web page.
So I have a web page that consists of front-end page and a backend API + DB.
In this admin web page, I can execute a vpn binary ...
- 121
0
votes
0
answers
112
views
Approach for comprehensive data/activity logging
I would like to be able to build up a log of user activities, capturing data such as who they were, where they logged in from, what activity did they take, and what data did they change (both before ...
- 275
2
votes
1
answer
122
views
Handling Back-dated Transactions and "Online" Transactions on ERP/Banking Systems
I was currently developing a PoC of a "core banking system" in my current company, a pawn shop that generally offers lending services to retail customer and deposit services. We've built a ...
- 29
0
votes
1
answer
329
views
Clarification on using timestamp without time zone and LocalDateTime in UTC-centric systems
I'm seeking clarification regarding the usage of timestamp without time zone in a database and its corresponding Java type, LocalDateTime. The current setup I'm working on involves servers and (...
user175557