flutter connect to SQL server directly

[charles...@gmail.com]

Hi guys,

Is there a way to connect SQL server like using the JDBC connection string. right now I am working on a project where the app needs to connect the SQL server directly, we do not want to provide a web API layer to flutter. Can we go this way to implement the access to SQL server?  Could you guys send me a solution back? Please, I have been looking for how to do this for a long time. However, I did not figure out it. 

Thanks a lot

[Anton Hughes]

>  we do not want to provide a web API layer to flutter

Why not? Youre going to have a great deal of difficulty without providing a web service to connect to your db. 

--
You received this message because you are subscribed to the Google Groups "Flutter Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to flutter-dev...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Adolfo Cueto]

totally agree with you, how hard is use a web service?

[Charles wang]

Yes , if we have a REST API, it would make the thing easy and smooth.

 

However, The company do not want to spent time adding a web server layer over the SQL server .they just provided me a VPN access point. It can makes flutter available to access the SQL server remotely as the way connect to it locally like using JDBC string .

 

I have to install the VPN on the tablet first. Even though it can work in theory. I can not find a SQL server driver in Flutter.

 

Regards

 

Sent from Mail for Windows 10

[Jimmy Aumard]

You can try to see jaguar_orm, it has SQL adapter I think :) might fit your needs 

[Charles wang]

Hi Jimmy,

 

Thanks a lot. I will try it.  The adapter code demo shows how to manipulate the postgres. Maybe it works for SQL Server.

 

 

 

Sent from Mail for Windows 10

 

[Jimmy Aumard]

There also an adapter for MySQL, but SQL Server I don't think so... you might need to create your own adapter... 

[Từ Phương Danh]

Is this help you?

https://pub.dartlang.org/packages/sqljocky#-readme-tab-

--