# Ionic and MySQL database

**URL:** <https://forum.ionicframework.com/t/ionic-and-mysql-database/92816>\
**Category:** ionic-v3\
**Created:** [June 2, 2017, 3:31pm UTC](https://forum.ionicframework.com/t/ionic-and-mysql-database/92816 "2017-06-02T15:31:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![garusan](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/garusan/32/110185_2.png) [@garusan](https://forum.ionicframework.com/u/garusan)\
**Post date:** [June 2, 2017, 3:31pm UTC](https://forum.ionicframework.com/t/ionic-and-mysql-database/92816/1 "2017-06-02T15:31:02Z")

</div>

I’m developing a new app with ionic2 with MySQL database.  
I need to know how can I get and post data from ionic list input to a database table?  
need your help.  
thanks in advance

---

<div class="post-metadata">

**Author:** ![rapropos](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/rapropos/32/100227_2.png) [@rapropos](https://forum.ionicframework.com/u/rapropos)\
**Post date:** [June 2, 2017, 8:03pm UTC](https://forum.ionicframework.com/t/ionic-and-mysql-database/92816/2 "2017-06-02T20:03:57Z")

</div>

You need to build a REST application server that accepts HTTP requests and talks to the database.

---

<div class="post-metadata">

**Author:** ![sondaniel96](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/sondaniel96/32/110164_2.png) [@sondaniel96](https://forum.ionicframework.com/u/sondaniel96)\
**Post date:** [June 2, 2017, 9:04pm UTC](https://forum.ionicframework.com/t/ionic-and-mysql-database/92816/3 "2017-06-02T21:04:57Z")

</div>

if you want, try using sqlite which ionic does support.

> **[Ionic Framework](https://ionicframework.com/docs/storage/)**
>
> Ionic is the app platform for web developers. Build amazing mobile, web, and desktop apps all with one shared code base and open web standards

But if want that MySQL database to be used, like @rapropos said, your gonna have to build some backend that is an RESTful application which you can set Url’s for your ionic2 application to hit, to Get, Post, Put, Delete, etc. to your database.

---

<div class="post-metadata">

**Author:** ![NjalTheKnut](https://avatars.discourse-cdn.com/v4/letter/n/f17d59/32.png) [@NjalTheKnut](https://forum.ionicframework.com/u/NjalTheKnut)\
**Post date:** [June 27, 2017, 12:37pm UTC](https://forum.ionicframework.com/t/ionic-and-mysql-database/92816/4 "2017-06-27T12:37:57Z")

</div>

Hey there! I’m also interested in connecting my Ionic app to a database, but I’m unsure which to use, SQLite, which appears to be more of a local filesystem on the phone, or a back-end connection with a MySQL or MSAccess dektop database.

I found a connector to Node.js on the MySQL website, which appears to be a new addition to their line of community downloads, but I am not certain if this will help.

The database and application I am creating are intended to keep record of our school’s IT assets, (desktops, monitors, et cetera) and enable rapid mobile access to that information when we’re not at a computer. I have a barcode scanner integrated into the app, but as of yet there is no connection to a database, and I am at a loss as to which option is best for my situation.

I suppose my main question is, would it be possible to link my app with an Access DB, and if so, would it be easier or better to do that rather than create a database in MySQL?

Any help is appreciated! Thanks!

PS- I’m in a time crunch to get this done, so if anybody sees this, I would LOVE to get help well before Friday!

---

<div class="post-metadata">

**Author:** ![sanjib\_dev](https://avatars.discourse-cdn.com/v4/letter/s/94ad74/32.png) [@sanjib\_dev](https://forum.ionicframework.com/u/sanjib_dev)\
**Post date:** [June 27, 2017, 12:50pm UTC](https://forum.ionicframework.com/t/ionic-and-mysql-database/92816/5 "2017-06-27T12:50:02Z")

</div>

You can use any database which is suited for your application.  
MSAccess is too old for a modern day app. MSSQL will do or better go with postgress.

About the architecture:  
As already mentioned in the previous posts, all the mobile app mostly work through API calls i.e. data is stored on a remote server and app just calls it and fetch the data and in case of saving, it again sends the data through POST call.

Another thing is, local db which reside in app i.e. in the user mobile itself, can also be a good choice to store temporary data as users may not have Internet connection all the time.

You can go with whatever way suitable for you

---

<div class="post-metadata">

**Author:** ![NjalTheKnut](https://avatars.discourse-cdn.com/v4/letter/n/f17d59/32.png) [@NjalTheKnut](https://forum.ionicframework.com/u/NjalTheKnut)\
**Post date:** [June 27, 2017, 1:48pm UTC](https://forum.ionicframework.com/t/ionic-and-mysql-database/92816/6 "2017-06-27T13:48:42Z")

</div>

Thank you, this helped me to understand a bit better. I will look into SQLite and MSSQL to see whether one or both meets my needs. Thank you again!
