MonetDB.jl
A pure Julia MonetDB connector.
Usage
Execute
MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")
df = MonetDB.execute(conn, "SELECT 1 AS \"foo\",2 AS \"bar\"")
1×2 DataFrame
Row │ foo bar
│ String String
─────┼────────────────
1 │ 1 2
Loading a DataFrame into a table
A DataFrame can be saved into a table:
MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")
MonetDB.load(conn, my_df, "my_table")
Prepared statements
MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")
prepared_statement = MonetDB.prepare(conn, "SELECT id, foo, bar FROM my_table WHERE bar = ?")
df = MonetDB.execute(conn, prepared_statement, ["there"])
Transaction
Additionally, a transaction can also be started:
MonetDB.connect("localhost", 50000, "monetdb", "monetdb", "demo")
MonetDB.transaction(conn) do
MonetDB.execute(conn, "INSERT INTO my_table VALUES ('foo')")
end