SQLite persistence on Droplet

@jarajesh

Any database software that relies on the disk for storage, or has disk storage as an option, will persist through a restart including SQLite, MySQL/MariaDB/Percona, PostgeSQL, and even NoSQL based DB.

The defaults for most database software is to use disk, so there’s no special setting, you’d simply use the programming language of choice to communicate with the user & database you setup once your chosen software has been installed.

As for block storage, it’s designed to be a flexible storage medium. For instance, you can attach it to one Droplet, detach it and then reattach it to another Droplet without losing data.

You could use it to store backups, logs, or even website data, the skies the limit really. There’s really not a best use case as everyone tends to use it for their own specific needs.

@jarajesh

Each Droplet comes with it’s own set amount of storage – you don’t need to add block storage if you don’t actually have a use for it.

You can install and use SQLite on the Droplet itself and read from & write to your databases freely. As for persistence, that all depends on how you setup your SQLite database(s). As long as you choose to setup a file based database, data will persist through a restart, however, if you choose to store your database to RAM (which is an option), then you would need to flush the database to a file if you need for it to persist.