March 2022 - Terr For MER

The World Of Blockchain And Cryptocurrencies: Trends-2022

By Terra03/12/202203/12/2022

DeFi, NFT-art, Ethereum 2.0, metaverses, government digital currencies (CBDC) are all the main trends in the world of blockchain and cryptocurrencies in 2022. Everyone writes and talks about them, because they are obvious, and their development is easy to predict. We will tell you about non-obvious trends – that it will not be so noticeable …

Metaverses and NFTs: Trends 2022

By Terra03/12/202203/12/2022

In 2021, the Metaverse and NFTs are recognized as the hottest trends in the world of blockchain and cryptocurrencies. Obviously, they will continue to attract the attention of investors and developers this year as well. But there are also not so obvious moments – the growth of crime, the birth of NFT 2.0 technology, the …

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;