Searching for updated database tutorial

New to Julia
,
1

It seems that Julia database tutorials that are on the web are outdated. Are there any simple examples of Julia and, say, MySQL.jl usage?

2

Hi Miko, if you are looking for first steps…

julia> using MySQL, DataFrames
julia> dbconn = DBInterface.connect(MySQL.Connection, "127.0.0.1", "wiag", "secret pwd", db = "wiag2")

This opens a database connection on host 127.0.0.1 (localhost) for user “wiag” identified with “secret pwd” on database “wiag2”. Then you can use the connection for queries or any other SQL-statement:

julia> sql = "SELECT id, givenname, familyname FROM person LIMIT 12"
julia> df_p = DBInterface.execute(dbconn, sql) |> DataFrame;

julia> df_p
12×3 DataFrame
 Row │ id     givenname  familyname
     │ Int32  String     String?
─────┼──────────────────────────────
   1 │    80  Ortlieb    Brandis
   2 │    81  Jean       Bourgeois
   3 │    82  Louis      Bourbon
   4 │    83  Radbod     missing
   5 │    84  Egilbert   missing
   6 │    85  Adelbold   missing
   7 │    86  Alfrid     missing
   8 │    87  Hunger     missing
   9 │    88  Liudger    missing
  10 │    89  Eginhard   missing
  11 │    90  Alberich   missing
  12 │    91  Friedrich  missing

The result of the query is used here to create a DataFrame.
As an alternative you may want to iterate over the result set:

julia> qi = DBInterface.execute(dbconn, sql);
julia> for row in qi
       println(row[:id], " ", row[:givenname])
       end
80 Ortlieb
81 Jean
82 Louis
83 Radbod
84 Egilbert
85 Adelbold
86 Alfrid
87 Hunger
88 Liudger
89 Eginhard
90 Alberich
91 Friedrich
3 Likes
3

Thank you!