We want to create a view counter per post (https://my-domain.com/posts/post-title) and we want to store views per day to allow posts to be sorted by "Most popular in the last 7 days", "Most popular in the last 30 days", etc.…
I have a service built on Microservices architecture. The design includes 3 components that communicating with queues. System components: Microservice "A" gets a request and generates subrequests. Each sub-request is a queue message written to the Service "B" queue. Each…
Looking for advice on whether I can improve my database statements or if I should start caching query results to increase performance. The schema is set up as a Many-To-Many Polymorphic relationship. I have a Videos table that contains video…
Im doing a project for restaurant.so in it i need invoice tabel in database.in invoise there are multiple items like mango juice and fried rice, like wise.the amount of items are different for each bills.so how i create my in…
Good example will be shopify. Where you have N number of users (in this case each user assume site). And each user will have it's own records in DB. But db schema will be the same (same tables for each…
So I'm not sure exactly how to title this question. I am creating a database and need to store some default SEO info as follows. default page title default keywords default page description header code footer code There will never…
We are developing a site at work for the xmas/new year period where individuals can buy/sell what they want its for charity basically, look at it as a smaller version of ebay. We currently have 15 parent categories, and these…
I am working on a project that requires that we query a number of different marketplace APIs (right now its just eBay and Etsy) and store the contents in our DB - updating nightly. Ideally, we would like to mirror…
After this comment to one of my questions, I'm thinking if it is better using one database with X schemas or vice versa. I'm developing a web application where, when people register, I create (actually) a database (no, it's not…