Planetscale · Blogs

Blogs listings from Planetscale on TechiSeek. 272 public listings.

• Automating cherry-picks between OSS and private forks (Planetscale)
  At Planet Scale, we encountered this issue firsthand while managing our private modifications alongside the continual evolution of the open…
• Database DevOps (Planetscale)
  Learn how PlanetScale enables databases to seamlessly fit into the DevOps lifecycle.
• PlanetScale is now available on the Google Cloud Marketplace (Planetscale)
  We’re excited to announce that PlanetScale is now available on the Google Cloud Marketplace.
• Amazon Aurora Pricing: The many surprising costs of running an Aurora database (Planetscale)
  Amazon describes Aurora as a scalable database that's simple to manage, but if you've ever gone through the "Create database" wizard, you k…
• MySQL scaling made easy (Planetscale)
  Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist.
• RLS sounds great until it isn't (Planetscale)
  PostgreSQL's Row Level Security sounds like a clean way to enforce access control at the database layer, but the foot-guns, pooling incompa…
• The operational relational schema paradigm (Planetscale)
  An exploration of the current landscape of schema change methodology and what the future should look like.
• Anatomy of a Throttler, part 1 (Planetscale)
  Learn about some design considerations for implementing a database throttler.
• Building PlanetScale with PlanetScale (Planetscale)
  How PlanetScale uses database branching and non-blocking schema changes to build PlanetScale.
• Introducing PlanetScale Portals: Read-only regions (Planetscale)
  Put your data where your users and applications are.
• IO devices and latency (Planetscale)
  Take an interactive journey through the history of IO devices, and learn how IO device latency affects performance.
• Introducing PlanetScale Managed on AWS and GCP (Planetscale)
  Deploy PlanetScale in your AWS or GCP account with our Enterprise PlanetScale Managed plan.
• MariaDB vs. MySQL (Planetscale)
  Learn the main differences between MariaDB and MySQL, why you might choose one over the other, scaling options, and how Vitess fits into th…
• Postgres backups under the hood (Planetscale)
  With backups being such a vital part of keeping your data safe, how do they actually work?
• Webhook security: a hands-on guide (Planetscale)
  Learn what went into building PlanetScale webhooks from a security perspective. This article covers SSRF, webhook validation, DDoS, and mor…
• Ruby on Rails: 3 tips for deleting data at scale (Planetscale)
  Learn how to delete data in large Rails apps with destroy_async delete destroy and scheduled cron jobs.
• Increase developer productivity with Database DevOps (Planetscale)
  Explore the evolution of “Database DevOps” and its impact on development workflows in this tech talk.
• MySQL Integers: INT BIGINT and more (Planetscale)
  Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are store…
• Building data pipelines with Vitess (Planetscale)
  Learn the basics of Change Data Capture (CDC) and how to leverage Vitess VStream API to build data pipelines.
• Introducing Prisma’s Data Platform PlanetScale integration (Planetscale)
  Warning The Prisma Data Platform integration was updated in September 2022. The information in this blog post is no longer up to date.
• Solving N+1’s with Rails `exists?` queries (Planetscale)
  Learn how to solve your Rails applications N+1’s caused by `exists?` queries.
• Safely making database schema changes (Planetscale)
  How to prevent schema changes from being scary with database best practices and PlanetScale.
• The lifecycle of a sharded Postgres query (Planetscale)
  Follow a SQL query through the router, across four Postgres shards, and back.
• Laravel’s safety mechanisms (Planetscale)
  A comprehensive overview of Laravel’s many safety features that can help you prevent painful mistakes.
• Temporal workflows at scale: Part 2 (Planetscale)
  Learn how PlanetScale simplifies the process of running Temporal in production by looking at how our customer runs heavy production workloa…
• The dangers of Postgres subtransactions (Planetscale)
  Subtransactions can slow down your entire PostgreSQL server and break your high availability strategy by keeping new read replicas from acc…
• Generated Hash Columns in MySQL (Planetscale)
  Creating generated hash columns in MySQL for faster strict equality lookups.
• What is a Neki router? (Planetscale)
  A Neki router gives applications a Postgres connection to one database while planning and coordinating queries across the shards behind it.
• Introducing Database Traffic Control (Planetscale)
  Enforce real-time limits on your Postgres query traffic to protect your database from runaway queries and unexpected load spikes.
• Introducing the schemadiff command line tool (Planetscale)
  We are releasing schemadiff, an open source command line tool to generate diffs between two MySQL databases.
• Gated Deployments: addressing the complexity of schema deployments at scale (Planetscale)
  We just introduced a new feature Gated Deployments that gives you more control over when your schema changes deploy.
• Achieving data consistency with the consistent lookup Vindex (Planetscale)
  What are Vindexes Vitess uses Vindexes (short for Vitess Index) to associate rows in a table with a designated address known as Keyspace ID.
• The Problem with Using a UUID Primary Key in MySQL (Planetscale)
  Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.
• Extract, load, and transform your data with PlanetScale Connect (Planetscale)
  Use PlanetScale Connect to easily perform ELT (Extract, Load, Transform) actions on your data to fulfill your application needs.
• What is MySQL partitioning? (Planetscale)
  Learn the basics of MySQL partitioning, including partitioning with range, list, and key strategies, as well as how partitioning relates to…
• B-trees and database indexes (Planetscale)
  Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
• Transparency in benchmarking (Planetscale)
  Transparent database benchmarks help customers make better decisions and push vendors to build better products.
• Announcing foreign key constraints support (Planetscale)
  You can now use foreign key constraints in PlanetScale databases.
• Announcing Vitess 14 (Planetscale)
  We are pleased to announce the general availability of Vitess 14. In this new release, major improvements have been made in several areas o…
• Pulling back the curtain: the new database overview page (Planetscale)
  Learn about the latest updates we made to our database overview page: load balancers, shards, and more.
• Introducing Lead: TIN-compatible full-text search for CI (Planetscale)
  Yesterday, we announced TIN, a fast, full-featured search index extension for Postgres. We got a question from several readers and customer…
• Designing Neki for performance (Planetscale)
  How Neki only decodes the parts of a PostgreSQL result the router actually needs.
• On benchmarking (Planetscale)
  Done wrong it is very misleading, and unfortunately it is frequently done wrong.
• How product design works at PlanetScale (Planetscale)
  Learn about the lightweight and highly collaborative process our product design team follows to ship quickly at PlanetScale.
• Grouping and aggregations on Vitess (Planetscale)
  Vitess is a database proxy that creates an illusion of a single database when in reality the query is sent to multiple MySQL instances.
• Zero downtime migrations at petabyte scale (Planetscale)
  Data migrations are a critical part of the database lifecycle, and are sometimes necessary for version upgrades, sharding, or moving to a n…
• OAuth applications are now available to everyone (Planetscale)
  You can now build integrations that seamlessly authenticate with PlanetScale and allow management access to your users’ organizations and d…
• Keeping a Postgres queue healthy (Planetscale)
  Dead tuples from high-churn job queues can silently degrade your Postgres database when vacuum falls behind—especially alongside competing…
• Announcing Vitess 16 (Planetscale)
  Vitess 16 is now generally available with updates to VDiff v2, VTOrc, MySQL compatibility, and more.
• Database branching: three-way merge for schema changes (Planetscale)
  Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches.