search

pa-w / nodejsotrbot

1 stars 11 forks source link

Let's talk about production readiness #4

Open n8fr8 opened 7 years ago

n8fr8 commented 7 years ago

What do we need to consider regarding scalability? We are only talking about 1000s of users right now, so the bar is low, but we should be ready for more.

Could we run multiple ractive front-ends, connected to a shared persistence server/db?

pa-w commented 7 years ago

So, I am thinking on adding a "bots" table in SQLite that defines all the bots we have that use that SQLite instance, the columns would be, for XMPP bots: username, pwd, brainPath (rivescript directory for that particular bot)

Then, with this schema we can have another table with users data, something like bot_id, username, and a JSON field with the user's data.

This would allow us to add bots quite easily and maintain coding tasks to a minimum.