Object-oriented database options for Lisp with SQL support

Backend
1

Hey everyone,

I’m looking for a good object-oriented database solution for Lisp that works with SQL. Does anyone know of any?

I really want to use the OO features of Lisp, but I also need something that plays nice with regular databases. My IT team is comfortable with SQL, so that’s a must.

I’ve looked at some non-commercial options, but they seem a bit outdated. It would be great to find something that has:

  • Transaction support
  • Multiple inheritance
  • Lazy loading

I’d rather not have to modify CLSQL myself to add these features. Any suggestions? What are you all using for your Lisp projects that need both OO and SQL capabilities?

Thanks in advance for your help!

2

hey, check out elephant. its an object database for common lisp with sql support. i’ve used it for a project and it handles transactions, inheritance, and lazy loading pretty well. might be worth a look for what youre trying to do. just my 2 cents!

3

Have you looked into Postmodern? It’s a PostgreSQL programming interface for Common Lisp that might suit your needs. While not strictly an object-oriented database, it offers a powerful ORM layer called S-SQL that allows you to work with database objects in an OO-like manner. It supports transactions, has good performance, and facilitates complex queries. The SQL compatibility would satisfy your IT team’s requirements, while the ORM capabilities could potentially address your OO needs. It’s actively maintained with robust documentation, making it a strong candidate to balance between the two paradigms.

4

have you considered AllegroCache? it’s not pure SQL, but it has some SQL-like querying capabilities. i’m curious tho, why do you need both OO and SQL? could you maybe elaborate on your use case? it might help us suggest better alternatives or workarounds. what kind of data are you dealing with?