Ruby Archives - Terr For MER

How to improve the QA process

By Terra07/08/202107/08/2021

As you already know, the QA process plays a significant role in product development. If software is not working right, your clients will let you know and it will have a huge impact on their desire to use your product/service in future. Therefore, knowing which tips and tricks to use in order to improve the …

How to become a QA engineer

By Terra02/11/202103/17/2021

What it takes to become a so-so QA engineer English from Intermediate, any QA courses, practice in an IT company. Done, you are amazing.What it takes to become a good QA engineer To begin with, you should understand if this is yours. I would single out a few basic characteristics of work and character traits …

Here’s why SQLite is perfect for your day-to-day work. It doesn’t matter if you are a developer, analyst, tester, admin or product manager.

For starters, a few known facts:

SQLite is the most widely used database management system in the world, included in all popular operating systems.

Works without a server.

For developers, it is embedded directly into the application.

For everyone else – a convenient console (REPL) in one file (sqlite3.exe on Windows, sqlite3 on Linux / macOS).

The console is a killer feature of SQLite: a more powerful data analysis tool than Excel, and much simpler than any pandas. Data from CSV is loaded with one command, the table is created automatically:

> .import –csv city.csv city
> select count (*) from city;
1117

Basic SQL features are supported, and the console shows the result in a nice table. There are also advanced SQL features, but more about them later.

select
century || ‘th century’ as dates,
count (*) as city_count
from history
group by century
order by century desc;