3 ms·
Application-defined functions are very useful. One of my company's applications is already designed to work with different SQL systems and a new customer despe
by foepys 6y ago
Application-defined functions are very useful.
One of my company's applications is already designed to work with different SQL systems and a new customer desperately wanted SQLite for a very special use case. As SQLite is quite simple and doesn't support many functions that are standard in SQL Server, MySQL, Oracle, etc., we used application-defined functions to implement all functions the application needs in C#. It's not very fast but also not slow and the customer is happy, which is what really counts.