Live data from Hacker News

sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

simonwillison.net

71–80 of 93 posts

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#71
post #31

just a note. in most parts of the world 149.25 USD can cover utilities, water, and food for a month for 1 adult person or even a family.

That's my electricity bill for a year, okay

I meant in total. food + electricity/water + housing = 150USD / month.

yep. same. my electircity is ~100 USD / year.

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#72

just a note. in most parts of the world 149.25 USD can cover utilities, water, and food for a month for 1 adult person or even a family.

In others it's pizza night for family or half a bill for sushi dinner, so what?

severely overpriced. that's what.

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#75

> I went out to enjoy the Half Moon Bay 4th of July parade, occasionally checking in and prompting the next step for Fable from my phone. This intensification of work will not be good for workers’ health. Like, put your phone down man. You can’t be modeling this behavior to young people. Further, the intensification of work is probably not even good for productivity in the long term. This periodic half-thinking about…

I've been reading articles that are telling me how they're prompting from their phone at 2am(and how they know that's not great) and when they're out driving their kids to their activities etc. They say all that as if it's something to be proud of. And what for? Oh they released all these packages that no one is going to use.

Burnout is real and these people have lost track of what's important.

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#76

> I went out to enjoy the Half Moon Bay 4th of July parade, occasionally checking in and prompting the next step for Fable from my phone. This intensification of work will not be good for workers’ health. Like, put your phone down man. You can’t be modeling this behavior to young people. Further, the intensification of work is probably not even good for productivity in the long term. This periodic half-thinking about…

Idk about you but this type of intensification of my work has been extremely good for my mental health, on all points:

1. I feel genuinely more productive, spending a lot less time on boilerplate and much more of my genuine time is spent thinking and communicating the thinking process.

2. I can take a ton of breaks, basically whenever I want. "Flow" is now entirely design flow and can be interrupted much more easily without damaging it.

3. If there is anything I actively dislike in my workflow or that makes me not enjoy my time... I can fix my workflow so that either I'm not the one doing it, or the item in question is no longer necessary.

AI is crazy. I get it, if you're at a shitty job that doesn't understand how to adapt well, it's tough... but if you're working on your own (like Simon does on this project), it's absolutely amazing and you're in full control of your life.

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#77
post #58

Earlier quoted context omitted.

> changes how sqlite's transactions work What specifically are you referring to? The apswutils website also does not explain.

Pythons options are here: https://docs.python.org/3/library/sqlite3.html 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.

> The regular implicit transactions there plus explicit where needed aren’t supported in any python mode

Specific examples would be extremely useful. You've done some work learning and deducing this stuff, others could learn if you would share and explain it.

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#78
post #57

Earlier quoted context omitted.

> changes how sqlite's transactions work What specifically are you referring to? The apswutils website also does not explain.

They're probably talking about the addition of the autocommit flag, which hides more fine-grained transaction control in favor of more uniform behavior across multiple databases: https://docs.python.org/3/library/sqlite3.html#sqlite3.Conne... You can still use previous behavior with "legacy" mode that lets you control when transactions are opened in which isolation level.

> hides more fine-grained transaction control

In what way does having autocommit=False hide more fine-grained transaction control?

autocommit=False gives full control to the programmer to do whatever they want.

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#79

I'm kind of surprised that there is no test case that would have identified the fact that delete_where() leaves the state corrupted. There would be no need to ask Fable if the problem gets identified by the test. And having a test will also catch all future problems that might arise in the same function. So maybe instead of asking Claude what is wrong it would be wiser to invest in test coverage.

I also stopped reading the article there. This is major version 4 of a library about providing higher level db actions, i.e. transactions are paramount to make them atomic

Re: sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

#80

> I went out to enjoy the Half Moon Bay 4th of July parade, occasionally checking in and prompting the next step for Fable from my phone. This intensification of work will not be good for workers’ health. Like, put your phone down man. You can’t be modeling this behavior to young people. Further, the intensification of work is probably not even good for productivity in the long term. This periodic half-thinking about…

Ideally it means a massive relaxation of the 9-5.

For my personal efforts yes I very much want on demand access, I want the thoughts to flow. It doesn't feel like that would be anything but great at my job too, if my job didn't define such narrow bounds of mandatory butts in chairs. What work says it wants is not effective, is not going to get my best work, is not going to really make sense. It didn't make sense before & it's absurdly out of pace with the Happy Warrior mode of software development today.

Post reply on HN