Posted in test automation

It is (sometimes) a good idea to automate your regression testing

 

Desejando-lhe uma

Let’s start from Wikipedia’s definition of Regression Testing:

Regression testing is a type of software testing which verifies that software, which was previously developed and tested, still performs correctly after it was changed or interfaced with other software. Changes may include software enhancements, patches, configuration changes, etc.

Now, when we are aware of what is all about, let’s get to the point.

How often do you proceed regression testing? Once per sprint? Once per month? Daily?

Here we are. If our regression testing is supposed to make any sense – it has to be performed as often as possible – at least on sprint basis. Ideally – daily. Why? Because  stable test suites would catch any unexpected system behaviors and react to a major change.

Minions-at-work

There is yet another question – how big your system is.

Small systems usually have rather checklists than test suites. Large ones – even the monsters:)
Deciding what should by automated  is always tough, because having automated test scrips may be just something you could show off with or present in front of the customer. I would rather ask: WHY do you want to automate anything?

The problem is that sometimes automated suites don’t test anything (or anything meaningful) and the effort to keep them alive is big.

If you wonder if it’s worth to automate repetitive stuff? I’d answer – sure mate!

Automation is good. But it is just another tool – NOT THE PURPOSE.

AUTOMATION

I think that automated regression tests might be brilliant and helpful, but you have to remember that you’ll have to take care of them and update them often. You’ll also spend way more time to prepare test suites than to proceed simple tests manually, so if the testing is not repetitive – it’s good to calculate what is more beneficial for your project.

When automating things – you improve your skills and gain time for other activities – so it’s basically a matter of time – the time you’ll save on running automated regression testing and time you’ll waste (it’s not wasted, I know) on preparing them.

I’m just the beginner , so I might be wrong. Don’t agree? Comment below or stalk me on Twitter.

Posted in databases

SQL for dummies

do-somethingkind-today-2

…and when I say dummies – I’m thinking about myself a while ago.

As a tester – I was a complete ignorant when it comes to databases. At the beginning of my career path SQL wasn’t so needed for me. It appeared here and there, but we’ve never had a true romance. But then… suddenly… at a glimpse… love exploded 🙂

No, well, to be honest, I just decided to stop being dummy and put myself together. And I- Kinga Witko – learned it by heart and – basically – by myself. How did I do that?

Today I’ll give you some useful tips, that might help all SQL beginners to start their database adventure. If I managed to learn it – why couldn’t you?

Where should I start?

Most of you probably know that the one and only knowledge source is W3Schools website. SQL course is there as well. It is vast, full of examples and great exercises. The whole necessary knowledge is there, but for me – it wasn’t enough and I lack some structure in that course.

Level up

Some time ago I started to get familiar with CodeShool. They have awesome online courses – each of them – which is basically adorable – has A SONG(!) about the language you’re learning. There is a song about SQL too :).

Their online course is divided into to parts: one of them is free -for the other one – ‘The Sequel to SQL’ – you have to pay a few $, but it’s worth it. Not only the knowledge is structured, but also supported with great examples and opportunity to go deeper into SQL.

That was it – nitty gritty online course. It was also just the beginning.

After the CodeSchool course I was familiar with SQL enough to get back to W3Schools and practice more. But it still wasn’t enough. I wanted to have some  real database to make and brake (in worst case scenario).

How to practice?

I was recommended to install a free database named PostgreSQL. It is easy to install and really great. When you go through setting up your own database, tables and so on, you’ll eventually learn a lot. Believe me.

If you’re a ‘mobile’ person like I am – I would also recommend you a great Android app (not very pretty, but valuable) – LearnSQL. I was going through several free Android applications for SQL learning and this one was the best. Well done, chaps!

Where to find correct queries?

Try this website. It’s about SQLite, but the whole queries stuff is represented by simple graphics and allows you to learn more and to get familiar with all useful possibilities that SQL gives you.

So – your mission for today. Stop being dummy as I was and learn SQL. It is not as hard as you might think. Good luck!

Should you find other great SQL learning-related online stuff please let me know 🙂

kkksqlu