2 ms·
What isn't supported? After window functions were added, what else is missing?
by chasil 10mo ago
What isn't supported? After window functions were added, what else is missing?
- hmry 10mo agoThe 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...