mysql - 使用 Angular 访问数据库

Question

是否可以在 Angular 框架中访问 MySQL 数据库，或者像其他 Javascript 一样不安全，我需要发布到 PHP 页面以从数据库中检索 data/json

Answer 1

1- 是否可以在 Angular 框架中访问 MySQL 数据库？

这个问题不是特定于 Angular ，但是是可能的，因为 MySQL 5.7 可以通过 HTTP 在 MySQL 中插入、更新和删除记录。像这样

http://127.0.0.1:8080/sql/myhttp/SELECT+name_first,+name_last+FROM+names 
``` [refer here][1]

> Hence you can interact with MySQL directly with any HTTP client  with
> out any middle-ware.

 By HTTP Client I mean Curl,Wget or any Http library/API of any language (ajax,request,fetch,axios ... for JavaScript/node) 

2 - Would that be insecure like other JavaScript?

Again not JavaScript specific, But **Yes it's insecure(not recommended)** to directly interact with the database from the client.
  Why?
You need to handle database security issues like SQL Injection from the client side (angular in this case). It's is very inconvenient to do that.


  [1]: https://scriptingmysql.wordpress.com/2015/01/15/mysql-5-7-labs-and-the-http-plugin-inserting-updating-and-deleting-records-in-mysql-via-http/

> I do recommend to always have database access middle-ware
> (php,node,python ...) than interacting from client side