Search: yugabyte intern

Using the PostgreSQL Recursive CTE – Part One

Using the PostgreSQL Recursive CTE – Part One

Traversing an employee hierarchy

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

Read more

YSQL Development Fundamentals Training Recap – Feb 25, 2021

YSQL Development Fundamentals Training Recap – Feb 25, 2021

Yesterday we delivered our free “YSQL Development Fundamentals” community training and certification class. A special thanks to Karen Tamrazyan and a variety of Meetup groups for hosting and helping promote the event! If you weren’t able to make it, here’s what you missed…

Course Content

In this 90 min training aimed at beginner and intermediate SQL developers, we’ll covered the following topics:

  • YugabyteDB Architecture Review
  • Local 3-Node Installation
  • Basic Administration
  • Installing a Sample Database
  • Configuring Graphical SQL Development Tools
  • Working with the YSQL Shell
  • Schemas and Databases
  • Table Management
  • Data Types
  • Data Manipulation
  • Queries
  • Joins

We worked through almost 80 exercises that showed how developers can immediately leverage their PostgreSQL knowledge and apply it to YugabyteDB.

Read more

Applying Legal Design Thinking to the Software Development Process

Applying Legal Design Thinking to the Software Development Process

Legal compliance for technology startups can be overwhelming. GDPR, CCPA, HIPAA, SOX, PCI, NIST — with so many long acronyms covering so many different legal frameworks, it can be hard to keep track of what applies to what, and become easy to fall into the trap of thinking you’ll deal with it later. But that can result in big technical and legal debt down the road that inhibits a startup’s growth very quickly. There is a middle road — applying legal design thinking from the beginning allows companies to innovate while at the same time choosing a legal framework for their software that meets customer needs and ensures business success.

Read more

Distributed SQL Summit Asia 2021 Recap and Highlights

Distributed SQL Summit Asia 2021 Recap and Highlights

We had a great time at Distributed SQL Summit Asia and hope you did, too! Now that the event has ended, we wanted to take a moment and recap some of the highlights, as well as provide you with links to playbacks of the presentations.

DSS Asia 2021 by the Numbers

We held the Asia Summit from 10am – 3pm India Standard Time for three days (Jan 20 –

Read more

Distributed SQL Summit Recap: The Future of Data Infrastructure, A Telco Roundtable

Distributed SQL Summit Recap: The Future of Data Infrastructure, A Telco Roundtable

At the Distributed SQL Summit 2020, leaders and architects from notable enterprises in the telco industry joined us for a panel to discuss the future of software development, including important trends such as IoT, 5G, Edge, cloud, and their impact on data infrastructure. Our panelists included Puneet Devadiga from Rakuten Mobile, Hale Donertasli from Rakuten Mobile, Kartik Rallapalli from TracFone Wireless, and James Taylor from Comcast; the panel was moderated by Yugabyte’s head of Data Engineering,

Read more

The Schedule Is Now Live for Distributed SQL Summit Asia!

The Schedule Is Now Live for Distributed SQL Summit Asia!

Last month, we officially announced the Distributed SQL Summit Asia virtual event, taking place Jan 20 – 22 in India Standard Time.

We have an amazing lineup of talks by industry-leading speakers from innovative companies including: Astronomer, Buoyant, CAST AI, Hasura, Infosys, InfraCloud, Last9.io, Liquibase, Manetu, Virtusa, VMware, Weaveworks, Wipro, and Xignite.

You can find all the talks here on the schedule, and summarized below.

While current events are full of lowlights,

Read more

Distributed SQL Tips and Tricks – Oct 16, 2020

Distributed SQL Tips and Tricks – Oct 16, 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:

How to use joins in UPDATE statements

Sometimes,

Read more

The Distributed Database Behind Twitter

The Distributed Database Behind Twitter

Twitter is one of the world’s favorite places for people and brands to connect online. Powering a global service that helps people share everything from breaking news and entertainment to sports, politics, and everyday interests takes infrastructure that can adapt and evolve over time.

In his talk at the 2020 Distributed SQL Summit, Mehrdad Nurolahzade, engineer on the real-time infrastructure team at Twitter, walks us through the distributed database behind Twitter,

Read more

Use Retool to Quickly Build Distributed SQL and React Apps

Use Retool to Quickly Build Distributed SQL and React Apps

Retool is a next generation WSIWYG SaaS-based tool that enables you to quickly build React applications for internal consumption from your existing data sources using a variety of pre-built “building blocks.” Developers can choose from over 58 drag and drop components and combine them with custom JavaScript to create applications that can be securely deployed on-premise or hosted environments like Heroku. Retool supports over 30 native integrations including PostgreSQL, GraphQL, AWS S3, and Cassandra.

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free