PostgreSQL (also known as Postgres ) is the world’s most popular and advanced open-source enterprise-grade object-relational database management system (ORDMS). PostgreSQL has a broad variety of community and commercial support choices accessible for users.
The PostgreSQL community and other online learning resource providers, provide many helpful resources to become familiar with PostgreSQL, discover how it works, and learn/master how to use it.
In this article, we will share useful websites and online resources about PostgreSQL.
1. The Official PostgreSQL Website
The first place to go is https://www.postgresql.org/, the home of PostgreSQL, which contains a wealth of information about PostgreSQL, including how to install and use it.
Here are some useful links/pages:
- Official Documentation – a page with links to the official documentation for different versions of PostgreSQL.
- PostgreSQL Downloads – a page that comes with some useful links to PostgreSQL packages and installers.
- Software Catalogue (Product Categories) – a page that helps you get PostgreSQL-related interfaces, extensions, and software accessible from a broad variety of Open Source projects, companies and users, that you need.
- PostgreSQL Wiki – a page that contains user documentation, how-tos, and tips ‘n’ tricks related to PostgreSQL.
- Planet PostgreSQL – a blog aggregation service run by the PostgreSQL community.
Besides you can also reach out to the PostgreSQL community here.
Secondly, we have 2ndQuadrant. Founded in 2001 by Simon Riggs (a major developer of the PostgreSQL project) but recently acquired by EDB (Enterprise DB). 2ndQuadrant is a leading sponsor of the PostgreSQL project, not to mention over 20% of the PostgreSQL code is written by 2ndQuadrant engineers. It is the largest and globally recognized organization of experts of PostgreSQL solutions, services, and training.
3. PostgreSQL Tutorial
As the name reads, PostgreSQL Tutorial is a useful and popular website for PostgreSQL tutorials that helps you understand PostgreSQL fast and easily. It is dedicated to developers and database administrators who are working on the PostgreSQL database management system. They provide resources to get you started with PostgreSQL quickly and effectively.
Tutorialspoint has a useful tutorial about PostgreSQL, prepared for beginners to help them understand the basic to advanced concepts related to PostgreSQL Database. It will give you a quick start with PostgreSQL and make you comfortable with PostgreSQL programming and more.
w3resource also has PostgreSQL tutorials that provide an online PostgreSQL course that includes relational database concepts, interview questions, and quizzes to help you better understand the PostgreSQL language.
You can also know more about Postgres and learn how to use it from the PostgreSQL tutorial on Guru99.com. It is designed for beginners with little or no PostgreSQL experience.
7. Postgres Guide
Postgres Guide is a helpful guide maintained on a “best effort basis”. It is designed as an aid for beginners as well as experienced users to find specific tips and explore tools available within the Postgres ecosystem.
PGTune is an online tool to help you generate the configuration for PostgreSQL based on the maximum performance for a given hardware configuration. However, according to the PGTune about page, the tool is not a silver bullet for the optimization of PostgreSQL because there are so many things to consider for full PostgreSQL database system optimization including, but not limited to hardware configurations.
9. Postgres Weekly
Postgres Weekly is a weekly email roundup to which you can subscribe to receive PostgreSQL news and articles.
We at Tecmint.com provide PostgreSQL guides too, such as installation and basic configuration of the PostgreSQL database system and other related administrative/development tools including pgAdmin, on mainstream Linux distributions.
That’s all! In this article, we have shared websites that provide many helpful resources to become familiar with the PostgreSQL database system, discover how it works, and learn how to use it. If you know of any website or online resource we need to add here, let us know via the feedback form below.