Database Schema Design Articles on Flatlogic Blog

Guides and best practices for designing database schemas, including entity-relationship models and table relationships.

What is PostgreSQL?

Postgres is a powerful open-source relational database that supports both SQL (relational) and JSON (non-relational) querying. It was created by scientists from the University of California at Berkeley. It is a very stable object-oriented database management system. The PostgreSQL community has grown for over 20 years, contributing to its high stability, consistency, and correctness.

by Alesia Sirotka • 5 min read

ETL (Extract, Transform, Load). Best Practices ETL Processes and Lifehacks

ETL (Extract, Transform, Load) is a well-known architecture pattern whose popularity has been growing recently with the growth of data-driven applications as well as data-centric architectures and frameworks.

by Alexey Vertel • 16 min read