plsci's Introduction

pl/sci

Status

This is very much an experiment and I'm open to feedback on where to take this next.

Build

Requirements

Steps

Set GRAALVM_HOME to your GraalVM directory (the one that contains the bin directory).
Run script/compile-libplsci. Currently this build script contains some macOS-specific things like .dylib and install_name_tool. This will be made more portable later on (PR welcome).
Run cargo pgx run pg13. Then try it out:

psql (13.0)
Type "help" for help.

plsci=# create extension plsci;
CREATE EXTENSION

plsci=# select * from plsci('(+ 1 2 3)');
 plsci
-------
 6
(1 row)

License

Distributed under the EPL License. See LICENSE.

plsci's People

Contributors

Stargazers

Watchers

plsci's Issues

Second invocation of `cargo pgx run pg13` after building libplsci fails with "Symbol not found: _eval_string"

The first time after building libplsci I can successfully run cargo pgx run:

installing extension
     Copying control file to `/Users/borkdude/.pgx/13.0/pgx-install/share/postgresql/extension/plsci.control`
     Copying shared library to `/Users/borkdude/.pgx/13.0/pgx-install/lib/postgresql/plsci.so`
     Writing extension schema to `/Users/borkdude/.pgx/13.0/pgx-install/share/postgresql/extension/plsci--1.0.sql`
    Finished installing plsci
    Starting Postgres v13 on port 28813
    Re-using existing database plsci
psql (13.0)
Type "help" for help.

plsci=# select * from plsci('(+ 1 2 3)');
 plsci
-------
 6
(1 row)

plsci=# ^D\q

However, the second time, I get:

$ cargo pgx run pg13
    Stopping Postgres v13
building extension with features `pg13`
"cargo" "build" "--features" "pg13" "--no-default-features"
   Compiling plsci v0.0.0 (/Users/borkdude/Dropbox/dev/clojure/plsci)
    Finished dev [unoptimized + debuginfo] target(s) in 2.83s

installing extension
     Copying control file to `/Users/borkdude/.pgx/13.0/pgx-install/share/postgresql/extension/plsci.control`
     Copying shared library to `/Users/borkdude/.pgx/13.0/pgx-install/lib/postgresql/plsci.so`
     Writing extension schema to `/Users/borkdude/.pgx/13.0/pgx-install/share/postgresql/extension/plsci--1.0.sql`
    Finished installing plsci
    Starting Postgres v13 on port 28813
    Re-using existing database plsci
psql (13.0)
Type "help" for help.

plsci=# select * from plsci('(+ 1 2 3)');
ERROR:  could not load library "/Users/borkdude/.pgx/13.0/pgx-install/lib/postgresql/plsci.so": dlopen(/Users/borkdude/.pgx/13.0/pgx-install/lib/postgresql/plsci.so, 10): Symbol not found: _eval_string
  Referenced from: /Users/borkdude/.pgx/13.0/pgx-install/lib/postgresql/plsci.so
  Expected in: flat namespace
 in /Users/borkdude/.pgx/13.0/pgx-install/lib/postgresql/plsci.so
plsci=#

Refactorings

@eeeebbbbrrrr suggested some refactorings here:

babashka/sci#373 (comment)

benchmarks for plsci

I'm currently using https://github.com/pllua/pllua at the moment. Are there any benchmarks for plsci in comparison:

ie:
https://gist.github.com/xvaara/df0b802b86d2aa4f30b88a3fd6b69a14

Create procedural language handler

@eeeebbbbrrrr said:

next you need to make a procedural language handler. You're free to use my not-yet-released pl/rust as a starting point: https://github.com/zombodb/plrust

Recommend Projects