Re:SQLite the only database you will ever need in most cases
by ngrilly on Thursday April 15, 2021 @01:17PM
(#26823381)
Since SQLite is embedded in your program, why not use your programming language directly. SQLite can even callback in custom functions you define. For example in Python: https://docs.python.org/3/library/sqlite3.html#sqlite3.Conne....
The main reason why main client-server databases have so many built-in functions is because of the round-trips. Let's say you want to filter rows based on the result of some function, if your function is implemented client-side, then the database would have to send each row to the client.
"Relational database engines act as bandwidth-reducing data filters." (https://www.sqlite.org/whentouse.html)
Re:SQLite the only database you will ever need in most cases
by NicoJuicy on Thursday April 15, 2021 @01:33PM
(#26823600)
I didn't consider it that way, thanks.
Round-trips and small queries don't have anything related to my comment?