Re: Notebook for sql ?
Date: Wed, 10 Feb 2021 02:55:54 -0500
Message-ID: <CAA_xQWrzrmqu-UkiYS93Bs-PMoHaKL7b17o1WW_mORDbWadpXQ_at_mail.gmail.com>
Thanks John, Tanel . Will try it out !
On Tue, Feb 9, 2021 at 10:55 PM Tanel Poder <tanel_at_tanelpoder.com> wrote:
> Incidentally, someone just posted this to HackerNews today:
>
> An SQL solution for JupyterAn SQL solution for JupyterThey started with
> SQLite, but now support other DBs too, including Oracle:
>
> https://blog.jupyter.org/an-sql-solution-for-jupyter-ef4a00a0d925
>
> --
> Tanel Poder
> https://tanelpoder.com/events
>
>
> On Tue, Feb 9, 2021 at 12:31 PM John Piwowar <jpiwowar_at_gmail.com> wrote:
>
>> I've tinkered with it, and might be able to offer more directed opinions
>> if you shared your goals. Frankly, once you've issued the SQL query and
>> fetched the data, jupyter notebooks are just another very flexible data
>> processing and presentation tool.
>>
>> I'll assume that you are just as capable of Googling "Jupyter Oracle SQL"
>> as I am, so I'll spare you that. :)
>>
>> Broadly speaking, IMO if you're working w/ SQL from within a Jupyter
>> notebook, you'll be well served by learning some of the common python
>> libraries for data processing (numpy/pandas) and visualization (there are
>> tons, maybe look for the ones that take pandas dataframes as an input).
>> It's certainly not a superior substitute for the more feature-rich SQL
>> development tools out there (e.g. Oracle SQL Developer), but there are some
>> decent use cases.
>>
>>
>>
>>
>> On Tue, Feb 9, 2021 at 8:46 AM kunwar singh <krishsingh.111_at_gmail.com>
>> wrote:
>>
>>> Hi All,
>>> Newbie here in Jupyter world .
>>> Anybody using sql in Jupyter notebook . ?
>>> I would like to learn more on it
>>>
>>> --
>>> Cheers,
>>> Kunwar
>>>
>> --
Rgds,
Sachin Pawar
https://twitter.com/sach_pwr
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 10 2021 - 08:55:54 CET