Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 4 years ago .

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, 2018 at 2: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, 2018 at 2: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, 2018 at 12:41 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, 2018 at 5:08

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.

@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 3, 2021 at 3:01