Hacker News new | ask | show | jobs
by oulipo 439 days ago
Nice!

How do "savepoints" work? does it work with any db backend, eg Postgres?

1 comments

it depends on the database. the major ones support savepoints. postgres included. https://www.postgresql.org/docs/current/sql-savepoint.html https://dev.mysql.com/doc/refman/8.4/en/savepoint.html https://learn.microsoft.com/en-us/sql/t-sql/language-element... https://sqlite.org/lang_savepoint.html

in kysely, the dialect you're using has to implement the new optional savepoint-specific methods for it to work.