Postgres wire compatible SQLite proxy

1

DB Browser for SQLite

#Databases #Database Management #MySQL Tools 195 social mentions

2

sshfs

One could use sshfs to access a remote SQLite DB file. https://github.com/libfuse/sshfs.

#FTP Client #File Transfer #Cloud Storage 31 social mentions

3

scuba.io Scuba Analytics

Awesome to see work in the DB wire compatible space. On the MySQL side, there <i>was</i> MySQL Proxy (https://github.com/mysql/mysql-proxy), which was scriptable with Lua, with which you could create your own MySQL wire compatible connections. Unfortunately it appears to have been abandoned by Oracle and IIRC doesn't work with 5.7 and beyond. I used it in the past to hack together a MySQL wire adapter for Interana (https://scuba.io/). I guess these days the best approach for connecting arbitrary data sources to existing drivers, at least for OLAP, is Apache Calcite (https://calcite.apache.org/). Unfortunately that feels a little more involved.

#Customer Success #Data & Analytics #Business Intelligence 1 social mentions

4

Apache Calcite

Awesome to see work in the DB wire compatible space. On the MySQL side, there <i>was</i> MySQL Proxy (https://github.com/mysql/mysql-proxy), which was scriptable with Lua, with which you could create your own MySQL wire compatible connections. Unfortunately it appears to have been abandoned by Oracle and IIRC doesn't work with 5.7 and beyond. I used it in the past to hack together a MySQL wire adapter for Interana (https://scuba.io/). I guess these days the best approach for connecting arbitrary data sources to existing drivers, at least for OLAP, is Apache Calcite (https://calcite.apache.org/). Unfortunately that feels a little more involved.

#Databases #Data Dashboard #Relational Databases 12 social mentions