3 ms·

I 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

• ngrilly 6y ago
  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.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)
  • NicoJuicy 6y ago
    I didn't consider it that way, thanks.
    • ngrilly 6y ago
      My initial comment was a bit cryptic to be honest :)
      • NicoJuicy 6y ago
        You resolved it perfectly. My experience with flatfiles dbs was not enough to interpret it correctly :p