2

I'm new to flutter and i really want to know, is there a way to connect to a database server (for instance mysql) in flutter rather using firebase. I'm working on a smart parking system project where i need to insert the latitude and longitude of the parking area which is free into the database which is created in server and retrieve it whenever user requests for it. It would be great if anyone gives solution for above mentioned problem (Flutter with database).

Improve this question
1

2 Answers 2

Reset to default
7

Since Flutter is just a UI Framework, topics such as persistence and databases may be out of scope or may depend on the use case.

Flutter UI's can persist data (application state) for short periods of time in a manner that is really only useful for the purposes of creating a good User Experience (is this button click? is it green? etc.)

For persisting more useful data outside of the application and on the actual device, you may want to consider the Shared Preferences Plugin for Flutter.

Wraps NSUserDefaults (on iOS) and SharedPreferences (on Android), providing a persistent store for simple data. Data is persisted to disk automatically and asynchronously.

Now, if you require persisting data in any centralized manner (e.g. RDMS, Firebase, or any data persistence service) your options are:

  • Persistence options that have a Flutter plugin (e.g. Firestore, Firebase)
  • Build your own service layer using HTTP, gRPC that talks to some backend service that provides access to a data store. You can do this with Express, Rails, CloudFunctions, etc.
  • As for connecting directly to a database such as MySQL, I don't see why you couldn't do that (maybe there is some technical limitation), but this would be a very bad idea in any practical situations as (unlike Firebase/Firestore) you won't be able to protect your data store once any client application has write access.

It sounds like you need a central read/write data store, so your best bet may be to host a server that provides access to a database while exposing an API to Flutter for which you can use dart:io to make requests.

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

Comments

2

Try using sqflite. It's a package you can include in your Flutter app that allows you to persist data to the local device. You will need to use the path_provider as well. Here is the link to the repository on Github https://github.com/tekartik/sqflite

Improve this answer

1 Comment

Could you include some sample code to help answer the question better rather than just posting a link as in future the link could change and the answer would then become irrelevant

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.