News for hackers. Stuff that matters.

A comment on SQL Notebook.

Re:SQL Notebook by daveorzach on Tuesday May 09, 2017 @02:16PM (#14302544)
Is there any Windows SQL software that can use system/machine ODBC data sources? My company uses OpenLink's ODBC drivers to access our main database (Progress OpenEdge.) I have no problem using Python, Pandas, and pyodb to connect to the data base but it isn't the best environment to develop queries.
[ Parent | on HN ]
Re:SQL Notebook by eterm on Wednesday May 10, 2017 @09:56AM (#14308184)
MySQL workbench (it is available as a free download but you have to dodge quite a few "No I really mean I want the free community ed" screens) is quite good for that.

https://www.mysql.com/products/workbench/

There are versions for linux and windows and iirc it supports any ODBC connection as well as out of the box SSL tunnelling for mysql/postgres/etc.

[ Parent | on HN ]