# API database external Mysql? **URL:** \ **Category:** External Collections, Custom Actions & Collections\ **Created:** [February 12, 2021, 1:24pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122 "2021-02-12T13:24:58Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![softal](https://avatars.discourse-cdn.com/v4/letter/s/41988e/32.png) [@softal](https://forum.adalo.com/u/softal)\ **Post date:** [February 12, 2021, 1:24pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/1 "2021-02-12T13:24:58Z")
Hello, I need an API for connecting to mysql databases? Any recommendations ? ---
**Author:** ![EdU](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/edu/32/6474_2.png) [@EdU](https://forum.adalo.com/u/EdU)\ **Post date:** [March 9, 2021, 1:10pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/2 "2021-03-09T13:10:02Z")
[https://dev.mysql.com/doc/index-connectors.html](https://dev.mysql.com/doc/index-connectors.html) Not sure if this is what you are looking for - it really depends on where your database is and how it is set up for interaction with other services ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [March 9, 2021, 6:29pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/3 "2021-03-09T18:29:56Z")
Hi @softal, There is no direct way to do it from Adalo. Please see here [Connect Adalo app with MySql database/table](https://forum.adalo.com/t/connect-adalo-app-with-mysql-database-table/7592) and here [Mysql data base vs adalo](https://forum.adalo.com/t/mysql-data-base-vs-adalo/5570) I’d be happy to discover if someone knows an easy way to do it! Best regards, Victor. ---
**Author:** ![Graham](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/graham/32/6788_2.png) [@Graham](https://forum.adalo.com/u/Graham)\ **Post date:** [March 10, 2021, 10:09am UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/4 "2021-03-10T10:09:04Z")
If you aren’t afraid of a bit of PHP coding you can create your own REST interface to read data fairly easily. But I’m running into all sorts of issues with updating the data ☹ Here is a good tutorial on it [https://codeofaninja.com/2017/02/create-simple-rest-api-in-php.html](https://codeofaninja.com/2017/02/create-simple-rest-api-in-php.html) ---
**Author:** ![EdU](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/edu/32/6474_2.png) [@EdU](https://forum.adalo.com/u/EdU)\ **Post date:** [March 10, 2021, 3:00pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/5 "2021-03-10T15:00:20Z")
Thank you for the great write ups on this issue. I found this > **[DreamFactory Product Packages](https://www.dreamfactory.com/products/)** > > DreamFactory is available in three editions: Community, Professional, and Enterprise. looks interesting but they don’t give a price - so that feels expensive ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [March 10, 2021, 5:51pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/6 "2021-03-10T17:51:35Z")
Hi @Graham, Thanks for the link, bookmarked! 🙂 As for me, the problem with building own API is not about coding, but more about maintaining it later… if you have just MySQL - ok, you can use AWS (for instance) to store the base for you. But if you need PHP - then you need Apache/Nginx. Which is, in turn, quite probably, will require some OS instance (Linux for example). Then you’ll need to install management tools there (to be sure that server is up and running, there is enough disk space, etc), be sure to have regular updates for the OS and software packages, etc. etc. etc… The beauty of SaaS and No Code is that you don’t really care about all this infrastructure 🙂 Just my 2 cents 🙂 Best regards, Victor. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [March 10, 2021, 5:56pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/7 "2021-03-10T17:56:57Z")
Hi @EdU, Thanks for the link! Yes, sites without pricing looks quite strange and make you think about some enterprise-level prices 🙂 Best, Victor ---
**Author:** ![Graham](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/graham/32/6788_2.png) [@Graham](https://forum.adalo.com/u/Graham)\ **Post date:** [May 24, 2021, 11:46pm UTC](https://forum.adalo.com/t/api-database-external-mysql/9122/8 "2021-05-24T23:46:32Z")
@EdU Yes Dreamfactory’s pricing is ridiculous, it was about $15,000 a year from memory, great product otherwise.