SQLite FDW 2.3.0 released

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.3.0 released
Date: 2023-01-20 11:07:26
Message-ID: 167421284684.2667300.4342435812650762059@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

We have just released version 2.3.0 of the Foreign Data Wrapper for SQLite.

This release can work with PostgreSQL 11, 12, 13, 14 and 15.
This release improves following items (from 2.1.1):

- Support PosgreSQL 15.0
- Support push down CASE expressions

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 Software Engineering & 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

Browse pgsql-announce by date

  From Date Subject
Next Message Toshiba via PostgreSQL Announce 2023-01-20 11:07:49 Parquet S3 FDW 1.0.0 released
Previous Message Toshiba via PostgreSQL Announce 2023-01-20 11:07:14 High-Performance SQL Cluster Engine PGSpider 3.0.0 released