Arctype

Collaborative SQL Client and DB Management Tool

continuously tested by QAwerk

Arctype
ArctypePalo Alto, CA, United States

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

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 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 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

Arctype - Supercharged SQL client for developers and teams | Product Hunt

Product Hunt, 5th Product of the Week 2021

Read more

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.

    Everett Berry, Head of Operations at Arctype

  • The QAwerk team has been one of our favorite vendors at Arctype. They help keep our app stable and are extremely responsive and thorough. I would recommend the QAwerk team to any startup looking for a great, affordable QA team for their product.

    Justin de Guzman, Founder at Arctype

Looking to strengthen your dev team with experienced QA engineers?

Talk to experts

200+

test cases written

8

hrs to test new build

5

test runs per week

7

testing 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.

Arctype
Arctype
Arctype

Related in Blog

test cases

Click to read more

How to Write Test Cases: QAwerk’s Comprehensive Guide
October 20, 2021

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 writin...

Read More

Click to read more

What is Software Testing Life Cycle (STLC)? Step by Step Guide
March 12, 2019

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...

Read More

Impressed?

Hire us

Other Case Studies

Norway
Helped Norway #1 study portal improve 8 content-heavy websites used by 110 mln students annually
France
Performed regression testing of desktop app with 600+ integrations on WidowsmacOSand Ubuntu
Evolv Case Study
United States
Speeded up delivery of new capabilities by 50% with automation and keep the platform running 24/7

Dear Friends!

We are a Ukrainian software testing company. Our country has been brutally attacked by Russia, which aims to destroy us as a nation and a sovereign country.

Despite Russia’s continuous aggression, shelling, and barbaric crimes, we stay strong and true to core democratic values.

QAwerk fights on the economic front. We keep helping businesses worldwide speed up releases, eliminate critical bugs, and win users’ love and world’s recognition with impeccable product quality.

We’d love to keep our team employed and hire those techies who lost jobs because of the war. While we may not be the right fit for you, perhaps you know someone who is.

Please reach out to your network and spread the word. They’ll get top-notch service from a grateful and highly motivated tech team.

Would you be open-minded to exploring more about how we deliver during the war?

Stand with Ukraine by working with Ukraine!