Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
11 blog posts in 13 categories

A Review of the New Analytic Window Functions in MySQL 8.0

This blog provides an overview of MySQL window functions. A window function performs an aggregate-like operation on a set of query rows. However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row.

How Roles Have Changed in MySQL 8.0 and How to Use Them

Making sure the right people have access to your MySQL data is very important. This blog shares what has changed with user management in MySQL 8.0.

MySQL in 2018: What’s in 8.0 and Other Observations

This blog details MySQL’s accomplishments in 2018, including the release of MySQL 8.0 which includes changes to roles and the integration of NoSQL.

Care To Know Clauses: All About SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT

In this blog post, we visit, at a high-level, the major SQL clauses as they apply to PostgreSQL. There are many dialects of SQL but PostgreSQL’'s interpretation is the focus in this blog.

Understanding Check Constraints in PostgreSQL

A check constraint is a type of integrity constraint in PostgreSQL which specifies a requirement that must be met by each row in a database table. The constraint must be a predicate. It can refer to a single column, or multiple columns of the table.

PostgreSQL Streaming Replication vs Logical Replication

This blog provides an overview of streaming replication and logical replication for PostgreSQL and what you can use each for in your setup.

More of My Favorite PostgreSQL Queries - and Why They Also Matter

This is the follow up to the popular blog ‘My favourite PostgreSQL queries and why they matter’. This new blog focusses on a particular query, multi-row UPDATE with a single CASE expression, and makes comparisons between that particular query, and one involving multiple single UPDATE statements.

Using pg_dump and pg_dumpall to Backup PostgreSQL

pg_dump and pg_dumpall are popular tools used to backup PostgreSQL.  This blog shows you how to use them, with some tips and tricks for ensuring you have a proper backup strategy.

Top PostgreSQL Security Threats

This blog details some of the most recent security threats to PostgreSQL and some tips and resources to keep your data secure.

My Favorite PostgreSQL Queries and Why They Matter

In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore, study, learn, or otherwise manipulate data sets.

Pages