ikkiwareEn 2023-09-19 18:21:52

Postgresql and Lisp

Postmodern is a Common Lisp library for interacting with PostgreSQL databases.
see for more information: http://marijnhaverbeke.nl/postmodern/#quickstart

14th September 2023: Postgresql 16 Released!

How to install postgresql

First we are going to create the user and  database into postgresql:

And after that we are going to create the database called my_database:

Now we need to load the library by quicklisp:

You can see:

How to install and configure your IDE for Common Lisp

next, we need to define a variable with database connection

Now need to define the connection pooler called with-database-connection:

Finally the PostgreSQL connection test:

Some examples:

You can download the code

#lisp #postgresql #postmodern #quicklisp