Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
sgbeal
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
33 ms
·
541.
▲
by
sgbeal
4y ago
> The OPFS is subject to browser quota restrictions. FWIW, 256mb last i checked (summer 2022). Perhaps less on mobile browsers, but that's just speculation.
542.
▲
by
sgbeal
4y ago
> So it is a sandboxed, abstract filesystem, not rw access to my actual filesystem? It's sandboxed storage which lives in your filesystem but is only available via the browser and is sandboxed on a per-HTTP-origin basis. That makes
543.
▲
by
sgbeal
4y ago
This quote from the article somehow justifies my continued willful ignorance of React: > It’s just abstractly funny to watch the ecosystem of a UI renderer work so tirelessly to keep using it while avoiding every part of it.
544.
▲
by
sgbeal
4y ago
> The question is, is it portable to the systems you want to support? "Want" isn't always the whole equation. Sysadmins are often called to support ancient OSes, in particular in environments which keep systems in operatio
545.
▲
by
sgbeal
4y ago
> assert(false && "Did I happen?"); If i may offer a simplification of that: assert(!"Did I happen?");
546.
▲
by
sgbeal
4y ago
> ... what other IT careers are there? Security, architecture (as opposed to coding), firmware development, database administration (Oracle is not just a database, it's a full-time (and well-paid) lifestyle choice), 3D modeling, ro
547.
▲
by
sgbeal
4y ago
> Is programming learnable or you born with it? FWIW... Programming has been a hobby of mine since Christmas day of 1983, but it literally never occurred to me to go into IT professionally because, for much of my life, i assumed that eve
548.
▲
by
sgbeal
4y ago
> It's a lot of work! But it's a godsend for those who care about it (as you obviously do or you wouldn't put in the effort). It was only through a recent changelog entry in Emscripten that i was able to locate a truly obs
549.
▲
by
sgbeal
4y ago
> It seems strange that they would make an official version and then not add it to the official JS package manager. None of us in the sqlite use npm in any way, shape, or form, so there's nothing at all unusual about us not publish
550.
▲
by
sgbeal
4y ago
Anyone else notice that the article in question is from more than two years ago? Sept. 2020.
551.
▲
by
sgbeal
4y ago
> And without an official one I imagine there will quickly emerge dozens of unofficial ones, many of which will end up poorly maintained in the future. Seeing as none of us in the sqlite project use NPM or node in any capacity whatsoever
552.
▲
by
sgbeal
4y ago
> the NPM registry is rather 'tooling agnostic' and publishing there would make it available to a lot more people ... The sqlite project is populated entirely by C coders (my primary language), none of whom have either experie
553.
▲
by
sgbeal
4y ago
> https://mozilla.github.io/standards-positions/ is positive on it To hopefully add a bit of clarity: indeed, that page has OPFS flagged as positive under the label "File System." Further down the page is
554.
▲
by
sgbeal
4y ago
> There isn't an "official" NPM package or ES6 model yet (The sqlite team's JS/WASM Guy here...) An ES6 module build was added shortly after the 3.40 release. NPM/node.js are nowhere on our radar. Our build
555.
▲
by
sgbeal
4y ago
> It would however be weird to do a CGI program in Go, because that language already have a really good build in webserver and more powerful/easily accessible features for interacting with requests compared to what CGI provides. No
556.
▲
by
sgbeal
4y ago
> CGI is slow .... CGI is _computationally_ slow, but in practice it's faster than it needs to be for most sites. Some examples of CGI-powered sites i'm aware of include: - https://sqlite.org/forum - https:&#x
557.
▲
by
sgbeal
4y ago
It might interest readers to know that the Fossil SCM's primary mode of operation is CGI, and has been since it began life in 2007: https://fossil-scm.org/home When i first discovered fossil, in December 2007, its abil
558.
▲
by
sgbeal
4y ago
That's a shame. Tableau is one of the few commercial software pieces i've used in the past decade which truly impressed me (excluding games, of course!). With a handful of clicks, i was able to produce amazing reports from it for
559.
▲
by
sgbeal
4y ago
The irony of this is hilarious: the Wall Street Journal is reporting about Meta being fined for ad personalization in the EU, while at the same time popping up a cookie acceptance banner proclaiming to do the same thing (to me, who sits in
560.
▲
by
sgbeal
4y ago
>> Could it have a cron that runs as a user with write access to perform upgrades, while publicly-accessible processes don't? > In theory yes. In practice no. FWIW, after my one and only Wordpress installation was cracked via
561.
▲
by
sgbeal
4y ago
> The trifactor of the Origin-Private FileSystem, WASM and SQLite is the missing link to make so many progressive web apps possible. FWIW, that's exactly our sentiment within the sqlite team. People have been using sqlite with brows
562.
▲
by
sgbeal
4y ago
> It can be compiled to WASI but there are no instructions on how to use zig cc to do it? We (sqlite team) are currently working on patches to get it building properly with wasi-sdk. When built as-is with wasi it's essentially non-f
563.
▲
SQLite3's WASM/JS build now includes ES6 module
(sqlite.org)
20 points
by
sgbeal
4y ago
|
1 comments
564.
▲
by
sgbeal
4y ago
(Text submitted in the original post...) The sqlite3.js/wasm build now includes sqlite3.mjs, providing the same API via an ES6 module. It's currently in the sqlite3 trunk and will be included in the 3.41 release (and possibly any
565.
▲
by
sgbeal
4y ago
> Before the interview, which was held with a panel of two native speakers, my supervisor told me to drink some beer. FWIW, i can attest that being slightly inebriated helps one speak a non-native language. My German is much more fluid w
566.
▲
Show HN: A preprocessor, similar to a C preprocessor, for arbitrary text inputs
(fossil.wanderinghorse.net)
1 points
by
sgbeal
4y ago
|
0 comments
567.
▲
by
sgbeal
4y ago
> Huh, I wonder why FTS4 and not FTS5? I could understand omitting both of them for reasons of size, but having the older version but not the new one feels surprising to me. It was an oversight on my part. It will be fixed in the trunk m
568.
▲
by
sgbeal
4y ago
> Does the WASM port include full-text search (FTS)? It inadvertently includes FTS4 instead of 5. That was my fault and it will be changed to include 5 instead Real Soon Now.
569.
▲
by
sgbeal
4y ago
> ... and the limitations of C makes it worse. That's somewhat ironic considering that C is one of the few languages which can do literally anything, from the lowest-level direct memory access to the highest-level abstractions. It&#
570.
▲
by
sgbeal
4y ago
> As in the outputs aren't useful, or the gifs are poor? As in they don't _show_ anything useful. Just to pick one at random: the last one, "Average all of the values in a range." All it shows is a list of numbers, no
More ›