What databases do note applications use to keep their users' notes synced across devices? The only option I keep bumping into is Pouchdb/CouchDB, but that takes me out of the AWS stack and introduces other issues and more costs.
With so many note-taking apps out there, I thought there must be a solution or a template stack. Most resources are either for a chat app with WebSockets or for toy apps without cross-device sync.
Using the subscription feature you may be able to set a trigger that if a user logs in it sends their notes from the database. Should not matter what device they are on. We used this to send automatic GPS updates to others in a GPS related game. A player would move the, the database would be updated, this would trigger a subscription service to send the new location to all other players. Worked like a dream
That would require each user having their own table to limit notifications right? cuz otherwise any user that sends something, the subscription would get triggered for everyone
Not exactly sure but you may be able to get away with a subscription table and join on ID/user. Not sure your exact use case but is pretty simple to set up and experiment with :)
are you using graphQL or DynamoDB?
From my experience, I can confirm that Elasticsearch is a highly flexible and powerful NoSql database that you can use for such purposes. It is actually used even for scenarios with much more pressure like logging systems that collect lots of logs per second. We used Elasticsearch in our company to collect logs of 90 different microservices in parallel each generating a huge amount of logs and it worked very nicely. In addition, if you want to stay with the AWS Stack, there is an Amazon service called "Amazon Elasticsearch Service" exactly for your case.