ipython-sql

ipython-sql copied to clipboard

Open connections after failure

1

I try to create a table with the magic which fails... The return is `__` If i use the following query ``` Select spid,hostname,hostprocess,program_name,nt_username, blocked, waittime, waittype, loginame,cmd,spid,waittype,waittime,lastwaittype,cpu,physical_io,memusage,login_time,last_batch,open_tran,status,net_address, t.text from...

RoelantStegmann

psal backslash error - \d tablename

5

Running the following: ``` %sql CREATE TABLE "test" ("col1" TEXT PRIMARY KEY, "col2" INTEGER); %sql \d test AttributeError: 'list' object has no attribute 'fetchall' --------------------------------------------------------------------------- AttributeError Traceback (most recent call...

psychemedia

I love this package, but it keeps printing out my password in cleartext when I use it with an odbc driver. For example: input cell: ``` %%sql select * from...

samghelms

I'm using a connection string like this: `%sql oracle://usersid:pw@ip:1521/SID` However, the specially encoded strings in the database (Vietnamese) are not returned correctly. What I got is `Nguy?n M?nh Linh` Any...

tuanna35

Hi With a set up of the form: ``` PGCONN='sqlite:///test.db' %load_ext sql %sql {PGCONN} ``` and then: ``` %%sql DROP TABLE IF EXISTS quickdemo; CREATE TABLE quickdemo(id INT, name VARCHAR(20),...

psychemedia

Not getting any results (using Vertica dialect)

10

Hi, I'm stuck here. Maybe someone can help. I added the Vertica dialect for SQLAlchemy. But I can't even get a simple result. I'll try to see if I can...

timolingh

Apologies if this is the wrong forum for this... is there a way to make NULL values display as something other than the string "None"?

cpainterwakefield

Low memory in Gephi

1

I have a bipartite network and i want to change it to one mode network and i use multi_mode network plugin. My friend use my data set and can change...

NeginZR

Hey Catherine, awesome work! I was wondering if you knew of any resources to use ipython as a SQL client with table column autocomplete.

ryanzebian

I have a use case in which it is sometimes necessary to clear all the connections on a database when working in a notebook with %sql magic configured. If I...

psychemedia