3 ms·

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

• igalklebanov 2y ago
  it depends on the database. the major ones support savepoints. postgres included. https://www.postgresql.org/docs/current/sql-savepoint.html https://www.postgresql.org/docs/current/sql-savepoint.html https://dev.mysql.com/doc/refman/8.4/en/savepoint.html https://dev.mysql.com/doc/refman/8.4/en/savepoint.html https://learn.microsoft.com/en-us/sql/t-sql/language-elements/save-transaction-transact-sql?view=sql-server-ver16 https://learn.microsoft.com/en-us/sql/t-sql/language-element... https://sqlite.org/lang_savepoint.html 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.