News for hackers. Stuff that matters.
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?
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!"

Re:SQLite is not a toy database by yawaramin on Thursday March 25, 2021 @09:03PM (#26587725)
Actually, for SQLite at least, they wouldn't. https://www.sqlite.org/copyright.html#notopencontrib