pgadapter

0.21.0 (2023-06-07)

Features

• support cursors and foreign data wrapper (#797) (5ee2200)
• support setting the well-known client (#837) (045156c)

Documentation

• document how to connect to IntelliJ (#870) (35ec68f)

0.20.0 (2023-05-26)

Features

• add support for Ruby ActiveRecord (#749) (442e45c)
• detect relation not found errors (#834) (8d21df7)

Bug Fixes

• latency benchmark should use random local port (#843) (e15711f)

0.19.1 (2023-05-17)

Performance Improvements

• add latency comparision test (#790) (9be6b09)
• bundle Ready response with the rest (#806) (af98023)

0.19.0 (2023-05-05)

Features

• automatically add LIMIT clause (#792) (c382392)
• emulate pg_class and related tables (#766) (e602750)
• support savepoints (#796) (570fb96)

Documentation

• add sample for Cloud Run (#770) (751030d)
• document psycopg3 and SQLAlchemy 2.x support (#801) (fe73c63)

0.18.4 (2023-04-15)

Documentation

• recommend psycopg3 over psycopg2 (#742) (8aec410)

Dependencies

• bump JDBC driver to 42.6.0 (#747) (9bdb5f4)
• bump Spanner client lib version to 6.40.0 (#781) (419c833)
• pin the SQLAlchemy 2.x version used for tests (#759) (2a78f4c)

0.18.3 (2023-03-20)

Bug Fixes

• close SpannerPool at shutdown (#734) (d67a75f)

Documentation

• add psycopg3 sample with embedded PGAdapter (#733) (0250b21)
• add sample application for JDBC (#592) (c1a5635)
• document SQLAlchemy 2.x experimental support (#728) (6a40e9e)
• pgx sample using embedded PGAdapter (#732) (7c95781)

0.18.2 (2023-03-17)

Bug Fixes

• add support for getting arrays using npgsql (#722) (6988ad1)

Documentation

• add documentation and sample for GKE sidecar proxy (#718) (f4246bd), closes #701

0.18.1 (2023-03-09)

Bug Fixes

• the JDBC reWriteBatchedInserts=true option could cause errors in DML batches (#713) (36bff88)

0.18.0 (2023-03-06)

Features

• support arrays in copy operations (#690) (ac624e5)

Bug Fixes

• add pg_sequence and pg_sequences views (#700) (2ad990a)
• allow unquoted text values in arrays (#706) (b09f540)
• support information_schema.sequences (#708) (c043c46), closes #705
• timestamp arrays should use timestamptz_array OID (#691) (52cac8c)

0.17.0 (2023-02-24)

Features

• allow timestamp param values in brackets (#661) (f84235f)
• support ARRAY typed query parameters (#653) (104c200)

Bug Fixes

• support 'localtime' as a timezone (#625) (f9973f1)

Performance Improvements

• do not create a transaction for describe+execute (#660) (e3856ce)

Documentation

• add example for using stale reads (#643) (a8022c2)
• added jsonb in the sample (#647) (01785fa)
• emphasize that internal debugging is for internal use (#612) (005b7f0)

Dependencies

• add dependabot for ecosystem tests and samples (#675) (3a6ee4e)
• bump node-postgres to 8.9.0 (#663) (ee436f0)
• setup dependabot for npgsql tests (#668) (e85d38c)

0.16.0 (2023-02-05)

Features

• allow unsupported OIDs as param types (#604) (5e9f95a)
• make table and function replacements client-aware (#605) (ad49e99)

Bug Fixes

• binary copy header should be included in first data message (#609) (2fbf89e)
• copy to for a query would fail with a column list (#616) (16f030e)
• CopyResponse did not return correct column format (#633) (dc0d482)
• csv copy header was repeated for each row (#619) (622c49a)
• empty copy from stdin statements could be unresponsive (#617) (c576124)
• empty partitions could skip binary copy header (#615) (e7dd650)
• show statements failed in pgx (#629) (734f521)
• support end-of-data record in COPY (#602) (8b705e8)

Dependencies

• update Spanner client to 6.35.1 (#607) (0c607c7)

Documentation

• document pgbench usage (#603) (5a62bf6)
• document unix domain sockets with Docker (#622) (e4e41f7)

0.15.0 (2023-01-18)

Features

• allow decimal values to be used for int params (#564) (3aecf34)
• auto-detect npgsql (#559) (e1e8526)
• support more timestamp values for query parameters (#565) (5905213)
• support TRUNCATE (#533) (293aaaa)
• support VACUUM as a no-op (#532) (20dc062)

Bug Fixes

• potential session leak when using prepared statements in autocommit mode (#591) (185dcd5)
• support (#586) (c91fe66), closes #581

Performance Improvements

• keep converted bytes (#584) (1486bc4)

0.14.1 (2023-01-06)

Bug Fixes

• enable gracefully stopping Docker container (#554) (80e9c8b)

Performance Improvements

• reduce conversion time for timestamptz, date and bytea (#572) (bb73990)

0.14.0 (2022-12-16)

Features

• support Connection API options in connection string (#542) (6247412)
• support force_autocommit (#541) (52fba80)

Documentation

• added sample application model for Django (#539) (72b173a)

0.13.1 (2022-12-09)

Bug Fixes

• allow start ddl batch / run batch in one query string (#529) (2ffb290)
• always return timestamp in microsecond precision (#513) (e385dd3)

Documentation

• document node-postgres support (#489) (61c6459)

0.13.0 (2022-12-07)

Features

• accept UUID as a parameter value (#518) (46941ab)
• support 'select version()' and similar (#495) (fbd16ec)
• Support Describe message for DDL statements and other no-result statements (#501) (cb616d8)
• support DML RETURNING clause (#498) (c1d7e4e)
• support more than 50 query parameters (#527) (9fca9ba)
• use session timezone to format timestamps (#470) (d84564d)

Bug Fixes

• client side results were not returned (#493) (5e9e85e)
• pg_catalog tables were not replaced for information_schema queries (#494) (e1f02fe)

Documentation

• [WIP] Hibernate sample (#373) (7125c91)
• document Liquibase Pilot Support (#485) (745089f)
• document Support for gorm (#469) (0b962af)
• remove limitation for RETURNING and generated columns for gorm (#526) (0420e99)

0.12.0 (2022-11-02)

Features

• reimplement COPY parser to support more options and legacy syntax (#410) (b8a38dd)
• replace sequences query with empty table (#366) (170dc7c)

Bug Fixes

• DDL batch errors halfway were not propagated (#444) (fc6efa4), closes #443

0.11.0 (2022-10-28)

Features

• add setting for copy_commit_priority (#426) (6d23184)

Bug Fixes

• close buffers used by Converter after use (#434) (4b0b500)
• memory leak caused by ConnectionHandler not removed from map (#437) (6ef7240)
• use copy commit timeout for all RPCs (#427) (0381a0c)

Documentation

• document support for psycopg2 (#395) (676ddcd)

0.10.1 (2022-10-21)

Performance Improvements

• use low latency TCP options (#414) (684506a)

Documentation

• add FAQ entries for Docker (#411) (cdfb76a)

0.10.0 (2022-10-14)

Features

• add experimental support for node-postgres (#362) (9e3e952)
• added support for Django specific statement (#382) (1137ed1)

Performance Improvements

• copy binary can write directly to a byte buffer (#385) (18ddbdd)
• do not create a new parser for each column (#383) (5352f79)
• write converted values directly to a byte buffer (#384) (bec1657)

Documentation

• document how to set a statement timeout (#390) (2db00f9)