chanukyasds / pg_math

pg_math extension to support statistical distribution functions for PostgreSQL

Hi there 👋

Databases: PostgreSQL
Languages: C, python, C#
Operating system: Ubuntu/linux
Infra: Ansible, Openshift
Cloud : AWS-ec2, Azure

PostgreSQL:
pg_math - statistical distribution for postgresql.
c_postgres_dev - overview to develop C functions to work on composite, array types in postgresql.

Others:
data_analytics - prototype to pull tabular data from website and convert to meaning information for analysis such as Graphs.

Contact: [email protected]

pg_math's Issues

Name could be more informative.

Given that this doesn't wrap all or even a large fraction of libgsl, it seems odd to name the whole thing pg_math. Things like pg_cdf_rdf or maybe pg_gsl_cdf would be more descriptive. The latter would open the door to wrapping other parts of libgsl.

Compile and launch in MacOS

I tried to use the extension in the MacOS Ventura 13.5 and found some issues:

1. User can't compile it as a part of the contrib - you provide the only PGXS make option.
2. LDFLAGS is overrided
3. Extension library couldn't be loaded because of the error:

CREATE EXTENSION pg_math;
ERROR:  could not load library "/Users/danolivo/PostgresPro/postgres/tmp_install/lib/pg_math.dylib": dlopen(/Users/danolivo/PostgresPro/postgres/tmp_install/lib/pg_math.dylib, 0x000A): symbol not found in flat namespace '_cblas_caxpy'

The first couple of issues I resolved by this changes of the makefile:
makefile.diff.zip
But the last one I still can't resolve. Maybe you already have experience with resolving it?