jupyterlab-sql icon indicating copy to clipboard operation
jupyterlab-sql copied to clipboard

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

Open JohnTheLearner opened this issue 4 years ago • 2 comments

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
    }
  }

JohnTheLearner avatar Oct 08 '19 21:10 JohnTheLearner

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

pbugnion avatar Jan 06 '20 07:01 pbugnion

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.

JohnTheLearner avatar Mar 24 '20 05:03 JohnTheLearner