News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by NicoJuicy on Thursday April 15, 2021 @11:00AM (#26821288)
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't have anything related to my comment?

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.
Re:SQLite the only database you will ever need in most cases by ngrilly on Thursday April 15, 2021 @01:54PM (#26823891)
My initial comment was a bit cryptic to be honest :)
Re:SQLite the only database you will ever need in most cases by NicoJuicy on Thursday April 15, 2021 @02:10PM (#26824140)
You resolved it perfectly.

My experience with flatfiles dbs was not enough to interpret it correctly :p