PostgreSQL
How to Connect to PostgreSQL in Delphi with Devart PgDAC
We will guide you through the steps to connect to PostgreSQL in Delphi using Devart PgDAC.
New in Delphi DAC: Support for RAD Studio 12, new versions of SQL Server, Oracle, MariaDB, and PostgreSQL
Devart Delphi Data Access Components line of products has received a significant update, making it even more compatible with the new database versions.
Exploring Dependency Injection in ASP.NET 6Â
This article builds a simple application to demonstrate the concepts covered and uses PostgreSQL as the database to store data and dotConnect for PostgreSQL as the data provider for PostgreSQL.Â
Get the Latest Maintenance Update of dbForge Edge!
Here comes a new maintenance update of dbForge Edge, which delivers support for MySQL 8.1, Oracle Database 23c, and PostgreSQL 16. Make sure you don't miss it!
Postgres.app or Native PostgreSQL Server Installer: Which Is the Best Installer for macOS?
Dive into the detailed analysis of Postgres.app vs. Native PostgreSQL Installer for macOS. Discover the tool which provides the best performance, ease of use, and compatibility for your system.
Release: Excel Add-ins Update – ver. 2.8
The Excel Add-ins update, version 2.8 has just dropped. Check out the new features and implementations!
Simplify Your Cross-Database Data Import with dbForge Edge
Microsoft Access is a rather popular relational database system, which nevertheless has a slew of considerable limitations. And if your business requirements grow beyond these limitations, you will need a more advanced solution like Microsoft SQL Server, and your migration from Access to SQL Server will begin with data transfers. This is what we are going to explore in this article.
High-Quality PostgreSQL GUI Tools for macOS
PostgreSQL stands out as one of the world's most favored database management systems, and a substantial number of PostgreSQL users are also devoted macOS users. They need tools that are fully compatible with their favored operating system. This article aims to guide you toward the most suitable Graphical User Interface (GUI) database tools for PostgreSQL on macOS.
How to Work With Hangfire in ASP.NET Core
This article builds a simple application that does some background processing to demonstrate the concepts covered using PostgreSql as the database to store data and dotConnect for PostgreSQL as the data provider for PostgreSQL.
A New Era for Time-Series Databases: dbForge Studio for PostgreSQL + TimescaleDB
A recent update of dbForge Studio for PostgreSQL has added one more entry to its list of supported databases. We're talking about TimescaleDB, a PostgreSQL fork marketed as "the easiest, fastest, and most cost-effective time-series database." Now it can be seamlessly accessed and managed from the Studio.
New in ADO.NET Data Providers, Entity Developer, and LinqConnect: Numerous Features and Fixes
Devart dotConnect line of products has received a significant update, making it even more compatible with the latest development environments.
Customizing HTTP 400 and 404 Errors in ASP.NET Core
This article discusses how we can build a custom class to intercept HTTP 400 and 404, and 500 responses and return customized responses from the action methods. This article builds a simple application to demonstrate the concepts covered and uses PostgreSQL as the database.
How to Connect to Your Aiven Database Using dbForge GUI Tools: A Step-by-Step Guide
The well-known as-a-service business model has long encompassed various digital solutions presented to customers, and databases are no exception. In this article, we'll have an overview of Aiven, a nice example of a cloud service that offers, among other things, fully managed MySQL and PostgreSQL databases.
dbForge Tools for PostgreSQL Got a New Update!
Coming on the heels of our recent big update of dbForge tools for MySQL, we'd love to share some more good news—and this time it's all about our product line for PostgreSQL database. Today's update introduces several enhancements that will surely come in handy in your daily work.
New in ODBC: Support for Visual Basic, Linked Server, Alteryx, and more
Devart ODBC line of products has received a significant update, making it even more compatible with the latest development environments.
Champs Recap: Award-Winning dbForge Database Solutions in Q1 2023
Now that Q1 2023 is over, it's time to deliver our traditional champs recap and showcase the awards and badges garnered by dbForge solutions on independent review platforms over this period.
Top-Rated PostgreSQL GUI Tools [2023]
The role of professional GUI tools is exceptional for database development, management, and administration. Let us review the best GUI tools designed for PostgreSQL – one of the most popular database management systems in the world.
How to implement IP Safelist in ASP.NET 6
This article builds a simple data-centric application and demonstrates how to disallow data access to certain IP Addresses. In this article, we’ll connect to PostgreSQL using dotConnect for PostgreSQL, a high-performance and enhanced data provider built on top of ADO.NET that can work on connected and disconnected modes.
PGDay/MED 2023 Conference On April 13th
On 13th of April 2023, Devart is sponsoring the PGDay/MED 2023 annual conference on PostgreSQL and other open-source technologies
How to Secure PostgreSQL Database – Tips and Tricks
Database security offers new challenges emerge daily, and you have to pay all your efforts to prevent risks. Reliable protection grounds on a system with several security levels. Let's talk about these levels and practical measures. To start, we'll take one of the most popular database management systems – PostgreSQL.
Meet dbForge Edge, Your Ultimate Multidatabase Solution!
If you are a database developer dealing with several projects, it means you have to handle a number of database management systems simultaneously. And for each of these systems, you need to have a proper set of tools at hand. Moreover, the said set of tools must be complete and flexible enough to follow the evolving project and its current requirements.
Uploading Files in ASP.NET Core 6 MVCÂ
This article talks about how you can upload one or more files in an ASP.NET Core 6 application.Â
Two ways to connect .NET 6 API to PostgreSQL
The integration of PostgreSQL with a .NET 6 Web API provides a powerful and flexible solution for building data-driven .NET applications.
Easily Connect to PostgreSQL via ODBC Drivers: Setup Guide
Connecting to a PostgreSQL database via ODBC (Open Database Connectivity) drivers allows for greater flexibility regarding the programming languages and tools used to interact with the database. ODBC is a widely supported, platform-independent API that allows for communication between an application and a database management system.
How to implement health checks in ASP.NET 6
ASP.Net Core is a popular web development framework with many features for building web modern web applications. One of its many great features is the ability to implement health checks to determine the health of APIs, databases, etc. Health checks can help you to know if connections to the database, third-party components, etc., are healthy, degraded, or unhealthy.
How to Configure PostgreSQL for Remote Connections: A Beginner’s Guide
Configuring PostgreSQL for remote connections is essential for accessing data from different locations. By default, PostgreSQL only allows connections from the local machine, which can be a limitation in many situations.
Empower Yourself With the Brand New dbForge Studio for PostgreSQL v3.0!
Hey PostgreSQL users, we've got some excellent news for you! There's a huge update of dbForge Studio for PostgreSQL coming your way.
Meet the Latest Update of dbForge Data Compare for PostgreSQL – v4.0!
Here comes the fourth major version of dbForge Data Compare for PostgreSQL, and it packs a bunch of new features and helpful enhancements.
dbForge Schema Compare for PostgreSQL v1.3 Is Out!
To catch up with the rest of the dbForge product line for PostgreSQL, Schema Compare has also received a couple of nice features in the newly released v1.3.
Strategies for Versioning RESTful APIs in ASP.NET 6
Consider a scenario where you already have an API live and being used by users. Let's assume you want to enhance existing API capabilities while maintaining existing functionality. While some users may still use the older API, others prefer a version with new or improved features. So, you need a way to build and manage multiple versions of your APIs. This strategy is also known as API versioning.
dbForge Studios Add Support for a Slew of Cloud Services and Databases
We've got some good news for you today! The extensive compatibility of our database tools became even broader with a good number of cloud services that you can now seamlessly use with dbForge Studio for PostgreSQL and dbForge Studio for MySQL.
TRUNCATE TABLE in SQL
The article will overview the TRUNCATE TABLE statement in SQL on particular examples and describe the differences between the TRUNCATE, DELETE, and DROP statements.
When...
Working with Integration Tests in ASP.NET 6 Core
Introduction
Testing is an integral element of the development process for every application. There are many types of tests such as unit tests, integration tests,...
How to Use pgFormatter: Features and Alternatives
Formatting makes SQL code accurate, readable, understandable, and standardized for teams and individuals. SQL formatter is a tool that beautifies code automatically. Formatting tools...
PostgreSQL Foreign Key
Foreign keys help normalize data in databases and reduce redundancy. In fact, it is the FOREIGN KEY mechanism that provides the relationality of relational...
Best Practices in Using the DbContext in EF Core
Entity Framework Core is an open-source, popular, lightweight, and flexible cross-platform ORM. In Entity Framework Core (also called EF Core), a Db context is...
Consume a RESTful API Using RestSharp and C#
This article talks about REST concepts, the RESTSharp library, and how it can be used to work with RESTful APIs in ASP.NET 6. We’ll...
PostgreSQL Primary Key: CREATE and ALTER TABLE Statements
Referential Integrity is a must when it comes to proper relational database design. The consistent usage of primary keys can help you ensure the...
Implementing Rate Limiting in ASP.NET 6 Core and C#
Throttling and rate limiting restrict API access, but they serve different purposes. While rate limiting can limit API usage to ensure stability, throttling prevents...
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...
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...
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...
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...
5 Simple Tips for PostgreSQL Data Access Components in 2023
In this article, we would like to introduce one of the rock-solid sets of data access components - the PgDAC or PostgreSQL data access...
What is the Difference Between Schema and Database?
Today, we are going to talk about whether schema and database is the same. To be more precise, we will describe the main differences...
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...
PostgreSQL vs MySQL/MariaDB Comparison: Differences, Performance, and Syntax
When it comes to choosing the database management system (DBMS), questions arise. You need the one that will match your needs and deliver the...
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...
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...
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.
With Devart ODBC drivers, you can access various data sources to view and...
