SQLite 3.53.0

71 points by EvanHahn

JulianWgs

Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints.

That‘s awesome! Hope they continue to enhance ALTER TABLE even more, because it is such annoying limitation.

Does anyone know if the sqlite team ever responded to Turso reimplementing sqlite in Rust?

scruss

I never saw anything, but what benefit would it bring to Richard Hipp to go public?

hmpc

Always use a sort-and-merge algorithm for EXCEPT, INTERSECT, and UNION, since this is almost always faster than using a hash table.

Does anyone have more information about this? I'm curious about the benchmarks they used and whether they dug further into the performance differences.

simonw

Here's a playground UI for trying the new results formatter library (built from my phone with Claude Code).

ilyagr

The wrapping is very nice (if you set screen width or column wrap to a low value).

mond

Over here I'm wishful and hoping that maybe someday we'll get Pipe syntax in SQLite, but this release is not the one, and it's probably wishful thinking.

lalitm

It's not as unlikely as you think: Dr Hipp said he'll add it when Postgres adds it!

Now just need to convince the Postgres developers to do so...
viraptor

You can use https://prql-lang.org/ in your apps / interface and compile it down to SQL. It gives you one of the best pipe options there is.

adeolemon

I love SCREAMING in my head when reading about SQL semantics, I don’t know why.

Anyone else? Am I just weird?

hawski

I think closest analog I have to how I pronounce it in my head is robot voice or serious business voice. If robot voice it would be a bit retrofuturistic in vibe as it reminds me of C64 BASIC.
- adeolemon
  
  Love it. I don’t normally have a voice when reading code either. Just prose and SQL.