16

Does anyone can tell me how to connect to mysql database with Dart? I've been reading and searching for days but can't find any suitable answers. I just learning web programming. Thank you!

hoantrung
  • 191
  • 1
  • 1
  • 6
  • This problem I've solved recently. I just created a server with NodeJS, then I connect my flutter app yo mysql through a rest API. – Jesus Hedo Feb 10 '20 at 20:29

4 Answers4

15

You can use SQLJocky to connect to MySQL. Add 

dependencies:
  sqljocky: 0.0.4

to your pubspec.yaml an run pub install. Now you can connect to MySQL like this

var cnx = new Connection();
cnx.connect(username, password, dbName, port, hostname).then((nothing) {
    // Do something with the connection
    cnx.query("show tables").then((Results results) {
    print("tables");
    for (List row in results) {
      print(row);
    }
  });
});
Lars Tackmann
  • 20,275
  • 13
  • 66
  • 83
9

I think for dart 2 mysql1 is a simple choice.

Example:

import 'package:mysql1/mysql1.dart';

Future main() async {
  // Open a connection (testdb should already exist)
  final connection = await MySqlConnection.connect(new ConnectionSettings(
      host: '10.0.2.2',
      port: 3306,
      user: 'root',
      password: '0123456789',
      db: 'development',
      ));
  var results = await connection.query('select * from tableName');
  for (var row in results) {
    print('${row[0]}');
  }

  // Finally, close the connection
  await connection.close();
}

(tested on Dart version 2.1.0 (build 2.1.0-dev.9.4 f9ebf21297))

Nae
  • 14,209
  • 7
  • 52
  • 79
0

I haven't tried this, but here is one: http://github.com/jamesots/sqljocky

mwattsun
  • 1
  • 4
0

You can try using sqljocky -> http://pub.dartlang.org/packages/sqljocky

adlerluiz
  • 1
  • 2
  • Mine is giving me late initialization error have you tackle with this error, when you connect to MySQL connection it gives you late initialization or null error – Ismail Shah Nov 17 '21 at 13:52