Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
sekao
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
16 ms
·
31.
▲
by
sekao
5y ago
Making it available via a static file host dramatically lowers the barrier. If you have an interesting dataset, you can even throw it on github pages and pay nothing; that likely is not true for your mongo db server. A typical request using
32.
▲
by
sekao
5y ago
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
33.
▲
by
sekao
5y ago
> 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 par
34.
▲
Make the “semantic web” web 3.0 again – with the help of SQLite
(ansiwave.net)
461 points
by
sekao
5y ago
|
213 comments
35.
▲
by
sekao
5y ago
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
36.
▲
by
sekao
5y ago
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.
37.
▲
by
sekao
5y ago
> 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.
38.
▲
by
sekao
5y ago
> 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 c
39.
▲
by
sekao
5y ago
> 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
40.
▲
by
sekao
5y ago
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 sma
41.
▲
by
sekao
5y ago
My nim implementation of phiresky's technique is here: https://github.com/ansiwave/wavecore/blob/master/src/wavecor...
42.
▲
Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps
(ansiwave.net)
94 points
by
sekao
5y ago
|
24 comments
43.
▲
by
sekao
5y ago
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 j
44.
▲
by
sekao
5y ago
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 confide
45.
▲
by
sekao
5y ago
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 allo
46.
▲
by
sekao
5y ago
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
47.
▲
by
sekao
5y ago
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.
48.
▲
by
sekao
5y ago
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.
49.
▲
by
sekao
5y ago
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, outda
50.
▲
by
sekao
5y ago
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
51.
▲
by
sekao
5y ago
Cálmate, my friend...pretty sure the comment was a light hearted joke.
52.
▲
Ansiwave BBS, a modern BBS with ANSI art and MIDI music
(ansiwave.net)
153 points
by
sekao
5y ago
|
74 comments
53.
▲
by
sekao
5y ago
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
54.
▲
by
sekao
5y ago
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
55.
▲
by
sekao
5y ago
> 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 h
56.
▲
by
sekao
5y ago
See also... https://github.com/hpjansson/chafa
57.
▲
by
sekao
5y ago
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 you