Welcome back to our tips and tricks blog series! With October officially a wrap, I have the pleasure of recapping some distributed SQL questions from around the Internet. There was no Tips and Tricks edition for September as the Yugabyte team was focused on our 2021 Distributed SQL Summit. If you did not have a chance to check it out, you can view the sessions on-demand.
As always,
…
At Distributed SQL Summit 2021, we presented a workshop on how to build an application using the YugabyteDB Spark Connector and YugabyteDB to deliver business outcomes for our customers.
The YugabyteDB Spark Connector brings together the best of breed technologies Apache Spark — an industry-leading, distributed computing engine — with YugabyteDB, a modern, cloud-native distributed SQL database. This connector allows customers to seamlessly and natively read from, perform complex ETL,
…
In this blog post, you’ll learn how to implement a timer for multi-statement operations using SQL with YugabyteDB or PostgreSQL. These tools are commonly used for various tasks, but their native timing feature only times individual SQL statements and doesn’t support end-to-end timing or output to spool files.
A few weeks ago, Yugabyte CEO Bill Cook and I had the pleasure of speaking with Paul Gaffney, the CTO and Chief Supply Chain Officer of Kohl’s during a virtual fireside chat as part of our Catalysts of Change series. Paul is a visionary tech leader with an extensive track record of driving technology change and innovation at companies like Dick’s Sporting Goods, The Home Depot, and AAA of Northern California,
…
Back in 2016 I started at Nutanix, fresh after finishing my graduate studies. This was barely a couple of weeks after two of Nutanix’s employees, Karthik and Kannan, left to start Yugabyte with Mikhail Bautin. They were still the subject of a few watercooler chats at Nutanix, mainly because of their bold decision to enter the database market, one that is definitely not known for being easy.
It became apparent to me why databases are hard.
…
At the Distributed SQL Summit, Mahesh Tyagarajan – VP Engineering, Kroger – presented the talk “Technology Strategy and Transformation”. The talk focused around the technology infrastructure, current challenges, and the need faced by Kroger to transform its technology stack.
Kroger is the largest supermarket in the US, 2nd largest retailer in the US,
…
5G is backed by a cloud native, service-based architecture. Hale from Rakuten Mobile describes the 5G data challenges and the solutions needed to fully realize its potential.
Discover the seamless compatibility between PostgreSQL and YugabyteDB. Learn how the installation commands overlap, including connecting to databases, creating users, schemas, and executing files from the SQL shell.
Getting the total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database) is a useful SQL technique to have in your toolkit. This blog post will guide you to obtain per-table row counts of all tables in PostgreSQL and YugabyteDB. This can serve as a first sanity check after migrating an application with pre-existing data from PostgreSQL to YugabyteDB.
This blog post also outlines how to get the following row counts broken down per table in a schema,
…
We are excited to announce the availability of yugabyted, a native server that acts as a parent server across the YB-TServer and YB-Master servers. yugabyted’s immediate goal is to remove the day-1 learning curve that can be daunting for new users.
