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?
[ Parent
| on HN ]
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...