Connect with us

Tech

The Google CloudSpanner dialect for SQLAlchemy is generally available

Published

on

 


Google Cloud recently announced the general availability of the Spanner dialect that allows SQLAlchemy applications to run on distributed SQL database management and storage services.

Used by companies such as DropBox and Reddit, SQLAlchemy is a Python SQL toolkit that enables application developers to use SQL. Known as the Object-Relational Mapper (ORM). It is a component that provides a data mapper pattern that allows you to isolate classes and map them to a database to keep the underlying SQL and object-relational details transparent.

The CloudSpanner dialect for SQLAlchemy, built on top of the Spanner DB API, is an open source project that supports migration via Alembic. Shanika Kuruppu, Google’s senior software engineer, warns:

The migration script can generate many DDL statements, and executing each statement individually will slow down the migration. Therefore, it is highly recommended to use the Alembic batch context feature to pack DDL statements into groups of statements.

Cloud Spanner supports interleaved tables, generated columns, query hints, and old reads. All read-only transactions default to strong reads, but you can use explicit timestamp bindings to perform old reads. To improve performance, Kuruppu suggests:

Use explicit connections to reuse connections across multiple queries. You can also use an implicit connection, but this is not recommended because the dialect requires you to establish a new connection to the database for each Connection.execute () call.

Among the restrictions when running SQLAlchemy in Cloud Spanner, distributed databases do not support the creation of unique constraints, do not allow DDL statements in transactions, and do not support mutations. All features and limitations, including the lack of auto-increment IDs, are described on the GitHub page.

Cloud providers have also announced the general availability of the Ruby Active Record Adapter for Google Cloud Spanner, an ORM library bundled with Ruby on Rails. Pritam Shah, Google’s Director of Engineering, explains the importance of supporting different ORM frameworks:

I want to democratize Spanner-I want it to be available to all developers, not just large companies. We have released the CloudSpannerAdapter for ActiveRecord and the Spanner dialect for SQLAlchemy for Ruby and Python developers.

The Python client for CloudSpanner and SQLAlchemy 1.3 documentation details how to use SQLAlchemy to query and modify Google Spanner data.

Sources

1/ https://Google.com/

2/ https://www.infoq.com/news/2022/01/cloud-spanner-sqlalchemy/

The mention sources can contact us to remove/changing this article

What Are The Main Benefits Of Comparing Car Insurance Quotes Online

LOS ANGELES, CA / ACCESSWIRE / June 24, 2020, / Compare-autoinsurance.Org has launched a new blog post that presents the main benefits of comparing multiple car insurance quotes. For more info and free online quotes, please visit https://compare-autoinsurance.Org/the-advantages-of-comparing-prices-with-car-insurance-quotes-online/ The modern society has numerous technological advantages. One important advantage is the speed at which information is sent and received. With the help of the internet, the shopping habits of many persons have drastically changed. The car insurance industry hasn't remained untouched by these changes. On the internet, drivers can compare insurance prices and find out which sellers have the best offers. View photos The advantages of comparing online car insurance quotes are the following: Online quotes can be obtained from anywhere and at any time. Unlike physical insurance agencies, websites don't have a specific schedule and they are available at any time. Drivers that have busy working schedules, can compare quotes from anywhere and at any time, even at midnight. Multiple choices. Almost all insurance providers, no matter if they are well-known brands or just local insurers, have an online presence. Online quotes will allow policyholders the chance to discover multiple insurance companies and check their prices. Drivers are no longer required to get quotes from just a few known insurance companies. Also, local and regional insurers can provide lower insurance rates for the same services. Accurate insurance estimates. Online quotes can only be accurate if the customers provide accurate and real info about their car models and driving history. Lying about past driving incidents can make the price estimates to be lower, but when dealing with an insurance company lying to them is useless. Usually, insurance companies will do research about a potential customer before granting him coverage. Online quotes can be sorted easily. Although drivers are recommended to not choose a policy just based on its price, drivers can easily sort quotes by insurance price. Using brokerage websites will allow drivers to get quotes from multiple insurers, thus making the comparison faster and easier. For additional info, money-saving tips, and free car insurance quotes, visit https://compare-autoinsurance.Org/ Compare-autoinsurance.Org is an online provider of life, home, health, and auto insurance quotes. This website is unique because it does not simply stick to one kind of insurance provider, but brings the clients the best deals from many different online insurance carriers. In this way, clients have access to offers from multiple carriers all in one place: this website. On this site, customers have access to quotes for insurance plans from various agencies, such as local or nationwide agencies, brand names insurance companies, etc. "Online quotes can easily help drivers obtain better car insurance deals. All they have to do is to complete an online form with accurate and real info, then compare prices", said Russell Rabichev, Marketing Director of Internet Marketing Company. CONTACT: Company Name: Internet Marketing CompanyPerson for contact Name: Gurgu CPhone Number: (818) 359-3898Email: [email protected]: https://compare-autoinsurance.Org/ SOURCE: Compare-autoinsurance.Org View source version on accesswire.Com:https://www.Accesswire.Com/595055/What-Are-The-Main-Benefits-Of-Comparing-Car-Insurance-Quotes-Online View photos

ExBUlletin

to request, modification Contact us at Here or [email protected]