3 ms·
Awesome! SQLite, from my perspective at least is feature-complete! Anyone else have any notable missing features?
by radus 6y ago
Awesome! SQLite, from my perspective at least is feature-complete! Anyone else have any notable missing features?
- pgwhalen 6y agoAs superb a piece of software as SQLite is, it's definitely still missing features that many would use. No FULL OUTER JOINs is maybe the most notable that I've encountered. https://www.sqlite.org/omitted.html https://www.sqlite.org/omitted.html
- simonw 6y agoI'm curious as to what you use FULL OUTER JOINS for - I've so far never felt the need for them in my own work but I'd love to understand what I'm missing out on.
- pgwhalen 6y agoThe one use case I’ve found recently is joining sparse time series data. In other words, when the tables you’re joining are “equally important” as opposed to one depending on the other.