jph00

SQLite behavior is here: https://sqlite.org/lang_transaction.html . The regular implicit transactions there plus explicit where needed aren’t supported in any python mode.

Comment · 3 months ago

I'm a big fan of sqlite-utils, but I really don't like how Python (particularly 3.12+) changes how sqlite's transactions work -- the native behavior explained in the sqlite docs is much better IMO. I understand why Python had to change it (to be compatible with other databases) but I don't think it's a good model for sqlite.

Therefore, I created apsw-utils, a port of sqlite-utils to the amazingly-awesome apsw lib -- which is a really idiomatic sqlite lib for python. It's here: https://answerdotai.github.io/apswutils/

I've used it in lots of projects including in significant production stuff, and it's always worked great for me. IMO if you're serious about doing sqlite in python, at some point you'll probably want to check out apsw.

Comment · 5 months ago

It's both an illogical question and comes from a place of ignorance about a topic which one would expect folks nowadays to have some basic competence in.

First, the illogical part: the statement was about "inequality" to which you asked about wealth generation. These are two separate issues, and inequality is not, logically, necessarily tied to wealth generation. So "How does creating wealth hurt others?" is, at best, a non sequitur.

The ignorance part: there is a lot of empirical research over many decades showing the negative impact of wealth inequality on societies. With Google and AI there's really no good reason to ask such ignorant questions when in a moment you could educate yourself, and then ask an informed and thoughtful question instead.

Comment · 5 months ago

You seem to have a rather limited understanding of what kinds of concurrency exist and how those needs are best met. Whether something is a server or not is not very relevant to this discussion.

SQLite is an excellent production db for many real world workloads, as has been widely documented. It is very different to Postgres, so requires learning a whole new skill set.

One way to think about it is that SQLite can work well for the parts of your system where there is naturally strong partitioning.

Comment · 5 months ago

I couldn't find a CPAP mask that worked for me, even after 6 months of trying across 4 different masks.

Then I read studies showing oropharyngeal exercises can help treat sleep apnea. Originally I used https://snoregym.com/ for that, but then I switched to simply chewing gum once a day (being careful to chew on both sides of my mouth roughly equally), and also chewing my food a bit longer.

It totally cured my sleep apnea.

Comment · 5 months ago

q and ch both exist in pinyin, and have different sounds. The q sound requires placing the tip of the tongue on the teeth, and isn’t an initial consonant we have in English, so we don’t have a way to spell it.

Comment · 5 months ago

TIL HN still doesn't support rfc3492, 23 years after it was published, and so this domain is not rendered correctly on the site. :( (It should appear as: マリウス.com )

Comment · 5 months ago

He states in the article that they use LLMs for this purpose and find them extremely useful.