In this article, see some new security features in open-source YugabyteDB, and see how to implement them. The YugabyteDB 2.5 release adds many critical enterprise-grade security features. This blog post outlines these newly added features.
Adding scram-sha-256 Authentication
The first notable addition is the addition of a much improved, password-based authentication mechanism called Salted Challenge Response Authentication Mechanism (or simply SCRAM) as described in [RFC5802]. This scram-sha-256 authentication mechanism, identical to the most secure PostgreSQL authentication schema, is a challenge-response scheme that prevents password sniffing on untrusted connections and supports storing passwords on the server in a cryptographically hashed form that is thought to be secure.
YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. This post has shown how to use the YSQL functions for linear regression analysis, as well as a broad variety of generic YSQL features, to create a study of immediate real-world application.
This post has shown you how to use the YSQL functions for linear regression analysis along with a wide range of generic YSQL functionality to implement a study with acute real-world relevance.
This video on PostgreSQL Tutorial will help you understand what PostgreSQL is, and the features of PostgreSQL. You will learn the important PostgreSQL commands using pgAdmin and PSQL shell. You get an idea about basic SQL queries, filter clauses, constraints, functions, and much more.
This Edureka video on PostgreSQL Tutorial For Beginners will help you learn PostgreSQL in depth. You will also learn how to install PostgreSQL on windows.
Compare PgBouncer vs. Pgpool-II to see which PostgreSQL connection pooler offers the best features, and analyze throughput (TPS) in a performance benchmark.