News for hackers. Stuff that matters.
Re:C Is Best by chasil on Tuesday January 06, 2026 @09:50AM (#46512956)
What isn't supported? After window functions were added, what else is missing?
Re:C Is Best by hmry on Tuesday January 06, 2026 @10:17AM (#46513335)
The ones that come to mind immediately are more ALTER statements (especially adding non-virtual columns), DATE, TIME, and TIMESTAMP types and their associated functions, and ARRAY types. Although I don't wish to disparage SQLite, they do support a lot of features. Just that I constantly run into the ones they don't, with my use cases.

And beyond standard SQL, stuff like hashmap/bloom filter/vector indices, nearest neighbor search, etc...