How to connect Ms SQL from a Flutter App?

Question

Some context: The Db already exists and the app is for internal use of the company, that's why I'm not doing an API.

I need to connect my app to an SQL server to execute a query and retreive data from it.

I've already tried with this plugin but no succes SqlJocky5

Someone have done something similar already with flutter? How you did it? there's another library for connecting the app with a sql server? So, What I'm looking for is if there's a library to do it like in Xamarin Forms (SqlClient) or in Android Studio Java (JDBC Driver).

SqlJocky5 is driver for MySQL not SQL Server there is no SQL server for dart as far as i know but help me to understand why you are not doing an API ? — Raouf Rahiche, Jul 12 '18 at 02:28
@RaoufRahiche I'ts for a company that provides a finnancial services and more, i just started working there like a month ago and I really dont get to decide yet about the tech used. So instead of making an API by miself I have to use and existing server and Sql Database — Joaquín, Jul 12 '18 at 02:43
"thats why im not doing an api" you mean hide the SQL server behind a REST API? You still should, even when it's only an internal app. — Günter Zöchbauer, Jul 16 '18 at 12:41
@GünterZöchbauer as I've explained before I'm an intern and I can't decide those things — Joaquín, Jul 16 '18 at 12:46
That's not really a decision. Connecting a mobile client to an SQL server directly doesn't make sense. Also "tried with this plugin but no succes" isn't really useful information. You should add the expected behavior and the actual behavior (error message, ...) — Günter Zöchbauer, Jul 16 '18 at 12:48
https://groups.google.com/forum/#!topic/flutter-dev/GO9ilukcoN4 //please visit this google group link. I hope this link helps you. — rahul singh Chauhan, Jul 21 '18 at 05:08

score 17 · Accepted Answer · edited Jul 17 '18 at 00:24

17

I tried to ask a question and I got block because I didn’t answer some question.

Here is the answer:

From https://groups.google.com/forum/#!topic/flutter-dev/GO9ilukcoN4 from @Abner Hernandez

First: you need a SQLServerSocket: https://github.com/nippur72/SqlServerSocket is free and works! Second: you need a client https://github.com/nippur72/SqlServerSocket (look in DartClient folder). I did several connections and it works very well.

Of course, it is not as "easy to use, with 2 or 3 clicks and less programming..." but yes, you can "implement a simple SELECT * FROM XXX and show the results on both devices (IOS and Android) with Flutter." I did it.!

Yes I tested it with my remote sql and is working on CRUD. I didn't test for extensive query yet.

günter-zöchbauer gives the best practices.

You should use AQUEDUCT aqueduct.io and create a web api so your Flutter app connects to the server more securely.

edited Jul 17 '18 at 00:24

Serl

240
1
14

answered Jul 16 '18 at 19:06

NTMS

816
7
22

then how can I connect aqueduct to mysql or oracle? – Nick Feb 04 '19 at 06:12
there is no SqlServerSocket.exe in SqlServerSocket.exe – ThitSarNL Oct 18 '19 at 21:26
@ThitSarNL have you found the solution to this? – Steven Dec 17 '20 at 05:21
Have anyone found sqlserversocket.exe?? – Qaiser Hussain Mar 04 '21 at 11:53
Question wasSfor Flutter and Dart programming. so you can't find windows base exe in dart programming. – NTMS Mar 04 '21 at 16:00
@Nick you need to convert mysql or oracle connection string to dart http. – NTMS Mar 04 '21 at 16:01
@Nick check the solution in here: https://stackoverflow.com/questions/11963444/how-to-connect-mysql-database-with-dart – NTMS Mar 04 '21 at 16:03
for Oracle try this solution: https://stackoverflow.com/questions/52448788/how-can-i-connect-flutter-dart-with-my-oracle-server-have-some-one-tried-on – NTMS Mar 04 '21 at 16:04
2

@QaisarKhanBangash to get sqlserversocket.exe you need to pull above git's server project. then open it using visual studio (mine vs 2019). after open you can build exe your self by click on start button. this will create exe in bin folder in it – T.A.Chathura Priyahsad May 03 '21 at 03:01

How to connect Ms SQL from a Flutter App?

1 Answers1

Linked