SQLite made Simple

SQLite is a fast, popular and easy to use database. Its speed and easy of use make it a practical choice for use when you need an indexed file system for an app. Databases you create can be accessed, without change, on any platform SQLite supports. Using the SQLite (WASM) library, it is usable on almost all platforms and browsers.

• Your app can create, update and delete SQLite databases.
• Databases are kept in your app's localStorage.
• Apps cannot access each other's data for security purposes.
• The exception is apps which are loaded from the same server.
• Databases cannot be directly imported or exported, once again, for security reasons. You can include an SQLite database with your app.
• Databases can be imported or exported using SqlExport and SqlImport.

We will go in depth on SQLite in the next Section.

The maximum size of an SQLite database varies by OS and device. It is limited by the maximum size of localStorage, generally about 5 or 10 megs.