With necessity being the mother of invention, PlanetScale co-founder Jitan Vaidya needed a way to scale the MySQL databases that were running many of YouTube's operational systems. They developed a piece of middleware that would sit between the database client and logically shard the database in the underlying storage engine. That open source project became Vitess, and it was the technology around which PlanetScale, a company with $25 million in venture backing, was founded. The company, which was founded in 2018, began with offering commercial support for Vitess, and over the past six months, has introduced its cloud transaction database-as-a-service, PlanetScale DB. The core technology, Vitess, is intended to enable SQL databases to scale out in a manner similar to NoSQL platforms like MongoDB, relying heavily on sharding.
Roughly six months after AWS's Outposts hybrid cloud platform outposts hit general release, RDS databases, including MySQL and PostgreSQL are now generally available on it. That makes RDS on Outposts one of the first vendor-managed Database-as-a-Service (DBaaS) offerings that can run inside the customer's data center. For the record, Oracle is the only other database provider to have a similar offering, with Exadata Cloud at Customer. On initial release, RDS on AWS Outposts will support MySQL 8.0.17 and PostgreSQL 12.2. AWS Outposts is a hybrid cloud platform that takes a very familiar form: the classic turnkey system, where the vendor provides bundled hardware and software, and manages the provisioning, database setup, patching, and backups. In essence, it is a piece of the AWS cloud that runs inside the customer's data center.
For nearly 30 years, PostgreSQL (a.k.a., Postgres) has arguably been the most common SQL open source database that you have never heard of. Call it the Zelig of databases, its technology either sat behind or acted as the starting point behind an array of nearly a dozen commercial database offerings from EnterpriseDB to Redshift, Greenplum, Netezza, CockroachDB and a host of others. And PostgreSQL has distinguished lineage as one of the brainchilds of Turing Award winner and database legend Dr. Michael Stonebraker, who started the PostgreSQL project based on the lessons learned from his previous database venture, Ingres. But now there are commercial products that put PostgreSQL out front and center. EnterpriseDB opened the Pandora's Box roughly a decade ago with a commercially supported platform designed as an Oracle replacement.
Write SQL queries to explore and analyze databases with MySQL Workbench Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently Analyze data across multiple tables with powerful MySQL JOIN statements Solve practical hands-on assignments and real-world business use cases Master unique tips, tools and case studies that you won't find anywhere else Get LIFETIME access to resource files, quizzes, assignments, and expert support Master unique tips, tools and case studies that you won't find anywhere else "Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!" "I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"