Hello Arctype Community,
This week we’re celebrating a big milestone, 1,000 sign ups! @maximgeller_ on Twitter was the 1,000th user and is getting a sweet hoodie out of it. That also means - if you’re receiving this email - then you’re one of our first 1,000 users. We’re so psyched to be building for you!
In this newsletter, we have an important release for you focused on quality of life changes, an inside look at how we improved a critical part of the app, and tips for optimizing your queries.
Blog Post: How we Improved User Onboarding
After building a metrics dashboard and talking to users, we were able to double our activation rate. Our strategy is to focus on getting users in the door, getting users to experience core value as fast as possible, and delivering core value as often as possible. In the last few months we focused on the second goal, getting users to experience Arctype as fast as possible, and we saw some impressive results. This post covers our design journey, from interviews to analytics to mockups.
New Release with Editor Improvements
0.8.8 has several improvements for day to day users of Arctype. Along with numerous polish items, some highlights are:
- Line numbers persists after you use auto format (CMD or CTRL Shift F)
- Query variables are now ordered by where they appear in the query
- Charts made from the query view no longer display Subtitle if you didn’t specify it
- The close, maximize, minimize button makes room for collapsing the sidebar
Blog Post: Anatomy of a PostgreSQL Query Plan
Understanding the PostgreSQL query plan is a critical skill set for developers and database administrators alike. It is probably the first thing we would look at to start optimizing a query, and also the first thing to verify and validate if our optimized query is indeed optimized the way we expect it to be. This post covers the EXPLAIN keyword as well as an in depth look at the Postgres query planner and how to understand what it’s telling you.
Chat with Us, Get an Arctype Hoodie
It's not every day your favorite dev tool gives out swag right? Well maybe it is. The point is we're on a mission to learn from every Arctyper out there to keep releasing the most useful features we can. So talk to us! And get a hoodie for it.
The Arctype Team