Connect to MySQL using Ionic Framework without api layer

Question

Is it possible to connect to a MySQL database directly from an Ionic application without an integration/api layer?

All the answers I found online suggest to create API in php or nodejs, but I would like to develop a sql client and the whole point of the application is to be able to make queries directly from the client device.

I cannot use the node mysql library from client side.

I am using Ionic 6 React.

you can't direct access mysql from device... nodejs can access it because it acts as a server but as a native/hybrid platform, it can't direct access mysql... the only possible solution is to using api's.. — Mostafa Harb
– Mostafa Harb, Commented Jun 25, 2022 at 8:03

Patrick Kenny · Accepted Answer · 2022-08-26 17:27:57Z

1

No, as noted by Mostafa Harb, you cannot directly access a MySQL database in the cloud from a device. You'll need to use some kind of API.

The basic flow:

Ionic app authenticates to the API if necessary.
Ionic app uses Axios or Fetch to use the API to query the cloud database.
The API returns the response in a format the Ionic app understands.

The good thing about Ionic is that it is mostly framework-agnostic, so you can use any API you like.

Personally, I use Drupal, which is a PHP-based CMS that has support for providing access to Ionic via REST, JSON:API, or GraphQL (or a mix of the three).

answered Aug 26, 2022 at 17:27

Patrick Kenny

6,88519 gold badges67 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to MySQL using Ionic Framework without api layer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related