3 ms·
So you want to write functions in SQL? With SQLite you can define your own functions which can be called in your queries, but they do need to be written in yo
by config_yml 4y ago
So you want to write functions in SQL?
With SQLite you can define your own functions which can be called in your queries, but they do need to be written in your application language.
- doctor_eval 4y agoYeah I know. But I find stored SQL to be a lot more concise than the application language, and less prone to bugs. I also find that it creates a much better separation of concerns between stuff that touches the database versus non-database stuff. Just one example, error behaviour is well defined in PLPGSQL so I don’t have to constantly check for errors. That’s not true in my host language. I am super impressed with SQLite, it’s just not a good fit for how I use databases yet.