Sample Header Ad - 728x90

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