https://www.datanami.com/2021/10/12/google-cloud-gives-spanner-a-postgresql-interface/ [datanami-l] Language Flags Translation Disclaimer [Search this site ][Search] * About * Resources * Subscribe Follow Datanami: Menu * Home * COVID-19 * Features + Articles + This Just In + People to Watch o 2021 o 2020 o 2019 o 2018 o 2017 + Readers' Choice Awards o 2021 o 2020 o 2019 o 2018 o 2017 o 2016 + Decade of Datanami * Sectors + Academia + Biosciences + Financial Services + Government + Healthcare + Manufacturing + Retail + Science + Other * Applications + Artificial Intelligence + Complex Event Processing + Data Mining + Enterprise Analytics + Predictive Analytics + Research Analytics + Visualization * Technologies + Cloud + Frameworks + Middleware + Network + Processors + Storage + Systems * Vendors * Job Bank * Events + Events + Advanced Scale Forum + HPC + AI Wall St October 12, 2021 Google Cloud Gives Spanner a PostgreSQL Interface Alex Woodie [Spanner_logo_plus_Postgres-300x152] Google Cloud has developed a PostgreSQL interface for Spanner, its globally distributed relational database. The new interface, which is in preview and which is being officially unveiled tomorrow at Google Cloud's Next '21 conference, is designed to lower the barrier of entry for a uniquely scalable database that supports some of the biggest workloads on the planet. Up until 2021, Spanner has mostly been used by larger companies that not only have the need for a database with 99.999% availability, but also can afford to pay the Spanner fees, which started at $650 per month. That's not a trivial amount, and it reflects the considerable amount of hardware infrastructure required to support a system that is capable of running one billions queries per second, Google Cloud said. Remember that Google Cloud uses super-sensitive atomic clocks and GPS systems to deliver the transactional guarantees necessary for a globally distributed relational database, which is no small feat. This is part of the reason why Spanner use has been somewhat restricted, at least up until now. But Google Cloud clearly is looking to take the shackles off Spanner and bolster its usage. One way it's doing that is by eliminating cost as a barrier. It did that earlier this year when it announced that customers can get started on just a 10% slice of Spanner for just $65 per month, with the ability to scale up the Spanner deployment incrementally to support full petabyte-scale workloads. [edge_globe_shutterstock_TAW4-300x200] (TAW4/Shutterstock) Now, with the revelation that Google Cloud is delivering a PostgreSQL-compatible interface for Spanner, it's working eliminate the need to rewrite your database application to support Spanner as a barrier, too. Andi Gutmans, the vice president and general manager of databases at Google Cloud, explained what drove Google Cloud to open up Spanner in an exclusive conversation with Datanami. "While we've been using ANSI SQL-and of course SQL is very familiar to developers-the whole tooling ecosystem, framework ecosystem [for Spanner] we had to develop," Gutmans said. "So if you want to use like Hibernate or other tools, we had to develop all the adapters. And obviously we're only a limited size team we can't do everything. "So what we [said] is why don't we go and support a PostgreSQL interface," Gutmans continued. "Basically, make it very, very easy for people with existing tools, existing skillsets, to come and use Spanner." Google Cloud is delivering PostgreSQL support two different ways. For starters, it has started to add native support for PostgreSQL data types and the PostgreSQL grammar on Spanner itself. Spanner doesn't support all of the data types and grammar that PostgreSQL offers, but the plan is to add more support over time. The other method involves deployment of a "sidecar" next to the Google Cloud Compute instance that runs Spanner (it's not an actual sidecar, just a virtual one). The sidecar essentially translates the wire protocol from the PostgreSQL to Spanner. [Google_cloud_shutterstock_-DANIEL-CONSTAN] (DANIEL CONSTANTE/Shutterstock) "For customers who want to use the Postgres wire protocol, that don't want to make changes, we actually have a sidecar they can deploy on the client side," Gutmans said. "That way, customers get the best of both worlds. They can still get to use tools like PostgresSQL but they're still getting the five-nines availability of Spanner, the global network routing benefits and so on." The new $65/month entry fee and the capability to scale to petabyte-size deployments has already paid dividends in spurring Spanner interest, and the hope is the new PostgreSQL interface will generate even more interest, Gutmans said. "Theres' been a huge spike in new users coming in trying out PostgreSQL, and we haven't even GA'd yet," he said. Gaming companies are among the outfits that could benefit the most. There are many smaller gaming companies that don't have the resources for a large scale-out infrastructure, which can hobble their ability to scale to meet surging demand. "With granular instance sizing, they can basically launch a game with almost no cost," he said. "But if it hit overnight success, they're basically future-proof. They know that they're going to be able to scale to whatever size they need to and scale up with zero downtime." Google Cloud Next '21 is taking place today through Thursday. For other company announcements, see "Google Cloud Widens Its Big Data Reach at Next '21." Google Cloud CEO Thomas Kurian and Sundar Pichai, the CEO of Google and parent company Alphabet, will be kicking things off with a keynote this morning at 9 a.m. PT. See cloud.withgoogle.com/next for more information. Related Items: One on One with Google Cloud Product Director Irina Farooq Google Cloud Tackles Data Unification with New Offerings Who's Winning the Cloud Database War Tags: 99.999 availability, Andi Gutmans, ANSI SQL, Google Cloud Next '21, postgresql, Spanner Join the discussion 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 Comment] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] Only registered users may comment. Register using the form below. * Check off newsletters you would like to receive* + [ ] HPCwire + [ ] EnterpriseTech + [*] Datanami + [ ] Technology Conferences & Events + [ ] Advanced Computing Job Bank + [ ] Technology Product Showcase * Email* [ ] * Name* [ ] First [ ] Last * Organization* [ ] * Job Function* [Technology: CIO/CTO/CSO ] * Industry* [Aerospace ] * Country* [United States ] * City* [ ] * State* [Alabama ] * Province* [Alberta ] * + [*] Please check here to receive valuable email offers from Datanami on behalf of our select partners. [Submit] * This Just In * Most Read October 12, 2021 * Trifacta and Google Cloud Deliver New Cloud Data Warehouse Optimizations * PrivaceraCloud 4.0 Enables Governed Data Sharing Across the Open Cloud * Hitachi Vantara Enhances Storage Portfolio, New Enterprise and Midrange Solutions * Accenture to Acquire BRIDGEi2i for Data Science, ML and AI-Powered Insights * Informatica Announces Joint Strategic Cloud Data Management Partnership with Google Cloud * Denodo Joins AWS ISV Accelerate Program * New $24M AI Cancer Project OPTIMA Launches October 11, 2021 * Splunk Advances Future of Observability with OpenTelemetry Donations * Tsecond Launches BRYCK, a Solution to Capture, Process, Move and Store Up to a Petabyte of Data * IBM and Deloitte Launch New AI Offering to Unlock Business Insights in Hybrid Cloud Environments October 8, 2021 * Gretel.ai Closes $50 Million Series B Round for Privacy Engineering as a Service * Elastic Showcases How Customers Solve Data Challenges at ElasticON Global Virtual Conference October 7, 2021 * IDC Survey: Managed Service Providers Face Numerous Challenges in Managed Cloud Services Market * OpsCruise Introduces New Free Forever Plan to Empower DevOps * Infoworks v5.0 Automates Cloud Migration and Enterprise Data Operations * Scality Positioned in the Leaders Quadrant of the Magic Quadrant for Distributed File Systems and Object Storage * BigBear.ai Awarded Data Analytics Contract by USCYBERCOM * Cisco Launches First Global Hybrid Work Index * Samsung Introduces Industry's First Open-Source Software Solution for CXL Memory Platform * Alteryx Announces Acquisition of Hyper Anna * More This Just In... Most Read Features * One on One with Google Cloud Product Director Irina Farooq * What Is Data Science? A Turing Award Winner Shares His View * Big Data File Formats Demystified * Google Cloud Gives Spanner a PostgreSQL Interface * SambaNova Brings Custom Silicon To Bear on High-End AI Workloads * We're In the Moneyball 3.0 Era. Here's What It Means for Live Sports * What's the Difference Between AI, ML, Deep Learning, and Active Learning? * Who's Winning In the $17B AIOps and Observability Market * How the Coronavirus Response Is Aided by Analytics * Rethinking Education in an AI-First World * More Features... Most Read News In Brief * LinkedIn Open Sources Tech Behind 10,000-Node Hadoop Cluster * Data and AI Salaries Continue Upward March, O'Reilly Says * Data Prep Still Dominates Data Scientists' Time, Survey Finds * Bigeye Observes $45 Million in Funding * Gartner Shuffles the Technology Deck with Latest 'Hype Cycle' Report * Why Is SAS Going Public? * Feature Stores Emerging as Must-Have Tech for Machine Learning * Logistics Operators Look to Data, Technology for Advantage * An Interactive Analytics Whiteboard for COVID Times * Sisu Nabs $62M to Grow Data Analytics Biz * More News In Brief... Most Read This Just In * TIBCO NOW 2021 Showcases Limitless Power of Data * Toloka Launches Data Research Grants, Announces First Eight Recipients * Transaction Processing Performance Council (TPC) Launches an Artificial Intelligence Benchmark (TPCx-AI) * MariaDB Announces SIS Provider Campus Cloud Services Migration to MariaDB SkySQL * Aporia Launches Self-Serve Machine Learning Platform Open to Public * Kinetica Fuses Streaming and Contextual Analysis At Scale * Snowflake Launches Financial Services Data Cloud * BriefCam Introduces Video Analytics Enabled on Deep Learning Cameras from Axis Communications * OneTrust Enhances First-Party Data Solution to Strengthen Holistic Consent and Preference Management Platform * NetApp to Acquire CloudCheckr and Expand its Spot by NetApp CloudOps Platform * More This Just In... Sponsored Partner Content * Streamline Lakehouse Analytics with Matillion and Databricks SQL * Close the Information Gap: How to Succeed at Analytics in the Cloud * Data Lake vs. Cloud Data Warehouse * Who wins the hybrid cloud? * The Best Techniques for Data Integration in 2021 * Onboard data AND coffee! * The object store of choice for VMware's Tanzu initiative Solution Providers [altair_90x] [CData_90x4] [cockroach-] [GoodData_9] [h2o_90x45] [harbr_90x4] [KX_black_9] [kyvos-logo] [matillion_] [MinIO_90x4] [onetrust_9] [redis_90x4] [TigerGraph] [trifacta_9] Tabor Network HPCwire EnterpriseAI HPCwire Japan Sponsored Whitepapers * Close the Information Gap: How to Succeed at Analytics in the Cloud * Guide to Self-Service Data Preparation * View the Whitepaper Library Sponsored Multimedia [210722MatillionWebca] Goodbye 3 V's, Hello 3 D's: Tackling Distributed, Diverse and Dynamic Data No Comments [210416OracleWe] Speed Innovation with performance gains of up to 42% on the most powerful HPC Cloud No Comments [210302Pavilion] LIVE EVENT: Accelerating GPU Based Applications No Comments [210120WorldQua] Proxies During a Pandemic: Using Data Analytics to "See Around Corners" No Comments [210104VaradaWe] Breaking the Data Warehouse Paradigm: What do your workloads really need? No Comments [200902QumuloWebinar_] Accelerating Research Innovation with Qumulo's File Data Platform No Comments < > Contributors Alex Woodie Alex Woodie Managing Editor Oliver Peckham Oliver Peckham Editor Steve Conway Steve Conway Contributing Editor Tiffany Trader Tiffany Trader Editorial Director John Russell John Russell Contributing Editor Todd Weiss Todd R. Weiss Contributing Editor Featured Events 1. CISO London October 19 London United Kingdom 2. CDAO Fall Boston [0871-CDAO-Fall-B] October 27 - October 28 3. AWS re:Invent 2021 [AWS_reinvent_2021_lo] November 29 - December 3 4. Data Governance & Information Quality Conference (DGIQ) [DGIQ_logo_150px] December 6 - December 10 San Diego CA United States 5. The Connected Worker Summit [Datanami-CW-Hous] February 7, 2022 - February 9, 2022 Houston TX United States 6. Building Business Capability [bbc21_120x60] June 26, 2022 - June 30, 2022 Hollywood FL United States View More... (c) 2021 Datanami. All Rights Reserved. A Tabor Communications Publication * Back to Top * Contact * Privacy Policy * Cookie Policy * About Datanami * Update Subscription Preferences * California Consumers Datanami This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More Privacy & Cookies Policy Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience. Necessary [*] Necessary Always Enabled Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information. Non-necessary [*] Non-necessary Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website. SAVE & ACCEPT