postgresql

PostgreSQL Materialized Views

In this tutorial you’ll discover what PostgreSQL materialized views are and in what cases you should consider working with them. Moreover, you will get familiar with a convenient IDE by Devart – dbForge Studio for PostgreSQL that is designed to make your database development routine easier and more pleasant.

(more…)

Scheduling Cron Jobs in ASP.NET 6 and C#

This article covers cron jobs and how we can leverage Quartz.Net to schedule cron jobs in ASP.NET 6. It shows how we can store messages in a PostgreSQL database using Devart for PostgreSql, Quartz.Net, and ASP.NET 6.

(more…)

What Is a Database?

The article provides a general overview of the databases in simple terms, discusses their advantages and drawbacks, and covers the types of data to be used in databases to better understand and more effectively organize your databases.

(more…)

ORDER BY in PostgreSQL – Different Ways to Sort the Output Results Easily

The SELECT statement is the most widely used SQL method to find and retrieve data from databases according to particular criteria. No matter which RDBMS you are using, you will need this command. The PostgreSQL system we will be dealing with in this article is not an exception. However, there is a catch.

(more…)

5 Simple Tips for PostgreSQL Data Access Components in 2022

In this article, we would like to introduce one of the rock-solid sets of data access components – the PgDAC or PostgreSQL data access component.

(more…)

4 Ways to Test an ODBC Connection

Are you looking for different ways to test an ODBC connection? In this article, we will discuss 4 easy ways to test the connectivity and show how to do it with examples.

(more…)

Understanding PostgreSQL Date Types and Functions (by Examples)

In this article, we will look into working with dates in PostgreSQL, including the various date data types and formats, their functions, and the ways how to deal with them in your everyday routine. We will be using dbForge Studio for PostgreSQL to illustrate the examples.

(more…)

PostgreSQL Indexes: An In-Depth Guide

All relational database management systems, including PostgreSQL, provide specialized means and techniques to get the necessary information quickly and accurately. These means include indexes — database objects that are used to increase database performance, allowing the database server to find and retrieve specific rows faster. Indexes can also be used to help maintain data integrity, since tables with unique indexes cannot have rows with identical keys.

(more…)

Support for Load Balancing and Other Improvements in dotConnect for PostgreSQL 7.24

The new version of dotConnect for PostgreSQL offers support for load balancing. It allows specifying multiple hosts with their ports in the Host parameter of the connection string. The servers should be separated by commas.

(more…)

New Release of ODBC Drivers: Windows 11, PostgreSQL 14, MariaDB 10.6, and Firebird 4 Supported

We are pleased to inform you about the release of all our ODBC drivers for cloud data sources and databases.

(more…)