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