Arctype

Collaborative SQL Client and DB Management Tool

continuously tested by QAwerk
Girl Image Boy Image Clip Icon Blue Clip Icon Red
×
Where do you want us to send our Arctype case study?
Please enter your business email isn′t a business email

Arctype is an SQL client and database management tool for individual developers, students, and enterprise teams. It makes querying databases more efficient, visualizes data with charts, and offers collaboration features with granular permissions for better security.

All Customers

Overnight Testing

QAwerk uses the difference in time zones with North America, Australia, and New Zealand to speed software releases by 20%. We thoroughly test your software when it’s nighttime in your country and business hours here in Ukraine.

Learn more

QA Manual Testing

We help Arctype developers use their time efficiently by taking over all the software testing routines. We write new test cases, maintain documentation, and perform different types of testing, catching bugs before they reach end-users.

Learn more

Challenge

As a successfully growing startup, Arctype felt the need to strengthen their development team with experienced QA engineers. They needed someone to follow the best practices and draw on their expertise to create new test cases. This way, developers won’t waste their time on software testing and instead will channel their energy toward feature development and bug fixing.

Arctype turned to QAwerk to help them ensure multiple monthly releases go smoothly and with the needed speed. We were expected to run test cases the same day the release was put out. Thanks to the difference in our time zones and overnight testing, it was possible that when Arctype developers log off, it’s daytime here in Ukraine and our QA engineers begin testing. The next day, Arctype developers have all bugs already logged in Jira to start bug fixing first thing in the morning.

Another milestone is to retain 10-20% consumers who churn because of bugs by significantly increasing the software quality and preventing critical issues from appearing in prod.

Solution

Our QAwerk team is primarily engaged in testing the Arctype desktop app for macOS. At the same time, if we see that the new version works incorrectly, we also test the web client and go through the most critical test cases on Windows.

Here are the types of testing we regularly perform to achieve the desired quality:

  • Functional Testing – the groundwork we lay to ensure users encounter no obstacles with the app’s functionality.
  • Integration Testing – essential to guarantee the SQL client has no integration issues with databases, such as MySQL, PostgreSQL, SQLite, Yugabyte, and PlanetScale.
  • Regression Testing – a must-have for startups like Arctype that continuously work on releasing new features. We do regression consistently to check if updates affect the existing functionality.
  • Automation Testing – we combine manual testing with QA automated testing to speed up the releases. We’ve automated registration and login test cases and are looking into other areas that have automation potential.
  • Installation Testing – a basic type of testing, yet also important. We ensure Arctype users can download, install, and update the app without technical errors.
  • Smoke Testing – before going through an extensive list of test cases, we need to ensure the build is stable to avoid wasting time. We quickly check critical features to see if there are any showstoppers and if we can proceed.

We started with 50 test cases Arctype suggested and expanded them to over 200. Those include sad and happy paths as well as test cases with different database types and details. We test new builds weekly and add test cases together as we go.

Our QA engineers are deeply involved in creating new test cases and making them as detailed as possible. The amount of time needed for a test run of a new build only takes 8-9 hours, considering the complexity and variety of features.

Bugs Found

Bugs related to data loss and application blocking should be under closer control – as they can lead to customer loss.

Actual result: The app is blocked. The user sees the error “There was an error loading this component. We’ve been notified of the error and will fix it as soon as possible.”

Expected result: The user is able to connect.

Actual result: The user sees an empty screen.

Expected result: Connection is deleted successfully, chosen data source in the left sidebar should be closed.

Actual result: When the user makes a search on the second page, he needs to go back to the first page to view results.

Expected result: When the user searches for a number, only the rows containing the requested number are shown.

Result

We are proud to know Arctype recognized our commitment to their success by steadily increasing our workload and delegating us more and more functions. What used to be 5 test runs per month is now performed by the QAwerk team weekly. We’ve significantly expanded the number of test cases, removed outdated ones, and detailed the existing ones.

Having witnessed how thorough we are with manual testing, Arctype also entrusted us with test automation. With our support, Arctype has gained confidence and stability in software releases, delivering new capabilities faster and more frequently.

Awarded

In Press

This product is new, free to use, and has a community on Discord, to help. This is a nice way to get the power of SQL databases with a user-friendly interface.

Tech blog on distributed databases, open source, and cloud native.

Arctype features a fast, modern interface with many keyboard shortcuts, a command bar to quickly find objects, and the best support for JSON in a SQL client. It’s also free to use.

PlanetScale database management blog.
The collaboration between QAwerk and our developers has been very successful. They exhibit a sincere investment in the client's application and often suggest innovations to improve the platform. Our CEO called them “the best vendor he’s ever worked with” and I got major brownie points for their selection. High fives all around.
star star star star star
Everett Berry

Looking to strengthen your dev team with experienced QA engineers?

Talk to experts

Tools

JiraJira
LinearLinear
Google DocGoogle Doc
200+test cases written
8hrs to test new build
5test runs per week
7testing types
20%faster releases

QAwerk Team Comments

Alexander

Alexander
QA engineer

Arctype is a desktop app that will turn any database-related tasks into a straightforward and convenient process. I’m mostly engaged in conducting regular regression tests, scrutinizing new functionality, and documenting all steps as we move forward.

In-depth test case descriptions and consistent checks have allowed us to achieve improved product quality. Arctype’s product is simple in use, yet offers a broad variety of features – exactly what keeps me interested and motivated while testing.

Oleh

Oleh
QA engineer

As a QA team, we perform regression test runs several times a week. We also conduct new feature testing. I’ve developed a genuine interest in the project thanks to abundant growth opportunities and highly supportive folks who are always ready to answer my questions. I’d also like to recognize the app’s high data load speed and overall performance.

Media
Media
Media

Related in Blog

How to Write Test Cases: QAwerk’s Comprehensive Guide

How to Write Test Cases: QAwerk’s Comprehensive Guide

  Right from the start, we are set to announce that there is no single all-purpose test case type. However, there is an easy-to-follow set of practices and solutions that, when implemented properly, will result in a good one. We’ve put together the test case writing bes...

Read More
What is Software Testing Life Cycle (STLC)? Step-by-Step Guide

What is Software Testing Life Cycle (STLC)? Step-by-Step Guide

Software testing life cycle (STLC) is a set of actions that are performed coherently and on a systematic and planned basis in order to find out if a software product works properly and if there are any options to improve it. All stages of the software testing cycle have an exact ...

Read More

Impressed?

Hire us

Other Case Studies

Keystone

Keystone

Norway

Helped Norway’s #1 study portal improve 8 of their content-heavy websites, which are used by 110 million students annually

Station

Station

France

Performed exemplary regression testing of a desktop app with 600+ integrations on Windows, MacOS, and Ubuntu

Evolv

Evolv

United States

Increased this digital growth platform’s regression-testing speed by 50%, and ensured the platform runs optimally 24/7