ipython-sql

ipython-sql copied to clipboard

Reuse existing connection object or accept one

2

Hi. I am using ipython-sql as an easy-to-access SQL terminal, but in other cases I use the peewee ORM. This leads to having 2 open database connections and some temporal...

ckald

Sqlalchemy with pytds

1

I have Jupyter notebook in which I am able to access using pytds. I would like to use it with sqlalchemy and the %%sql command. however when try the following:...

ifuchs

Suppress message "Returning data to local variable"

3

Example: In: ``` %%sql result

ellipticview

Persist pandas data frame without index

1

Can we persist a pandas data frame to the database without index? ```python import pandas as pd mytable = pd.DataFrame({'col0': [10,20,30], 'col1': ['a','b','c'] %sql --persist mytable ``` This includes the...

bhishanpdl

Loading from dsn file is not working

1

Steps to reproduce the issue. 1. Create dsn file 3. Run below commands %config SqlMagic.dsn_filename='./dsn.ini' %sql –section [DB_CONFIG_1] I get below error instead of connecting to db "Environment variable $DATABASE_URL...

sivankumar86

Getting AttributeError: type object 'CommManager' has no attribute 'class_traits'

1

Tried to run below code in jupyter notebook `%load_ext sql` `%config SqlMagic.displaylimit = 5` Got error message: "AttributeError: type object 'CommManager' has no attribute 'class_traits'" I did successfully run the...

Baoooooooda

Error connecting to python-oracledb

1

Hello , I opened a Issue at sqlalchemy regarding a connection to oracle wiyh new driver oracle+oracledb, and they tell me that this issue was related to ipython-sql. The trhread...

centeiol

SQL Meta command doesn't work.

4

First I run ``` %%sql create table Userpro ( email text primary key, username text unique not null, birthday timestamp not null, Home_Adress text not null, Phone_No text unique not...

YousefSaber

Revisit version pin for prettytable

2

Looking at the history of the `prettytable` version pin (see #136 and #144) and checking that [package's release history](https://pypi.org/project/prettytable/#history) on PyPI, I don't see a release with version `7`. Was...

phmccarty

0.4.0 release tag missing

1

The 0.4.0 git tag is missing.

SuperSandro2000