sgbeal

10 ms·

151.
by sgbeal 7mo ago
> Why would an LLM be better trained to access Redis via a FS vs. a native library API? Limiting the potential blast radius. If you give an agent "access to a Python REPL" (your words), you're giving it access to all of
152.
by sgbeal 7mo ago
> What are other people's favorite humorous responses? "For a given definition of 'morning'."
153.
by sgbeal 7mo ago
> The user must perform visual triage, identify the close icons (which are deliberately given low contrast) and execute side quests just to access the 5KB of text they came for. They thing is, though... they _don't_ have to. It&#x27
154.
by sgbeal 7mo ago
Reminiscent of the classic DMCA email footer: This email is encoded with ROT-26 encoding. Decoding it is in violation of the Digital Millennium Copyright Act.
155.
by sgbeal 7mo ago
> At these prices they're accessible to everyone It's inaccurate to assume that "300-400" is readily within anyone's reach. 300-400 is virtually a king's ransom for some of us.
156.
by sgbeal 7mo ago
> (which of course shoots it upwards, that's the "doubling in late 2022" you mention). i guaranty you that my electricity costs were 22c in mid-2022, jumped to 47c in either late 2022 or January 2023, and just went up from
157.
by sgbeal 7mo ago
> Less people buying power from the utilities means they increase prices on the remaining customers. Ergo... claims of lower electricity costs are BS, in that electricity's not getting cheaper per unit but is getting more expensive
158.
by sgbeal 7mo ago
> Solar on the balcony railing is very popular right now, mostly amongst apartment renters i have yet to see a single solar panel on an apartment building in Brandenburg, Germany, whereas a large portion (perhaps even a majority) of sing
159.
by sgbeal 7mo ago
i call BS: in Germany we're paying more than twice per kw than we were 3.5 years ago (it literally doubled in late 2022, from some 22c to 40-odd cents), and it just went up again in February 2026. Lots and lots of talk about lower ener
160.
by sgbeal 8mo ago
> The behavior of bash would be to produce "a/c" and "b/c", even if both files don't exist In bash patterns like {a,b} aren't glob-expansion expansions, they're string operations, and those re
161.
by sgbeal 9mo ago
> The query optimizer is allowed to see more opportunities to optimize and avoid unnecessary work. Let's also not forget that db servers can have a memory, in that they can tweak query optimization based on previous queries or scans
162.
by sgbeal 9mo ago
> I’ve been experimenting with LiveStoreJS which uses a custom SQLite WASM binary for event sync i'm not sure whether this might be helpful to you, but 3.52 will include a revamped "kvvfs" which (A) also works (non-persist
163.
by sgbeal 9mo ago
> That @ syntax is used in modern day Fossil too. Maybe that adds some extra overhead? (Long-time Fossil dev here.) The @ syntax is pre-processed, transformed to printf()-like calls, the destination of which depends on whether fossil is
164.
by sgbeal 9mo ago
> The fact that they didn’t make STRICT default is really a shame. SQLite makes strong backwards-compatibility guarantees. How many apps would be broken if an Android update suddenly defaulted its internal copy of SQLite to STRICT? Or if
165.
by sgbeal 9mo ago
> are people actually using it or does it just have good marketers? _You_ are using it right this second. It's storing your browser's bookmarks (at a minimum, and possibly other browser-internal data).
166.
by sgbeal 10mo ago
> The great thing is that my blog is architecturally very simple, with all the content and images in an SQLite database that is live replicated with litestream. What a weird definition of "architecturally very simple".
167.
Show HN: C-Minus Preprocessor v2(fossil.wanderinghorse.net)
2 points by sgbeal 11mo ago|0 comments
168.
by sgbeal 11mo ago
> Where can I read more about this? There's nothing specific to read about it, just plenty of anecdotal evidence. People use connection pools because connecting to _remote_ databases is slow. SQLite _is not remote_. It's _in-pr
169.
by sgbeal 1y ago
> I have a python web app that creates a DB connection per request (not ideal I know) FWIW, "one per request per connection is bad" (for SQLite) is FUD, plain and simple. SQLite's own forum software creates one connection
170.
by sgbeal 1y ago
> No, but as morbid as this sounds, the three(?) devs... Two full-time core devs and three part-time "peripheral" devs. > ... one day will pass away ... And not a one of us are young :/.
171.
by sgbeal 1y ago
> It runs against the same test suite with no issues It runs against the same public test suite. The proprietary test suite is much more intensive.
172.
by sgbeal 1y ago
> you prefer you program doing widely arbitrary and as such potentially dangerous things over it having a clean abort or proper error. SQLite isn't a program, it's a library used by many other programs. As such, aborting is no
173.
by sgbeal 1y ago
OP here: see also < https://github.com/emscripten-core/emscripten/discussions/25... >
174.
SQLite 3.51.0 supports 64-bit browser-side WASM(sqlite.org)
3 points by sgbeal 1y ago|1 comments
175.
by sgbeal 1y ago
> I suppose the encryption is only at the TLS layer? Correct unless the fossil repository in question uses SQLite's SEE (encryption) extension (which fossil can, but relatively few repositories use that, AFAIK).
176.
by sgbeal 1y ago
> 3DS carts are actually NAND flash TIL. Thank you :).
177.
by sgbeal 1y ago
Back around 1990 my youngest brother, who had always seen CDs, asked me one day, "what are those things in your closet?" "What things?" "They look like CDs but they're big and black!" He had never seen a r
178.
by sgbeal 1y ago
> Unlike ROM cartridges, which AFAICT died with the GBA in 2008. Look up the Gameboy 3DS :).
179.
by sgbeal 1y ago
> Micro-transactions are accepted, but far from universal. People bemoan them for some reason, ... Because, for one, with them came "Pay to Win". Nothing good comes from Pay to Win except that someone lines their pockets. A pro
180.
by sgbeal 1y ago
> You can run the DLL in a "shim" subprocess that proxies function calls over IPC. That doesn't address the need of some DLLs to malloc() resources in the context of the applications linking to them. This problem _cannot_

More ›