Lisp

53 readers

3 users here now

founded 1 year ago

MODERATORS

rglullis

defmacro

Any library to connect to Postgres and call a stored procedure? (alien.top)

submitted 1 year ago by AxenZh@alien.top to c/lisp

5 comments fedilink hide all child comments

As the title says, I am looking for a library that can connect to Progres and execute a stored procedure with either input or output parameters. Or even a user defined function.

I've checked the documentation of these three libraries:

cl-progres
pg-dot-lisp
clsql

but there seems to be no mention or example of executing a stored procedure. Is it just not documented? Are there other ways I can do it apart from these three?

you are viewing a single comment's thread
view the rest of the comments

[–] defaultxr@alien.top 1 points 1 year ago

I use Postmodern for Postgres and I quite like it. Never used stored procedures but the readme seems to suggest that it does support them:

Convenient support for prepared statements and stored procedures