Live data from Hacker News

Show HN: Capsule – Single-file web apps that save their data into SQLite

withcapsule.app

81–90 of 175 posts

Re: Show HN: Capsule – Single-file web apps that save their data into SQLite

#81
post #72
post #60

> 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.

*In Chrome.

That file editor seems to work in Firefox. I just tested the save/open functionality.

Re: Show HN: Capsule – Single-file web apps that save their data into SQLite

#82
post #66

It kinda reminds me of MS Access, which ended up being a pain in the butt for IT departments, but also covered a need within some department with limited resources. Really curious to see where this goes. Do you plan to open-source the client, or simply make the file specification open when stabilized?

I'm currently 50/50 on open source the full app vs just the spec. Since I'm currently having a strong idea of what features and functionality is still missing I feel that open-sourcing right now would distract to much in this phase. But maybe when the main features are done it would make sense to have more people looking at and improving it.

Re: Show HN: Capsule – Single-file web apps that save their data into SQLite

#83

An idea for a killer feature: Make it so that auhors can expose their capsules to the internet, and the people whoe wants to use them(lets call them users) can type the name(lets call it address) of the caplsue into the app, and your program will pull that capsule in the the users device..

nice. we should call it web, like spiders' web all connected.

Re: Show HN: Capsule – Single-file web apps that save their data into SQLite

#84
post #7

Earlier quoted context omitted.

You'd think so, but web browsers are downright lobotomizing the ability for local HTML files to run any meaningful javascript code. Want to run a JS file from the same directory? CORS ERROR!!!! Hence 200MB applications that are complete copies of the Chromium browser to run under 1MB of actual web code.

couldn't you just embed the js directly into the html file though? that would sidestep the CORS error. and since most of the people using a program like this are likely to be using AI to generate their ( likely throwaway ) applets anyway, readability and maintainability for the source doesn't matter as much as it would with human authors so having a separate js file doesn't bring that many advantages anyway.

Sharing HTML files with embedded Javascript is problematic: iOS users can't open the files directly, and have to save the file and then 'open with ... '.

Re: Show HN: Capsule – Single-file web apps that save their data into SQLite

#86
I remember a million years ago, when I was writing apps with Cordova/Phonegap, I would use Web SQL to do all my storage [1]. This kind of reminds me of that.

I always thought that there should be an easy way to export it, but I don't think that ever materialized.

[1] https://en.wikipedia.org/wiki/Web_SQL_Database

Re: Show HN: Capsule – Single-file web apps that save their data into SQLite

#88
post #53

I wish there was a way to see the underlying HTML/JS and schema of these container files. Maybe you can on the desktop app? But it would be cool to see what's happening under the hood. Do you have any plans to do merging of two versions of the same app? E.g. I send a todo list to someone, they mark some things as done and send it back to me. Will that merge into my copy if I've added some more items or would it open…

Merging works already but is a little bit hidden under the data editor function in the Capsule edit menu. Currently the last record update wins, but a merge UI is planed to do manual conflict resolving.
Post reply on HN