sgbeal

12 ms·

181.
by sgbeal 1y ago
> Too bad the notion of completed/finished/done software is very weak. FWLIW, this simple definition suffices for me: software is complete insofar as it requires no changes to do what its maintainers would like to do with it at
182.
by sgbeal 1y ago
There is no safe, reliable, cross-environment way to deal with closing a DLL. A DLL initialization function can allocate arbitrary resources, some of which may be in use by clients of the DLL when it is closed. The only safe, consistent, re
183.
by sgbeal 1y ago
The focus of that experiment was to find out of LSM-based storage[^1] would prove to be faster. It turned out that LSM, for SQLite's workloads, did not provide enough benefit to justify the upheaval. [^1]: https://en.wikiped
184.
by sgbeal 1y ago
> If you have MFA turned on then you’re safe enough right? Many of these payments (or would-be payments) are automated, so MFA doesn't play a role. i had automated payments get blocked yesterday for the first time ever and thought i
185.
by sgbeal 1y ago
The comedy continues in the next paragraph: > Readers MUST NOT hold this against the project, and SHOULD use this as motivation to keep some of their own side projects fun and short. That's comedy gold, right there. (Tip: RFC-2119)
186.
by sgbeal 1y ago
> The SQLite website ( https://sqlite.org/ ) uses SQLite itself Almost. The main site is static HTML except for the site search (which of course uses SQLite). However, several of its top-most paths are CGIs based on the Fo
187.
by sgbeal 1y ago
> I know that the post is light on details regarding how exactly we apply embeddings in TW. More significantly, after having read the first 6 or 8 paragraphs, i still have no clue what an "embedding" is. From the 3rd paragraph:
188.
by sgbeal 1y ago
> I wanted to refute the "the constant churn of new frontend frameworks to learn". If you just stuck with React since 2015, they've only had 4 major versions since then and every ver they deprecate only a few things and th
189.
by sgbeal 1y ago
> the link to gmvault in your readme is now a dead end, is this it https://github.com/gaubert/gmvault . Funnily enough, the gmvault.org domain _that_ page points to is simply a parked GoDaddy placeholder. It's a
190.
by sgbeal 1y ago
> on good wifi with no interference you can get good 2ms avg and 0.2-0.4 ms SD ping distribution. i opine that there's no _functional_ difference between those speeds for purposes of a home LAN. Both values are far below humans&#x27
191.
by sgbeal 1y ago
> I was initally hesitant about using WiFi for DNS, but after reading comments it seemed that no one really had any issues FWIW, that was also an initial concern of mine. Almost three years later, i've never once had an issue with r
192.
by sgbeal 1y ago
> I love my pi-hole but am surprised to see him recommending a $155 kit + keyboard, mouse, and monitor. My pi-hole runs on a Pi Zero 2W and connects via USB for power. FWIW, even a Pi Zero 2 is overkill. My pi-hole has been running for t
193.
by sgbeal 2y ago
> We have not yet officially replaced the SQLite TEA build with teaish ... As of today, the SQLite's "TEA build" is now done with teaish.
194.
Show HN: Teaish – An Alternative to Tcl's TEA(fossil.wanderinghorse.net)
4 points by sgbeal 2y ago|1 comments
195.
by sgbeal 2y ago
> I don't think this is official. FWIW, the site doesn't claim to be. The OP mislabeled it as such.
196.
by sgbeal 2y ago
The full text from their announcement, received less than an hour ago via email and not readily available online in text form (only as PNG): ================================================== An Important Announcement From Dark Horse Comics
197.
by sgbeal 2y ago
Their proposed workaround is to "download them to the app," which of course only works until you change devices (and might not work at all - my collection is too large to fit on any of my mobile devices (2300-odd books, 100GB)). F
198.
DarkHorse Digital shutting down – access to content gone soon(digital.darkhorse.com)
6 points by sgbeal 2y ago|2 comments
199.
by sgbeal 2y ago
> Arguably, this makes PostgreSQL the only mainsteam database system that is truly open-source. It can't be bought or license-rug-pulled and this creates a kind of trust that can't be emulated in any other way. SQLite, with far
200.
by sgbeal 2y ago
> Do you have any examples? Not personally, because i've never been affected by it, but it's a topic now and again in the SQLite forum (where i'm a daily visitor).
201.
by sgbeal 2y ago
> What's difficult about schema migration? Not being snarky, genuinely curious :) SQLite's ALTER TABLE support isn't on par with other dbs. That's primarily (perhaps solely) because it stores table definitions as thei
202.
by sgbeal 2y ago
> Board game geeks do this often. They have seen so many games before that they learned to identify patterns in the rules and they learned names for those patterns. Funnily, enough: < https://boardgamegeek.com/browse&#x
203.
by sgbeal 2y ago
> If you blink and miss something, hunting around a video is much worse than scanning a rulebook. Not only that, but very nearly every one of them has rules errors. There is exactly one YouTuber (from Watch It Played) who consistently pu
204.
Every board game rulebook is awful [pdf](drive.google.com)
340 points by sgbeal 2y ago|288 comments
205.
by sgbeal 2y ago
> And if you care about data integrity, you shouldn't be using these [ext4 or XFS] FUD. i've been using ext4 since it came out (and ext2 and ext3 before that), on dozens of computers, and have literally never once had any corru
206.
by sgbeal 2y ago
> Sounds like we should all just be doing sqlite3 /dev/sda2 A recent forum post on that topic: < https://sqlite.org/forum/forumpost/66b4d47514b442af >
207.
by sgbeal 2y ago
> would cutting out the filesystem out of the equation entirely improve things further still? This recent forum post on that subject: < https://sqlite.org/forum/forumpost/66b4d47514b442af > doesn't ans
208.
by sgbeal 2y ago
> The .bat build (Windows) will not change via this port. Only Unix-like environments will potentially be affected. It turns out that that's not _entirely_ true now: Richard got jimsh working on Windows, which means that nmake-drive
209.
by sgbeal 2y ago
As of moments ago, linked-to announcement became a reality and the current SQLite trunk now uses autosetup instead of the autotools. We still have some cleanups to do before the 3.48 release but the majority of the build functionality is wo
210.
by sgbeal 2y ago
> Is it really desirable to have complex build tools be part of the project, especially after the xz-utils takeover? That's a fair question, but i'm confident that in this case such a risk is simply not there. We've inter

More ›