3 ms·

Full outer join is my fave update. I kinda wish sqlite has more functions though.

• bob1029 4y ago
  You can add as many functions as you like: https://www.sqlite.org/appfunc.html https://www.sqlite.org/appfunc.html
  • Rebelgecko 4y ago
    Unfortunately I don't think that can be done natively (like defining a function before using it in a query via the CLI). Only by writing and compiling some C
    • zimpenfish 4y ago
      > Only by writing and compiling some C Or Rust - https://ricardoanderegg.com/posts/extending-sqlite-with-rust/ https://ricardoanderegg.com/posts/extending-sqlite-with-rust...
  • tanin 4y ago
    There is something like this: https://news.ycombinator.com/item?id=26683832 https://news.ycombinator.com/item?id=26683832 But I would prefer using something Sqlite officially maintains and not to maintain anything myself. I also don't prefer using libraries from random people unfortunately. Working at a fintech makes me paranoid...