Thomas Sibley

Better transaction handling would be really great. Some of my thoughts on implementing better transaction discipline are in https://github.com/simonw/sqlite-utils/pull/118#issuecomment-655239728. My preferences: - Each CLI command should operate in a single...

Yep, I agree that makes more sense for backwards compat and more casual use cases. I think it should be possible for the Database/Queryable methods to DTRT based on seeing...

I'd like to see this feature!

Yep. [I suggested the newer APIs](https://github.com/nextstrain/augur/pull/1281#discussion_r1298856930) in the work which added the older API usage.

Yes, exceptions should be chained (except in rare cases), and the default handler should know how to emit the full chain with all the gory details when a debug or...

@victorlin unfinished comment? I'd recommend the debug flag live in the environment rather than a command-line option, as it makes it much easier to set in a wide variety of...

Yeah, I've worked around UTF-8 safeness of recs before using `env PERL_UNICODE=SAD`, which is roughly equivalent to your `use open` line. Note that `:encoding(UTF-8)` is preferred to `:utf8` for the...

Unfortunately the patch above is fixing a symptom, not the root cause. The root cause is that recs doesn't decode/encode its input/output streams and instead treats them as bytes. This...

Nod. The patch may fix the specific case presented, but it introduces other bugs due to treating Perl's internal SV state as a "UTF-8 sniffer." I don't recommend applying it...

However! Text::VisualWidth::PP may still be useful, and I'm glad @bokutin mentioned it. :-)