Book Image

DART Cookbook

By : Ivo Balbaert
Book Image

DART Cookbook

By: Ivo Balbaert

Overview of this book

Table of Contents (18 chapters)
Dart Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Storing data in MySQL


MySQL is undeniably the most popular open source SQL database. Dart can talk to MySQL using the pub package sqljocky by James Ots (https://github.com/jamesots/sqljocky). In this section, we will demonstrate how to use this driver step by step. You can see it in action in the using_mysql project.

Getting ready

  • To get the database software, download and install the MySQL Community Server installer from http://dev.mysql.com/downloads/mysql/. This is straightforward. However, if you need any help with the installation, visit http://dev.mysql.com/doc/refman/5.7/en/installing.html.

  • Run the MySQL database system by starting mysqld on a command prompt from the bin folder of the MySQL installation. We need to create a database and table to store data. The easiest way is to start the MySQL Workbench program, make a connection, and then click on the button Create a new schema in the connected server, name it jobsdb, and click on apply.

  • Select the schema by double-clicking on it, and...