With which other programming languages can we combine SQL and for what? | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
+ 8

With which other programming languages can we combine SQL and for what?

7th Dec 2016, 2:31 PM
Michael Xanthopoulos
Michael Xanthopoulos - avatar
6 ответов
+ 7
Well almost any general purpose language has some kind of database bindings so you can use those that do to perform SQL queries on a database.
7th Dec 2016, 3:42 PM
James Durand
James Durand - avatar
+ 7
I'm not quite done with it yet, but I'm doing some cryptoanalysis in Javascript. I've embedded the AlaSQL engine because queries are easier and more clear than a bunch of javascript. For example, a list of palindromes by popping off to embedded SQL from javascript: // Setup var adb, num_created, sql, result; adb = new alasql.Database(); alasql.fn.REVERSE = function(s) { return s.split('').reverse().join(''); } num_created = adb.exec("CREATE table dictionary (id INT autoincrement, word STRING);"); // Load the database dictionary...(not shown) // Prepare palindrome query (assume case-insensitive / indexing) sql = "SELECT id from dictionary d where EXISTS (SELECT word from dictionary d2 WHERE d2.word = REVERSE(d.word));"; // This is the entire list, in one query. result = adb.exec(sql);
25th Jan 2017, 1:46 PM
Kirk Schafer
Kirk Schafer - avatar
+ 4
wit s depending. on what you want. to make. if you want. to create. web site. you can combinated with php or if it s an appsyou well need. java or c# to creat interface. for your apps
9th Dec 2016, 4:55 PM
Abdenour Sahel
Abdenour Sahel - avatar
+ 4
Almost any. For Database connectivity. I'm learning to use it with PHP.
29th Jan 2017, 10:55 AM
Kartikay Sharma
Kartikay Sharma - avatar
+ 3
depends what you mean by combine. for how we use it we use Stored Procedures to do the work while the front end is in .Net or VBA
24th Dec 2016, 8:30 PM
Tom Govier
Tom Govier - avatar
+ 3
well being a product of Microsoft, SQL can combines with any Microsoft language,
29th Jan 2017, 3:13 AM
Prakash Rawat
Prakash Rawat - avatar