PlanetScale
@PlanetScale
Followers
27,162
Following
124
Media
261
Statuses
1,354
The modern MySQL platform. Discord: Status: Support: @planetscalehelp
Joined February 2018
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
オーロラ
• 492250 Tweets
Joost
• 334472 Tweets
#الهلال_الحزم
• 85607 Tweets
Fulham
• 81859 Tweets
#SixTONESANN
• 78237 Tweets
Man City
• 62845 Tweets
自分これ
• 61859 Tweets
Gvardiol
• 54232 Tweets
Ali Koç
• 47760 Tweets
Dremo
• 41197 Tweets
太陽フレアのせい
• 39467 Tweets
Burnley
• 33746 Tweets
SEE YOU NEXT MONTH JIN
• 31685 Tweets
دوري روشن
• 30597 Tweets
الدوري الاقوي
• 28769 Tweets
Granada
• 25210 Tweets
روشن السعودي
• 24591 Tweets
Luton
• 22315 Tweets
Haley
• 22196 Tweets
やまとなでしこ
• 14763 Tweets
الدوري التاريخي
• 14541 Tweets
#الهلال_بطل_الدوري_التاريخي
• 11927 Tweets
Last Seen Profiles
Pinned Tweet
🌐 Introducing global replica credentials 🌐
You can now automatically route reads to the nearest replica using a single replica credential.
2
7
71
🌐 We just released the PlanetScale serverless driver for JavaScript.
With this Fetch API-compatible driver, you can now use PlanetScale with platforms that require HTTP connections like
@Cloudflare
Workers,
@vercel
, and
@Netlify
Edge Functions.
24
138
816
UUIDs as primary keys can be bad for database performance:
19
76
555
The database for developers is here.
Live database branches.
Non-blocking schema changes.
No headaches, just scale.
Try it out now.
17
91
552
🎉 Introducing schema recommendations
You will now automatically receive recommendations to improve database performance, reduce memory and storage, and improve your schema based on production traffic.
28
40
548
The database for developers is coming. Sign up for our beta waitlist now.
5
35
201
PlanetScale is now GA.
From the first code push to GA in less than a year, we are determined to give you a serverless database platform that is powerful, easy to use, and has impeccable DX — and we're just getting started.
9
52
361
Introducing PlanetScale Boost ✨
Make your application's queries up to 1,000x faster in just a few clicks, without having to write and maintain painful, tedious, and error-prone caching logic:
13
68
332
🚀 MySQL for Developers video course is live 🚀
This free, 64 lesson course is perfect for developers who want to strengthen MySQL skills in a way that is relevant to everyday work.
Watch it now here!
6
58
305
🚀 The Database Scaling course is now available!
We've crafted a 22 lesson video course to teach you techniques for scaling your MySQL database, allowing it to handle massive demand.
Learn about tuning, caching, replication, sharding, and more:
9
50
278
5M concurrent users, 800k req/sec - and completely reliant on the cache to serve data. These were the early days at Instagram.
Rick Branson, Dir of Eng at PlanetScale & one of IG's 1st engineers, tells all in this Tech Talk.
🍿 Full video available now:
4
28
244
Put your data where your users and applications are!
Today, we’re launching PlanetScale Portals.
Learn how PlanetScale Portals lets you create read-only regions in seconds with just the click of a button to better serve your users worldwide.
4
39
238
🔥 Just shipped a huge update to your database overview page in the PlanetScale dashboard! We're pulling back the curtain to show you all of the power that comes with your PlanetScale database:
- Load balancers & availability zones
- Primary + replicas
- Shards
- And more
8
27
226
✅ No cold starts
✅ Unlimited connections
✅ 10PB storage limit
✅ Millions of QPS
✅ Pay by usage
PlanetScale is the best database for serverless workloads.
3
6
206
We're bringing vectors to MySQL! You can soon use PlanetScale in your AI/ML applications with vector search and storage.
Sign up using the link below to be first in line for the private beta:
11
30
203
New course launching tomorrow!
MySQL for Developers, a free 64 lesson video course, will be available tomorrow. You'll learn everything from setting up an efficient schema to improving query performance.
Sign up here to be notified when we're live:
4
27
197
It's been an incredible Launch Week! Over the past five days, we've launched:
- The Future Database principles
- 4 brand new features (details below)
- The Future Database Podcast
Here's a recap of everything we shipped this week. 🧵 (1/8)
4
25
185
💡 Did you know that in MySQL, you can store IP addresses as numbers instead of strings? Storing IP addresses as numbers is beneficial because it makes them easily sortable and more compact.
Learn how to accomplish this with a single function:
11
24
177
PlanetScale now has a web console. Query your database directly from the UI.
6
13
177
Vitess 18 is live! Some notable updates in this latest version release:
- Foreign key constraint support is here!
- Vitess query planner improvements
- Updates to point in time recoveries
Find out more in the latest blog post:
7
16
171
How is MySQL is pronounced?
My S-Q-L
7457
My Sequel
5812
157
40
166
Want the ease of a fully managed database, but need to host your data for compliance? We’ve built a product for you, PlanetScale Managed Cloud — your cloud, our platform.
2
25
149
Want to write better queries, improve your application speed, and learn the parts of MySQL that are relevant to you as an app developer?
MySQL for Developers is the course for you. A free video course with over 40 videos, coming in January.
Get notified:
3
39
164
Introducing the PlanetScale API and OAuth applications ✨
A new way to manage your PlanetScale databases programmatically and build on top of PlanetScale
7
21
163
📣 Our Database scaling course by
@aarondfrancis
will be live in the next few weeks! It covers partitioning, replication, sharding, caching, and more.
Sign up now to be notified when it's released:
3
25
157
We would like to apologize for making our customers so successful that their users table keeps growing.
5
3
158
Our new best practices doc for using
@prisma
with PlanetScale just shipped! We cover referential integrity, indexes, migrations, and solutions to some commonly encountered errors.
0
16
155
Spend too much time identifying troubling queries?
Today, we’re launching PlanetScale Insights.
Insights provides detailed real-time, fully-integrated database performance metrics at your fingertips. No third-party APM required.
2
30
155
🚀 Due to the overwhelming demand & love for our MySQL course, we’ve decided to ship another one. In this upcoming course,
@aarondfrancis
covers database scaling techniques like sharding, replication, & more.
Sign up now to get notified when it releases:
8
15
154
"The best way to explain it is to do it." - Alice's Adventures in Wonderland
1
20
154
In this blog post, you'll learn why our engineering team chose to use NanoIDs over UUIDs for the PlanetScale API.
2
11
150
Paginating records in MySQL? We've got a brand new video just for you!
We cover limit/offset and cursor-based pagination and the tradeoffs between the two.
Attached is a preview, head over to YouTube to watch the full thing!
6
12
145
Connection strings are now live on PlanetScale. Start building with the tools you love and connect your PlanetScale database to any MySQL client.
9
21
143
🚀 One million queries per second 🚀
We ran some benchmarks to test PlanetScale’s ability to handle large query volumes and predictable scalability via horizontal scaling.
This post from
@hashtagjonah
covers how we achieved 1M QPS over 5 minutes:
2
25
140
Our job is just...
7
3
137
⚒️ New PlanetScale GitHub Actions just dropped, making it easier to integrate PlanetScale into your workflow.
Our first 4 Actions allow you to automate:
- Branch creation
- Branch password creation
- Deploy request creation
- Deploying a deploy request
3
18
137
We're excited that the new
@vercel
Platforms Starter Kit is built on top of PlanetScale! 🚀
Platforms Starter Kit: a template for site builders, multi-tenant platforms, and low-code tools.
View the demo and deploy your own.
33
209
1K
1
10
135
🔗 MySQL partitioning
There are many ways to improve the performance of your database in MySQL. One way is by splitting large, heavily used tables into separate files on your database server.
If this sounds like a daunting task, you might be surprised that it’s a feature…
3
14
134
You should almost always decouple your database schema and application code changes. So, how should you change your application code when it also requires changes in the database schema?
Find out how in our latest post from
@taylor_atx
:
2
14
132
Prisma Data Platform + PlanetScale = ❤️
See how building with PlanetScale and
@prisma
just got even better.
3
18
132
As of March 1st, all Scaler customers will have their read limits increased to 100 Billion reads.
You shouldn't worry about your database while you build your dreams, so we took one more worry off your plate.
P.S. the free plan also got a boost!
3
19
128
According to the MySQL docs, creating a composite index across several columns might be slower than creating an index on a single, hashed column. We know this because
@aarondfrancis
actually read the docs (nerd).
6
13
127
The countdown to launch week has started. Get ready for 11/15.
1
19
126
🚀 Introducing Insights Anomalies
Debugging a slow database can be difficult. With Anomalies, we tell you when your database is running slower than expected and show you exactly which queries are to blame.
Now available on all plans:
2
14
124
We just added
@DrizzleORM
and
@kysely_
to our onboarding walkthrough, making it easier than ever to connect your projects to PlanetScale!
5
6
123
There are two primary ways to paginate in MySQL: offset/limit and cursors.
Our latest blog post from
@aarondfrancis
walks you through an example showing how each of these work along with some pros and cons of each method.
1
14
121
🧢 database. hat DROP; tomorrow.
Follow 🤝, RT 🔁, and turn notifications on 🔔.
6
49
110
What's the most efficient way to count all the rows in a table? 🤔
7
11
117
You can go from sign up to fully creating and managing your database without ever leaving the terminal.
4
11
114
Have you heard of MySQL's 2038 problem? In MySQL, the TIMESTAMP column maxes out at 2038, so you have three options:
1. Use a DATETIME
2. Don't store future values
3. Retire and make it someone else problem 🤷
Which one are you picking?
16
12
110
Calculating the distance between two points on the Earth (which is not flat) takes a *little* bit of effort. Fortunately, MySQL has us covered! Learn all about the bounding boxes and the ST_DISTANCE_SPHERE function in our newest video.
6
12
109
Let's see if we can index JSON in MySQL in less than 1 minute ⏳
4
9
110
Introducing the
@Cloudflare
Workers + PlanetScale integration!
🚀 Automatically generate database credentials
🚀 Uses our HTTP serverless driver
🚀 Integrate with just a few clicks
0
10
108
Why has MySQL chosen *not* to use your index? 👀 You might be obfuscating it!
3
17
105
PlanetScale Deploy Requests warn you if you are about to take a destructive action on a table or column that is still being queried. 🪄
5
10
103
📢 Foreign key constraints are now GA
1
12
99
Why settle for slow? PlanetScale Boost is now available to everyone.
Read more:
4
21
96
The unique and lightweight product design process at PlanetScale is part of what allows us to ship new features so quickly.
Learn about what that process looks like in our latest blog post from our Product Designer
@jasonlong
.
2
14
94
In
@MySQL
, you can't add a B-tree index to a blob or text column, but you *can* create a generated column that is an MD5 hash of a blob or text column, and put an index on that! 😎
3
15
94
The results of the poll are in, and we finally have a definitive answer on the pronunciation of MySQL. Thank you all for voting.
18
5
93
Internal reaction to our upcoming announcement from
@mscccc
and
@no_itsbackpack
. March 24th can't come soon enough! 👀
8
12
90
One of the biggest myths around MySQL is that COUNT(id) is somehow faster than COUNT(*).
In this video we (hopefully!) put that myth to rest once and for all.
1
16
89
Get a peek into how we build PlanetScale using PlanetScale.
@kwuchu
breaks down how we utilize database branching and non-blocking schema changes to increase developer velocity and quickly ship new features.
3
15
88
⚡️ Introducing FastPage: a faster way to perform deep pagination queries in your Rails applications.
Learn how to use it in your own Rails app in this blog post from
@mscccc
:
2
17
85
Introducing Beam, a simple message board for your organization or project.
0
18
85
ENUMs give you the best of both worlds. You get the readability of a string and the benefits of integer storage. So, what's the catch?
3
10
82
We’re committed to building the world’s best database -- and we’ve got a clear vision for how to do it.
Read the principles that will guide us and others in building the future database that will transform how developers work.
1
18
80
You asked, we answered.
Build, ship, and scale faster with the new PlanetScale + Vercel integration.
5
11
75
MySQL, the database you know, love, and trust - soon will have support for vector embeddings and search ✨
6
3
75
📣 Our new database scaling course drops next month! It covers:
- Replication
- Partitioning
- Sharding
- Caching
- Multi vs single tenant architectures
- Connection management
- And more!
7
9
75
Do more with your data!
Today, we’re launching PlanetScale Connect.
Built using an
@AirbyteHQ
connector, learn how Connect helps make data in PlanetScale more accessible. Easily extract and load data for analytical queries.
1
13
73
We had to overcome challenges in almost every single layer of the product: MySQL limitations, Online DDL, branching, and schema analysis logic.
Learn how we overcame them:
0
11
72
ICYMI we launched the PlanetScale API, a new way to manage your databases programmatically:
To celebrate the launch, we're doing a hat DROP; be one of the first ten people to share what you want to build with the API, and we will send you a hat. 🧢
23
9
71
"Super hyped for this.”
"This will benefit us!"
– Reactions after a sneak peak
05.25.2022
4
7
68
No question in history has been asked more than "what GUI is that?" We finally provide an answer (spoiler: it's TablePlus).
3
3
64
Dropping unused tables can be scary. You may *think* they're not being used, but are you sure?
🪄 PlanetScale now warns you if a table you're about to drop has been recently queried. Learn more in this new blog post by
@davidgraham
.
1
9
66
Rails is fast, the speed of light is slow.
Putting your Rails app *and* your database in multiple regions across the globe can help!
In this post,
@mscccc
shows us how to deploy a multi-region Rails app.
3
16
66
💻 The expand, migrate, & contract pattern
People often ask us what should come first: application code changes or schema changes. The answer is a little complex, but important to understand if you want to ship no downtime and backward compatible schema changes.
Let's dive in.
1
12
66