Databases Archives - Page 27 of 37

Databases Distributed SQL Google Cloud Platform How To PostgreSQL YugabyteDB 2.1

February 27, 2020

Getting Started with Distributed SQL on Yugabyte Cloud

With the release of YugabyteDB 2.1 earlier this week, we introduced many exciting new features: performance optimizations, 2DC and read replica support, and more. We also announced that Yugabyte Cloud is now officially in Beta! In this blog post we’ll show you how to quickly get up and running with a YugabyteDB cluster on Yugabyte Cloud, build a sample database, and connect to it with JetBrain’s DataGrip database administration tool.

…

Databases Distributed SQL GraphQL Open Source PostgreSQL YugabyteDB 2.1

February 25, 2020

By Sid Choudhury

YugabyteDB 2.1 is GA: Scaling New Heights with Distributed SQL

Team Yugabyte is excited to announce the general availability of YugabyteDB 2.1! The highlight of this release is that Yugabyte SQL (YSQL), YugabyteDB’s PostgreSQL-compatible API, has not only improved performance 10x since the 2.0 release in September 2019 but is also production ready for multiple geo-distributed deployment scenarios. For those of you who are new to distributed SQL, YugabyteDB is a Google Spanner-inspired, cloud native distributed SQL database that is 100% open source.

…

Databases Distributed SQL Open Source Performance Benchmarks PostgreSQL YugabyteDB 2.1

February 25, 2020

By Karthik Ranganathan

Achieving 10x Better Distributed SQL Performance in YugabyteDB 2.1

When starting the YugabyteDB project, our founding thesis was to build a high-performance distributed SQL database for the cloud native era. Achieving high performance will always remain an ongoing initiative, especially when additional optimizations are required to support new features and new use cases. We are excited that the current YugabyteDB 2.1 release has a number of improvements that make Yugabyte SQL’s performance 10x better on average than the previous 2.0 release (from September 2019).

…

Distributed SQL How To PostgreSQL

February 24, 2020

By Jimmy Guerrero

Getting Started with JetBrains DataGrip on a Distributed SQL Database

If you’re a database developer, you know the time saving value of an IDE in helping you create and navigate database objects, plus query and edit data from single UI. DataGrip from JetBrains is a well-rounded, visual database tool that supports almost 20 SQL and NoSQL databases from a single interface. And because YugabyteDB is PostgreSQL compatible, getting DataGrip to work with a distributed SQL database is relatively simple. In this post we’ll show you how to get DataGrip connected to a YugabyteDB cluster,

…

Databases Distributed SQL Google Spanner How To PostgreSQL

February 21, 2020

By Dorian Hoxha

Distributed SQL Tips and Tricks – Feb 21, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

When should I use JSON vs JSONB data types?

…

Databases Distributed SQL How To Spring

February 19, 2020

By Nikhil Chandrappa

Developing Reactive Microservices with Spring Data and Distributed SQL

In 2016 in the keynote presentation of Spring One Platform, Juergen Hoeller announced Spring WebFlux, one of the most highly anticipated projects being worked on by the Spring Team due to the performance gains that reactive streams promised for web controllers. Subsequently, with Spring Framework 5.0, Spring Reactive MVC went GA along with the release of WebFlux API, making the reactive stream based web controller mainstream.

Fast-forward to 2020, Spring WebFlux MVC has gained wide adoption in cloud native applications,

…

Databases Distributed SQL PostgreSQL

February 18, 2020

By Bryn Llewellyn

Natural versus Surrogate Primary Keys in a Distributed SQL Database

There’s a subtle, but critical, difference between the two notions business-unique key and primary key in a relational database. For example, in a “users” table, the “user_id” could be the primary key while the “email_address” (which must be not null and unique) could be the business-unique key. The columns that implement each notion may or may not coincide. This post shows that,

…

Community News Databases Distributed SQL How To PostgreSQL

February 14, 2020

By Jimmy Guerrero

Distributed SQL Tips and Tricks – Feb 14, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub or Stackoverflow. Ok, let’s dive right in: