HNHacker News
TopNewBestAskShowJobs

sekao

953 karma · joined March 14, 2021

submissionscomments
sekao··on Make the “semantic web” web 3.0 again – with the help of SQLite
My point was not that people are using SQLite in prod everywhere; read that paragraph in more of a speculative voice, not a statement of fact about the present. At any rate, i do think the range request technique makes SQLite more practical to use in database-driven apps that normally would've opted for a traditional db like postgres (though there is more work to be done to make this technique fast when doing complex queries...lots of joins are no bueno right now).
sekao··on Make the “semantic web” web 3.0 again – with the help of SQLite
> Graph databases are necessary to implement semantic web databases.

The online docs (and TBL himself) rarely mention of graph databases, but obviously the idea is tied tightly to RDF. Separating it from that implementation detail is part of the point, though. Getting people to represent their data via an additional format was never going to work.

> For the BBS mentioned here, that might actually be illegal, as it might contain PII

Can't imagine the purpose you had in even making this point. In theory, any arbitrary database exposed publicly could be illegal to replicate due to copyright, PII laws, etc. But that has nothing at all to do with a technical discussion of a technique for exposing data. What a bizarre point to make.

As an aside, I'm glad you removed the "Uh........." from the beginning of your post. We're all making an effort to reduce the typical HN snark in the comments, and there's always room for improvement :D

sekao··on Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
The offline version still needs internet to send new posts but it saves drafts so you can send them later. Not sure what you mean by synchronizing reads against writes; reads only ever occur on the copy in S3, and writes only directly occur on the copy in the linux server. In theory it is possible for a read to occur while S3 is in the middle of updating the db files (not sure if they update multiple files atomically) but it would be a rare problem, and probably could be automatically dealt with by rerunning the request after a short wait.
sekao··on Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
No, it's not accepting database chunks; it's doing all the writes the typical way. And you are right that all data is completely public, unless you restrict access at the file host itself.
sekao··on Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
> So there’s a server which accepts arbitrary writes to the database?

No, all writes have to go through a normal POST endpoint, it does not accept arbitrary writes from clients.

sekao··on Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
> but that's all built on the assumption the file exists on a normal file system with locks, consistency, etc. However, this is not the case here.

It is the case here. Writes are happening on a normal linux VPS, and subsequently copied to S3. The read-only queries are using the HTTP VFS. It would be incredibly bad to enable direct writes to a db from arbitrary clients.

sekao··on Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
> Interesting idea - but like some other posts here I'm wondering how exactly writes and concurrency would work

For writes, SQLite's single threaded restriction still applies. But for most use cases, scaling reads is by far the most important thing.

> Why not just use a traditional DB like MySQL or Postgres on the backend and a WASM SQL client on the frontend?

The point is that you don't need a backend at all for reads, only for writes. All reads can be served by a static file host or cloud object store.

sekao··on Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
That would be fine, sqlite takes care of correctly updating the db file, though i do need to ensure i'm writing from a single thread. And yes every update sends the whole block over, which is 1/4 of a MB (could've made it smaller but i felt that was small enough).
sekao··on Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
My nim implementation of phiresky's technique is here: https://github.com/ansiwave/wavecore/blob/master/src/wavecor...
sekao··on A Review of the Zig Programming Language (Using Advent of Code 2021)
The way zig does generics is brilliant, and made me think "this is how every language should do it". One of those things that seems obvious in retrospect: just pass the types as normal parameters, and for generic data structures just represent their type as a function that receives those parameters and returns a new type. Man that's just beautiful. Only downside is, i suppose the types can never be inferred so they always need to be explicitly passed. But being explicit seems to be their thing anyway.
sekao··on Ansiwave BBS, a modern BBS with ANSI art and MIDI music
You won't be able to change it manually because it's a hard limit in their webgl implementation. But hopefully they'll increase it later.

We can't mimic the local feel of BBSes on the modern internet but i'm confident we can capture the rest of the experience, and at least have something better than the ad-infested garbage heap we see on the web today :D

sekao··on Ansiwave BBS, a modern BBS with ANSI art and MIDI music
You won't be able to change the font because it's being rendered in webgl. In fact, the page is one big canvas tag. I'm painfully aware of the downsides, but it gives me a lot of control when rendering ANSI art, and will allow me to make a killer desktop GUI app later on (a very fast/efficient opengl program, no electron nonsense).

Before anyone asks about accessibility...i should point out i am still injecting a text-only version into the DOM behind the canvas tag for the sake of screenreaders.

The reason firefox looks so much worse is that it has a smaller webgl size limit than chrome (specifically MAX_RENDERBUFFER_SIZE). When rendering at full resolution, it was not large enough to hold the content sometimes. I only check that webgl value so this will resolve itself if/when firefox increases it.

sekao··on Ansiwave BBS, a modern BBS with ANSI art and MIDI music
You can click on a post and go to "see user", which will show their user page. You could also add a signature to your posts -- they're more fun and personalized anyway. Right now that's manual effort, but i will probably add the ability to preset the editor with something so it's there every time you make a new post.

Usernames just don't work because they require an authoritative server to divvy them out. Ansiwave is designed to eventually be partially or completely decentralized -- all users are just ed25519 public keys, and the ID of a post is the signature of it, so there will never be conflicts between users/posts on different servers.

In theory we could one day have a decentralized way of registering unique usernames, similar to that DNS-like thing they made on ethereum. But i'm not even close to thinking about that right now.

sekao··on Ansiwave BBS, a modern BBS with ANSI art and MIDI music
There are no usernames, only tags, of which modleader is one (and multiple users can have it). Only mods can edit tags, so you can think of them somewhat like flairs on reddit.
sekao··on Ansiwave BBS, a modern BBS with ANSI art and MIDI music
Nope no animations. I think that functionality would come from extensions to the scripting language i mentioned, but that would of course be a different format than original ansi animations.
sekao··on Ansiwave BBS, a modern BBS with ANSI art and MIDI music
I hesitated with the word choice but when i say "modern" i mean that the project dispenses with the implementation details of BBSes that are not relevant to the "BBS experience", such as the use of telnet/ssh, outdated text encodings, and long signup forms asking for copious amounts of personal info. I think adding images/videos would definitely affect the experience.
sekao··on Ansiwave BBS, a modern BBS with ANSI art and MIDI music
Depends on what you mean by real :D It's all unicode text, but you can actually share old school ANSI art in the .ans format because it includes a cp437 to utf8 converter. No door games but i hope to extend the MIDI scripting language to do other things, including eventually making games. Little programs/games embedded directly inside posts is an exciting idea.
sekao··on All the giant companies used ffmpeg (2020)
Cálmate, my friend...pretty sure the comment was a light hearted joke.
sekao··on Nim 1.6.2
I've been using nim for a few years. I wouldn't have made either design choice (i always do qualified imports, it's just a few extra characters of typing). That said, there is a reason these superficial things always come up in HN threads. If you haven't used a language before, syntax is the only thing you can talk about. It's the equivalent of low effort political banter and the dopamine hit you get from junk food or watching a tiktok. These things melted away after my first 30 minutes with the language, and that's about when the real work began.
sekao··on Using BBS with my Amiga 3000 in 2021
The BBS code isn't public yet but it'll end up on https://github.com/ansiwave/ansiwave when it's ready. I've been posting devlog videos here... https://www.reddit.com/r/ANSIWAVE/

I think the best chance you'd have of getting the local aspect is to not run it on the public internet. Maybe use a local mesh network, packet radio, etc. But the community you end up with, if any, will be quite different than the one that formed around BBSes, i imagine.

sekao··on Using BBS with my Amiga 3000 in 2021
> I'd love some kind of a modern hybrid.

I'm working on it. A BBS with a built-in ANSI art + MIDI music editor, accessible from terminals and web browsers, all unicode, no telnet. Ready later this month most likely.

It's hard to replicate the local feel of BBSes though. You can't really enforce local usage on the modern internet, and it wouldn't be great for privacy if you could. But the rest we can do.

sekao··on Super Pyxelate converts images to 8-bit pixel art
See also... https://github.com/hpjansson/chafa
sekao··on NumWorks – An open source Graphing Calculator
I had no need for one but got it anyway. The OS is really easy to build and install. Amazing work. Try booting it up next to your smartphone. There is no perceptible boot time -- and its arm cortex processor is probably much weaker than your phone's. It reminded me what computing could be like if you're willing to cut out the layers and build from scratch.
← PreviousPage 2 of 2