| From: | Toshiba via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
|---|---|
| To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
| Subject: | SQLite FDW 2.4.0 released |
| Date: | 2023-09-28 21:15:23 |
| Message-ID: | 169593572372.3727338.2454492517131690098@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
We have just released version 2.4.0 of the Foreign Data Wrapper for SQLite.
This release can work with PostgreSQL 12, 13, 14, 15 and 16.
This release improves following items (from 2.3.0):
- Support PosgreSQL 16.0
- Add text transformations for pg DB encoding
- Add updatable option on different levels
- Improve error messages
- Refactor README.md
The FDW supports following key features :
- SELECT, INSERT, UPDATE and DELETE of foreign tables
- WHERE clauses is pushed down
- Aggregate is pushed down
- ORDER BY is pushed down
- JOIN is pushed down (LEFT,RIGHT,INNER)
- LIMIT and OFFSET are pushed down (*when all tables queried are fdw)
- Transactions
This is developed by Toshiba Digital Innovation Technology Center.
Please see the repository for details.
Source repository : [https://github.com/pgspider/sqlite_fdw](https://github.com/pgspider/sqlite_fdw)
Best Regards,
TAIGA Katayama
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Citus Data via PostgreSQL Announce | 2023-10-06 18:43:16 | Citus 12.1 Released! |
| Previous Message | Synthesized via PostgreSQL Announce | 2023-09-27 09:41:53 | Synthesized TDK. Populating Test Environments with Production-Like Data |