4 ms·
You don't really need v8 JavaScript functions built-in in the database when you use SQLite, because SQLite is running in the same process than your application.
by ngrilly 6y ago
You don't really need v8 JavaScript functions built-in in the database when you use SQLite, because SQLite is running in the same process than your application. The round trips between your application and SQLite cost almost nothing.
Also see "Many Small Queries Are Efficient In SQLite":
https://sqlite.org/np1queryprob.html https://sqlite.org/np1queryprob.html
- NicoJuicy 6y agoI was literally talking about using v8 functions when managing data ( eg. updating event versions should be a clear use-case) Round-trips and small queries don't have anything related to my comment?
- ngrilly 6y agoSince 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.Connection.create_function 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 https://www.sqlite.org/whentouse.html)