Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enter SQLalchemy URL, but nothing shows in window & no feedback #101

Open
JohnTheLearner opened this issue Oct 8, 2019 · 2 comments
Open

Comments

@JohnTheLearner
Copy link

JohnTheLearner commented Oct 8, 2019

I've tried this with a clickhouse as well as a postgres database where both work inside a notebook after using %sql $dbString to connect where dbString is a string in SQL Alchemy format. Using the same dbString, though, does NOT work in the SQL window while I was successfully connecting and querying in a notebook. As mentioned in the title of the issue, there is no error, etc. either in the window or in the terminal where jupyter lab was launched from that indicates what the issue might be.

Below is what I see indefinitely after pressing enter in the field where I entered the database URL:
image

I followed the instructions while installing in my conda environment. No errors during installation. I restarted jupyter lab after the install as well. Note that I couldn't pip search jupyterlab_sql, but the hyphenated pip search jupyterlab-sql version does show the below installed version.

Below are the installed versions:

jupyterlab                         1.0.2      
jupyterlab-launcher                0.10.2     
jupyterlab-server                  1.0.0      
jupyterlab-sql                     0.3.1  

It may not matter, but I found the below interesting that one config file shows jupyterlab_sql, but another doesn't when cat'ing some of the config files:

...anaconda3/envs/py3/etc/jupyter/jupyter_notebook_config.d/jupyterlab.json 
{
  "NotebookApp": {
    "nbserver_extensions": {
      "jupyterlab": true
    }
  }
}

vs

anaconda3/envs/py3/etc/jupyter/jupyter_notebook_config.json 
{
  "NotebookApp": {
    "nbserver_extensions": {
      "jupyterlab": true,
      "jupyterlab_sql": true
    }
  }
@pbugnion
Copy link
Owner

pbugnion commented Jan 6, 2020

Thanks for raising this. Does the browser console show anything?

@JohnTheLearner
Copy link
Author

JohnTheLearner commented Mar 24, 2020

See issue #131 for details - Now that the projects have progressed, I got this extension working later in some more current versions including jupyterlab==2.0.0a1. @pbugnion I recommend closing this unless the team is wanting to maintain older version support.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants