Re: Help with plpython3u

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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com