The author is a technology enthusiast who explores new trends in the tech world, particularly in software engineering. They are drawn to WebAssembly (Wasm) and its practical applications, especially in web frontend development. The author wants to use Wasm to make money and has been thinking of ways to do so. They came across a discussion about combining SQLite Wasm with the Origin Private File System (OPFS) to enable persistent storage on the web frontend. OPFS is a storage endpoint that allows web apps to handle folders and files in a way that is invisible to the user, and it is highly optimized for performance. The author explains the differences between OPFS and localStorage, including data structure, storage capacity, performance, API, data types, and use cases. Despite its advantages, OPFS has limitations, such as limited browser support and difficulty in inspecting and deleting data. The author combines SQLite Wasm with OPFS to achieve data persistence entirely within the browser, which can help minimize costs for businesses. They also created a library called neverchange to wrap around SQLite Wasm + OPFS, making it easier to implement persistent storage on the web frontend. The author uses sqlc to generate code for database operations, making the development process more efficient.
dev.to
dev.to
