Move database from SQLite to Amazon RDS to make it more reliable

WebThingsIO / registration_server

The registration server for WebThings Gateway.

Mozilla Public License 2.0

79 stars 33 forks source link

Move database from SQLite to Amazon RDS to make it more reliable #39

Closed andrenatal closed 6 years ago

andrenatal commented 6 years ago

I think this is very important, we are currently relying on a flat file and use a more reliable db would be a wise decision. @mrstegeman Could you take a look on this, please?

mrstegeman commented 6 years ago

Amazon Aurora looks promising. Should be able to use a standard mysql library to connect, such as: https://github.com/blackbeam/rust-mysql-simple

andrenatal commented 6 years ago

That's very cool!

mrstegeman commented 6 years ago

Done! Databases are now using Amazon Aurora MySQL.

andrenatal commented 6 years ago

Very nice @mrstegeman! Thanks for that!