Babelfish：讓 PostgreSQL 可以吃 Microsoft SQL Server 的協定
source link: https://blog.gslin.org/archives/2021/11/01/10402/babelfish%ef%bc%9a%e8%ae%93-postgresql-%e5%8f%af%e4%bb%a5%e5%90%83-microsoft-sql-server-%e7%9a%84%e5%8d%94%e5%ae%9a/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Babelfish：讓 PostgreSQL 可以吃 Microsoft SQL Server 的協定
看到「Goodbye Microsoft SQL Server, Hello Babelfish」這篇，AWS 對 Aurora (PostgreSQL) 推出了可以吃 Microsoft SQL Server 協定的 Babelfish：
Today, we are making Babelfish for Aurora PostgreSQL available. Babelfish allows Amazon Aurora PostgreSQL-Compatible Edition to understand the SQL Server wire protocol.
查了一下資料發現是去年年底的時候發表的：「Want more PostgreSQL? You just might like Babelfish」，不過當時沒注意到這東西，大概是因為是 preview 的關係：
We are open sourcing Babelfish in 2021. Until then, you can use Babelfish on Amazon Aurora in a preview to see how it works and to get a sense for whether this is the right approach for you.
用起來不知道怎樣，但感覺很值得注意，目前雖然沒用到 Microsoft SQL Server 的東西，但以後遇到可以考慮看看...
除了在 AWS 上用以外，也可以自己到 GitHub 上拉 patch 回來上：「babelfish-for-postgresql」。
話說回來，PostgreSQL 被 AWS 拿來用在好多地方啊，先前大家也猜是 DocumentDB 後面是 PostgreSQL (參考「大家在猜 Amazon DocumentDB 的底層是不是 PostgreSQL...」這篇)，不知道之後會不會想要跟 Oracle 的律師打架...
Related
Amazon RDS 的 RI 也支援彈性計價了
AWS 宣佈 RDS 的 RI 也支援彈性計價了：「Amazon RDS Reserved Instances Offer Instance Size Flexibility」。 也就是說跟 EC2 的 RI 方式切齊，買 db.m4.2xlarge 的 RI 後，可以用在兩台 db.m4.xlarge 上： For example, let’s say you purchased a db.m4.2xlarge MySQL RI in US East (N. Virginia). The discounted rate of this RI can automatically apply to 2…
October 12, 2017In "AWS"
Amazon Aurora (MySQL) 提供 Parallel Query 讓人申請使用
AWS 宣佈了 Amazon Aurora (MySQL) 支援 Parallel Query：「Amazon Aurora Parallel Query is Available for Preview」。 這邊提到的 Parallel Query 比較像是 Amazon Athena，直接把單一 Query 打散到多台機器上跑： Amazon Aurora Parallel Query improves the performance of large analytic queries by pushing processing down to the Aurora storage layer, spreading processing across hundreds of nodes. 也就是說，這算是單一…
February 3, 2018In "AWS"
AWS Database Migration Service
AWS 正式向所有使用者開放「AWS Database Migration Service」了：「AWS Database Migration Service」。 AWS 把前置作業 (setup & initial backup) 與 replication 的部份都包好，讓使用者可以很輕鬆的轉移。 支援的來源資料庫種類包括了這五種： Supported database sources include: (1) Oracle, (2) SQL Server, (3) MySQL, (4) Amazon Aurora and (5) PostgreSQL. All sources are supported on-premises, in EC2, and RDS except Amazon Aurora which is available…
March 17, 2016In "AWS"
Author Gea-Suan LinPosted on November 1, 2021Categories AWS, Cloud, Computer, Database, Murmuring, Network, PostgreSQL, Service, SoftwareTags amazon, aurora, aws, babelfish, cloud, compatible, database, db, layer, microsoft, open, postgresql, protocol, rdbms, rds, server, service, source, sql, wire Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
Comment
Name *
Email *
Website
Notify me of follow-up comments by email.
Notify me of new posts by email.
Post navigation
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK