Skip to content

Releases: DallasHoff/sqlocal

0.11.1

31 Jul 16:32
Compare
Choose a tag to compare
  • Fix database returning stale data after calling overwriteDatabaseFile on it
  • Fix build error when drizzle-orm is not installed

0.11.0

28 Jul 22:11
Compare
Choose a tag to compare
  • The transaction method has been reworked with a new implementation. Its new API allows running arbitrary logic between the SQL queries executed as part of a transaction while still ensuring that the transaction is atomic and isolated.
  • The SQLocalKysely dialect has been modified so that Kysely's transaction method uses SQLocal's new transaction functionality, which allows it to ensure isolation of transactions run using it.
  • A warning has been added to the SQLocalDrizzle driver that is logged when using Drizzle's transaction method since that method cannot ensure the transaction's isolation. It recommends using SQLocal's transaction method instead, as documented here.
  • The previous implementation of the transaction method is now named batch.

0.10.2

21 Jul 02:44
Compare
Choose a tag to compare
  • The SQLocal constructor can now accept an object with additional options to define the behavior of the client. For now, this includes 2 new options: readOnly and verbose
  • The sql method can now be called with a plain string if needed (e.g. sql('SELECT * FROM foo')), instead of as a tagged template
  • The sql method's type parameter was changed to represent one record in the query result (extends Record<string, any>), instead of an array of results (extends Record<string, any>[]), and a matching type parameter was added to the transaction method to allow assertion of the return type of queries

0.10.1

11 Jul 02:25
Compare
Choose a tag to compare
  • The file returned by getDatabaseFile now has the MIME type application/x-sqlite3, instead of an empty MIME type
  • Fix getDatabaseFile failing for databases not stored at the root of the origin private file system

0.10.0

06 Jul 21:41
Compare
Choose a tag to compare
  • Add getDatabaseInfo method
  • The destroy method now executes PRAGMA optimize on the database before closing the connection
  • In a future update, the transaction method will be reworked, and the current version of the method will be named batch. This update adds a batch method that is an alias of transaction.

0.9.0

10 May 02:35
Compare
Choose a tag to compare

0.8.0

21 Apr 21:24
Compare
Choose a tag to compare

0.7.1

21 Apr 21:19
Compare
Choose a tag to compare
  • kysely is now a peer dependency instead of a direct dependency, allowing any kysely version to be installed alongside SQLocal

0.7.0

21 Apr 21:12
Compare
Choose a tag to compare

0.6.4

21 Apr 21:08
1e0c074
Compare
Choose a tag to compare

No significant changes