How can I connect my Flutter app to local sql server database using API?

Question

Am working on a flutter app that is required to do CRUD functions from sql server. I have researched and found that I can use REST API or webservice for the same. How can I implement this?

How can I implement this is too broad. Implement the API and use it basically. — Vladyslav Matviienko
– Vladyslav Matviienko, Commented Nov 25, 2019 at 7:17

jaredbaszler · Accepted Answer · 2021-09-24 18:18:16Z

3

Step 1: choose a backend language/framework that will let you create a REST API. Laravel is one. If you want everything in Dart, Aqueduct I hear is a good choice.

EDIT/NOTE: Aqueduct sunset news here: https://stablekernel.com/article/announcing-the-sunsetting-of-aqueduct-our-open-source-server-side-framework-in-googles-dart/

Step 2: Make that backend do the things that need to be done with the database. Make sure you handle security/authentication. Test it with something like Postman. Manually be able to use it just like the app would use it, e.g., "making this request adds a post".

Step 3: Now develop a Flutter app that connects to this backend with a Dart package such as dio, http, etc. More info here: https://flutter.dev/docs/cookbook#networking

edited Sep 24, 2021 at 18:18

jaredbaszler

4,8693 gold badges35 silver badges42 bronze badges

answered Nov 25, 2019 at 6:30

Gazihan Alankus

12.2k7 gold badges52 silver badges68 bronze badges

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

1 Comment

JaredKarl Over a year ago

Thanks, @Gazihan Alankus for your response. I have experience in laravel though I don't know how to link the laravel REST API with the flutter.

Collectives™ on Stack Overflow

How can I connect my Flutter app to local sql server database using API?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related