arc-in-space

Joined 7 years ago

Karma

794

Submissions

251

Member since

Nov 21

View on Hacker News

Recent submissions

Comment · 11 days ago

I literally know them in person. It's a guy. They have a signal and an email right there, you can message them and talk it's not that deep

Comment · 20 days ago

One of the reasons is high resilience, practically state of the art as far as writing to a single storage device allows. You're less likely to end up with corrupted files with sqlite. This is much more difficult to get right when manipulating files yourself than you might think.

For your consideration (I'll add that I used to think similarly as you, and I still wouldn't use sqlite for everything, but it's shockingly effective):

https://www.sqlite.org/transactional.html

https://www.sqlite.org/fasterthanfs.html

https://www.sqlite.org/atomiccommit.html

https://www.sqlite.org/aff_short.html

https://www.sqlite.org/testing.html

https://danluu.com/file-consistency/

Comment · 20 days ago

I don't recall exactly, other than having a hard time making sense of the transaction management.

Comment · 21 days ago

This library is great, and recently saved a project of mine. Figuring out what was going on with some of python's sqlite3 quirks was too much of a hassle, meanwhile this more or less just worked the way I expected it to. Because of this experience I started defaulting to it over sqlite3 for other projects as well.

(This documentation page explains the library's intent: https://rogerbinns.github.io/apsw/pysqlite.html)

Comment · 2 months ago

You might want to note that "this particular user" is "extremely active" on this website.

(Nothing against it, I'm always happy to hear what Thomas has to say)

Comment · 2 months ago

Disappointed at the lack of replies here, I've had a similar thought before and I'd be curious to hear about the technical viability of this

Comment · 4 months ago

Am I getting overly paranoid, or does this account look incredibly unnatural?

Comment · 5 months ago

The monsters running away when wounded is a basic element in the Monster Hunter games, which are still very unique in how they present the relationship between the player character and the world.

Comment · 5 months ago

Absolutely. Whenever I learn a new thing I'll always approach it from different angles - sources from people with varying skill levels (it can be useful to know how another beginner dealt with something!), video form, written text, reading the theory, seeing the applications, trying it yourself in various forms, different constraints etc. For example, since we're on hn - writing some data structure or algorithm you're learning in a few different languages. Doing all this helps massively with building up to true understanding.

(cooking - when learning a new recipe, I'll always find a few versions from reliable sources to compare, see what they have in common, and try to understand the reasoning behind differences)

Comment · 5 months ago

Blatant bot

Comment · 6 months ago

I'm surprised how many comments in this thread swear by the position that you literally can't tell based on a picture, as if eating trick foods designed to mislead you was an everyday occurence. Most of the time in typical use you could make a reasonable guess, maybe with some obvious caveats such as "well idk if that Coke is Diet or not so"

Comment · 7 months ago

Oh, I was not expecting an entire DSL for this. This looks really useful.

Comment · 7 months ago

God damn those featured pages load so fast.

Comment · 8 months ago

Wait, I thought I've been seeing 'genuine question' a lot lately, but does that actually have anything to do with AI? I had assumed people were always annoying with it and it just so happened to bother me more recently