Newbie Area Revolution

saat install debian 9/stretch 64 bit, secara default tidak support 32 bit, jadi harus diatur secara manual. jadi ketika saya donlot <https://sqlite.org/download.html> versi "Precompiled Binaries for Linux" (yg cuma ada 32bit), lalu saya jalankan, tapi debian tidak bisa membaca file tersebut. lalu saya baca wikinya <https://wiki.debian.org/Multiarch/HOWTO>, kalo ia32-libs sudah deprecated dan sudah dihilangkan pada debian 9/stretch. lalu disarankan untuk, bahwa ia32-libs tidak ada penggantinya, tapi kita bisa pakai "Android SDK compat libraries" <https://wiki.debian.org/Multiarch/HOWTO#Installing_Android_SDK_compat_libraries>. ``` sudo dpkg --add-architecture i386 sudo apt update sudo apt install gcc-multilib sudo apt-get install libstdc++6:i386 libgcc1:i386 zlib1g:i386 libncurses5:i386 ``` berhasil.

I just known, that Firebird have DDL (Data Definition Language) for DROP+CREATE store procedure in one go. so instead of "CREATE PROCEDURE test; ALTER PROCEDURE test;" or "DROP PROCEDURE test; CREATE PROCEDURE test;" you can just "RECREATE PROCEDURE test;" and boom! done 😎.