Issue #78 : Software Testing Notes
How to Quickly and Efficiently Create Tests for MySQL
Hello there! 👋
Welcome the 78th edition of Software Testing Notes, a weekly newsletter featuring must-read content on Software Testing.
Consider subscribing if you haven’t already 👇
Database Testing might be one of the few field that very few people in software testing community gets a chance to work with regularly. Also, in my curation, I see very few articles on the Databases (Also accessibility testing, but that’s a story for the another day) as my feed is mostly filled with UI and API automation. Although this might change in the future as I’m adding more and more sources for the curation (150+ so far and growing).
This week, I have lots of nice reads for you talking about Testing GPT-Based Apps, testing Screenshots, Mobile app shortcuts, MySQL stored procedures, creating disposable databases for testing, Implementing CI/CD with Github Actions, doing Accessibility Testing on Windows Apps and much more…
So, without any further delay, Lets dive into this week’s curated link. Please do let me know what your favorite is!
This is a great article by Jason Arbon going into great detail of what large language models (LLMs) are, their usage, their features, limitations and how to go about testing GPT-based features and apps with an AI-first approach.
Get better at understanding screenshot tests for mobile apps with this article. Ubiratan Soares writes about two strategies that we can adopt and follow. Along with how to approach investing in screenshot tests and how it can help to catch more visual regressions as part of the test suite.
Kristin Jackvony is back with the third article of the “Logical Fallacies for Testers” series. In this piece, Kristin talks about the one of the most common assumption that we place: “Since an expert has said so, it must be true!”. Also read Part-1 about The Causal Fallacy and Part-2 about The Sunk-Cost Fallacy.
Really great efforts by Rahul Parwal analyzing and converting Common Software Errors (bbst.courses) by Dr. Cem Kaner into a nice to follow checklist for everyone. As the name suggests, it’s a list of common software errors to assist you in your testing journey.
Becoming an expert tester depends on recognizing the underlying structure of problems and how to test for them.
With the example of the certain text that Michael Bolton stumbled upon recently, he explains the importance of continuous learning even from little bugs that seem insignificance and how human interpretation, common sense and sound judgement can make us better at testing.
➜ Read all curated stuff on Software Testing here.
Speeding up the executions of automated tests is a good thing. Right? In this article, Paul Grizzaffi explains it might be a good thing to introduce the delay when it comes to the mimicking actual human behavior, so that we could expose some potential unknown behaviors of the system.( Just like how we generally use ThinkTime and PacingTime to mimic the real world users for performance testing.)
If you are using cypress and want to implement a mechanism to execute your failed tests using GitHub actions then this article is for you. Gleb Bahmutov has posted this nice step by step article with great example.
Do you know how to perform Click, Double Click, Right-click, Mouse Hover, Drag and Drop with Playwright? It’s easier than you think. Read this article by Akhil Singh Rawat to know more.
The "App Shortcuts" feature allows users to access a specific part of the application from the device's home screen.
You know how to automate your mobile app. But what about the other parts of the android platform that interacts with your app. Such as “
Dynamic Shortcuts that can involve some form of business logic of the application”. Take a look at this article by Alex Zhukovich showing how to cover them using UiAutomator.
Additionally, Amr Salem has written a step by step guide on How to Run Android Emulator out of the box with GitHub Actions!
➜ Read all curated stuff on Software Testing Automation.
Wanna learn how to test stored procedures and functions for MYSQL Database? In this article Yuri Danilov shows how you can perform database testing without installing any additional utilities.
How to run disposable databases for your tests. Improve your integration tests accuracy with Testcontainers by Daniel Genezini
In this post, Daniel Genezini explains how to spin up disposable database containers to use in integration tests using Testcontainers in C#.
➜ Read all curated stuff on Database Testing.
This post by Akash Khunt details a interesting false positive performance issue. This particular issue was only observable when profiling a release build, and that is also on a device which was constrained on memory (RAM) and CPU power.
Some tips and tricks to properly debug and identify the performance bottlenecks within the Linux Systems along with some common performance issues.
➜ Read all curated stuff on Performance Testing.
Another under the hood kind of article about selenium that I have shared it in one of the previous issue. In this piece, Abhishek Dhoundiyal explains how selenium manages the Same Origin policy to interact with the web browser.
A nice article detailing the importance of penetration testing and why every organization should care about it.
Have you ever needed to test desktop applications for accessibility? Andreea D. has documented her learning along with some nice tips for us.
➜ Read all curated stuff on Accessibility Testing.
Thanks for reading Software Testing Notes! Subscribe for free to receive new posts and support my work.
🛠️ Resources & Tools
Thunder Client — Add an API endpoint and header information, along with query parameters, and check the response, all within VS Code.
Jest VS Code extension — It supports full Jest features within the VS Code environment. If the extension can find a Jest command within your project, it will run and monitor your project's tests in watch mode, upon launch. It will also display inline and in the TestExplorer, which tests passed and failed.
Browse curated library of 300+ hand-picked tools & resources to help you solve your everyday software testing problems and supercharge your testing.
📝 List of Software Testers
It's hard to find good articles, podcasts on Software Testing. Even hard to find people who create them. Are you also looking for amazing software testers to follow or read their content ? check out this page dedicated to software testers.
Do you also create content around Software Testing ? Submit yours here and I will add it to the list.
🎁 Bonus Content
📌 OTHER INTERESTING STUFF
⭐ LAST WEEK'S MOST READ
😂 And Finally,
Keep Smiling and have a fun week.
📨 Send Me Your Articles, Tutorials, Tools!
Thanks to everyone for subscribing and reading!