PostgreSQL Developer Tools and Scripts for Node.js, PHP, Python, Go and Java

PostgreSQL developer's resources consist of PostgreSQL installation and configuration guide, training materials, deployment, and use cases, example scripts, codes, tips, and tricks to interact with PostgreSQL from different programming languages such as PHP, Python, Golang, Java, and Node.js.

How to use EXPLAIN ANALYZE for Planning and Optimizing Query Performance in PostgreSQL

Richard Yen · April 30, 2020

With many people working from home these days because of the coronavirus pandemic, it can be a little challenging to get help from a colleague...

Why Django is so impressive for developing with PostgreSQL and Python

Navnath Gadakh · April 15, 2020

This post gives you a brief idea about why you should use PostgreSQL as a backend database with Django. It also describes how to use it and the benefits of using PostgreSQL with Django.

PostgreSQL query tuning checklist

Tushar Ahuja · April 6, 2020

This article offers a checklist of tools available for improving PostgreSQL query performance.

How to quickly build an API using Node.js & PostgreSQL

EDB Team · February 20, 2020

This article describes how you can use Node.js and PostgreSQL to create an API and provides an example for how to create a table.

Connecting to PostgreSQL using PHP

Abhishek Deb · February 19, 2020

This article reviews the steps necessary for connecting to a PostgreSQL database using PHP.

How to use PostgreSQL with Go

Richard Yen · January 9, 2020

This article covers how to use PostgreSQL together with the programming language Golang (Go). After showing how to get started with Go’s Object Relational Mapper, it offers an example of setting up a PostgreSQL database using Go.

How to use Java to create a table in PostgreSQL

Ranjeet Dhumal · December 30, 2019

This article shares a sample Java program that can be used to create a table in PostgreSQL.

How to use PostgreSQL with Django

Richard Yen · December 30, 2019

This article covers how to use PostgreSQL together with the Python web application framework Django. After walking through the Django installation process it shows how to get started creating a simple Django application.

10 Tools every developer should have when working with PostgreSQL

Tushar Ahuja · December 20, 2019

This article lists 10 open source tools to help developers working with PostgreSQL.

How to use PostgreSQL with Laravel

Richard Yen · December 19, 2019

This article covers how to use PostgreSQL together with the PHP framework Laravel to deploy web applications. After walking through the Laravel installation process it shows how to get started and create tables.

Why Do We Install Software As Root ?

Dave Page · September 11, 2018

Why do we install as root? A couple of common questions I hear from customers (usually long-time users of a particular database from Redwood) via our...

Index Corruption in PostgreSQL: The Hidden Cost of Your Queries

Ajay Patel · May 7, 2020

A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The...

How to make queries faster with multicolumn indexes

Ranjeet Dhumal · March 25, 2020

This article introduces multicolumn indexes and explains how they can by used to make large queries run faster.

How to implement faceted search with Django and PostgreSQL

Navnath Gadakh · March 24, 2020

This article discusses the advantages of faceted search and how to create a faceted search using Django and PostgreSQL.

The Future of Postgres in a Multi-Cloud World: A Developer Perspective

Marc Linster · March 3, 2020

The annual PGConf India conference just took place in Bengaluru on February 26-28, where EDB had seven of its experts speaking—including a keynote...

How to call PostgreSQL stored procedures from a PHP application

Abbas Butt · February 19, 2020

This tutorial provides instructions and an example for calling a PostgreSQL stored procedure from a PHP application.

How to work with Blobs when using PostgreSQL and PHP

Abbas Butt · February 19, 2020

This tutorial provides instructions and an example for converting large files like images into binary large objects (blobs) that can be stored in a PostgreSQL database using PHP.

How to use clauses when querying data (FROM, WHERE, GROUP BY, HAVING, BETWEEN, LIKE, FETCH)

Arun Gavhane · February 19, 2020

This article discusses the use of clauses in PostgreSQL queries to filter and organize data in results. It introduces different clauses and provides examples of their usage.

How to query PostgreSQL data using the SELECT statement in Java

Ranjeet Dhumal · January 2, 2020

This article provides instructions for querying data using the PostgreSQL SELECT statement in Java.

How to use tables and column aliases when building a PostgreSQL query

Prabhat Sahu · January 2, 2020

This article explains how to use table and column aliases in PostgreSQL to create more meaningful queries.

How to combine multiple queries into a single result set using UNION, INTERSECT, and EXCEPT

Thom Brown · December 6, 2019

This article discusses methods for comparing and combining multiple queries into a single result set in PostgreSQL.

Using SELECT to query data from a single table and multiple tables

Hrishikesh Gore · December 6, 2019

This article covers the SELECT statement in PostgreSQL and how to use it to query data from single and multiple tables

How to select distinct values from query results in PostgreSQL

Tushar Ahuja · December 4, 2019

In this post, we are going to see how to select distinct values from SQL queries/statements. One of the easiest ways to select distinct values is using the DISTINCT keyword.

Indexing Documents for Full Text Search in PostgreSQL

Dave Page · November 6, 2019

During a conversation with $BOSS a couple of days ago the topic of the new Full Text Search in MongoDB came up. He (knowing of, but presumably having never worked with FTS in PostgreSQL) suggested I might create a tool like the one the MongoDB guys were proudly showing off in their keynote video from their recent conference to make it easy to index and search HTML documents on disk.

pgbouncer auth_query and auth_user pro tips

Richard Yen · November 6, 2019

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep resource usage under control. PgBouncer is one such tool, and it’s great because it’s lightweight and yet has a handful of nifty features for DBAs that have very specific needs.

jsquery vs SQL/JSON

Thom Brown · August 30, 2019

SQL/JSON is coming to PostgreSQL 12 and provides a native way to query JSON data (although, to be specific, JSON data stored as a JSONB data type)...

Postgres Developer Tools: 6 Things You Should Know

EDB Team · May 16, 2019

Postgres Sees a Sharp Rise in Popularity with Developers For a long time now, PostgreSQL has been one of the most frequently deployed relational...

JDBC logging using java.util.logging

Eric McCormack · March 26, 2019

The EnterpriseDB JDBC Driver supports the use of logging (or tracing) to help resolve issues with the JDBC Driver when is used in your application...

How to Plan Queries Involving Foreign PostgreSQL Tables

Ashutosh Bapat · July 3, 2018

Cost based optimization A query may be executed in many different ways, modeled as plans in query optimizer, differing in resources required and/or...

How to use Xmin in PostgreSQL Queries

Bruce Momjian · December 5, 2017

Someone at a conference mentioned they were using the invisible xmin column to perform updates. I was initially skeptical of this approach, but once he explained the purpose, it made sense.

PL/Java Adoption

Bruce Momjian · September 19, 2017

PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java...

Using Java to Manipulate SQL Structures and Arrays

Dick Dowdell · November 6, 2015

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } The only data structure recognized in...

React.js vs. Vue.js: Choosing a Web Framework in 2020

Sergey Krivov · February 13, 2020

Deciding on a development framework for a new project is often done ad hoc, based on the available expertise and personal preferences of the...

Query Plan Improvement with Expression Indexes in PostgreSQL

Bruce Momjian · November 7, 2019

Most people know that Postgres allows the creation of indexes on expressions. This is helpful if you need index lookups of expressions used in where clauses. However, there is another benefit to expression indexes, and that is optimizer statistics. Not only do expression indexes allow rapid lookups of matching expressions, but they also provide optimizer statistics, which improve row estimates and hence query plans.

Partition-wise Joins: “Divide and Conquer" for Joins Between Partitioned Table

Ashutosh Bapat · January 2, 2018

Unlike inheritance-based partitioning, declarative partitioning introduced in PostgreSQL 10 leaves nothing to infer about how the data is divided into...

How to install PostGIS on EDB Postgres Advanced Server

Phil Allsopp · May 8, 2019

PostGIS is a spatial extender for Postgres and adds more geometric types and spatial functionality to Postgres. You can use PostGIS to easily calculate distances between geometric objects, examples of which are points, lines, and polygons; you can easily calculate areas, whether one or more points sit within any geometric shapes.

Us and Them: The DBA – Developer Conflict

Jan Karremans · May 3, 2019

Us (us, us, us, us) and them (them, them, them, them) And after all we're only ordinary men - Wright/Waters Database Administrator vs Developer “Us...

Installing and running EDB Postgres Advanced Server cluster on RHEL 6 or RHEL 7

Haris Iftikhar · March 27, 2019

Quickly (less than five minutes) install and run a default EPAS 11 cluster on RHEL 6 or RHEL 7

Get Postgres tips & tricks

Subscribe to our newsletter to get advanced Postgres how-tos.

Related Tutorials

Featured Webinar

Programming the SQL Way with Common Table Expression

This webinar will compare jquery and SQL/JSON by discussing: The similarities and differences between the two features, the equivalent functionality where they aren't identical, and examples of how they compare in practice

Watch Now

Introducing Postgres Pulse Live

Free To Attend: Every other Monday 11AM ET

A biweekly blog and live video forum series built to offer insight into how we analyze problems and develop solutions using Postgres.

About Postgres Pulse Live

6 Things a Developer Should Know About Postgres

In this tech guide, we describe the six things a developer should know about in terms of how easy it is to install, work with, and deploy Postgres as well as the unique capabilities and wide range of features that Postgres offers.

Download Now