puter/zopu-code
1
0
Fork 0
Code Issues 2 Pull Requests Actions Packages Projects Releases Wiki Activity
Files
feat/slice5-complete
zopu-code/repos/effect/packages/sql/pg/CHANGELOG.md

207 KiB
Raw Permalink Blame History

@effect/sql-pg

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

0.45.0

Patch Changes

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

0.41.14

Patch Changes

0.41.13

Patch Changes

0.41.12

Patch Changes

0.41.11

Patch Changes

0.41.10

Patch Changes

0.41.9

Patch Changes

0.41.8

Patch Changes

0.41.7

Patch Changes

0.41.6

Patch Changes

0.41.5

Patch Changes

0.41.4

Patch Changes

0.41.3

Patch Changes

0.41.2

Patch Changes

0.41.1

Patch Changes

0.41.0

Patch Changes

0.40.0

Patch Changes

0.39.2

Patch Changes

0.39.1

Patch Changes

0.39.0

Patch Changes

0.38.12

Patch Changes

0.38.11

Patch Changes

0.38.10

Patch Changes

0.38.9

Patch Changes

0.38.8

Patch Changes

0.38.7

Patch Changes

0.38.6

Patch Changes

0.38.5

Patch Changes

0.38.4

Patch Changes

0.38.3

Patch Changes

0.38.2

Patch Changes

0.38.1

Patch Changes

0.38.0

Patch Changes

0.37.0

Patch Changes

0.36.8

Patch Changes

0.36.7

Patch Changes

0.36.6

Patch Changes

0.36.5

Patch Changes

0.36.4

Patch Changes

0.36.3

Patch Changes

0.36.2

Patch Changes

0.36.1

Patch Changes

0.36.0

Patch Changes

0.35.1

Patch Changes

0.35.0

Patch Changes

0.34.21

Patch Changes

0.34.20

Patch Changes

0.34.19

Patch Changes

0.34.18

Patch Changes

0.34.17

Patch Changes

0.34.16

Patch Changes

0.34.15

Patch Changes

0.34.14

Patch Changes

0.34.13

Patch Changes

0.34.12

Patch Changes

0.34.11

Patch Changes

0.34.10

Patch Changes

0.34.9

Patch Changes

0.34.8

Patch Changes

0.34.7

Patch Changes

0.34.6

Patch Changes

0.34.5

Patch Changes

0.34.4

Patch Changes

0.34.3

Patch Changes

0.34.2

Patch Changes

0.34.1

Patch Changes

0.34.0

Minor Changes

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

Patch Changes

0.33.4

Patch Changes

0.33.3

Patch Changes

0.33.2

Patch Changes

0.33.1

Patch Changes

0.33.0

Patch Changes

0.32.1

Patch Changes

0.32.0

Patch Changes

0.31.7

Patch Changes

0.31.6

Patch Changes

0.31.5

Patch Changes

0.31.4

Patch Changes

0.31.3

Patch Changes

0.31.2

Patch Changes

0.31.1

Patch Changes

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

0.29.2

Patch Changes

0.29.1

Patch Changes

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

0.25.1

Patch Changes

0.25.0

Patch Changes

0.24.4

Patch Changes

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

0.24.0

Patch Changes

0.23.7

Patch Changes

0.23.6

Patch Changes

0.23.5

Patch Changes

0.23.4

Patch Changes

0.23.3

Patch Changes

0.23.2

Patch Changes

0.23.1

Patch Changes

0.23.0

Patch Changes

0.22.4

Patch Changes

0.22.3

Patch Changes

0.22.2

Patch Changes

0.22.1

Patch Changes

0.22.0

Minor Changes

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

Patch Changes

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

0.21.7

Patch Changes

0.21.6

Patch Changes

0.21.5

Patch Changes

0.21.4

Patch Changes

0.21.3

Patch Changes

0.21.2

Patch Changes

0.21.1

Patch Changes

0.21.0

Patch Changes

0.20.0

Patch Changes

0.19.5

Patch Changes

0.19.4

Patch Changes

0.19.3

Patch Changes

0.19.2

Patch Changes

0.19.1

Patch Changes

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

0.18.10

Patch Changes

0.18.9

Patch Changes

0.18.8

Patch Changes

0.18.7

Patch Changes

0.18.6

Patch Changes

0.18.5

Patch Changes

0.18.4

Patch Changes

0.18.3

Patch Changes

0.18.2

Patch Changes

0.18.1

Patch Changes

0.18.0

Patch Changes

0.17.0

Minor Changes

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

Patch Changes

0.16.6

Patch Changes

0.16.5

Patch Changes

0.16.4

Patch Changes

0.16.3

Patch Changes

0.16.2

Patch Changes

0.16.1

Patch Changes

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

0.15.0

Patch Changes

0.14.1

Patch Changes

0.14.0

Patch Changes

0.13.4

Patch Changes

0.13.3

Patch Changes

0.13.2

Patch Changes

0.13.1

Patch Changes

0.13.0

Patch Changes

0.12.6

Patch Changes

0.12.5

Patch Changes

0.12.4

Patch Changes

0.12.3

Patch Changes

0.12.2

Patch Changes

0.12.1

Patch Changes

0.12.0

Patch Changes

0.11.3

Patch Changes

0.11.2

Patch Changes

0.11.1

Patch Changes

0.11.0

Patch Changes

0.10.4

Patch Changes

0.10.3

Patch Changes

0.10.2

Patch Changes

0.10.1

Patch Changes

0.10.0

Patch Changes

0.9.7

Patch Changes

0.9.6

Patch Changes

0.9.5

Patch Changes

0.9.4

Patch Changes

0.9.3

Patch Changes

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

0.8.6

Patch Changes

0.8.5

Patch Changes

0.8.4

Patch Changes

0.8.3

Patch Changes

0.8.2

Patch Changes

0.8.1

Patch Changes

0.8.0

Patch Changes

0.7.0

Patch Changes

0.6.3

Patch Changes

0.6.2

Patch Changes

0.6.1

Patch Changes

0.6.0

Patch Changes

0.5.3

Patch Changes

0.5.2

Patch Changes

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

0.4.24

Patch Changes

0.4.23

Patch Changes

0.4.22

Patch Changes

0.4.21

Patch Changes

0.4.20

Patch Changes

0.4.19

Patch Changes

0.4.18

Patch Changes

0.4.17

Patch Changes

0.4.16

Patch Changes

0.4.15

Patch Changes

0.4.14

Patch Changes

0.4.13

Patch Changes

0.4.12

Patch Changes

0.4.11

Patch Changes

0.4.10

Patch Changes

0.4.9

Patch Changes

0.4.8

Patch Changes

0.4.7

Patch Changes

0.4.6

Patch Changes

0.4.5

Patch Changes

0.4.4

Patch Changes

0.4.3

Patch Changes

0.4.2

Patch Changes

0.4.1

Patch Changes

0.4.0

Minor Changes

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

Patch Changes

0.3.19

Patch Changes

0.3.18

Patch Changes

0.3.17

Patch Changes

0.3.16

Patch Changes

0.3.15

Patch Changes

0.3.14

Patch Changes

0.3.13

Patch Changes

0.3.12

Patch Changes

0.3.11

Patch Changes

0.3.10

Patch Changes

0.3.9

Patch Changes

0.3.8

Patch Changes

0.3.7

Patch Changes

0.3.6

Patch Changes

0.3.5

Patch Changes

0.3.4

Patch Changes

0.3.3

Patch Changes

  • Updated dependencies [3e86ced]:
    • @effect/sql@0.3.2

0.3.2

Patch Changes

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

0.2.15

Patch Changes

0.2.14

Patch Changes

0.2.13

Patch Changes

0.2.12

Patch Changes

0.2.11

Patch Changes

0.2.10

Patch Changes

0.2.9

Patch Changes

0.2.8

Patch Changes

0.2.7

Patch Changes

0.2.6

Patch Changes

0.2.5

Patch Changes

0.2.4

Patch Changes

0.2.3

Patch Changes

0.2.2

Patch Changes

0.2.1

Patch Changes

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

0.1.15

Patch Changes

0.1.14

Patch Changes

0.1.13

Patch Changes

0.1.12

Patch Changes

0.1.11

Patch Changes

0.1.10

Patch Changes

0.1.9

Patch Changes

0.1.8

Patch Changes

0.1.7

Patch Changes

0.1.6

Patch Changes

0.1.5

Patch Changes

0.1.4

Patch Changes

0.1.3

Patch Changes

0.1.2

Patch Changes

0.1.1

Patch Changes

0.1.0

Minor Changes

Patch Changes