Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

simonwillison.net

Post reply on HN
Print view View original

81–90 of 93 posts

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

#81

Post by c-hendricks »

scorpioxy wrote: post #75
avidphantasm wrote: post #56

> 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.

I worked for a startup in Canada, with Dutch founders, and operations in France and California.

That meme about how different countries treat out-of-office is very accurate.

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

#82

Post by mirekrusin »

5701652400 wrote: post #72
mirekrusin wrote: post #30

Earlier quoted context omitted.

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

severely overpriced. that's what.

it's not overpriced but high-priced looking from other countries and mostly not a markup, normal considering median wages.

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

#83

Post by dxdm »

jmalicki wrote: post #78
dxdm wrote: post #57

Earlier quoted context omitted.

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.

From the link in my previous post[0]:

> False: Select PEP 249-compliant transaction behaviour, implying that sqlite3 ensures a transaction is always open.

This means you don't get to control the isolation level of the transaction, because [1]:

> sqlite3 uses BEGIN DEFERRED statements when opening transactions.

If you want to use `IMMEDIATE` or `EXCLUSIVE` isolation level[2] for your sqlite transaction using the new flag, you have to set `autocommit=True` to be able to open the transaction yourself with `.execute("BEGIN IMMEDIATE")`.

However, with `autocommit=True`, the connection's `.commit()` and `.rollback()` methods will *silently do nothing* and you have to execute the respective raw SQL yourself to commit or abort your manually-opened transaction. This also concerns the context-manager behavior of the connection object, which will not commit or abort manual transactions on context exit in this case.

So, the autocommit flag becomes a little complicated and foot-gunny if you want more precise control over when exactly other readers or writers should get blocked by sqlite.

[0] https://docs.python.org/3/library/sqlite3.html#sqlite3.Conne...

[1] https://docs.python.org/3/library/sqlite3.html#sqlite3-trans...

[2] https://sqlite.org/lang_transaction.html#deferred_immediate_...

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

#84

Post by jmalicki »

dxdm wrote: post #83
jmalicki wrote: post #78

Earlier quoted context omitted.

> 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.

From the link in my previous post[0]: > False: Select PEP 249-compliant transaction behaviour, implying that sqlite3 ensures a transaction is always open. This means you don't get to control the isolation level of the transaction, because [1]: > sqlite3 uses BEGIN DEFERRED statements when opening transactions. If you want to use `IMMEDIATE` or `EXCLUSIVE` isolation level[2] for your sqlite transaction using the new f…

Thank you!

The link had some of the details, but not the intelligent thought linking them into a narrative, much appreciated! This is something super important I would have been foot-gunned on at some point.

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

#87

Post by palmotea »

jauntywundrkind wrote: post #80
avidphantasm wrote: post #56

> 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 befo…

>>> 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.

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

Why? That's the time they've purchased. They'll just demand that and more. "People like Simon Willison are prompting during their 'off time,' and that's expected under our new ways of working."

Also, being always on, always available doesn't sound like it would amount to "massive relaxation."

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

#88

Post by scrollaway »

scrollaway wrote: post #76
avidphantasm wrote: post #56

> 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…

I love how this completely personal opinion and experience is getting downvoted. The blind hate on anything AI on HN is mind boggling. True ostrich behaviour.

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

#89

Post by AlexeyBelov »

scrollaway wrote: post #88
scrollaway wrote: post #76

Earlier quoted context omitted.

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…

I love how this completely personal opinion and experience is getting downvoted. The blind hate on anything AI on HN is mind boggling. True ostrich behaviour.

Please don't post such low effort comments. Complaining about the downvotes is a faux pas.

Ask AI to tell you five reasons you _could_ be downvoted for this post.

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

#90

Post by scrollaway »

AlexeyBelov wrote: post #89
scrollaway wrote: post #88

Earlier quoted context omitted.

I love how this completely personal opinion and experience is getting downvoted. The blind hate on anything AI on HN is mind boggling. True ostrich behaviour.

Please don't post such low effort comments. Complaining about the downvotes is a faux pas. Ask AI to tell you five reasons you _could_ be downvoted for this post.

It's not low effort. I've noticed the blind AI hate on HN and I talked about it before. I think that "downvotes on the report of an experience" is good evidence of this. People don't want to hear that AI coding has positive outcomes.
Post reply on HN