4 ms·
SQL is a real programming language (even though, many people seems to not think so). I use SQLite, although there are other SQL implementations (with different
by zzo38computer 8y ago
SQL is a real programming language (even though, many people seems to not think so). I use SQLite, although there are other SQL implementations (with different features) too.
It is true many thing can be done well with SQL, whether you call from other programs or use standalone.
Whether it will be faster or not to use SQL probably depends on what SQL implementation is in use, whether the indexing is set up properly, and what programming language you are calling it from.
Also, much things can be done with a shorter code in SQL if you are doing such things as sorting the result set.