Databases

PipelineDB

PipelineDB is an open-source relational database that runs SQL queries continuously on streams, incrementally storing results in tables.

PL/SQL

Procedural Language / Structured Query Language is a procedural language extension to SQL that allows programmers to write code in a procedural format. It is embedded in the Oracle Database (since version 6), along with SQL itself and Java.

PlanetScale

PlanetScale is a fully managed database platform for Vitess/MySQL and Postgres, delivering NVMe-backed performance, massive scale through horizontal sharding, and enterprise-grade reliability.

PostGIS

A software that adds support for geographic features to the PostgreSQL relational database. PostGIS is developed in accordance with the Simple Features for SQL specification from the Open Geospatial Consortium (OGC).

PostgreSQL

An object-relational database management system (ORDBMS), the most developed of open database systems in the world and is a real alternative to commercial databases.

Presto

An SQL database query engine for running analytical queries on large volumes of data, from gigabytes to petabytes of information. It integrates with databases, such as Apache Hive, Cassandra or relational databases, tunning the queries where the data is stored.

Primary Key

A column or a set of columns that uniquely identifies each row in the table. A primary key must contain unique values. If the primary key consists of multiple columns, the combination of values in these columns must be unique.

RDBMS

Relational Database Management System is a program that lets you create, update, and administer a relational database. Most relational database management systems use SQL to access the database.

Prisma

Prisma is an open-source database toolkit that simplifies database access for application developers. It provides a set of tools and libraries that enable easy and type-safe database queries and operations. Prisma supports multiple programming languages, including JavaScript (Node.js), TypeScript, and Rust.

Prisma supports various databases, including PostgreSQL, MySQL, SQLite, and SQL Server.

Database migration

Database migration — means moving your data from one platform to another.

Redis

REmote DIctionary Server is a non-relational high-performance database. Redis stores all data in memory, access to data is carried out by the key. This approach provides performance that is tens of times higher than the performance of relational databases, and also simplifies data partitioning.

Redshift

An Internet hosting service and data warehouse product which is a part of the larger cloud-computing platform Amazon Web Services. It is built on technology of MPP. It can analyze your data using standard SQL and your available BI tools.

Relational DB

MySQL, Oracle, Access, MS SQL Server (mostly for Microsoft stack), PostgreSQL, SQLite.

RethinkDB

A document-oriented database for storing JSON documents. It is useful for applications with real-time data feeds. An app can benefit from RethinkDB, for example, when streaming analytics is involved, for multiplayer gaming apps, in real-time marketplace and collaborative web apps.

Riak

A distributed NoSQL key-value database, provides high availability, fault tolerance, operational simplicity, and scalability, commonly used case in storing large amounts of log data.

ETL (Extract, Transform and Load)

Refers to a process in database usage and in data warehousing. It includes three stages: data extraction from homogeneous/heterogeneous data sources, its storage and transformation into the proper format or structure for the purposes of analysis, and data loading into the final target.

RDMS

Stans for the relational database management system. RDBMS is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database.

RocksDB

A high performance embedded database written in C++, can be used to persistently store keys and values. It is a fork of LevelDB which was then optimized to exploit many central processing unit (CPU) cores, and make efficient use of fast storage.

SAP MaxDB

A free relational database management system from SAP AG. It is ANSI SQL-92 compliant and is a good alternative to expensive database management systems for medium and large server configurations. It offers built-in features for self-administration and managing complex objects. It is available for Windows, Linux and Unix.

ScyllaDB

A drop-in Apache Cassandra alternative big data database that powers applications with ultra-low latency and extremely high throughput.

Snowflake

Data warehouse for the Cloud provided as SaaS. Uses a new SQL database engine with a unique architecture designed for the cloud.

Solr

A scalable Apache platform for searches of data stored, used for full-text search, hit highlighting, dynamic clustering, database integration, has NoSQL features and rich document handling.

Spanner

Google's globally distributed NewSQL database. Designed to distribute data at global scale and support externally-consistent distributed transactions. 

Spark SQL

A Spark module for structured data processing. It provides a programming abstraction called DataFrames and can also act as a distributed SQL query engine. It enables unmodified Hadoop Hive queries to run up to 100x faster on existing deployments and data.

Sphinx

SQL Phrase Index is a full text search server that enables to batch index and searches data stored in the SQL databases, NoSQL storages, API for common web programming languages or just files quickly and easily.