Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
49 KiB
@effect/sql-sqlite-node
0.9.4
Patch Changes
- Updated dependencies [
413994c,14a47a8,35be739,f8326cc,0c09841,8dd3959,2cb6ebb,5e9f51e,83a108a,f2c8dbb,5e9f51e]:- @effect/platform@0.62.2
- effect@3.6.5
- @effect/sql@0.9.4
0.9.3
Patch Changes
- Updated dependencies [
c3446d3,9efe0e5]:- @effect/sql@0.9.3
- @effect/platform@0.62.1
0.9.2
Patch Changes
- Updated dependencies [
cfcfbdf]:- @effect/sql@0.9.2
0.9.1
Patch Changes
0.9.0
Minor Changes
-
#3457
a07990dThanks @IMax153! - Add support for executing raw SQL queries with the underlying SQL client.This is primarily useful when the SQL client returns special results for certain query types.
For example, because MySQL does not support the
RETURNINGclause, themysql2client will return aResultSetHeaderforINSERT,UPDATE,DELETE, andTRUNCATEoperations.To gain access to the raw results of a query, you can use the
.rawproperty on theStatement:import * as Effect from "effect/Effect"; import * as SqlClient from "@effect/sql/SqlClient"; import * as MysqlClient from "@effect/sql/MysqlClient"; const DatabaseLive = MysqlClient.layer({ database: Config.succeed("database"), username: Config.succeed("root"), password: Config.succeed(Redacted.make("password")), }); const program = Effect.gen(function* () { const sql = yield* SqlClient.SqlClient; const result = yield* sql`INSERT INTO usernames VALUES ("Bob")`.raw; console.log(result); /** * ResultSetHeader { * fieldCount: 0, * affectedRows: 1, * insertId: 0, * info: '', * serverStatus: 2, * warningStatus: 0, * changedRows: 0 * } */ }); program.pipe(Effect.provide(DatabaseLive), Effect.runPromise);
Patch Changes
- Updated dependencies [
8295281,c940df6,00b6c6d,a07990d,f8d95a6]:- effect@3.6.4
- @effect/sql@0.9.0
- @effect/platform@0.62.0
0.8.7
Patch Changes
- Updated dependencies [
04adcac]:- effect@3.6.3
- @effect/platform@0.61.8
- @effect/sql@0.8.7
0.8.6
Patch Changes
- Updated dependencies [
17245a4,630d40e,630d40e]:- @effect/platform@0.61.7
- @effect/sql@0.8.6
0.8.5
Patch Changes
- Updated dependencies [
d829b57,fd4b2f6]:- @effect/platform@0.61.6
- effect@3.6.2
- @effect/sql@0.8.5
0.8.4
Patch Changes
- Updated dependencies [
056b710]:- @effect/platform@0.61.5
- @effect/sql@0.8.4
0.8.3
Patch Changes
- Updated dependencies [
e7cb109]:- @effect/platform@0.61.4
- @effect/sql@0.8.3
0.8.2
Patch Changes
- Updated dependencies [
510a34d,fb9f786,45dbb9f]:- effect@3.6.1
- @effect/platform@0.61.3
- @effect/sql@0.8.2
0.8.1
Patch Changes
- Updated dependencies []:
- @effect/platform@0.61.2
- @effect/sql@0.8.1
0.8.0
Patch Changes
- Updated dependencies [
42d0706,11223bf]:- @effect/sql@0.8.0
- @effect/platform@0.61.1
0.7.0
Patch Changes
- Updated dependencies [
1e0fe80,8135294,cd255a4,3845646,2d09078,4bce5a0,4ddbff0,e74cc38,bb069b4,cd255a4,7d02174]:- effect@3.6.0
- @effect/platform@0.61.0
- @effect/sql@0.7.0
0.6.3
Patch Changes
- Updated dependencies [
6359644,7f41e42,f566fd1]:- effect@3.5.9
- @effect/platform@0.60.3
- @effect/sql@0.6.3
0.6.2
Patch Changes
- Updated dependencies [
eb4d014,1ba640c,c8c71bd,a26ce58,fc20f73]:- @effect/platform@0.60.2
- effect@3.5.8
- @effect/sql@0.6.2
0.6.1
Patch Changes
- Updated dependencies []:
- @effect/platform@0.60.1
- @effect/sql@0.6.1
0.6.0
Patch Changes
- Updated dependencies []:
- @effect/platform@0.60.0
- @effect/sql@0.6.0
0.5.3
Patch Changes
-
#3310
99bddcfThanks @fubhy! - Added additional pure annotations to improve tree-shakeability -
Updated dependencies [
3afcc93,99bddcf]:- effect@3.5.7
- @effect/platform@0.59.3
- @effect/sql@0.5.3
0.5.2
Patch Changes
- Updated dependencies [
cc327a1,4bfe4fb,2b14d18]:- effect@3.5.6
- @effect/platform@0.59.2
- @effect/sql@0.5.2
0.5.1
Patch Changes
- Updated dependencies [
a9d7800,fcecff7,adbf753,adbf753]:- effect@3.5.5
- @effect/platform@0.59.1
- @effect/sql@0.5.1
0.5.0
Minor Changes
Patch Changes
-
Updated dependencies [
53c0db0,ed0dde4,ada68b3,ca775ce,5be9cc0,203658f,eb1c4d4]:- @effect/platform@0.59.0
- @effect/sql@0.5.0
- effect@3.5.4
0.4.27
Patch Changes
- Updated dependencies [
edb0da3,a1db40a,c8d3fb0,dabd028,786b2ab,fc57354]:- effect@3.5.3
- @effect/platform@0.58.27
- @effect/sql@0.4.27
0.4.26
Patch Changes
- Updated dependencies [
639208e,6684b4c,6684b4c,6684b4c]:- effect@3.5.2
- @effect/platform@0.58.26
- @effect/sql@0.4.26
0.4.25
Patch Changes
- Updated dependencies [
0623fca]:- @effect/platform@0.58.25
- @effect/sql@0.4.25
0.4.24
Patch Changes
- Updated dependencies [
55fdd76]:- effect@3.5.1
- @effect/platform@0.58.24
- @effect/sql@0.4.24
0.4.23
Patch Changes
- Updated dependencies [
a1f5b83,a1f5b83,a1f5b83,60bc3d0,5ab348f,60bc3d0,3e04bf8,e7fc45f,a1f5b83,4626de5,f01e7db,60bc3d0,79d2d91,ac71f37,8432360,e4bf1bf,13cb861,79d2d91,e7fc45f,9f66825]:- effect@3.5.0
- @effect/platform@0.58.23
- @effect/sql@0.4.23
0.4.22
Patch Changes
- Updated dependencies [
7af137c,ee4b3dc,366f2ee,366f2ee,097d25c]:- effect@3.4.9
- @effect/platform@0.58.22
- @effect/sql@0.4.22
0.4.21
Patch Changes
- Updated dependencies [
a435e0f,b5554db,a9c4fb3]:- effect@3.4.8
- @effect/platform@0.58.21
- @effect/sql@0.4.21
0.4.20
Patch Changes
- Updated dependencies [
a5737d6]:- effect@3.4.7
- @effect/platform@0.58.20
- @effect/sql@0.4.20
0.4.19
Patch Changes
- Updated dependencies []:
- @effect/platform@0.58.19
- @effect/sql@0.4.19
0.4.18
Patch Changes
- Updated dependencies [
7f8900a]:- @effect/platform@0.58.18
- @effect/sql@0.4.18
0.4.17
Patch Changes
- Updated dependencies [
5c0ceb0,5c0ceb0,33735b1,5c0ceb0,139d4b3]:- effect@3.4.6
- @effect/platform@0.58.17
- @effect/sql@0.4.17
0.4.16
Patch Changes
- Updated dependencies []:
- @effect/platform@0.58.16
- @effect/sql@0.4.16
0.4.15
Patch Changes
- Updated dependencies [
baa90df]:- @effect/platform@0.58.15
- @effect/sql@0.4.15
0.4.14
Patch Changes
- Updated dependencies [
52a87c7,6d2280e]:- @effect/platform@0.58.14
- @effect/sql@0.4.14
0.4.13
Patch Changes
- Updated dependencies [
a047af9,dbd53ea]:- effect@3.4.5
- @effect/platform@0.58.13
- @effect/sql@0.4.13
0.4.12
Patch Changes
- Updated dependencies [
74e0ad2,74e0ad2,72638e3,d7dde2b,9b2fc3b]:- @effect/platform@0.58.12
- effect@3.4.4
- @effect/sql@0.4.12
0.4.11
Patch Changes
- Updated dependencies [
a5b95b5,5e29579]:- @effect/platform@0.58.11
- @effect/sql@0.4.11
0.4.10
Patch Changes
-
Updated dependencies [
a48ee84,c342739,8898e5e,a48ee84,a48ee84,ff78636,c86bd4e,bbdd365,ab3180f,bbdd365]:- @effect/platform@0.58.10
- effect@3.4.3
- @effect/sql@0.4.10
0.4.9
Patch Changes
- Updated dependencies []:
- @effect/platform@0.58.9
- @effect/sql@0.4.9
0.4.8
Patch Changes
- Updated dependencies [
3da1497]:- effect@3.4.2
- @effect/platform@0.58.8
- @effect/sql@0.4.8
0.4.7
Patch Changes
- Updated dependencies [
027004a]:- @effect/platform@0.58.7
- @effect/sql@0.4.7
0.4.6
Patch Changes
- Updated dependencies [
66a1910,2e8e252]:- effect@3.4.1
- @effect/platform@0.58.6
- @effect/sql@0.4.6
0.4.5
Patch Changes
- Updated dependencies [
37a07a2]:- @effect/platform@0.58.5
- @effect/sql@0.4.5
0.4.4
Patch Changes
- Updated dependencies [
b77fb0a]:- @effect/platform@0.58.4
- @effect/sql@0.4.4
0.4.3
Patch Changes
- Updated dependencies []:
- @effect/platform@0.58.3
- @effect/sql@0.4.3
0.4.2
Patch Changes
- Updated dependencies []:
- @effect/platform@0.58.2
- @effect/sql@0.4.2
0.4.1
Patch Changes
- Updated dependencies [
5a248aa]:- @effect/platform@0.58.1
- @effect/sql@0.4.1
0.4.0
Minor Changes
Patch Changes
- Updated dependencies [
c0ce180,d33d8b0,63dd0c3,61707b6,9c1b5b3,a35faf8,ff73c0c,984d516,8c3b8a2,017e2f9,91bf8a2,c6a4a26]:- effect@3.4.0
- @effect/sql@0.4.0
- @effect/platform@0.58.0
0.3.19
Patch Changes
- Updated dependencies [
3ba7ea1]:- @effect/platform@0.57.8
- @effect/sql@0.3.18
0.3.18
Patch Changes
- Updated dependencies []:
- @effect/platform@0.57.7
- @effect/sql@0.3.17
0.3.17
Patch Changes
- Updated dependencies []:
- @effect/platform@0.57.6
- @effect/sql@0.3.16
0.3.16
Patch Changes
- Updated dependencies [
b8ea6aa]:- @effect/platform@0.57.5
- @effect/sql@0.3.15
0.3.15
Patch Changes
- Updated dependencies [
6c89408]:- effect@3.3.5
- @effect/platform@0.57.4
- @effect/sql@0.3.14
0.3.14
Patch Changes
- Updated dependencies [
a67b8fe]:- effect@3.3.4
- @effect/platform@0.57.3
- @effect/sql@0.3.13
0.3.13
Patch Changes
- Updated dependencies [
06ede85,7204ca5]:- effect@3.3.3
- @effect/platform@0.57.2
- @effect/sql@0.3.12
0.3.12
Patch Changes
- Updated dependencies [
07e12ec,3572646,1aed347,df4bf4b,f085f92]:- @effect/platform@0.57.1
- effect@3.3.2
- @effect/sql@0.3.11
0.3.11
Patch Changes
- Updated dependencies [
eb98c5b,184fed8,4d3fbe8,6068e07,3a77e20]:- effect@3.3.1
- @effect/platform@0.57.0
- @effect/sql@0.3.10
0.3.10
Patch Changes
- Updated dependencies [
2b9ddfc,1f4ac00,9305b76,0f40d98,188f0a5,b761ef0,b53f69b,0f40d98,5bd549e,67f160a]:- @effect/platform@0.56.0
- effect@3.3.0
- @effect/sql@0.3.9
0.3.9
Patch Changes
-
#2860
e50e01dThanks @tim-smart! - fix .values for non-reader statements -
#2932
fd8d860Thanks @tim-smart! - update @effect/sql dependencies -
Updated dependencies [
a67d602]:- @effect/platform@0.55.7
- @effect/sql@0.3.8
0.3.8
Patch Changes
- Updated dependencies [
8c5d280,6ba6d26,3f28bf2,5817820,799aa20]:- effect@3.2.9
- @effect/platform@0.55.6
- @effect/sql@0.3.7
0.3.7
Patch Changes
- Updated dependencies []:
- @effect/platform@0.55.5
- @effect/sql@0.3.6
0.3.6
Patch Changes
- Updated dependencies [
fb91f17]:- effect@3.2.8
- @effect/platform@0.55.4
- @effect/sql@0.3.5
0.3.5
Patch Changes
- Updated dependencies [
6801fca]:- effect@3.2.7
- @effect/platform@0.55.3
- @effect/sql@0.3.4
0.3.4
Patch Changes
- Updated dependencies [
2c2280b,cc8ac50]:- @effect/platform@0.55.2
- effect@3.2.6
- @effect/sql@0.3.3
0.3.3
Patch Changes
- Updated dependencies [
3e86ced]:- @effect/sql@0.3.2
0.3.2
Patch Changes
- Updated dependencies []:
- @effect/platform@0.55.1
- @effect/sql@0.3.1
0.3.1
Patch Changes
0.3.0
Minor Changes
Patch Changes
- Updated dependencies [
af0543c,608b01f,031c712,a44e532,5133ca9]:- @effect/sql@0.3.0
- effect@3.2.5
- @effect/platform@0.55.0
0.2.18
Patch Changes
- Updated dependencies [
1af94df,1af94df,c07e0ce,e313a01,1af94df]:- effect@3.2.4
- @effect/platform@0.54.0
- @effect/sql@0.2.17
0.2.17
Patch Changes
-
Updated dependencies [
45578e8]:- effect@3.2.3
- @effect/platform@0.53.14
- @effect/sql@0.2.16
0.2.16
Patch Changes
- Updated dependencies [
5d9266e,9f8122e,6a6f670,c1eaef9]:- effect@3.2.2
- @effect/platform@0.53.13
- @effect/sql@0.2.15
0.2.15
Patch Changes
- Updated dependencies []:
- @effect/platform@0.53.12
- @effect/sql@0.2.14
0.2.14
Patch Changes
- Updated dependencies [
c1e991d]:- effect@3.2.1
- @effect/platform@0.53.11
- @effect/sql@0.2.13
0.2.13
Patch Changes
- Updated dependencies [
146cadd,7135748,7135748,963b4e7,64c9414,7135748,2cbb76b,870c5fa,146cadd,7135748,64c9414]:- effect@3.2.0
- @effect/platform@0.53.10
- @effect/sql@0.2.12
0.2.12
Patch Changes
- Updated dependencies [
17fc22e,810f222,596aaea]:- @effect/platform@0.53.9
- effect@3.1.6
- @effect/sql@0.2.11
0.2.11
Patch Changes
- Updated dependencies []:
- @effect/platform@0.53.8
- @effect/sql@0.2.10
0.2.10
Patch Changes
-
#2712
01b4553Thanks @vecerek! - Use constants from@opentelemetry/semantic-conventionsas span attribute names instead of hard-coded values -
Updated dependencies [
01b4553]:- @effect/sql@0.2.9
- @effect/platform@0.53.7
0.2.9
Patch Changes
- #2749
fdb7203Thanks @tim-smart! - add backup api to sqlite-node client
0.2.8
Patch Changes
- Updated dependencies [
6ac4847,6ac4847]:- @effect/platform@0.53.6
- effect@3.1.5
- @effect/sql@0.2.8
0.2.7
Patch Changes
- Updated dependencies []:
- @effect/platform@0.53.5
- @effect/sql@0.2.7
0.2.6
Patch Changes
- Updated dependencies [
e41e911]:- effect@3.1.4
- @effect/platform@0.53.4
- @effect/sql@0.2.6
0.2.5
Patch Changes
- Updated dependencies []:
- @effect/platform@0.53.3
- @effect/sql@0.2.5
0.2.4
Patch Changes
- Updated dependencies [
1f6dc96]:- effect@3.1.3
- @effect/platform@0.53.2
- @effect/sql@0.2.4
0.2.3
Patch Changes
- Updated dependencies []:
- @effect/platform@0.53.1
- @effect/sql@0.2.3
0.2.2
Patch Changes
- Updated dependencies [
d57fbbb]:- @effect/platform@0.53.0
- @effect/sql@0.2.2
0.2.1
Patch Changes
- Updated dependencies [
5866c62]:- @effect/platform@0.52.3
- @effect/sql@0.2.1
0.2.0
Minor Changes
-
#2693
0724274Thanks @tim-smart! - make @effect/sql dialect agnosticAll of the client implementations now share the same Context.Tag. This means you can create services that support multiple SQL flavors.
You can now use the
@effect/sqlpackage to access the client apis:import * as Sql from "@effect/sql"; import { Effect } from "effect"; Effect.gen(function* () { const sql = yield* Sql.client.Client; yield* sql`SELECT * FROM users`; });If you need a functionality that is specific to a implementation, you can use the tag from the implementation package:
import * as Sqlite from "@effect/sql-sqlite-node"; import { Effect } from "effect"; Effect.gen(function* () { const sql = yield* Sqlite.client.SqliteClient; const dump = yield* sql.export; });If you need to run a different query depending on the dialect, you can use the
sql.onDialectapi:import * as Sql from "@effect/sql"; import { Effect } from "effect"; Effect.gen(function* () { const sql = yield* Sql.client.Client; yield* sql.onDialect({ sqlite: () => sql`SELECT * FROM sqlite_master`, mysql: () => sql`SHOW TABLES`, mssql: () => sql`SELECT * FROM sys.tables`, pg: () => sql`SELECT * FROM pg_catalog.pg_tables`, }); });
Patch Changes
-
#2693
0724274Thanks @tim-smart! - add .returning helper to insert and update apis -
Updated dependencies [
0724274,0724274]:- @effect/sql@0.2.0
0.1.17
Patch Changes
- Updated dependencies [
2e1cdf6,d3cf2d8,56ec8dd]:- @effect/platform@0.52.2
- effect@3.1.2
- @effect/sql@0.1.17
0.1.16
Patch Changes
- Updated dependencies [
e5e56d1]:- effect@3.1.1
- @effect/platform@0.52.1
- @effect/sql@0.1.16
0.1.15
Patch Changes
- Updated dependencies [
9deab0a,7719b8a]:- @effect/platform@0.52.0
- @effect/sql@0.1.15
0.1.14
Patch Changes
- Updated dependencies [
c3c12c6,ba64ea6,b5de2d2,a1c7ab8,a023f28,0ec93cb,1c9454d,a023f28,92d56db]:- effect@3.1.0
- @effect/platform@0.51.0
- @effect/sql@0.1.14
0.1.13
Patch Changes
-
#2656
557707bThanks @tim-smart! - update dependencies -
Updated dependencies [
16039a0,557707b,d1d33e1,f4ed306,661004f,e79cb83]:- @effect/platform@0.50.8
- effect@3.0.8
- @effect/sql@0.1.13
0.1.12
Patch Changes
- Updated dependencies [
18de56b]:- effect@3.0.7
- @effect/platform@0.50.7
- @effect/sql@0.1.12
0.1.11
Patch Changes
-
#2621
f363af0Thanks @tim-smart! - add sql transaction tracing spans -
#2621
f363af0Thanks @tim-smart! - update sql span attributes to follow semantic conventions -
#2621
f363af0Thanks @tim-smart! - add sql....unprepared, to run a query without trying to PREPARE it -
Updated dependencies [
ffe4f4e,027418e,f363af0,ac1898e,ffe4f4e,f363af0,f363af0]:- effect@3.0.6
- @effect/sql@0.1.11
- @effect/platform@0.50.6
0.1.10
Patch Changes
- Updated dependencies [
6222404,868ed2a]:- effect@3.0.5
- @effect/platform@0.50.5
- @effect/sql@0.1.10
0.1.9
Patch Changes
- Updated dependencies [
9a24667]:- effect@3.0.4
- @effect/platform@0.50.4
- @effect/sql@0.1.9
0.1.8
Patch Changes
- Updated dependencies [
b3b51a2]:- @effect/platform@0.50.3
- @effect/sql@0.1.8
0.1.7
Patch Changes
- Updated dependencies []:
- @effect/platform@0.50.2
- @effect/sql@0.1.7
0.1.6
Patch Changes
- Updated dependencies []:
- @effect/platform@0.50.1
- @effect/sql@0.1.6
0.1.5
Patch Changes
- Updated dependencies [
6f38dff,a7b4b84,a3b0e6c,6f38dff]:- @effect/platform@0.50.0
- effect@3.0.3
- @effect/sql@0.1.5
0.1.4
Patch Changes
-
Updated dependencies [
2cecdbd]:- @effect/platform@0.49.4
- effect@3.0.2
- @effect/sql@0.1.4
0.1.3
Patch Changes
- Updated dependencies [
8d39d65]:- @effect/platform@0.49.3
- @effect/sql@0.1.3
0.1.2
Patch Changes
- Updated dependencies [
5ef0a1a]:- @effect/platform@0.49.2
- @effect/sql@0.1.2
0.1.1
Patch Changes
- Updated dependencies [
3da0cfa,570e8d8,87c5687,f838c15,8edacca]:- effect@3.0.1
- @effect/platform@0.49.1
- @effect/sql@0.1.1
0.1.0
Minor Changes
-
#2104
1499974Thanks @IMax153! - initial @effect/sql release -
#2207
2fb7d9cThanks @github-actions! - Release Effect 3.0 🎉
Patch Changes
-
#2529
78b767cThanks @fubhy! - RenamedReadonlyArrayandReadonlyRecordmodules for better discoverability. -
Updated dependencies [
1b5f0c7,d50a652,9a3bd47,1499974,6460414,cf69f46,cf69f46,be9d025,78b767c,aa4a3b5,1499974,1b5f0c7,5c2b561,6c6087a,a18f594,1499974,2f96d93,5a2314b,25d74f8,6c6087a,271b79f,1b5f0c7,2fb7d9c,53d1c2a,e7e1bbe,10c169e,6424181]:- effect@3.0.0
- @effect/sql@0.1.0
- @effect/platform@0.49.0