Re:SQLite is not a toy database
by flyflyFenix on Thursday March 25, 2021 @05:25PM
(#26585592)
I was a fan of SQLite until I needed a full outer join of two tables. It was such a pain to create a workaround when I found out it isn't supported, and the result was still sub-optimal and needlessly complex. Is running a full outer joins such a unreasonable assumption within a DBMS?
[ Parent
| on HN ]
Re:SQLite is not a toy database
by justin_oaks on Thursday March 25, 2021 @05:40PM
(#26585763)
I hear you. MySQL still doesn't have full outer joins either.
I would think this would be one of the easier features to add.
Of course, I'm sure the people working on MySQL or SQLite would say "Patches welcome!"
Actually, for SQLite at least, they wouldn't. https://www.sqlite.org/copyright.html#notopencontrib