Can JavaScript connect with MySQL?

by

Client-side JavaScript cannot access MySQL without some kind of bridge. But the above bold statements that JavaScript is just a client-side language are incorrect — JavaScript can run client-side and server-side, as with Node.js.

Node.js can access MySQL through something like https://github.com/sidorares/node-mysql2

You might also develop something using Socket.IO

Did you mean to ask whether a client-side JS app can access MySQL? I am not sure if such libraries exist, but they are possible.

EDIT: Since writing, we now have MySQL Cluster:

The MySQL Cluster JavaScript Driver for Node.js is just what it sounds like it is – it’s a connector that can be called directly from your JavaScript code to read and write your data. As it accesses the data nodes directly, there is no extra latency from passing through a MySQL Server and need to convert from JavaScript code//objects into SQL operations. If for some reason, you’d prefer it to pass through a MySQL Server (for example if you’re storing tables in InnoDB) then that can be configured.

More Related Contents:

  1. Why does Google prepend while(1); to their JSON responses?
  2. jQuery AJAX cross domain
  3. Serializing to JSON in jQuery [duplicate]
  4. AJAX cross domain call
  5. Post data to JsonP
  6. Convert JSON array to an HTML table in jQuery
  7. Ajax request returns 200 OK, but an error event is fired instead of success
  8. Converting a string to JSON object
  9. Chrome refuses to execute an AJAX script due to wrong MIME type
  10. Why is it a bad practice to return generated HTML instead of JSON? Or is it?
  11. How do I load a JSON object from a file with ajax?
  12. JSON security best practices?
  13. loading json data from local file into React JS
  14. Jquery getJSON populate select menu question
  15. jQuery AJAX polling for JSON response, handling based on AJAX result or JSON content
  16. Get JSON in a Chrome extension
  17. send json object from javascript to php
  18. React Js: Uncaught (in promise) SyntaxError: Unexpected token < in JSON at position 0
  19. AJAX call and clean JSON but Syntax Error: missing ; before statement
  20. jQuery AJAX Call to PHP Script with JSON Return
  21. console.log(result) prints [object Object]. How do I get result.name? [duplicate]
  22. Make XmlHttpRequest POST using JSON [duplicate]
  23. Execute function after Ajax call is complete
  24. Why does Google prepend while(1); to their JSON responses?
  25. Annoying javascript timezone adjustment issue
  26. SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
  27. Cross-Origin resource sharing and file://
  28. creating highchart with ajax json data
  29. How to return an array from an AJAX call?
  30. JQuery getJSON – ajax parseerror

Leave a Comment