Re: Help with plpython3u - Mailing list pgsql-general

From PEDRO PABLO SEVERIN HONORATO
Subject Re: Help with plpython3u
Date
Msg-id CAB2K=JOy4C9EZ7m6ms5vp3HD4Rix6yYKAc9b_pYnvWLwg7CFsQ@mail.gmail.com
Whole thread Raw
In response to Re: Help with plpython3u  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
I just think it would make your life easier to reduce the number of
Python installs you have. If I'm keeping track correctly you now have:

1) Anaconda Python

2) OS system Python

3) EDB Python.


The OS is windows, and afaik python is not included in windows, so it would be just Anaconda python and EDB python.

What happens if you try to create a plpythonu3u function in the database? 

The database crashes and tells me "Connection to the server has been lost.

El mié., 10 jun. 2020 a las 13:12, Adrian Klaver (<adrian.klaver@aklaver.com>) escribió:
On 6/10/20 9:57 AM, PEDRO PABLO SEVERIN HONORATO wrote:
> Alright. Before we go any further it would be best to determine what
> your needs are. So:
>
> 1) Did you install Anaconda just to get Python or for the science data
> set of libraries it provides?
>
> A: For the data science set of libraries. Also, it helps to keep
> libraries updated.
>
> 2) Do you need the system Python you installed for anything that
> Anaconda does not provide?
>
> A: I don't know if I understood well this question, but I think the
> answer is no. Anaconda does provide almost all the libraries I need. I
> just installed a couple more (like talib, tensorflow, keras, psycopg2,
> etc) and created some libraries of my own.

Those libraries are available from Anaconda:

https://docs.anaconda.com/anaconda/packages/py3.7_win-64/

or from AnacondaCloud:

https://anaconda.org/

I just think it would make your life easier to reduce the number of
Python installs you have. If I'm keeping track correctly you now have:

1) Anaconda Python

2) OS system Python

3) EDB Python.


What happens if you try to create a plpythonu3u function in the database?


>
> 3) What are you planning to do with plpython3u?
>
> A: I'm planning to create some functions using python language to
> process data that is stored in real time in the database and then use
> them as triggers. I would like to be able to import some libraries that
> I have in python to do it. Some of the functions are fourier and wavelet
> transforms. If I can't import the library, then I'll have to code the
> full function, but it's easier (for me) to code them in python language
> rather than sql language.
>
> El mié., 10 jun. 2020 a las 12:17, Adrian Klaver
> (<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>) escribió:
>
>     On 6/10/20 8:25 AM, PEDRO PABLO SEVERIN HONORATO wrote:
>      > Just to be clear those where instructions from here, correct?:
>      >
>      >
>     https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/language-pack-guide/12/EDB_Postgres_Language_Pack_Guide.1.08.html#
>      >
>      > Yes. When I did that I could execute python functions and create the
>      > extension in postgres without problem, but later I realized that
>     doing
>      > this will create the other problem with anaconda.
>      >
>      > So when you did the Anaconda install:
>      >
>      > https://docs.anaconda.com/anaconda/install/windows/
>      >
>      > What did you check for the Advanced options in Step 8?
>      >
>      > I left the first one unchecked and the second one checked, which
>     is the
>      > default settings.
>      >
>
>     Alright. Before we go any further it would be best to determine what
>     your needs are. So:
>
>     1) Did you install Anaconda just to get Python or for the science data
>     set of libraries it provides?
>
>     2) Do you need the system Python you installed for anything that
>     Anaconda does not provide?
>
>     3) What are you planning to do with plpython3u?
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Help with plpython3u
Next
From: PEDRO PABLO SEVERIN HONORATO
Date:
Subject: Re: Help with plpython3u