t3-code-android-nightly/.repos/effect-smol/packages/sql/pg/CHANGELOG.md
Julius Marminge 6f9cea00ae
chore(refs): sync Effect and Alchemy references to 4.0.1 and beta.80 (#16170)
Co-authored-by: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
2026-10-05 13:22:30 -07:00

311 KiB

@effect/sql-pg

4.0.1

Patch Changes

4.0.0

Patch Changes

  • #8633 2c552f2 Thanks @IMax153! - Effect 4.0 is the first stable release of Effect v4. It replaces the 4.0.0 beta and release-candidate series, whose per-release notes remain below under the 4.0.0-beta.* and 4.0.0-rc.* headings. To upgrade from Effect 3, follow the migration guide.

    Packaging and versioning

    • All Effect packages share one version number and are released together. Use the same version of effect and every @effect/* package.
    • @effect/platform, @effect/rpc, @effect/cluster, @effect/cli, @effect/ai, @effect/sql, @effect/workflow, @effect/experimental and similar packages are merged into effect. Separate packages remain only for platforms (@effect/platform-*), SQL drivers (@effect/sql-*), AI providers (@effect/ai-*), framework bindings (@effect/atom-*), OpenTelemetry, Vitest and tooling.
    • Modules such as effect/http, effect/http-api, effect/rpc, effect/cluster, effect/workflow, effect/ai, effect/cli, effect/sql and effect/schema import from effect/<area>. APIs tagged @stability unstable may have breaking changes in minor releases. APIs without a stability tag follow semver.
    • APIs that expose a third-party dependency are tagged @stability unstable, because that dependency's releases can change them. This covers NodeRedis, DenoRedis, BunRedis, @effect/platform-node/Undici and the undici dispatcher APIs, the ws options and re-exports in the platform packages, driver-specific options and clients in @effect/sql-clickhouse, @effect/sql-d1, @effect/sql-libsql, @effect/sql-mssql, @effect/sql-mysql2, @effect/sql-pglite and @effect/sql-sqlite-do, the provider clients, models and generated schemas in the @effect/ai-* packages, @effect/opentelemetry, and the vitest re-export in @effect/vitest.
    • effect has no runtime dependencies.
    • New packages in v4: @effect/platform-deno, @effect/sql-pglite, @effect/ai-openai-compat, @effect/ai-typesafe, @effect/atom-react, @effect/atom-solid, @effect/atom-vue, @effect/openapi-generator and @effect/doctest. @effect/docgen now lives in this repository.

    Core

    • The fiber runtime was rewritten for lower memory use and faster execution, with smaller bundles and better tree-shaking.
    • Services are defined with Context.Service, FiberRef is replaced by Context.Reference, Cause has a flat structure, and many combinators were renamed. See the migration guide for the full list.
    • Software transactional memory is built into Effect.tx, with TxRef, TxQueue, TxHashMap, TxPubSub, TxSemaphore and related Tx* data types.
    • Clock separates wall-clock time from monotonic time.
    • New modules include Semaphore, Latch, LayerRef, ErrorReporter, ByteSize, Newtype and Crypto. Arbitrary is now a native property-based testing module and no longer depends on fast-check.

    Schema

    • Schema v4 is a new implementation with faster parsing, class-based schemas, make constructors on every schema, and effectful decoding with services.
    • SchemaRepresentation powers JSON Schema (Draft-04, Draft-07, 2020-12 and OpenAPI 3.0/3.1) import and export, TypeScript code generation, and AI structured output.
    • SchemaBinary provides a compact binary codec and is the default wire format for cluster transports.
    • Optional JIT and AOT schema compilers are available as experimental modules.

    Platform, HTTP and RPC

    • HttpApi supports typed response headers, streaming and SSE responses, the HTTP QUERY method, HttpApiTest for in-memory testing, and much faster type checking for large APIs.
    • The HTTP modules add static file serving, response compression, rate-limited clients and graceful server shutdown.
    • Socket has a pull-based reader with backpressure and STARTTLS support. Network addresses are modeled by effect/net.
    • RPC serialization is schema-aware and supports server-originated requests and notifications.
    • @effect/platform-deno adds full Deno support. The Node, Bun, Deno and browser packages all provide the platform Crypto service, and the browser package adds IndexedDB support.

    Cluster and Workflow

    • Workflows can be declared with class syntax, and DurableQueue and an in-memory WorkflowEngine are available.
    • Runner memory can be bounded with ShardingConfig limits. Shutdown, entity movement and persisted replies are more reliable.

    SQL

    • @effect/sql-pg uses a built-in PostgreSQL client with pipelining, prepared statements and binary codecs, and no longer depends on pg.
    • @effect/sql-sqlite-node uses Node's built-in node:sqlite and requires Node 22.16 or newer.
    • SqlError exposes structured reasons such as UniqueViolation.

    AI

    • effect/ai adds EmbeddingModel, the DecisionModel classification and rating API, dynamic tools and tool approvals.
    • The MCP server supports protocol versions 2024-11-05 through 2026-07-28, including elicitation, sampling with tools, resource subscriptions and typed tool output.
    • Provider packages cover Anthropic, OpenAI, OpenAI-compatible APIs and OpenRouter.

    CLI, Atom, observability and testing

    • effect/cli adds global flags, command aliases and examples, an interactive wizard mode, and shell completions for Bash, Zsh and Fish.
    • effect/reactivity and the @effect/atom-* bindings add SSR hydration, stale-while-revalidate atoms and serializable RPC and HttpApi queries.
    • The OTLP exporters can be configured with standard OpenTelemetry environment variables, and @effect/opentelemetry aligns logs and spans with the OpenTelemetry specification.
    • @effect/vitest runs property tests with the native Arbitrary module and supports Vitest fixtures.

    Requirements

    • TypeScript 5.9 or newer. TypeScript 7 is recommended.
    • @effect/vitest and @effect/doctest require Vitest 5.
    • @effect/atom-react requires React 19.
    • @effect/platform-deno requires Deno 2.8.3 or newer.
  • Updated dependencies [cbfc7b4, 5a81a6f, 68b6394, 5250ca6, 5f9c9d1, 3278821, 83429b4, 0af6d0c, 927e01e, 10d8524, 35ac25a, 29e0aa7, 8783536, df77fff, ef7d77f, 035e369, f72790c, aa19472, 988c467, 735b77b, e5f7d12, 2c552f2]:

    • effect@4.0.0

4.0.0-rc.118

Patch Changes

4.0.0-rc.117

Patch Changes

  • #8309 7869f54 Thanks @tristanz! - Decode binary regclass and regclass[] values as unsigned numeric OIDs, fixing the migration runner's table-existence check. Cast regclass values to text in SQL to return relation names.

  • #8327 201b5ab Thanks @tim-smart! - Namespace prepared statement names per connection to avoid collisions when backend sessions are shared.

  • #8308 106af64 Thanks @tristanz! - Release savepoints after nested transactions succeed or successfully roll back in PostgreSQL, PGlite, MySQL, libSQL, and the Node, Bun, React Native, and WASM SQLite clients. This frees PostgreSQL transaction locks before the outer transaction completes.

    Custom SQL clients can opt in through the new releaseSavepoint option. Clients that omit it are unchanged.

  • #8330 27de875 Thanks @tim-smart! - Retire pooled PostgreSQL sessions with an unconfirmed CancelRequest, preventing a delayed cancel from reaching a later checkout. This includes interrupts sent while idle. The current checkout and unpooled sessions remain exposed to their own late cancel.

  • Updated dependencies [9953c92, c6e8b20, 8d40572, 1b21e0d, 3b155e3, 895d944, 705fb68, 87912c0, 106af64, 1b21e0d, 3d59ae6, 89c9a39]:

    • effect@4.0.0-rc.117

4.0.0-rc.116

Patch Changes

  • #8215 9367dcb Thanks @hsyntax! - Preserve the original SqlError when a PostgreSQL LISTEN connection fails after registration, allowing Stream.retry to acquire a new listener. Intentional scope closure still interrupts consumers.

    Notification queues returned by PgClient.listen and PgConnection.listen now carry SqlError. Update explicit queue and stream type annotations to include this error.

  • #8200 8feeb3c Thanks @tim-smart! - Support sslmode=prefer and sslmode=allow by trying TLS first, then plaintext if the server declines SSLRequest. Unlike libpq, allow also tries TLS first. Explicit ssl overrides and certificate verification are unchanged. TLS handshake and certificate failures remain fatal. Cancellation never downgrades a TLS session to plaintext.

  • #8234 4e4a3a6 Thanks @tim-smart! - Add structured startupParameters and opaque startupOptions to connection config, and restore support for URL options. Explicit startupOptions overrides URL options; the startup packet field remains options. Send session defaults in every physical connection's startup packet, including pooled replacements, with config validation and documented application-name precedence.

  • #8224 205066a Thanks @alvarosevilla95! - Support infallible Effect password providers with no service requirements, refreshed per PostgreSQL connection and schema dump.

  • #8241 8ef3fcb Thanks @tim-smart! - Decode timestamp and timestamptz values, including array elements, as Date instead of epoch milliseconds. Their encoders, including PgTypes.timestamp and PgTypes.timestamptz, accept either form. Precision remains milliseconds.

    Breaking changes

    • Numeric readers must call date.getTime() or restore numeric codecs with PgTypes.register or a client Registry passed as types.
    • infinity, -infinity and values outside the JavaScript Date range decode to an invalid Date. Numeric ±Infinity still encodes PostgreSQL's sentinels; encoding an invalid Date fails with PgTypes.CodecError.

    Date parameters bind as timestamptz. Inserting one into a timestamp column applies the session TimeZone. Use UTC or PgTypes.timestamp(value) to preserve its UTC fields. timestamptz round trips preserve the instant regardless of session timezone.

  • #8240 fd910d1 Thanks @tim-smart! - Decode unregistered OIDs as UTF-8 text so scalar enums return string labels.

    Other binary user-defined types, including enum arrays, may produce garbled text or fail UTF-8 decoding. Decode failures close the connection, failing its pending queries and discarding transactions and LISTEN subscriptions; the pool replaces it.

    Register scalar codecs with PgTypes.register. For arrays, use PgTypes.makeRegistry().register(elementOid, codec, { arrayOid }) and pass the registry as the client's types option.

  • Updated dependencies [c19c63f, 8cb0a4f, 8f420bb, 1393080, ccae354, 553c403, 45b5103, 77a5612, 1076170, f110af1, 0045152, 51d4a2f, 4d4c4e8, ccfe152, d30a0c8, 84fe64a, 49e4b37, 49e4b37, a2c4154, 23a58c0, feef90c, 755e863, 49e4b37, 9ad9891, 0beded0, 2940742, 63c1566]:

    • effect@4.0.0-rc.116

4.0.0-rc.115

Patch Changes

4.0.0-rc.114

Patch Changes

  • #8174 91abe38 Thanks @tim-smart! - Default TLS servername to the hostname for non-IP hosts during connection startup and cancellation, restoring connections to Postgres endpoints that require SNI. Preserve explicit SSL servername overrides.
  • Updated dependencies [3ff4952, 6d55555, 716e0c0, d4e4ad5, b1988f4, 482b7d7, 716e0c0, 9941e6d]:
    • effect@4.0.0-rc.114

4.0.0-rc.113

Patch Changes

4.0.0-rc.112

Patch Changes

4.0.0-rc.111

Patch Changes

4.0.0-rc.110

Patch Changes

4.0.0-rc.109

Patch Changes

4.0.0-rc.108

Patch Changes

4.0.0-beta.107

Patch Changes

4.0.0-beta.106

Patch Changes

4.0.0-beta.105

Patch Changes

4.0.0-beta.104

Patch Changes

4.0.0-beta.103

Patch Changes

4.0.0-beta.102

Patch Changes

4.0.0-beta.101

Patch Changes

4.0.0-beta.100

Patch Changes

4.0.0-beta.99

Patch Changes

4.0.0-beta.98

Patch Changes

4.0.0-beta.97

Patch Changes

  • Updated dependencies []:
    • effect@4.0.0-beta.97

4.0.0-beta.96

Patch Changes

4.0.0-beta.95

Patch Changes

4.0.0-beta.94

Patch Changes

4.0.0-beta.93

Patch Changes

4.0.0-beta.92

Patch Changes

  • Updated dependencies [affdc13]:
    • effect@4.0.0-beta.92

4.0.0-beta.91

Patch Changes

4.0.0-beta.90

Patch Changes

  • Updated dependencies [d237fdf]:
    • effect@4.0.0-beta.90

4.0.0-beta.89

Patch Changes

4.0.0-beta.88

Patch Changes

4.0.0-beta.87

Patch Changes

4.0.0-beta.86

Patch Changes

4.0.0-beta.85

Patch Changes

4.0.0-beta.84

Patch Changes

4.0.0-beta.83

Patch Changes

  • Updated dependencies [1f2e8ce]:
    • effect@4.0.0-beta.83

4.0.0-beta.82

Patch Changes

  • Updated dependencies [193690b]:
    • effect@4.0.0-beta.82

4.0.0-beta.81

Patch Changes

4.0.0-beta.80

Patch Changes

4.0.0-beta.79

Patch Changes

4.0.0-beta.78

Patch Changes

4.0.0-beta.77

Patch Changes

4.0.0-beta.76

Patch Changes

4.0.0-beta.75

Patch Changes

4.0.0-beta.74

Patch Changes

  • Updated dependencies [b1fc6a4]:
    • effect@4.0.0-beta.74

4.0.0-beta.73

Patch Changes

4.0.0-beta.72

Patch Changes

4.0.0-beta.71

Patch Changes

4.0.0-beta.70

Patch Changes

4.0.0-beta.69

Patch Changes

4.0.0-beta.68

Patch Changes

4.0.0-beta.67

Patch Changes

4.0.0-beta.66

Patch Changes

4.0.0-beta.65

Patch Changes

  • #2148 6f11454 Thanks @tim-smart! - Add UniqueViolation as a new SQL error reason. Supported unique constraint violations now classify as UniqueViolation instead of the broader ConstraintError reason.

    This covers PostgreSQL, PGlite, MySQL, MSSQL, and the shared SQLite classification used by the SQLite-family clients. UniqueViolation.constraint contains the best available constraint, index, or key identifier and falls back to exactly "unknown" when no reliable identifier is available.

  • Updated dependencies [6f11454]:

    • effect@4.0.0-beta.65

4.0.0-beta.64

Patch Changes

  • Updated dependencies [7d4877a]:
    • effect@4.0.0-beta.64

4.0.0-beta.63

Patch Changes

4.0.0-beta.62

Patch Changes

  • Updated dependencies [4ab4b90]:
    • effect@4.0.0-beta.62

4.0.0-beta.61

Patch Changes

4.0.0-beta.60

Patch Changes

4.0.0-beta.59

Patch Changes

  • Updated dependencies [56837ea]:
    • effect@4.0.0-beta.59

4.0.0-beta.58

Patch Changes

4.0.0-beta.57

Patch Changes

4.0.0-beta.56

Patch Changes

  • Updated dependencies []:
    • effect@4.0.0-beta.56

4.0.0-beta.55

Patch Changes

4.0.0-beta.54

Patch Changes

4.0.0-beta.53

Patch Changes

4.0.0-beta.52

Patch Changes

4.0.0-beta.51

Patch Changes

4.0.0-beta.50

Patch Changes

4.0.0-beta.49

Patch Changes

4.0.0-beta.48

Patch Changes

4.0.0-beta.47

Patch Changes

4.0.0-beta.46

Patch Changes

  • Updated dependencies [3a30b9e]:
    • effect@4.0.0-beta.46

4.0.0-beta.45

Patch Changes

  • Updated dependencies [5c3af6d]:
    • effect@4.0.0-beta.45

4.0.0-beta.44

Patch Changes

4.0.0-beta.43

Patch Changes

4.0.0-beta.42

Patch Changes

4.0.0-beta.41

Patch Changes

4.0.0-beta.40

Patch Changes

4.0.0-beta.39

Patch Changes

4.0.0-beta.38

Patch Changes

  • #1835 3a5b0ca Thanks @tim-smart! - Use pg_notify in PgClient.notify so channel and payload are sent through parameters instead of a NOTIFY statement string.

  • Updated dependencies [f4dbe5b, a71a607, 66a0494, 5ef7218, 472d260]:

    • effect@4.0.0-beta.38

4.0.0-beta.37

Patch Changes

  • #1812 f7a0b71 Thanks @tim-smart! - Consolidate the SqlError changes to the new reason-based shape across effect and the SQL drivers, classifying native failures into structured reasons with Unknown fallback where native codes are unavailable.

  • #1834 89ed5d6 Thanks @tim-smart! - Use a dedicated PostgreSQL client for LISTEN / UNLISTEN subscriptions instead of checking out a pooled connection for the listener lifecycle.

  • Updated dependencies [f7a0b71, 1e223c3, 53740f4, 8c7cf89, b6b81a9, 8f4c1f9, f2479f9, c919921, 7af90c2, f3be185]:

    • effect@4.0.0-beta.37

4.0.0-beta.36

Patch Changes

4.0.0-beta.35

Patch Changes

4.0.0-beta.34

Patch Changes

4.0.0-beta.33

Patch Changes

  • Updated dependencies [571447d]:
    • effect@4.0.0-beta.33

4.0.0-beta.32

Patch Changes

4.0.0-beta.31

Patch Changes

4.0.0-beta.30

Patch Changes

4.0.0-beta.29

Patch Changes

4.0.0-beta.28

Patch Changes

4.0.0-beta.27

Patch Changes

4.0.0-beta.26

Patch Changes

4.0.0-beta.25

Patch Changes

4.0.0-beta.24

Patch Changes

4.0.0-beta.23

Patch Changes

  • Updated dependencies [5c73c41]:
    • effect@4.0.0-beta.23

4.0.0-beta.22

Patch Changes

4.0.0-beta.21

Patch Changes

4.0.0-beta.20

Patch Changes

4.0.0-beta.19

Patch Changes

  • Updated dependencies []:
    • effect@4.0.0-beta.19

4.0.0-beta.18

Patch Changes

4.0.0-beta.17

Patch Changes

  • Updated dependencies [8f59c32]:
    • effect@4.0.0-beta.17

4.0.0-beta.16

Patch Changes

4.0.0-beta.15

Patch Changes

4.0.0-beta.14

Patch Changes

4.0.0-beta.13

Patch Changes

4.0.0-beta.12

Patch Changes

4.0.0-beta.11

Patch Changes

4.0.0-beta.10

Patch Changes

4.0.0-beta.9

Patch Changes

4.0.0-beta.8

Patch Changes

  • #1371 246e672 Thanks @IMax153! - Fix ChildProcess options type and implement PgMigrator

  • Updated dependencies [246e672, 807dec0]:

    • effect@4.0.0-beta.8

4.0.0-beta.7

Patch Changes

4.0.0-beta.6

Patch Changes

4.0.0-beta.5

Patch Changes

4.0.0-beta.4

Patch Changes

4.0.0-beta.3

Patch Changes

4.0.0-beta.2

Patch Changes

4.0.0-beta.1

Patch Changes

4.0.0-beta.0

Major Changes

Patch Changes

  • Updated dependencies [be642ab]:
    • effect@4.0.0-beta.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

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

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

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

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

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

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

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

0.34.16

Patch Changes

0.34.15

Patch Changes

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

0.34.12

Patch Changes

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

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

0.33.2

Patch Changes

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

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

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

0.30.1

Patch Changes

0.30.0

Patch Changes

0.29.4

Patch Changes

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

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

0.28.0

Patch Changes

0.27.1

Patch Changes

0.27.0

Patch Changes

0.26.2

Patch Changes

0.26.1

Patch Changes

0.26.0

Patch Changes

0.25.3

Patch Changes

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

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

0.23.7

Patch Changes

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

0.23.3

Patch Changes

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

0.23.2

Patch Changes

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

0.22.4

Patch Changes

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

0.21.11

Patch Changes

0.21.10

Patch Changes

0.21.9

Patch Changes

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

0.21.5

Patch Changes

0.21.4

Patch Changes

0.21.3

Patch Changes

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

0.21.2

Patch Changes

0.21.1

Patch Changes

0.21.0

Patch Changes

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

0.20.0

Patch Changes

0.19.5

Patch Changes

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

0.19.4

Patch Changes

0.19.3

Patch Changes

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

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

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

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

0.14.1

Patch Changes

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

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

0.11.3

Patch Changes

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

0.11.2

Patch Changes

0.11.1

Patch Changes

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

0.11.0

Patch Changes

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

0.10.0

Patch Changes

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

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 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:

    import * as Effect from "effect/Effect";
    import * as MysqlClient from "effect/unstable/sql/MysqlClient";
    import * as SqlClient from "effect/unstable/sql/SqlClient";
    
    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

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

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

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

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

0.5.0

Minor Changes

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

Patch Changes

0.4.27

Patch Changes

0.4.26

Patch Changes

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

0.4.22

Patch Changes

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

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

0.4.11

Patch Changes

  • Updated dependencies [a5b95b5, 5e29579]:
    • @effect/platform@0.58.11
    • @effect/sql@0.4.11

0.4.10

Patch Changes

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

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

0.3.11

Patch Changes

0.3.10

Patch Changes

0.3.9

Patch Changes

  • Updated dependencies [a67d602]:
    • @effect/platform@0.55.7
    • @effect/sql@0.3.8

0.3.8

Patch Changes

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

0.2.17

Patch Changes

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

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:

    import { Effect } from "effect";
    import * as Sql from "effect/unstable/sql";
    
    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.onDialect api:

    import { Effect } from "effect";
    import * as Sql from "effect/unstable/sql";
    
    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

0.1.17

Patch Changes

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

0.1.13

Patch Changes

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

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

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

0.1.0

Minor Changes

Patch Changes