[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: SQLite FDW 2.4.0 released
From: Toshiba via PostgreSQL Announce <announce-noreply () postgresql ! org>
Date: 2023-09-28 21:15:23
Message-ID: 169593572372.3727338.2454492517131690098 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>SQLite FDW 2.4.0 released</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<h1 style="color: #000; font-family: sans-serif; line-height: 1.4; margin: 0; \
margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: center">SQLite \
FDW 2.4.0 released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">We have just released version 2.4.0 of the Foreign Data Wrapper \
for SQLite.</p> <p style="font-family: sans-serif; font-size: 14px; font-weight: \
normal; margin: 0; margin-bottom: 15px">This release can work with PostgreSQL 12, 13, \
14, 15 and 16.<br/> This release improves following items (from 2.3.0): </p>
<ul style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: \
5px">Support PosgreSQL 16.0</li> <li style="list-style-position: inside; margin-left: \
5px">Add text transformations for pg DB encoding</li> <li style="list-style-position: \
inside; margin-left: 5px">Add updatable option on different levels</li> <li \
style="list-style-position: inside; margin-left: 5px">Improve error messages</li> <li \
style="list-style-position: inside; margin-left: 5px">Refactor README.md </li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">The FDW supports following key features :</p> <ul \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: \
5px">SELECT, INSERT, UPDATE and DELETE of foreign tables</li> <li \
style="list-style-position: inside; margin-left: 5px">WHERE clauses is pushed \
down</li> <li style="list-style-position: inside; margin-left: 5px">Aggregate is \
pushed down</li> <li style="list-style-position: inside; margin-left: 5px">ORDER BY \
is pushed down</li> <li style="list-style-position: inside; margin-left: 5px">JOIN is \
pushed down (LEFT,RIGHT,INNER)</li> <li style="list-style-position: inside; \
margin-left: 5px">LIMIT and OFFSET are pushed down (*when all tables queried are \
fdw)</li> <li style="list-style-position: inside; margin-left: 5px">Transactions</li>
</ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">This is developed by Toshiba Digital Innovation Technology \
Center.<br/> Please see the repository for details.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Source repository : <a \
href="https://github.com/pgspider/sqlite_fdw" style="color: #3498db; text-decoration: \
underline">https://github.com/pgspider/sqlite_fdw</a></p> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: \
15px">Best Regards,<br/> TAIGA Katayama</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from Toshiba. It was delivered on \
their behalf by the PostgreSQL project. Any questions about the content of the \
message should be sent to Toshiba.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic