January 2021 - Terr For MER

In short, it is a powerful data analysis and transformation tool that allows developers to access a variety of databases. And if we want to analyze data, we need to get it from somewhere, and we get it, as a rule, from databases. This is not always visible with the naked eye, but whether we …

SQLite is not a toy

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

Console, import and export

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;