Re: Help with plpython3u - Mailing list pgsql-general

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