All Questions
Tagged with database-design web-applications
31
questions
2
votes
1
answer
149
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 ...
-2
votes
1
answer
356
views
Storing a large number of user permissions [closed]
I am refactoring an old application which has about 200 user permissions.
Based on access permissions for the user, menu items for webpages will be Enabled or not.
Permissions are also checked on the ...
0
votes
2
answers
92
views
Where to sync Database and Search-Database in MVC pattern
I have a website-sideproject (Application Server: Django, Database: sqlite) with "search" functionality and I've recently stumbled over this problem.
When you have a full-text-search-...
1
vote
0
answers
371
views
Providing guest users with full accounts vs only sessions (a.k.a. guest checkout)
I'm working on a web application with JWT authentication (with token stored in cookie) and an SQL database. Upon loading, the frontend makes a request to the backend to determine whether the user is ...
3
votes
2
answers
942
views
Approach for storing lots of data of unknown type in database
I have an web app to which external applications can be connected to send their data. This is for telemetry purposes.
The web app is not controlling what kind of telemetry data is sent to it - it can ...
4
votes
1
answer
362
views
User management: third party Identity Management vs local user
Context
Let's considering a standard web application handling cars. Each car has an owner. So the car structure looks like:
cars(
id INTEGER PRIMARY KEY,
...
owner_id *???*
)
For simplicity ...
-3
votes
1
answer
225
views
Database design for online applications
I am developing an Online Application portal. But I am stuck in designing my database tables, and am unsure about the best approach to take.
Background: how the portal is supposed to work
Let me tell ...
0
votes
1
answer
209
views
How to make an server side application independent of database
We have a server-side application (in JAVA, communicates via web services) that accesses a database. If we wish to sell just the application to a customer, so that he can use his own choice of ...
4
votes
2
answers
1k
views
How to properly use a database containing common tables in a multi-application system?
I'm trying to determine the best application and database architecture for a project I am working on.
The idea is that there will be multiple, separate applications that will all share a few tables ...
0
votes
2
answers
54
views
How to track past week visits in a web app?
I am developing a newspaper-like MVC webapp with an article content type which has a visits field. The database is mysql.
Each time a visitor requests an article, the visits field of the article is ...
2
votes
2
answers
2k
views
Techniques for efficiently partitioning data in a shared multi-tenant database
I work for a franchise and am beginning the complete redesign of the application that each franchise uses to manage its daily operations. It functions as a point of sale and scheduling application. ...
2
votes
1
answer
4k
views
What is the best way to structure my web permissions tables?
I want to set up basic "permissions" for a website. It has a basic "roles" system where users are part of certain groups and get all the permissions allowed to that group. However, I need more than ...
1
vote
0
answers
63
views
Using fixtures to maintain static database assets
I have a pattern that's something like this:
Create a database model UsagePlan which stores how many usage tokens a paid customer receives in exchange for its respective monthly fee. Through my ORM (...
2
votes
4
answers
1k
views
Data first or code first?
I have seen many questions on whether to design data first or code first when designing a new application. I wonder if some have the same conclusions/ideas as me. I come from painting/digital design/...
0
votes
1
answer
286
views
RESTful way to define an API that requires two keys to return a resource
In my application, I have resource A that is super class and A1, A2 that inherits A and other properties that are specific to them. A cannot exist by itself, it must be either A1 or A2. This is a ...