Enhance SQLite output

2 minute read Published:

I’ve been doing some development in Baoqu with SQLite recently, and one of the problems I’ve faced is that the default output from a query in the SQLite client is too basic, almost confusing: sqlite> select * from users; 1|Ramira 2|Maria 3|Yamilo 4|Mario 5|PĂ©rez-Reverte 6|Yisus 7|Miguel 8|Marta 9|andy 10|lol 11|lol2 12|lolaso That’s a simple query, let’s complicate it a little more: sqlite> select * from users as u inner join users_circles as uc on u.