All Questions
Tagged with web-development database
68 questions
2
votes
1
answer
240
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
-2
votes
2
answers
251
views
Designing a database schema for a website related to my town's history
I am working on digitizing old photographs, articles, ephemera, etc. related to my town's history, and I've been tasked to put these scans I've made onto a website for the public to see. There are ...
- 13
1
vote
0
answers
40
views
Storing SQL for table creation
I am currently working on a small web-app stored in a monorepo and using PSQL as database (hosted on GCP). It's my first time working for a web app and I have to create a lot of tables manually such ...
- 165
0
votes
1
answer
136
views
Sync customers between shop and CRM-system (two-way)
I have a shop system that is based on a MySQL database and over which I have full control. On this system runs my synchronization plugin.
And then there is an external CRM system with a fixed API. ...
- 131
4
votes
3
answers
830
views
Why not use SQL to query an API instead of GraphQL?
nalzok posted an interesting question over a year ago: "Why not use SQL instead of GraphQL?".
Respondents seem to suggest three main problems:
One should not directly expose one's database ...
- 157
3
votes
2
answers
479
views
Storing a function body inside a database table
Let us say that for a web application, inside the source code of the app you created a function called calculateAmount. Inside the
web app, you need to call that function.
But for some reason, due ...
- 181
-4
votes
1
answer
67
views
How to create a quiz app without multiple choice?
So I'm trying to make a quiz app where the answers should be typed rather than multiple choice. However, even though there is always one right answer, in english, we have many ways of writing the same ...
- 143
1
vote
0
answers
1k
views
How to store articles (with text and images) in SQLAlchemy database
I'm working on a blog-like application with Flask and SQLAlchemy and I'm unsure how to store the blog posts (articles) in the database. These are going to contain text and images (placed between ...
2
votes
1
answer
519
views
How to handle frequent update requests to an API which is connected to the database?
In a document editing web application such as Google Docs or Evernote, sync/save has to happen almost instantaneously to make sure data loss is minimal in case of a connection failure or a client ...
- 29
43
votes
5
answers
16k
views
Why not use SQL instead of GraphQL?
Recently I learned about GraphQL which claims to be superior to RESTful. However, I started wondering why don't we simply put SQL statements into an HTTP GET request.
For example, in GraphQL I would ...
- 579
4
votes
5
answers
11k
views
How can a web app work correctly when Internet connection is lost for some hours?
Our team wants to design a Web-Based retail pharmacy management system. A web based solution is good because no user installations are needed.
Some of the data fetched from central database are read-...
- 207
0
votes
3
answers
4k
views
For what kind of websites is it ok or even better to use SQLite? [closed]
I'm familiar with the process of setting up Postgresql. And I'm also thinking of using SQLite for some of my websites for I don't need that much functionality that Postgresql offers. And I also want ...
- 85
3
votes
1
answer
159
views
Data to pre-populate a database kept in text files
Many web application require a seed file -- a file, written in the same language as a web application, where I have data to pre-populate a database. This makes sense.
Nonetheless, I sometimes see ...
- 67
-1
votes
1
answer
143
views
How to make sure I have the contract proposal approval in my system?
I am building a website and in it I am trying to follow the rbac (role-based access control) model.
Now, the thing is that managers need to send their contract proposals to approvers
(people who will ...
- 489
3
votes
1
answer
3k
views
Keeping data between two databases in sync
Let's say I have a forum application running, and I start building a separate web application with a Python web framework. Both applications use their own MySQL databases, which contain their own ...
- 47