What database should we use to store ~1000 image URLs per hour — NoSQL like Firebase/MongoDB or Redis queue + PostgreSQL?
1
vote
1
answer
62
views
We are building a system that needs to store approximately 1000 image URLs every hour, which adds up to tens of thousands per day. The images themselves are stored on cloud storage; we only need to store their URLs along with some metadata (e.g., timestamp, userId, tags).
We are considering two approaches:
1. Use a NoSQL database like Firebase Firestore or MongoDB to directly store the image URL records.
2. Send the URLs to a Redis queue first, then batch insert them into a relational database like PostgreSQL at regular intervals.
Key requirements:
Fast write performance
Scalable over time
Efficient querying by date or user
Which approach would be more suitable for this use case in terms of scalability and performance?
Are there any trade-offs or best practices we should be aware of
Asked by Mohit Gupta
(11 rep)
May 14, 2025, 07:46 AM
Last activity: May 14, 2025, 01:57 PM
Last activity: May 14, 2025, 01:57 PM