java Archives - 2ndQuadrant

Posts

RESTful CRUD API using PostgreSQL and Spring Boot – Part 2

June 16, 2020/0 Comments/in Haroon's PlanetPostgreSQL /by Muhammad Haroon

Overview This article is an extended version atop of the previous article which was a kickstart for building an application using Spring Boot and PostgreSQL. There is no internal feature supported by Java which offers mapping between class objects and database tables; therefore, we use Object Relational Model (ORM). JPA is an abstraction above JDBC […]

RESTful CRUD API using PostgreSQL and Spring Boot – Part one

June 8, 2020/0 Comments/in Haroon's PlanetPostgreSQL /by Muhammad Haroon

Overview Spring Boot is a framework that is used to build stand-alone Java applications following the Spring framework but with less hassle and minimal configuration. Learning by practical examples is always great; therefore, this article will walk you through the creation of a RESTful CRUD (create-read-update-delete) application using Spring Boot and its connectivity with PostgreSQL. […]

Processing PostgreSQL JSON & JSONB data in Java

February 8, 2017/6 Comments/in Umair's PlanetPostgreSQL /by Umair Shahid

This is part of a series of blogs on Java & PostgreSQL. For links to other blogs in this series, please scroll to the end of this post. Starting v9.2, PostgreSQL is providing native data type support for JSON objects. Subsequent releases introduced JSONB (binary formatted JSON objects) and many data manipulation functions for JSONs, […]

PostgreSQL-based application performance: latency and hidden delays

May 23, 2016/2 Comments/in Craig's PlanetPostgreSQL, PostgreSQL /by craig.ringer

If you’re trying to optimise the performance of your PostgreSQL-based application you’re probably focusing on the usual tools: EXPLAIN (BUFFERS, ANALYZE), pg_stat_statements, auto_explain, log_statement_min_duration, etc. Maybe you’re looking into lock contention with log_lock_waits, monitoring your checkpoint performance, etc too. But did you think about network latency? Gamers know about network latency, but did you think […]

Compiling and debugging PostgreSQL’s PgJDBC under Eclipse

September 24, 2014/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

I’ve always worked on PgJDBC, the JDBC Type 4 driver for PostgreSQL, with just a terminal, ant and vim. I recently had occasion to do some PgJDBC debugging work on Windows specifics so I set up Eclipse to avoid having to work on the Windows command prompt. As the process isn’t completely obvious, here’s how […]

Setting JDBC with Greenplum

January 19, 2012/1 Comment/in Greenplum /by Carlo Ascani

JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation. In this short article we’ll see how to use it.

Posts

RESTful CRUD API using PostgreSQL and Spring Boot – Part 2

RESTful CRUD API using PostgreSQL and Spring Boot – Part one

Processing PostgreSQL JSON & JSONB data in Java

PostgreSQL-based application performance: latency and hidden delays

Compiling and debugging PostgreSQL’s PgJDBC under Eclipse

Setting JDBC with Greenplum

Support & Services

Products

Postgres Learning Center

About Us