Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
sgbeal
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
18 ms
·
301.
▲
by
sgbeal
2y ago
Direct link to the project: https://github.com/RNRetailer/terminal-gmail-client
302.
▲
by
sgbeal
2y ago
This part: > ... the requirement of cross-origin isolation, which would have prevented us from rolling out to any browser beyond Chrome and Edge. Is incorrect. The primary development browser for the two VFS APIs they're writing abo
303.
▲
by
sgbeal
2y ago
> I think what the author misses is that SQLite's choices make a lot of sense in a world where working with the DB is super easy and you can move a lot of the complexity to the code around it. One concrete example of that is sqlite&
304.
▲
by
sgbeal
2y ago
> If it wasn't that way, we'd all be running SQLite for our web services, but we're not. Noting that every interactive site run under the Hwaci[^1] umbrella does, e.g. sqlite's own forum and source control system. [1]
305.
▲
Ask HN: Your Yearly Power Usage in Kwh?
3 points
by
sgbeal
2y ago
|
3 comments
306.
▲
by
sgbeal
2y ago
> Does anyone know WHY they did this? That sounds like a classic case of software trying to be "too clever," nine times out of ten of which will invariably backfire. As a software developer, one should always resist the temptat
307.
▲
by
sgbeal
2y ago
i know of this one but have no experience with it so cannot comment on it: https://8th-dev.com/
308.
▲
by
sgbeal
2y ago
> Sqlite is a battle tested sql database used on millions of devices. Billions, perhaps hundreds of billions.
309.
▲
by
sgbeal
2y ago
Wow! We're now just a hair's-width away from finally being able to say, "Computer, enhance image!" without sounding like we're in a bad sci-fi show.
310.
▲
by
sgbeal
2y ago
Not quite science, but this quote from Conan the barbarian is, IMO, nonetheless relevant: "I know this: if life is illusion, then I am no less an illusion, and being thus, the illusion is real to me. I live, I burn with life, I love, I
311.
▲
by
sgbeal
2y ago
> Once you're really familiar with the codebase, you know where dragons be, and you can make changes more easily. This is an interesting, and often overlooked, point. A month or two ago someone asked us, the Fossil SCM maintainers,
312.
▲
by
sgbeal
2y ago
Isn't pop[ular] culture necessarily an oligopoly, in that in any sort of popularity-driven competition, popular things will always win out over less popular things? > oligopoly: a state of limited competition, in which a market is s
313.
▲
by
sgbeal
2y ago
> In conclusion, good code is rarely read. i offer the entirety of sqlite as a counter-example. Based on that project's forum traffic and my participation within that project, i estimate that there are hundreds, if not thousands, of
314.
▲
by
sgbeal
2y ago
From that post: The benefits of open source must make up for the fact that: - It’s hard to deal with unappreciative or rude feedback - It’s hard to manage long back-and-forth feedback cycles - It’s hard to decline a contr
315.
▲
by
sgbeal
2y ago
> I ran a stress test of 14k RPS My built-in Devil's Advocate feels compelled to ask: do you have any reason to believe that your production site would get even a small fraction (single-digit percentage) of that traffic? As a point
316.
▲
by
sgbeal
2y ago
> I stick with h264 for the most part because h265 encoding requires far too much extra compute relative to the space savings. I can spend an hour compressing a file down to 1gb with h264, or I can spend 12 hours compressing the same fil
317.
▲
by
sgbeal
2y ago
> ~800k extra added to initial page load? If you're serving it uncompressed, which no production-grade site will (for a given definition of "no"/"none"). > K matter on the web still. Not, i opine, for the
318.
▲
by
sgbeal
2y ago
> unfortunately in the browser it needs to be downloaded so you’re stuck with indexeddb That argument implies that we're stuck with the browser's single built-in home page because every other web page has to be downloaded. How
319.
▲
by
sgbeal
2y ago
> I've never seen SQLite used in a setup which multiple machines connect to the same database over a network. Noting that the sqlite developers recommend against such usage: https://sqlite.org/whentouse.html Section
320.
▲
by
sgbeal
2y ago
Another one, which i'm admittedly personally vested in, is fnc, a TUI for the Fossil SCM: < https://fnc.bsdbox.org >
321.
▲
by
sgbeal
2y ago
> I still have a hard time with curses. FWIW, _everybody_ has a hard time with curses. That's why it's (aptly) named "curses!"
322.
▲
by
sgbeal
2y ago
The "htop" app, an alternative to the conventional "top," is a nice example of a TUI: < https://htop.dev/ >
323.
▲
by
sgbeal
2y ago
> Unlike emacs or vim or even nano, it didn't have a bunch of invisible shortcut keys, just a Windows-like drop-down menu system (but rendered in DOS). You might like "joe", which was inspired by WordStar: < https:/
324.
▲
by
sgbeal
2y ago
i'm curious whether that article was inspired by the recent SQLite article about bytecode vs ASTs (< https://sqlite.org/whybytecode.html >).
325.
▲
by
sgbeal
2y ago
Fixed, thank you for the report. It won't be visible on the site until the next time it's rebuilt.
326.
▲
by
sgbeal
2y ago
Just FYI: showing hash prefix collision counts is a built-in feature of the Fossil SCM. e.g. the collisions of one particularly well-known repo can be seen at: < https://sqlite.org/src/hash-collisions > and fossil&
327.
▲
by
sgbeal
3y ago
> I ran through the same issue for so long until I heard a quote that said — “think twice, code once”, — and I incorporated it into my process Conversely, Bob Dylan has, for many years, been telling us, "don't think twice, it&#
328.
▲
by
sgbeal
3y ago
FWIW, my favorite IT managers have been ones who, for example: > That's one principle I try to follow - leave estimates to the ones doing the actual work. And... > In other words - I try to help them understand what the end goal&
329.
▲
by
sgbeal
3y ago
FWIW... i was an early adopter of SourceForge and absolutely loved it for the first few years. It was a godsend at the time. At some point (2004? 2006?) its web interface became so ad-ridden that it was effectively unusable, and that was wh
330.
▲
by
sgbeal
3y ago
> Why? Because once your app gets more than _n_ users you will run into scaling problems and then you end up with huge tech debt Anecdote: the sqlite forum runs on a single sqlite db and has well over 1500 users. Similarly, the sqlite so
More ›