Does SQLite work offline?

I use it in an Android Webview to store offline data and it works pretty well . The data are stored on a local database (using IndexedDB or WebSQL) if there is no internet connection available and is synchronized with a remote database (CouchDB database) when there is an available connection.

Read more

What is a local database?

Local databases reside on your local drive or on a local area network . They often have proprietary APIs for accessing the data. When they are shared by several users, they use file-based locking mechanisms. Because of this, they are sometimes called file-based databases.

Read more