Database architecture with a great number of users

24 views
Skip to first unread message

Bruno Ricci

unread,
Aug 9, 2016, 10:03:20 PM8/9/16
to PouchDB
Hello everybody

I'm new to PouchDB/couchDB and I has to build a mobile application for a large number of users

great number <=>  thousands of users

Each user should be able to consult his owned document (messages) and not documents of other users

What is the best solution to architect the database

1/ Should I use a single database with all messages and filter with the user_id
2/ Should I use a databse by user and at connection time user_A will only be able to connect to database_A

With a small number of users, I have no doubts that both approachs are possible but I don't have any figure about the maximum number of database that a single server may accept

Any  ideas ?

Thanks in advance
Reply all
Reply to author
Forward
0 new messages