@effect/sql-pg

Source

0.53.0

Patch Changes

Updated dependencies [fffdee0]:
- effect@3.22.0
- @effect/experimental@0.61.0
- @effect/platform@0.97.0
- @effect/sql@0.52.0

0.52.1

Patch Changes

#6140 4767f86 Thanks @tim-smart! - Use a dedicated PostgreSQL connection for LISTEN / UNLISTEN so active listeners do not consume a pooled query connection.

0.52.0

Patch Changes

Updated dependencies [f7bb09b, bd7552a, ad1a7eb, 0d32048, 0d32048]:
- effect@3.21.0
- @effect/experimental@0.60.0
- @effect/platform@0.96.0
- @effect/sql@0.51.0

0.51.0

Patch Changes

Updated dependencies [fc82e81, 82996bc, 4d97a61, f6b0960, 8798a84]:
- effect@3.20.0
- @effect/experimental@0.59.0
- @effect/platform@0.95.0
- @effect/sql@0.50.0

0.50.3

Patch Changes

#6033 740a912 Thanks @tim-smart! - Add PgClient.fromPool and PgClient.layerFromPool.
Updated dependencies [22d9d27]:
- @effect/platform@0.94.4

0.50.2

Patch Changes

#5998 7b8165f Thanks @Brandon-Perry! - Readded stream as an optional parameter to PgClientConfig.
Updated dependencies [0023c19, e71889f, 9a96b87]:
- @effect/platform@0.94.3
- effect@3.19.16

0.50.1

Patch Changes

#5943 c5a1e33 Thanks @sidpremkumar! - Fix crash when pool.connect fails by ensuring client exists before attaching error handler

0.50.0

Patch Changes

Updated dependencies [77eeb86, ff7053f, 287c32c]:
- effect@3.19.13
- @effect/platform@0.94.0
- @effect/experimental@0.58.0
- @effect/sql@0.49.0

0.49.7

Patch Changes

#5808 7b23d9a Thanks @tim-smart! - add PersistedQueue module
Updated dependencies [7b23d9a]:
- @effect/experimental@0.57.5
- @effect/sql@0.48.1

0.49.6

Patch Changes

#5758 fe2792a Thanks @rocwang! - Fix query result streaming in @effect/sql-pg
Updated dependencies [1deeb6a, e144f02]:
- @effect/experimental@0.57.2
- @effect/platform@0.93.3

0.49.5

Patch Changes

#5735 973c90a Thanks @tim-smart! - handle undefined pg client

0.49.4

Patch Changes

#5725 06b49b9 Thanks @janglad! - Fix: populate PgClient config with values parsed from URL if not provided

0.49.3

Patch Changes

#5717 d277a32 Thanks @tim-smart! - improve pg client error handling

0.49.2

Patch Changes

#5705 84d22eb Thanks @tim-smart! - only cancel postgres queries on a best effort basis

0.49.1

Patch Changes

#5701 c00268d Thanks @tim-smart! - support query interuption in sql-pg

0.49.0

Minor Changes

#5686 571025c Thanks @tim-smart! - allow any type to be used as sql parameters

Patch Changes

#5690 106abe0 Thanks @lucas-barake! - fix handling of multi-statement queries (pg returns an array of results)
Updated dependencies [571025c]:
- @effect/sql@0.48.0
- @effect/experimental@0.57.0

0.48.0

Minor Changes

#5606 24a1685 Thanks @tim-smart! - Use “pg” npm library for @effect/sql-pg backend

Patch Changes

#5606 24a1685 Thanks @tim-smart! - disable pg onnotice by default
Updated dependencies [3c15d5f, 3863fa8, 2a03c76, 24a1685]:
- effect@3.19.0
- @effect/platform@0.93.0
- @effect/experimental@0.57.0
- @effect/sql@0.47.0

0.47.0

Patch Changes

Updated dependencies [1c6ab74, 70fe803, c296e32, a098ddf]:
- effect@3.18.0
- @effect/platform@0.92.0
- @effect/experimental@0.56.0
- @effect/sql@0.46.0

0.46.0

Patch Changes

Updated dependencies [d4d86a8]:
- @effect/platform@0.91.0
- @effect/experimental@0.55.0
- @effect/sql@0.45.0

0.45.1

Patch Changes

#5397 0e46e24 Thanks @IMax153! - Avoid issues with ESM builds by removing dependency on @opentelemetry/semantic-conventions
Updated dependencies [8c7bb52, 0e46e24]:
- @effect/platform@0.90.4
- @effect/sql@0.44.2

0.45.0

Patch Changes

Updated dependencies [7813640]:
- @effect/platform@0.90.0
- @effect/experimental@0.54.0
- @effect/sql@0.44.0

0.44.0

Patch Changes

Updated dependencies [40c3c87, ed2c74a, 073a1b8, f382e99, e8c7ba5, 7e10415, e9bdece, 8d95eb0]:
- effect@3.17.0
- @effect/experimental@0.53.0
- @effect/platform@0.89.0
- @effect/sql@0.43.0

0.43.0

Minor Changes

#5192 17a5ea8 Thanks @nikelborm! - Updated deprecated OTel Resource attributes names and values.

Many of the attributes have undergone the process of deprecation not once, but twice. Most of the constants holding attribute names have been renamed. These are minor changes.

Additionally, there were numerous changes to the attribute keys themselves. These changes can be considered major.

In the @opentelemetry/semantic-conventions package, new attributes having ongoing discussion about them are going through a process called incubation, until a consensus about their necessity and form is reached. Otel team recommends devs to copy them directly into their code. Luckily, it’s not necessary because all of the new attribute names and values came out of this process (some of them were changed again) and are now considered stable.

Reasoning for minor version bump

Package	Major attribute changes	Major value changes
Clickhouse client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`
MsSQL client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`	`mssql` -> `microsoft.sql_server`
MySQL client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`
Pg client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`
Bun SQLite client	`db.system` -> `db.system.name`
Node SQLite client	`db.system` -> `db.system.name`
React.Native SQLite client	`db.system` -> `db.system.name`
Wasm SQLite client	`db.system` -> `db.system.name`
SQLite Do client	`db.system` -> `db.system.name`
LibSQL client	`db.system` -> `db.system.name`
D1 client	`db.system` -> `db.system.name`
Kysely client	`db.statement` -> `db.query.text`
@effect/sql	`db.statement` -> `db.query.text` `db.operation` -> `db.operation.name`

Patch Changes

Updated dependencies [f5dfabf, 17a5ea8, d25f22b]:
- effect@3.16.14
- @effect/sql@0.42.0
- @effect/platform@0.88.1
- @effect/experimental@0.52.1

0.42.0

Patch Changes

Updated dependencies [27206d7, dbabf5e]:
- @effect/platform@0.88.0
- @effect/experimental@0.52.0
- @effect/sql@0.41.0

0.41.14

Patch Changes

Updated dependencies [c1c05a8, 81fe4a2]:
- effect@3.16.13
- @effect/experimental@0.51.14
- @effect/platform@0.87.13
- @effect/sql@0.40.14

0.41.13

Patch Changes

Updated dependencies [32ba77a, d5e25b2]:
- @effect/platform@0.87.12
- @effect/experimental@0.51.13
- @effect/sql@0.40.13

0.41.12

Patch Changes

Updated dependencies [001392b, 7bfb099]:
- @effect/platform@0.87.11
- @effect/experimental@0.51.12
- @effect/sql@0.40.12

0.41.11

Patch Changes

Updated dependencies [678318d, 678318d]:
- @effect/platform@0.87.10
- @effect/experimental@0.51.11
- @effect/sql@0.40.11

0.41.10

Patch Changes

Updated dependencies [54514a2]:
- @effect/platform@0.87.9
- @effect/experimental@0.51.10
- @effect/sql@0.40.10

0.41.9

Patch Changes

Updated dependencies [4ce4f82]:
- @effect/platform@0.87.8
- @effect/experimental@0.51.9
- @effect/sql@0.40.9

0.41.8

Patch Changes

Updated dependencies [a9b617f, 7e26e86]:
- @effect/platform@0.87.7
- @effect/experimental@0.51.8
- @effect/sql@0.40.8

0.41.7

Patch Changes

Updated dependencies [905da99]:
- effect@3.16.12
- @effect/experimental@0.51.7
- @effect/platform@0.87.6
- @effect/sql@0.40.7

0.41.6

Patch Changes

Updated dependencies [96c1292]:
- @effect/experimental@0.51.6
- @effect/sql@0.40.6

0.41.5

Patch Changes

Updated dependencies [2fd8676]:
- @effect/platform@0.87.5
- @effect/experimental@0.51.5
- @effect/sql@0.40.5

0.41.4

Patch Changes

Updated dependencies [e82a4fd]:
- @effect/platform@0.87.4
- @effect/experimental@0.51.4
- @effect/sql@0.40.4

0.41.3

Patch Changes

Updated dependencies [1b6e396, 46c3216]:
- @effect/platform@0.87.3
- @effect/sql@0.40.3
- @effect/experimental@0.51.3

0.41.2

Patch Changes

Updated dependencies [4fea68c, b927954, 99590a6, 6c3e24c]:
- @effect/platform@0.87.2
- effect@3.16.11
- @effect/experimental@0.51.2
- @effect/sql@0.40.2

0.41.1

Patch Changes

Updated dependencies [faad30e]:
- effect@3.16.10
- @effect/experimental@0.51.1
- @effect/platform@0.87.1
- @effect/sql@0.40.1

0.41.0

Patch Changes

Updated dependencies [b5bac9a]:
- @effect/platform@0.87.0
- @effect/experimental@0.51.0
- @effect/sql@0.40.0

0.40.0

Patch Changes

Updated dependencies [5137c70, c23d25c, 5137c70, 5137c70]:
- effect@3.16.9
- @effect/platform@0.86.0
- @effect/experimental@0.50.0
- @effect/sql@0.39.0

0.39.2

Patch Changes

Updated dependencies [914a191]:
- @effect/platform@0.85.2
- @effect/experimental@0.49.2
- @effect/sql@0.38.2

0.39.1

Patch Changes

Updated dependencies [8cb98d5, db2dd3c]:
- effect@3.16.8
- @effect/experimental@0.49.1
- @effect/platform@0.85.1
- @effect/sql@0.38.1

0.39.0

Patch Changes

Updated dependencies [93687dd, 93687dd, 93687dd]:
- @effect/platform@0.85.0
- @effect/experimental@0.49.0
- @effect/sql@0.38.0

0.38.12

Patch Changes

Updated dependencies [1bb0d8a]:
- effect@3.16.7
- @effect/experimental@0.48.12
- @effect/platform@0.84.11
- @effect/sql@0.37.12

0.38.11

Patch Changes

Updated dependencies [a5f7595, a02470c, bf369b2, f891d45]:
- effect@3.16.6
- @effect/platform@0.84.10
- @effect/experimental@0.48.11
- @effect/sql@0.37.11

0.38.10

Patch Changes

Updated dependencies [bf418ef]:
- effect@3.16.5
- @effect/experimental@0.48.10
- @effect/platform@0.84.9
- @effect/sql@0.37.10

0.38.9

Patch Changes

Updated dependencies [8b9db77]:
- @effect/platform@0.84.8
- @effect/experimental@0.48.9
- @effect/sql@0.37.9

0.38.8

Patch Changes

Updated dependencies [74ab9a0, 770008e]:
- effect@3.16.4
- @effect/experimental@0.48.8
- @effect/platform@0.84.7
- @effect/sql@0.37.8

0.38.7

Patch Changes

Updated dependencies [a2d57c9]:
- @effect/experimental@0.48.7
- @effect/sql@0.37.7

0.38.6

Patch Changes

Updated dependencies [ceea77a]:
- @effect/platform@0.84.6
- @effect/experimental@0.48.6
- @effect/sql@0.37.6

0.38.5

Patch Changes

Updated dependencies [ec52c6a]:
- @effect/platform@0.84.5
- @effect/experimental@0.48.5
- @effect/sql@0.37.5

0.38.4

Patch Changes

Updated dependencies [87722fc, 36217ee]:
- effect@3.16.3
- @effect/experimental@0.48.4
- @effect/platform@0.84.4
- @effect/sql@0.37.4

0.38.3

Patch Changes

Updated dependencies [ab7684f]:
- @effect/platform@0.84.3
- @effect/experimental@0.48.3
- @effect/sql@0.37.3

0.38.2

Patch Changes

Updated dependencies [0ddf148]:
- effect@3.16.2
- @effect/experimental@0.48.2
- @effect/platform@0.84.2
- @effect/sql@0.37.2

0.38.1

Patch Changes

Updated dependencies [71174d0, d615e6e]:
- @effect/platform@0.84.1
- effect@3.16.1
- @effect/experimental@0.48.1
- @effect/sql@0.37.1

0.38.0

Patch Changes

Updated dependencies [ee0bd5d, 5189800, 58bfeaa, 194d748, 918c9ea, 9198e6f, 2a370bf, 58ccb91, fd47834]:
- effect@3.16.0
- @effect/experimental@0.48.0
- @effect/platform@0.84.0
- @effect/sql@0.37.0

0.37.0

Patch Changes

Updated dependencies [5522520, cc5bb2b]:
- @effect/platform@0.83.0
- effect@3.15.5
- @effect/experimental@0.47.0
- @effect/sql@0.36.0

0.36.8

Patch Changes

Updated dependencies [0617b9d]:
- @effect/platform@0.82.8
- @effect/experimental@0.46.8
- @effect/sql@0.35.8

0.36.7

Patch Changes

Updated dependencies [f570554, 78047e8, c20b95a, 94ada43]:
- effect@3.15.4
- @effect/platform@0.82.7
- @effect/experimental@0.46.7
- @effect/sql@0.35.7

0.36.6

Patch Changes

Updated dependencies [618903b]:
- @effect/platform@0.82.6
- @effect/experimental@0.46.6
- @effect/sql@0.35.6

0.36.5

Patch Changes

Updated dependencies [7764a07, 4577f54, 30a0d9c]:
- @effect/platform@0.82.5
- effect@3.15.3
- @effect/experimental@0.46.5
- @effect/sql@0.35.5

0.36.4

Patch Changes

Updated dependencies [d45e8a8, 89657ac, d13b68e]:
- @effect/platform@0.82.4
- @effect/sql@0.35.4
- @effect/experimental@0.46.4

0.36.3

Patch Changes

Updated dependencies [b8722b8, a328f4b]:
- effect@3.15.2
- @effect/platform@0.82.3
- @effect/experimental@0.46.3
- @effect/sql@0.35.3

0.36.2

Patch Changes

Updated dependencies [739a3d4]:
- @effect/platform@0.82.2
- @effect/experimental@0.46.2
- @effect/sql@0.35.2

0.36.1

Patch Changes

Updated dependencies [787ce70, 1269641, 1269641]:
- effect@3.15.1
- @effect/experimental@0.46.1
- @effect/platform@0.82.1
- @effect/sql@0.35.1

0.36.0

Patch Changes

Updated dependencies [c654595, d9f5dea, 49aa723, 74c14d0, e4f49b6, 6f02224, 1dcfd41, b21ab16, fcf1822, 0061dd1, 8421e6e, a9b3fb7, fa10f56]:
- effect@3.15.0
- @effect/platform@0.82.0
- @effect/experimental@0.46.0
- @effect/sql@0.35.0

0.35.1

Patch Changes

Updated dependencies [24a9ebb]:
- effect@3.14.22
- @effect/experimental@0.45.1
- @effect/platform@0.81.1
- @effect/sql@0.34.1

0.35.0

Patch Changes

Updated dependencies [672920f]:
- @effect/platform@0.81.0
- @effect/experimental@0.45.0
- @effect/sql@0.34.0

0.34.21

Patch Changes

Updated dependencies [2f3b7d4]:
- effect@3.14.21
- @effect/experimental@0.44.21
- @effect/platform@0.80.21
- @effect/sql@0.33.21

0.34.20

Patch Changes

Updated dependencies [17e2f30]:
- effect@3.14.20
- @effect/experimental@0.44.20
- @effect/platform@0.80.20
- @effect/sql@0.33.20

0.34.19

Patch Changes

Updated dependencies [056a910, e25e7bb, 3273d57]:
- effect@3.14.19
- @effect/platform@0.80.19
- @effect/experimental@0.44.19
- @effect/sql@0.33.19

0.34.18

Patch Changes

Updated dependencies [b1164d4]:
- effect@3.14.18
- @effect/experimental@0.44.18
- @effect/platform@0.80.18
- @effect/sql@0.33.18

0.34.17

Patch Changes

Updated dependencies [0b54681, 41a59d5]:
- effect@3.14.17
- @effect/experimental@0.44.17
- @effect/platform@0.80.17
- @effect/sql@0.33.17

0.34.16

Patch Changes

Updated dependencies [ee14444, f1c8583]:
- effect@3.14.16
- @effect/platform@0.80.16
- @effect/experimental@0.44.16
- @effect/sql@0.33.16

0.34.15

Patch Changes

Updated dependencies [239cc99, 8b6c947, c50a63b]:
- effect@3.14.15
- @effect/experimental@0.44.15
- @effect/platform@0.80.15
- @effect/sql@0.33.15

0.34.14

Patch Changes

Updated dependencies [6ed8d15]:
- effect@3.14.14
- @effect/experimental@0.44.14
- @effect/platform@0.80.14
- @effect/sql@0.33.14

0.34.13

Patch Changes

Updated dependencies [ee77788, 5fce6ba, 570e45f]:
- effect@3.14.13
- @effect/experimental@0.44.13
- @effect/platform@0.80.13
- @effect/sql@0.33.13

0.34.12

Patch Changes

Updated dependencies [c2ad9ee, 9c68654]:
- effect@3.14.12
- @effect/experimental@0.44.12
- @effect/platform@0.80.12
- @effect/sql@0.33.12

0.34.11

Patch Changes

Updated dependencies [e536127]:
- effect@3.14.11
- @effect/experimental@0.44.11
- @effect/platform@0.80.11
- @effect/sql@0.33.11

0.34.10

Patch Changes

Updated dependencies [bc7efa3]:
- effect@3.14.10
- @effect/experimental@0.44.10
- @effect/platform@0.80.10
- @effect/sql@0.33.10

0.34.9

Patch Changes

Updated dependencies [d78249f]:
- effect@3.14.9
- @effect/experimental@0.44.9
- @effect/platform@0.80.9
- @effect/sql@0.33.9

0.34.8

Patch Changes

Updated dependencies [b3a2d32]:
- effect@3.14.8
- @effect/experimental@0.44.8
- @effect/platform@0.80.8
- @effect/sql@0.33.8

0.34.7

Patch Changes

Updated dependencies [b542a4b]:
- effect@3.14.7
- @effect/experimental@0.44.7
- @effect/platform@0.80.7
- @effect/sql@0.33.7

0.34.6

Patch Changes

Updated dependencies [47618c1, 6077882]:
- effect@3.14.6
- @effect/experimental@0.44.6
- @effect/platform@0.80.6
- @effect/sql@0.33.6

0.34.5

Patch Changes

Updated dependencies [40dbfef, 85fba81, 5a5ebdd]:
- effect@3.14.5
- @effect/platform@0.80.5
- @effect/experimental@0.44.5
- @effect/sql@0.33.5

0.34.4

Patch Changes

Updated dependencies [e4ba2c6]:
- effect@3.14.4
- @effect/experimental@0.44.4
- @effect/platform@0.80.4
- @effect/sql@0.33.4

0.34.3

Patch Changes

Updated dependencies [37aa8e1, 34f03d6]:
- effect@3.14.3
- @effect/experimental@0.44.3
- @effect/platform@0.80.3
- @effect/sql@0.33.3

0.34.2

Patch Changes

Updated dependencies [f87991b, f87991b, 0a3e3e1]:
- effect@3.14.2
- @effect/experimental@0.44.2
- @effect/platform@0.80.2
- @effect/sql@0.33.2

0.34.1

Patch Changes

Updated dependencies [4a274fe]:
- effect@3.14.1
- @effect/experimental@0.44.1
- @effect/platform@0.80.1
- @effect/sql@0.33.1

0.34.0

Minor Changes

#4469 3131f8f Thanks @tim-smart! - refactor of @effect/cluster packages

Patch Changes

Updated dependencies [1f47e4e, 26dd75f, aba2d1d, 3131f8f, aba2d1d, 04dff2d, aba2d1d, c7fac0c, aba2d1d, ffaa3f3, ab957c1, 35db9ce, aba2d1d, cf77ea9, 26dd75f, baaab60]:
- effect@3.14.0
- @effect/experimental@0.44.0
- @effect/platform@0.80.0
- @effect/sql@0.33.0

0.33.4

Patch Changes

Updated dependencies [5662363, 5f1fd15, 8bb1460]:
- @effect/platform@0.79.4
- @effect/experimental@0.43.4
- @effect/sql@0.32.4

0.33.3

Patch Changes

Updated dependencies [0c4803f, 6f65ac4]:
- effect@3.13.12
- @effect/experimental@0.43.3
- @effect/platform@0.79.3
- @effect/sql@0.32.3

0.33.2

Patch Changes

Updated dependencies [fad8cca, 4296293, 9c241ab, 082b0c1, be12983, de88127]:
- effect@3.13.11
- @effect/experimental@0.43.2
- @effect/platform@0.79.2
- @effect/sql@0.32.2

0.33.1

Patch Changes

Updated dependencies [527c964]:
- effect@3.13.10
- @effect/experimental@0.43.1
- @effect/platform@0.79.1
- @effect/sql@0.32.1

0.33.0

Patch Changes

Updated dependencies [88fe129, d630249, 2976e52]:
- @effect/platform@0.79.0
- effect@3.13.9
- @effect/experimental@0.43.0
- @effect/sql@0.32.0

0.32.1

Patch Changes

Updated dependencies [c65d336, 22d2ebb]:
- effect@3.13.8
- @effect/experimental@0.42.1
- @effect/platform@0.78.1
- @effect/sql@0.31.1

0.32.0

Patch Changes

Updated dependencies [c5bcf53]:
- @effect/platform@0.78.0
- @effect/experimental@0.42.0
- @effect/sql@0.31.0

0.31.7

Patch Changes

Updated dependencies [840cc73, 9bf8a74, 87ba23c, f910880, 0d01480]:
- @effect/platform@0.77.7
- effect@3.13.7
- @effect/experimental@0.41.7
- @effect/sql@0.30.7

0.31.6

Patch Changes

Updated dependencies [3154ce4]:
- effect@3.13.6
- @effect/experimental@0.41.6
- @effect/platform@0.77.6
- @effect/sql@0.30.6

0.31.5

Patch Changes

Updated dependencies [367bb35, 6cf11c3, a0acec8]:
- effect@3.13.5
- @effect/experimental@0.41.5
- @effect/platform@0.77.5
- @effect/sql@0.30.5

0.31.4

Patch Changes

Updated dependencies [e0746f9, 17d9e89]:
- @effect/platform@0.77.4
- effect@3.13.4
- @effect/experimental@0.41.4
- @effect/sql@0.30.4

0.31.3

Patch Changes

Updated dependencies [cc5588d, 623c8cd, 00b4eb1, f2aee98, fb798eb, 2251b15, 2e15c1e, a4979db, b74255a, d7f6a5c, 9dd8979, 477b488, 10932cb, 9f6c784, 2c639ec, 886aaa8]:
- effect@3.13.3
- @effect/experimental@0.41.3
- @effect/platform@0.77.3
- @effect/sql@0.30.3

0.31.2

Patch Changes

Updated dependencies [31be72a, 3e7ce97, 31be72a]:
- effect@3.13.2
- @effect/platform@0.77.2
- @effect/experimental@0.41.2
- @effect/sql@0.30.2

0.31.1

Patch Changes

Updated dependencies [b56a211]:
- effect@3.13.1
- @effect/experimental@0.41.1
- @effect/platform@0.77.1
- @effect/sql@0.30.1

0.31.0

Patch Changes

Updated dependencies [8baef83, 655bfe2, d90cbc2, 75632bd, c874a2e, bf865e5, f98b2b7, de8ce92, cf8b2dd, db426a5, 6862444, 5fc8a90, 546a492, 65c4796, 9760fdc, 5b471e7, 4f810cc]:
- effect@3.13.0
- @effect/experimental@0.41.0
- @effect/platform@0.77.0
- @effect/sql@0.30.0

0.30.1

Patch Changes

Updated dependencies [4018eae, 543d36d, c407726, f70a65a, ba409f6, 3d2e356]:
- effect@3.12.12
- @effect/platform@0.76.1
- @effect/experimental@0.40.1
- @effect/sql@0.29.1

0.30.0

Patch Changes

Updated dependencies [b6a032f, 42ddd5f, 2fe447c, 2473ad5]:
- effect@3.12.11
- @effect/platform@0.76.0
- @effect/experimental@0.40.0
- @effect/sql@0.29.0

0.29.4

Patch Changes

Updated dependencies [e30f132, 33fa667, 87f5f28, 7d57ecd, 4dbd170]:
- effect@3.12.10
- @effect/platform@0.75.4
- @effect/experimental@0.39.4
- @effect/sql@0.28.4

0.29.3

Patch Changes

Updated dependencies [1b4a4e9]:
- effect@3.12.9
- @effect/experimental@0.39.3
- @effect/platform@0.75.3
- @effect/sql@0.28.3

0.29.2

Patch Changes

Updated dependencies [59b3cfb, 766113c, bb05fb8, 712277f, f269122, 8f6006a, c45b559, 430c846, 7b03057, a9c94c8, 107e6f0, c9175ae, 65c11b9, e386d2f, 9172efb]:
- @effect/platform@0.75.2
- effect@3.12.8
- @effect/experimental@0.39.2
- @effect/sql@0.28.2

0.29.1

Patch Changes

Updated dependencies [8dff1d1]:
- effect@3.12.7
- @effect/experimental@0.39.1
- @effect/platform@0.75.1
- @effect/sql@0.28.1

0.29.0

Patch Changes

Updated dependencies [5e43ce5, 289c13b, 76eb7d0, 8b4e75d, fc5e0f0, 004fd2b, b2a31be, 5514d05, bf5f0ae, 3b19bcf, b064b3b, eb264ed, 289c13b, f474678, ee187d0]:
- @effect/experimental@0.39.0
- @effect/platform@0.75.0
- effect@3.12.6
- @effect/sql@0.28.0

0.28.0

Patch Changes

Updated dependencies [bd0d489, a8b0ddb, 8653072, 507d546, a8b0ddb, 8db239b, 84a0911, 84a0911, 3179a9f, 6cb9b76, 1fcbe55, bd0d489, d9a63d9, 6cb9b76]:
- @effect/experimental@0.38.0
- @effect/sql@0.27.0
- effect@3.12.5
- @effect/platform@0.74.0

0.27.1

Patch Changes

Updated dependencies [5b50ea4, c170a68, a66c2eb, c9e5e1b, 7b3d58d]:
- effect@3.12.4
- @effect/platform@0.73.1
- @effect/experimental@0.37.1
- @effect/sql@0.26.1

0.27.0

Patch Changes

Updated dependencies [d7dac48, c110032, 1d7fd2b, 1d7fd2b, 23ac740, 8cd7319]:
- effect@3.12.3
- @effect/platform@0.73.0
- @effect/experimental@0.37.0
- @effect/sql@0.26.0

0.26.2

Patch Changes

Updated dependencies [734af82, b63c780, 212e784, f852cb0, 7276ae2, 212e784, 212e784, 212e784, c640d77, 0def088]:
- effect@3.12.2
- @effect/platform@0.72.2
- @effect/experimental@0.36.2
- @effect/sql@0.25.2

0.26.1

Patch Changes

Updated dependencies [302b57d, 0988083, 8b46be6, bfe8027, 16dd657, 39db211]:
- effect@3.12.1
- @effect/experimental@0.36.1
- @effect/platform@0.72.1
- @effect/sql@0.25.1

0.26.0

Patch Changes

Updated dependencies [abb22a4, f369a89, 642376c, 3d2b7a7, ef64c6f, 73f9c6f, 17cb451, d801820, e1eeb2d, c11f3a6, 618f7e0, c0ba834, e1eeb2d]:
- effect@3.12.0
- @effect/platform@0.72.0
- @effect/experimental@0.36.0
- @effect/sql@0.25.0

0.25.3

Patch Changes

Updated dependencies [39457d4, a475cc2, 199214e, b3c160d]:
- effect@3.11.10
- @effect/experimental@0.35.3
- @effect/platform@0.71.7
- @effect/sql@0.24.3

0.25.2

Patch Changes

Updated dependencies [1c08a0b, 1ce703b, 1ce703b]:
- effect@3.11.9
- @effect/experimental@0.35.2
- @effect/platform@0.71.6
- @effect/sql@0.24.2

0.25.1

Patch Changes

Updated dependencies [05d71f8, e66b920]:
- @effect/platform@0.71.5
- @effect/experimental@0.35.1
- @effect/sql@0.24.1

0.25.0

Patch Changes

Updated dependencies [909181a, 909181a, 1a6b52d]:
- @effect/platform@0.71.4
- effect@3.11.8
- @effect/experimental@0.35.0
- @effect/sql@0.24.0

0.24.4

Patch Changes

Updated dependencies [6984508, 883639c]:
- @effect/platform@0.71.3
- @effect/experimental@0.34.3
- @effect/sql@0.23.3

0.24.3

Patch Changes

#4143 f7f2dd6 Thanks @tim-smart! - add timeout to sql connection attempts

0.24.2

Patch Changes

Updated dependencies [2408616, cec0b4d, cec0b4d, 8d978c5, cec0b4d, cec0b4d]:
- effect@3.11.7
- @effect/platform@0.71.2
- @effect/experimental@0.34.2
- @effect/sql@0.23.2

0.24.1

Patch Changes

Updated dependencies [1d3df5b]:
- @effect/platform@0.71.1
- @effect/experimental@0.34.1
- @effect/sql@0.23.1

0.24.0

Patch Changes

Updated dependencies [662d1ce, c99a0f3, 11fc401, c99a0f3, 31c62d8]:
- effect@3.11.6
- @effect/platform@0.71.0
- @effect/experimental@0.34.0
- @effect/sql@0.23.0

0.23.7

Patch Changes

Updated dependencies [9f5a6f7, ef70ffc, 22905cf, 9f5a6f7, 1e59e4f, 9f5a6f7, 8d914e5, 03bb00f, 9f5a6f7, 14e1149, 9f5a6f7, 9f5a6f7]:
- effect@3.11.5
- @effect/experimental@0.33.7
- @effect/platform@0.70.7
- @effect/sql@0.22.7

0.23.6

Patch Changes

Updated dependencies [9a5b8e3]:
- @effect/platform@0.70.6
- @effect/experimental@0.33.6
- @effect/sql@0.22.6

0.23.5

Patch Changes

#4090 e993627 Thanks @rocwang! - Add the missing dependency on @effect/experimental to @effect/sql-X
Updated dependencies [415f4c9, 518b258, 6e323a3, 518b258, 6e323a3]:
- @effect/platform@0.70.5
- effect@3.11.4
- @effect/experimental@0.33.5
- @effect/sql@0.22.5

0.23.4

Patch Changes

Updated dependencies [90906f7, 3862cd3, 3862cd3, 343b6aa, afba339]:
- effect@3.11.3
- @effect/platform@0.70.4
- @effect/sql@0.22.4

0.23.3

Patch Changes

Updated dependencies [7044730]:
- @effect/platform@0.70.3
- @effect/sql@0.22.3

0.23.2

Patch Changes

Updated dependencies [01cee56, c2249ea, 1358aa5, 1de3fe7]:
- effect@3.11.2
- @effect/platform@0.70.2
- @effect/sql@0.22.2

0.23.1

Patch Changes

Updated dependencies [dd8a2d8, a71bfef]:
- effect@3.11.1
- @effect/platform@0.70.1
- @effect/sql@0.22.1

0.23.0

Patch Changes

Updated dependencies [147434b, 6e69493, 147434b, 5eff3f6, d9fe79b, 251d189, 5a259f3, b4ce4ea, 15fcc5a, 9bc9a47, aadb8a4, 1e2747c, 9264162, e0b9b09, c36f3b9, 672bde5, aadb8a4]:
- effect@3.11.0
- @effect/platform@0.70.0
- @effect/sql@0.22.0

0.22.4

Patch Changes

Updated dependencies [3069614, 09a5e52]:
- effect@3.10.20
- @effect/platform@0.69.32
- @effect/sql@0.21.4

0.22.3

Patch Changes

Updated dependencies [e6d4a37]:
- @effect/platform@0.69.31
- @effect/sql@0.21.3

0.22.2

Patch Changes

Updated dependencies []:
- @effect/sql@0.21.2

0.22.1

Patch Changes

Updated dependencies [270f199]:
- @effect/platform@0.69.30
- @effect/sql@0.21.1

0.22.0

Minor Changes

#4022 1b1ba09 Thanks @tim-smart! - allow cloning a SqlClient with transforms disabled

Patch Changes

#4021 e9dfea3 Thanks @tim-smart! - add .reactive method to SqlClient interface
Updated dependencies [e9dfea3, 1b1ba09, 24cc35e]:
- @effect/sql@0.21.0
- @effect/platform@0.69.29

0.21.12

Patch Changes

#4007 944025b Thanks @gcanti! - Wrap JSDoc @example tags with a TypeScript fence, closes #4002
Updated dependencies [edd72be, a3e2771, 944025b, 54addee, a9e00e4]:
- @effect/platform@0.69.28
- effect@3.10.19
- @effect/sql@0.20.12

0.21.11

Patch Changes

Updated dependencies [af409cf, beaccae]:
- effect@3.10.18
- @effect/platform@0.69.27
- @effect/sql@0.20.11

0.21.10

Patch Changes

Updated dependencies [c963886, 42c4ce6]:
- @effect/platform@0.69.26
- effect@3.10.17
- @effect/sql@0.20.10

0.21.9

Patch Changes

Updated dependencies [320557a, 4dca30c, 1d99867, 6dae414, 6b0d737, d8356aa, 7b93dd6]:
- @effect/platform@0.69.25
- effect@3.10.16
- @effect/sql@0.20.9

0.21.8

Patch Changes

Updated dependencies [3cc6514]:
- @effect/platform@0.69.24
- @effect/sql@0.20.8

0.21.7

Patch Changes

Updated dependencies [3aff4d3]:
- @effect/platform@0.69.23
- @effect/sql@0.20.7

0.21.6

Patch Changes

Updated dependencies [8398b32, 72e55b7]:
- effect@3.10.15
- @effect/platform@0.69.22
- @effect/sql@0.20.6

0.21.5

Patch Changes

Updated dependencies [f983946, 2d8a750]:
- effect@3.10.14
- @effect/platform@0.69.21
- @effect/sql@0.20.5

0.21.4

Patch Changes

Updated dependencies [995bbdf]:
- effect@3.10.13
- @effect/platform@0.69.20
- @effect/sql@0.20.4

0.21.3

Patch Changes

Updated dependencies [eb8c52d]:
- @effect/platform@0.69.19
- @effect/sql@0.20.3

0.21.2

Patch Changes

Updated dependencies [a0584ec, dd14efe, dd14efe]:
- @effect/platform@0.69.18
- effect@3.10.12
- @effect/sql@0.20.2

0.21.1

Patch Changes

Updated dependencies [5eef499, 8240b1c, 5eef499]:
- effect@3.10.11
- @effect/platform@0.69.17
- @effect/sql@0.20.1

0.21.0

Patch Changes

Updated dependencies []:
- @effect/sql@0.20.0

0.20.0

Patch Changes

Updated dependencies [cd720ae, cd720ae, cd720ae, b631f40, 7d89650]:
- effect@3.10.10
- @effect/platform@0.69.16
- @effect/sql@0.19.0

0.19.5

Patch Changes

Updated dependencies [8a30e1d]:
- @effect/platform@0.69.15
- @effect/sql@0.18.16

0.19.4

Patch Changes

Updated dependencies [a123e80, bd5fcd3, 0289d3b, 7386b71, 07c493a, 257ab1b, 4211a23]:
- effect@3.10.9
- @effect/platform@0.69.14
- @effect/sql@0.18.15

0.19.3

Patch Changes

Updated dependencies [68b5c9e, 9c9928d, 6306e66, 361c7f3]:
- effect@3.10.8
- @effect/sql@0.18.14
- @effect/platform@0.69.13

0.19.2

Patch Changes

Updated dependencies [33f5b9f, 50f0281]:
- effect@3.10.7
- @effect/platform@0.69.12
- @effect/sql@0.18.13

0.19.1

Patch Changes

Updated dependencies [ce1c21f, 81ddd45]:
- effect@3.10.6
- @effect/platform@0.69.11
- @effect/sql@0.18.12

0.19.0

Minor Changes

#3852 70dd4d7 Thanks @sukovanej! - Use layer / layerConfig naming convention for the /sql-* packages. Make layer constructors accept a raw config object. Add layerConfig constructors that accept Config.Config<...>.

Patch Changes

Updated dependencies [3a6d757, 59d813a]:
- effect@3.10.5
- @effect/platform@0.69.10
- @effect/sql@0.18.11

0.18.10

Patch Changes

Updated dependencies [2367708]:
- @effect/platform@0.69.9
- effect@3.10.4
- @effect/sql@0.18.10

0.18.9

Patch Changes

Updated dependencies [522f7c5]:
- @effect/platform@0.69.8
- @effect/sql@0.18.9

0.18.8

Patch Changes

Updated dependencies [690d6c5, b9423d8, 279fe3a]:
- @effect/platform@0.69.7
- effect@3.10.3
- @effect/sql@0.18.8

0.18.7

Patch Changes

Updated dependencies [714e119, c1afd55, 42cd72a]:
- effect@3.10.2
- @effect/platform@0.69.6
- @effect/sql@0.18.7

0.18.6

Patch Changes

Updated dependencies [9604d6b]:
- effect@3.10.1
- @effect/sql@0.18.6
- @effect/platform@0.69.5

0.18.5

Patch Changes

Updated dependencies [c86b1d7]:
- @effect/platform@0.69.4
- @effect/sql@0.18.5

0.18.4

Patch Changes

Updated dependencies [d5fba63, 1eb2c30, 02d413e]:
- @effect/platform@0.69.3
- @effect/sql@0.18.4

0.18.3

Patch Changes

Updated dependencies [e7afc47]:
- @effect/platform@0.69.2
- @effect/sql@0.18.3

0.18.2

Patch Changes

Updated dependencies []:
- @effect/sql@0.18.2

0.18.1

Patch Changes

Updated dependencies [7564f56, 7564f56]:
- @effect/platform@0.69.1
- @effect/sql@0.18.1

0.18.0

Patch Changes

Updated dependencies [4a01828, 6d9de6b, 4a01828, c79c4c1, 38d30f0, 5821ce3]:
- effect@3.10.0
- @effect/platform@0.69.0
- @effect/sql@0.18.0

0.17.0

Minor Changes

#3760 dacbf7d Thanks @tim-smart! - add sql-clickhouse & clickhouse dialect

Patch Changes

Updated dependencies [dacbf7d]:
- @effect/sql@0.17.0

0.16.6

Patch Changes

Updated dependencies []:
- @effect/platform@0.68.6
- @effect/sql@0.16.6

0.16.5

Patch Changes

Updated dependencies [2036402]:
- @effect/platform@0.68.5
- @effect/sql@0.16.5

0.16.4

Patch Changes

Updated dependencies [1b1ef29]:
- @effect/platform@0.68.4
- @effect/sql@0.16.4

0.16.3

Patch Changes

Updated dependencies [61a99b2, 8c33087]:
- effect@3.9.2
- @effect/platform@0.68.3
- @effect/sql@0.16.3

0.16.2

Patch Changes

Updated dependencies []:
- @effect/sql@0.16.2
- @effect/platform@0.68.2

0.16.1

Patch Changes

Updated dependencies [b75ac5d]:
- @effect/platform@0.68.1
- @effect/sql@0.16.1

0.16.0

Patch Changes

Updated dependencies [90ceeab, 90ceeab, 90ceeab]:
- @effect/platform@0.68.0
- @effect/sql@0.16.0

0.15.2

Patch Changes

#3744 9fef880 Thanks @tim-smart! - test sql connection as part of client construction

0.15.1

Patch Changes

Updated dependencies [3b2ad1d]:
- @effect/platform@0.67.1
- effect@3.9.1
- @effect/sql@0.15.1

0.15.0

Patch Changes

Updated dependencies [ff3d1aa, 0ba66f2, bf77f51, 016f9ad, 0779681, 534129f, d75140c, be0451c, 9237ac6, be0451c, 5b36494, c716adb, 4986391, d75140c, d1387ae]:
- effect@3.9.0
- @effect/platform@0.67.0
- @effect/sql@0.15.0

0.14.1

Patch Changes

#3704 b00f7a0 Thanks @wewelll! - accept tls options for ssl configuration of PgClient
Updated dependencies [88e85db, f40da15, 8e94585, 83887ca, 5266b6c, cdead5c, f40da15, 766a8af]:
- effect@3.8.5
- @effect/platform@0.66.3
- @effect/sql@0.14.1

0.14.0

Patch Changes

Updated dependencies [f100e20]:
- @effect/sql@0.14.0

0.13.4

Patch Changes

Updated dependencies []:
- @effect/sql@0.13.4

0.13.3

Patch Changes

Updated dependencies [0a68746, fd83d0e, 4509656, 090e41c]:
- @effect/sql@0.13.3
- @effect/platform@0.66.2
- effect@3.8.4

0.13.2

Patch Changes

Updated dependencies [3812788]:
- @effect/platform@0.66.1
- @effect/sql@0.13.2

0.13.1

Patch Changes

Updated dependencies [d5c8e7e]:
- @effect/sql@0.13.1

0.13.0

Patch Changes

Updated dependencies []:
- @effect/platform@0.66.0
- @effect/sql@0.13.0

0.12.6

Patch Changes

Updated dependencies [321b201, bb5ec6b]:
- @effect/platform@0.65.5
- effect@3.8.3
- @effect/sql@0.12.6

0.12.5

Patch Changes

Updated dependencies []:
- @effect/platform@0.65.4
- @effect/sql@0.12.5

0.12.4

Patch Changes

Updated dependencies []:
- @effect/sql@0.12.4

0.12.3

Patch Changes

Updated dependencies [f0d8ef1]:
- effect@3.8.2
- @effect/platform@0.65.3
- @effect/sql@0.12.3

0.12.2

Patch Changes

Updated dependencies [10bf621, ae36fa6]:
- effect@3.8.1
- @effect/platform@0.65.2
- @effect/sql@0.12.2

0.12.1

Patch Changes

Updated dependencies [e44c5f2]:
- @effect/platform@0.65.1
- @effect/sql@0.12.1

0.12.0

Patch Changes

Updated dependencies [fcfa6ee, bb9931b, 5798f76, 5f0bfa1, 812a4e8, 6a128f6, 273565e, adf7d7a, 569a801, aa1fa53, 02f6b06, 12b893e, bbad27e, 7041393, e0d21a5, adf7d7a, 007289a, 42a8f99, eebfd29, 040703d]:
- effect@3.8.0
- @effect/platform@0.65.0
- @effect/sql@0.12.0

0.11.3

Patch Changes

Updated dependencies [ccd67df]:
- @effect/sql@0.11.3

0.11.2

Patch Changes

Updated dependencies [d8aff79, 35a0f81, d8aff79, 8261c5a]:
- @effect/sql@0.11.2
- effect@3.7.3
- @effect/platform@0.64.1

0.11.1

Patch Changes

Updated dependencies []:
- @effect/sql@0.11.1

0.11.0

Patch Changes

Updated dependencies [90ac8f6, 90ac8f6, 3791e24, 3791e24]:
- @effect/platform@0.64.0
- @effect/sql@0.11.0

0.10.4

Patch Changes

Updated dependencies []:
- @effect/sql@0.10.4

0.10.3

Patch Changes

Updated dependencies [4a701c4]:
- @effect/platform@0.63.3
- @effect/sql@0.10.3

0.10.2

Patch Changes

Updated dependencies [8a601d7, 353ba19]:
- effect@3.7.2
- @effect/platform@0.63.2
- @effect/sql@0.10.2

0.10.1

Patch Changes

#3529 0ba81cb Thanks @aniravi24! - Add onnotice option to PgClient.
Updated dependencies [79859e7, f6a469c, dcb9ec0, 79aa6b1]:
- effect@3.7.1
- @effect/platform@0.63.1
- @effect/sql@0.10.1

0.10.0

Patch Changes

Updated dependencies [db89601, 2f456cc, 8745e41, e557838, d6e7e40, 8356321, 192f2eb, 718cb70, e9d0310, 6bf28f7]:
- effect@3.7.0
- @effect/platform@0.63.0
- @effect/sql@0.10.0

0.9.7

Patch Changes

Updated dependencies [e809286]:
- effect@3.6.8
- @effect/platform@0.62.5
- @effect/sql@0.9.7

0.9.6

Patch Changes

Updated dependencies [e7a65e3, 50ec889]:
- @effect/platform@0.62.4
- effect@3.6.7
- @effect/sql@0.9.6

0.9.5

Patch Changes

Updated dependencies [f960bf4, 46a575f]:
- effect@3.6.6
- @effect/platform@0.62.3
- @effect/sql@0.9.5

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

Updated dependencies [e9da539, 4fabf75]:
- @effect/sql@0.9.1

0.9.0

Minor Changes

#3457 a07990d Thanks @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 RETURNING clause, the mysql2 client will return a ResultSetHeader for INSERT, UPDATE, DELETE, and TRUNCATE operations.

To gain access to the raw results of a query, you can use the .raw property on the Statement:

1
import * as Effect from "effect/Effect"
2
import * as SqlClient from "@effect/sql/SqlClient"
3
import * as MysqlClient from "@effect/sql/MysqlClient"
4

5
const DatabaseLive = MysqlClient.layer({
6
  database: Config.succeed("database"),
7
  username: Config.succeed("root"),
8
  password: Config.succeed(Redacted.make("password"))
9
})
10

11
const program = Effect.gen(function* () {
12
  const sql = yield* SqlClient.SqlClient
13

14
  const result = yield* sql`INSERT INTO usernames VALUES ("Bob")`.raw
15

16
  console.log(result)
17
  /**
18
   * ResultSetHeader {
19
   *   fieldCount: 0,
20
   *   affectedRows: 1,
21
   *   insertId: 0,
22
   *   info: '',
23
   *   serverStatus: 2,
24
   *   warningStatus: 0,
25
   *   changedRows: 0
26
   * }
27
   */
28
})
29

30
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

#3398 45dbb9f Thanks @sukovanej! - Add listen / notify to PgClient.
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

#3365 f0d1824 Thanks @sukovanej! - Add socket option to PgClient.
#3364 16b2202 Thanks @sukovanej! - Add applicationName name option configuring connection.application_name.
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 99bddcf Thanks @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

#3260 53c0db0 Thanks @tim-smart! - replace /platform RefailError with use of the “cause” property

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

#3079 bbdd365 Thanks @tim-smart! - update dependencies
#3079 bbdd365 Thanks @tim-smart! - update to typescript 5.5
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

#3035 d33d8b0 Thanks @tim-smart! - restructure sql modules to have flat imports

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

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

#2838 bf66289 Thanks @tim-smart! - allow additional span attributes to be passed to sql clients

0.3.0

Minor Changes

#2833 af0543c Thanks @tim-smart! - remove file system migrator from web sql implementations

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.17

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.16

Patch Changes

Updated dependencies [45578e8]:
- effect@3.2.3
- @effect/platform@0.53.14
- @effect/sql@0.2.16

0.2.15

Patch Changes

#2783 5fb0b33 Thanks @giacomoran! - Replace Postgres.js parsed options in PgClient.config
Updated dependencies [5d9266e, 9f8122e, 6a6f670, c1eaef9]:
- effect@3.2.2
- @effect/platform@0.53.13
- @effect/sql@0.2.15

0.2.14

Patch Changes

Updated dependencies []:
- @effect/platform@0.53.12
- @effect/sql@0.2.14

0.2.13

Patch Changes

Updated dependencies [c1e991d]:
- effect@3.2.1
- @effect/platform@0.53.11
- @effect/sql@0.2.13

0.2.12

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.11

Patch Changes

Updated dependencies [17fc22e, 810f222, 596aaea]:
- @effect/platform@0.53.9
- effect@3.1.6
- @effect/sql@0.2.11

0.2.10

Patch Changes

Updated dependencies []:
- @effect/platform@0.53.8
- @effect/sql@0.2.10

0.2.9

Patch Changes

#2712 01b4553 Thanks @vecerek! - Use constants from @opentelemetry/semantic-conventions as span attribute names instead of hard-coded values
Updated dependencies [01b4553]:
- @effect/sql@0.2.9
- @effect/platform@0.53.7

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 0724274 Thanks @tim-smart! - make @effect/sql dialect agnostic

All 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/sql package to access the client apis:

1
import * as Sql from "@effect/sql"
2
import { Effect } from "effect"
3

4
Effect.gen(function* () {
5
  const sql = yield* Sql.client.Client
6
  yield* sql`SELECT * FROM users`
7
})

If you need a functionality that is specific to a implementation, you can use the tag from the implementation package:

1
import * as Sqlite from "@effect/sql-sqlite-node"
2
import { Effect } from "effect"
3

4
Effect.gen(function* () {
5
  const sql = yield* Sqlite.client.SqliteClient
6
  const dump = yield* sql.export
7
})

If you need to run a different query depending on the dialect, you can use the sql.onDialect api:

1
import * as Sql from "@effect/sql"
2
import { Effect } from "effect"
3

4
Effect.gen(function* () {
5
  const sql = yield* Sql.client.Client
6
  yield* sql.onDialect({
7
    sqlite: () => sql`SELECT * FROM sqlite_master`,
8
    mysql: () => sql`SHOW TABLES`,
9
    mssql: () => sql`SELECT * FROM sys.tables`,
10
    pg: () => sql`SELECT * FROM pg_catalog.pg_tables`
11
  })
12
})

Patch Changes

#2693 0724274 Thanks @tim-smart! - add .returning helper to insert and update apis
Updated dependencies [0724274, 0724274]:
- @effect/sql@0.2.0

0.1.17

Patch Changes

#2683 0f88814 Thanks @giacomoran! - add prepare and types to PgClientConfig
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

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 f363af0 Thanks @tim-smart! - add sql transaction tracing spans
#2621 f363af0 Thanks @tim-smart! - update sql span attributes to follow semantic conventions
#2621 f363af0 Thanks @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

#2562 2cecdbd Thanks @fubhy! - Added provenance publishing
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 1499974 Thanks @IMax153! - initial @effect/sql release
#2207 2fb7d9c Thanks @github-actions! - Release Effect 3.0 🎉

Patch Changes

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