Sqlite3 autocomplete

I started using pihole-FTL sql as my standard sqlite3 binary on all my work machines even when no Pi-hole is installed because it is easy to download, has zero dependencies and is always up-to-date. Thanks a lot for this.

This feature request asks for the auto-completion feature the system-provided sqlite3 has built-in. It would be tremendously helpful.

This is an easy task, I didn't notice we haven't had this enabled so far.

2 Likes

Almost zero :wink:

pi@ph5b:~ $ ldd /usr/bin/pihole-FTL
        /usr/lib/arm-linux-gnueabihf/libarmmem-${PLATFORM}.so => /usr/lib/arm-linux-gnueabihf/libarmmem-v6l.so (0xb6bc3000)
        libm.so.6 => /lib/arm-linux-gnueabihf/libm.so.6 (0xb6b54000)
        librt.so.1 => /lib/arm-linux-gnueabihf/librt.so.1 (0xb6b3c000)
        libgcc_s.so.1 => /lib/arm-linux-gnueabihf/libgcc_s.so.1 (0xb6b0f000)
        libpthread.so.0 => /lib/arm-linux-gnueabihf/libpthread.so.0 (0xb6ae3000)
        libc.so.6 => /lib/arm-linux-gnueabihf/libc.so.6 (0xb698f000)
        /lib/ld-linux-armhf.so.3 (0xb6ee5000)

This deserves just one word: AWESOME. This is more than I could have asked and it was there at the same day. Going to donate right now.

sqlite> SELECT * FROM 
Display all 148 possibilities? (y or n)

You really rock Pi-hole guys. I have never seen a project with such excellent support and community anywhere. Neither in the open-source nor in the paid software world.

@deHakkelaar You are missing out the excellent and very fast musl binaries:

$ ldd ./pihole-FTL-musl-linux-x86_64 
	not a dynamic executable

https://ftl.pi-hole.net/new/sqlite3_autocomplete/pihole-FTL-musl-linux-x86_64

4 Likes