はてなブックマーク

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Benjamin Dicken | September 9, 2024 What is a B-tree?The B-tree plays a foundational role in many pieces of software, especially database management systems (DBMS). MySQL, Postgres, MongoDB, Dynamo, and many others rely on B-trees to perform efficient data lookups via indexes. By the time you finish t

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Mike Coutermarsh | April 4, 2024 Engineering team velocity is one of our top priorities at PlanetScale, both for our own teams and for all developers using the tools we build. One of our early goals when building PlanetScale was to make the absolute best schema change process for engineering teams. We

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Brian Morrison II | March 19, 2024 Universally Unique Identifiers, also known as UUIDs, are designed to allow developers to generate unique IDs in a way that guarantees uniqueness without knowledge of other systems. These are especially useful in a distributed architecture, where you have a number of

By Sam Lambert | March 6, 2024 PlanetScale is an infrastructure company. Our service is mission critical, and we value reliability above all else. Reliability isn’t just an uptime percentage on your status page. It means your business is self-sustaining. Every unprofitable company has a date in the future where it could disappear. With an ever changing world and economy, this is a situation fraugh

Welcome! MySQL for Developers is PlanetScale’s free MySQL course that teaches you schema basics, indexing, querying, and beyond. This intermediate MySQL course is appropriate for both developers just getting started with MySQL and those who need a refresher. The course has been created with usability and application in mind. Everything you learn in this course can be taken and applied to your own

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Mike Coutermarsh | March 29, 2022 When we were first building PlanetScale’s API, we needed to figure out what type of identifier we’d be using. We knew that we wanted to avoid using integer IDs so that we wouldn’t reveal the count of records in all our tables. The common solution to this problem is us

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Matt Robenolt | January 4, 2023 Over here at PlanetScale, we offer you a MySQL database. As a part of this offering, it is critical that we offer you a MySQL protocol-compatible interface to access. This enables using mysql-client as well as any MySQL-compatible driver for your favorite language. But

And yes, I know what you’re thinking. “This query is bananas, man. I would never run this in production!”. I know! I agree. The query is not particularly hard to understand, but if you try running it in a standard relational database, you’ll see that as soon as you have a few thousand star rows, the execution time of the query balloons out of control. Although this query uses the relational model

I am excited to reveal our latest product, PlanetScale Boost, which makes your application’s queries up to 1,000× faster in just a few clicks. Building responsive, modern software often requires painful, tedious, error-prone caching logic to hide the latency of an expensive SQL query. Instead, PlanetScale Boost makes the queries you choose faster, with no additional logic and no infrastructure to

MySQL gave us the JSON data type back in mid-2015 with the release of MySQL 5.7.8. Since then, it has been used as a way to escape rigid column definitions and store JSON documents of all shapes and sizes: audit logs, configuration settings, 3rd party payloads, user-defined fields, and more. Although MySQL gives us functions for reading and writing JSON data, you’ll quickly discover something that

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Jonah Berquist | September 1, 2022 Knowing your database can scale provides great peace of mind. We built PlanetScale on top of Vitess so that we could harness its ability to massively scale. One of the core strengths in our ability to scale is horizontal sharding. To demonstrate the power of horizont

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Taylor Barnett, Matt Robenolt | August 18, 2022 Today we are introducing the PlanetScale serverless driver for JavaScript, a Fetch API-compatible database driver. This new driver and infrastructure update brings you: The ability to store and query data in PlanetScale from environments such as Cloudfla

Want to learn more about Vitess, horizontal sharding, or Enterprise options? Talk to Solutions By Mike Coutermarsh | August 16, 2022 We’d like to introduce FastPage, a new gem for ActiveRecord that applies the MySQL “deferred join” optimization to your offset/limit queries. Here is a slow pagination query in Rails: Post.all.order(created_at: :desc).limit(25).offset(100) # Post Load (1228.7ms) SELE

It is a common database pattern to increment an INT column when an event happens, such as a download or page view. You can go far with this pattern until bursts of these types of events happen in parallel and you experience contention on a single row. When multiple transactions are trying to update the counter, you are essentially forcing these transactions to run serially, which is bad for concur

If you deploy your applications in regions around the globe and need to keep database read latency low, you will want to physically have a database nearby. With PlanetScale Portals, you can now create read-only regions to support your globally distributed applications and better serve your users worldwide. Put your data where your users and applications arePortals allow you to read data from regio

Go 1.18 is here, and with it, the first release of the long-awaited implementation of Generics is finally ready for production usage. Generics are a frequently requested feature that has been highly contentious throughout the Go community. On the one side, vocal detractors worry about the added complexity. They fear the inescapable evolution of Go towards either a verbose and Enterprisey Java-lite

Bad migrations happen every day and data loss can be devastating. PlanetScale’s new schema revert feature gives you the power to revert changes after a schema migration with no downtime and zero data loss. What is it?Have you ever made a schema change, like changing a column’s data type or dropping a table, that broke your production application causing unplanned downtime, or even worse, a full-sc

How to manage your relational data without formal foreign key constraints in your schema. OverviewA foreign key is a logical association of rows between two tables, in a parent-child relationship. A row in a "parent" table may be referenced by one or more rows in a "child" table. A foreign key typically suggests how you should JOIN tables in most queries. A table can also refer to itself, as a spe

It has been an incredible six months since we released our product in beta. From the outset, we focused on creating a platform that would delight developers, built on top of the only open source database proven at hyper scale, Vitess. For years, our technology has allowed companies like Square, GitHub, and YouTube to scale their database and, in turn, their businesses. Our mission is to bring this

Scale, performance, and reliabilityScale, performance, and reliabilitypowered by Vitess The MySQL database platform built for scalePlanetScale is built on Vitess and unlocks performance, scalability, and cost optimization for hyperscale databases through horizontal sharding.