this is great for the 'make a webapp for me and my family' thing
Show HN: Capsule – Single-file web apps that save their data into SQLite
101–110 of 175 posts
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#102Earlier quoted context omitted.
*In Chrome.
That file editor seems to work in Firefox. I just tested the save/open functionality.
It's not using the File System Access API, on Firefox it uses for file-picking, and the save just downloads it. It's not synchronizing anything with your filesystem.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#103Looks amazing, I don't know if this is legit or useful feedback, but I navigated away after reading "Generate & update apps using AI".
I'm so tired of AI everywhere and everything trying to sell to you because of AI this and AI that.
I think that at this point we assume AI will be available if it makes sense for the product, making it a selling point to me is like slapping "No cholesterol!" on lettuce.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#104My take: If your app needs to update and preserve state (using SQLite or any other DB), it is probably not something you want to pass around as a bundled file. Or at least, it's extremely limiting, compared with hosting it somewhere on the web, which is not that hard to do these days. Think of the workflow: Any time the state changes, you need to email a new Capsule file to whoever else is using the app. And one woul…
Why not on a shared drive like dropbox? Concurrent editing wouldn't work, though.
Beyond "not working", concurrent editing is likely to silently lose data, or corrupt data, or possibly just fill up your drive with lots of "conflicted copies" that you have to manually reconcile.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#105Earlier quoted context omitted.
My dream is that you could write to Google Drive or iCloud Drive transparently too if the browser allows you to
I believe you are able to connect to a Google Drive account with a purely client side site via google oauth and then using the Google Drive rest api. There was an article in particular that I liked that walked through it. Let me see if I can find it
Yes but Google OAuth is a nightmare if you want to "publish" your client so that anyone can use it. If only you use it, you can add yourself as a test user. Just know your access token expires super fast and you will have to frequently re-auth. Its crazy annoying.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#106Is the file still fairly readable as plain text when opened with any old text editor? Is this asking too much?
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#107I've been working on this exact idea, with sqlar as the "format specification". Works in the browser, and desktop + Android using Tauri. https://github.com/JoshTheDerf/uapp Demo apps and games: https://thederf.com/uapp/demo/
FYI requests from your demo are being blocked by CORS in Firefox and it never loads.
Thanks for the heads up! Fixed now, was a bug in the service worker.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#108I 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…
Yep, like Hyperclay. https://news.ycombinator.com/item?id=49690814
They're like lightweight versions of https://github.com/kem-a/AppManager which is for AppImages.
Not a bad thing, but it's just another dependency and tied to an OS-specific base software install.
They could work well pre-installed on the Mecha Comet with a bunch of app files ready to launch.
Can the added layers guarantee a new level of security or privacy like zero telemetry or keyjacking? Protection from bad actors is a good thing while making things faster and easier overall. Browser extensions are a security risk, right?
Java applets were a good idea in the sense that so long as you had Java installed, the applet was just sitting there on a webpage. Finding and managing the apps is the problem, and using browser bookmarks is a decent solution to it. The web page should demo the app, and there can be an 'install local' button next to it. But at some point all these local versions need to be updated and then not be messed with like browser extensions can be. FanFare would be a decent name.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#109Earlier quoted context omitted.
That file editor seems to work in Firefox. I just tested the save/open functionality.
It's not using the File System Access API, on Firefox it uses for file-picking, and the save just downloads it. It's not synchronizing anything with your filesystem.
I see. Thanks for enlightening me.
Re: Show HN: Capsule – Single-file web apps that save their data into SQLite
#110Is this open source ?