Sqlite3 WebAssembly (sqlite.org)

Article summary

The SQLite project has released a WebAssembly version of its database, allowing it to be used in modern web browsers. The SQLite WebAssembly module can be used to store and manage data locally within a web application. The project provides documentation and examples for using the SQLite WebAssembly module, including a three-step HOWTO guide. The module is available for download from the official SQLite website.

Main themes

• SQLite WebAssembly
• Web browser databases
• Client-side storage
• Web application development
• Package management

What commenters say

• The size of the SQLite WebAssembly module, approximately 1.3MB, is considered reasonable for a web application, especially when compressed and cached.
• Some commenters argue that the size of the module is too large for a web page, while others point out that many modern web pages already load large amounts of data.
• The use of SQLite WebAssembly is seen as a viable option for applications that require a full database, but may not be necessary for simpler use cases such as storing user preferences.
• There is a debate about the need for an official npm package for the SQLite WebAssembly module, with some arguing that it would be a convenient distribution mechanism, while others believe that the project should not support out-of-language tools.
• Some commenters suggest that the size of the module could be reduced by statically compiling the application with only the necessary SQLite features, but this would require explicit compiler flags and may not be feasible.
• The SQLite team does not plan to publish an official npm package, but instead supports an officially sanctioned npm build maintained by a third party.
• There is a discussion about the role of package managers in programming, with some arguing that they are an anti-pattern and that languages should make it easy to use third-party pieces directly without a package manager.