ipython-sql

ipython-sql copied to clipboard

Connection lines for named pipes

2

Hi - I'm unclear on (and am not seeing examples of) how the connection line should look for connecting to a MySQL instance via named pipe. I guess it would...

MincingWords

I have a problem using ipython-sql with [ClickHouse](clickhouse.yandex). I use https://github.com/cloudflare/sqlalchemy-clickhouse connector, with the following code: ``` %load_ext sql %%sql clickhouse://username:password@host:8123/db SELECT count() FROM system.numbers LIMIT 5 ``` and get...

feriat

This doesn't seem to be supported; ``` for i in range(1,10): f = fields[0][0] r = %sql SELECT MAX(DATALENGTH('')) FROM :f ``` I get this; (pyodbc.ProgrammingError) ('42000', '[42000] [Microsoft][SQL Server...

ecsplendid

I forked the repository to fix a small issue (import of `reduce` in `sql/run.py`). However, when I run `./run_tests.sh`, tests fail, which have nothing to do with my change: ./run_tests.sh...

ZelphirKaltstahl

the library assumes that users have postgres with `psycopg` installed on their machine. If `psycopg` isn't install the set up fails.

hstoebel

Exception with `%config SqlMagic.autopandas=True`

6

``` %config SqlMagic.autopandas=True ``` ``` %%sql SELECT 1 AS one ``` ``` Done. --------------------------------------------------------------------------- ValueError Traceback (most recent call last) in () ----> 1 get_ipython().run_cell_magic('sql', '', 'SELECT 1 AS one')...

tebeka

I have had to install version `0.3.9` of ipython-sql due to https://github.com/catherinedevlin/ipython-sql/issues/67. But this version prints my sqlalchemy connection string containing username and password, which I certainly do not want...

florian-niefind

colorize failed cells

1

Syntax colorization of SQL cells only fires after successful execution - not on cells that fail with a SQL error. Colorizing cells with errors would help with fixing those errors.

catherinedevlin

secure database credentials

7

Hello! we are sharing our notebooks on github and want to avoid commiting our db credentials. Therefore we want to use environment variables. Is there any chance to do so:...

christophlingg

This (somewhat complicated) query returns the wrong results from Postgres. Compared to the exact same query through postgres' command-line tool, some months are missing altogether. To me, that would indicate...

darkobodnaruk