database-14.jl

using Cairo
using Compose
using DataFrames
using Gadfly
using Measures
Gadfly.push_theme(:dark)

benchmark = DataFrame(
    Time = [219.653593, 305.19222807884216, 0.566995, 12.32638692855835],
    Clients = repeat(["MySQL.jl", "PyMySQL"], outer= 2),
    Tasks = repeat(["Populating", "Reading"], inner = 2)
)

p = plot(
    benchmark,
    x = :Time,
    y = :Tasks,
    color = :Clients,
    Guide.xlabel("Processing Time in Seconds (Shorter is Better)"),
    Guide.colorkey(pos = [.775w, -0.13h]), 
    Geom.bar(position = :dodge, orientation = :horizontal),
    Guide.annotation(
        compose(
            context(),
            (context(), Compose.text(0.05w, 0.14h, "MySQL.jl took 0.57 second in reading the server response."), Compose.fill("#a0a0a0"))
        )
    ),
    Guide.annotation(
        compose(
            context(),
            (context(), Compose.text(0.15w, 0.74h, "Populating MySQL Table"), Compose.fill(colorant"#ffffff"), Compose.stroke(nothing))
        )
    ),
    Guide.annotation(
        compose(
            context(),
            (context(), Compose.text(0.15w, 0.8h, "with 336,776 rows."), Compose.fill("#ffffff"))
        )
    )
);

p |> PNG("benchmark-database.png", 6.5inch, 4inch, dpi = 200)