> but trying to save data required hosting it somewhere With the File System Access API, webpages nowadays can read and write local files just like desktop applications: https://developer.chrome.com/docs/capabilities/web-apis/file... Try this text editor for example: https://googlechromelabs.github.io/text-editor/ It works nicely on Desktop and Mobile.
Show HN: Capsule – Single-file web apps that save their data into SQLite
71–80 of 175 posts
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#72> but trying to save data required hosting it somewhere With the File System Access API, webpages nowadays can read and write local files just like desktop applications: https://developer.chrome.com/docs/capabilities/web-apis/file... Try this text editor for example: https://googlechromelabs.github.io/text-editor/ It works nicely on Desktop and Mobile.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#73Im finding a lot of success embedding metadata and data in SQLite files for music management.
Having a spec for a single file with a schema, version, metadata and binary blobs is super easy to shuffle around.
Agents crush reading and writing the data and writing tools around the spec.
All of a sudden things like backup, sharing and dedupe are snapping into place for my music library.
More thoughts here: https://deadca7.com/blog/deadca7-open-music-database-specifi...
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#74Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#75is the idea this would be hosted or run locally (like Electron)?
This is for local document like apps. Tauri is actually using the OS webview instead of bundling Chromium like Electron. That's why the download is only 10MB for Mac.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#76> but trying to save data required hosting it somewhere With the File System Access API, webpages nowadays can read and write local files just like desktop applications: https://developer.chrome.com/docs/capabilities/web-apis/file... Try this text editor for example: https://googlechromelabs.github.io/text-editor/ It works nicely on Desktop and Mobile.
The File System Access API makes it possible.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#77I don't know, this seems like an idea that maybe works in a specific context being generalized past the point of the original idea making sense. If the user needs to download a specific application to run this these web apps, then why not just send them that initial application in the first place? Why jump through the hoops of using Capsule when the same hoops can be jumped through to get to the same endpoint? If thi…
Bonus points for an intelligent way to manage these stored in OneDrive and other cloud folders. Easy to get corruption on SQLite files stored there.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#78"PocketBase is an open source backend consisting of embedded database (SQLite) with realtime subscriptions, builtin auth management, convenient dashboard UI and simple REST-ish API. It can be used both as Go framework and as standalone application.
The easiest way to get started is to download the prebuilt minimal PocketBase executable"
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#79Seems very "packable into a standalone binary" but doesn't seem like that is a planned use case.
The problem would be cross-platform support. In the end the capsule file is the standalone binary similar to a PDF or a Word document, you only need the viewer app to open any capsule file.
I might just be hyper-defensive to any sort of vendor lock-in like a "viewer app".