Re: Help with plpython3u - Mailing list pgsql-general

From PEDRO PABLO SEVERIN HONORATO
Subject Re: Help with plpython3u
Date
Msg-id CAB2K=JOT=UDaKOLevoJaA68iW+YmJv5BkN+5TuCZEuQ2Du3icQ@mail.gmail.com
Whole thread Raw
In response to Re: Help with plpython3u  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Help with plpython3u  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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.

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parallel safety of contrib extensions
Next
From: Michael Lewis
Date:
Subject: Re: Postgres server 12.2 crash with process exited abnormally andpossibly corrupted shared memory