I need to execute simple SQL (e.g. SELECT * FROM table) and fetch the returned data, but the database could be 1 of 4 types: PostgreSQL, MySQL, MariaDB and MS SQL Server. Ideally, I would like to use a package which deal with such database types using unified interface. I saw an example of Python …

There is an Octo.jl which can be useful. Also, if all you need is to execute simple queries which are known beforehand and they do not differ between databases, you can use DBInterface (connections strings are fake of course, you should refer to corresponding manuals). using ODBC using DBInterface…

What package to use for simple SQL query in different types of database

Specific Domains Data

TheCedarPrince March 24, 2021, 2:39pm 3

I think @cce is working on a package that might work for what you are thinking of - was it DataKnots.jl Clark? I cannot recall…

Topic		Replies	Views
Resurrecting universal database API Data	60	4755	August 17, 2018
ANN: Octo.jl: SQL Query DSL in Julia Data	2	1392	March 23, 2018
[ANN] DBInterface.jl, MySQL.jl 1.0, and SQLite.jl 1.0 Data	5	2482	February 28, 2020
Lack of stable PostgreSQL-communication a major showstopper Data	33	4950	January 8, 2021
Is there a SQL parser in Julia? New to Julia	1	1126	November 7, 2017

What package to use for simple SQL query in different types of database

Related topics