Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Database access with Angular

Tags:

mysql

angular

Is it possible to access MySQL databases in Angular framework or would that be insecure like other Javascript and I will need to post to a PHP page to retrieve data/json from a database

like image 276
Callum Chis Avatar asked Nov 07 '22 15:11

Callum Chis


1 Answers

1- Is it possible to access MySQL databases in angular framework?

The question is not angular specific but YES it's possible , since MySQL 5.7 inserting, updating and deleting records in MySQL via HTTP is possible. Something like this

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

like image 68
Mehari Mamo Avatar answered Nov 14 '22 22:11

Mehari Mamo