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 […]
5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways
/0 Comments/in 2ndQuadrant, Britt's PlanetPostgreSQL, International News /by Britt ColeIf you are eager to learn new competencies or advance your skills in PostgreSQL and other Open Source programs, platforms, and languages, you should join us at the 5432…MeetUs! conference! Between the workshop track offered during the conference and the optional trainings offered in the two days following the conference, it looks like there will be something […]
Second Edition of 5432…MeetUs!
/0 Comments/in 2ndQuadrant, Britt's PlanetPostgreSQL, International News /by Britt ColeThe second edition of the 5432…MeetUs! conference is sure to be one to remember. They will be hosting PostgreSQL experts, users, and contributors from all over the world. With talks, workshops, and trainings – we are sure to stay busy every minute! With speakers like Zalando’s Valentine Gogichasvili and IBM’s Andrea Vercellini, it will be […]
Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!
/0 Comments/in 2ndQuadrant, International News /by Britt ColeKeynote speakers are always something everyone looks forward to at conferences. We’re particularly looking forward to seeing Dragos Dumitriu team up with our very own Gabriele Bartolini at the 5432…MeetUs! conference in Milan, Italy June 28 and 29. Dragos Dumitriu is an industry leader in the Agile community and renowned Kanban expert – helping to improve […]
Using Java Object Oriented Querying (jOOQ) with PostgreSQL
/5 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidjOOQ is an ORM-alternative that is relational model centric rather than domain model centric like most ORMs. For example, while Hibernate lets you write Java code and then automatically translates it to SQL, jOOQ let’s you write relational objects in your database using SQL and then automatically generates Java code to map to those relational […]
PgDay France 2016
/1 Comment/in Simon's PlanetPostgreSQL /by Simon Riggs31 May 2016 – http://pgday.fr/ PgDay France was a well attended conference with more than 140 attendees, with many presentations from PostgreSQL users further demonstrating just how popular PostgreSQL is now. It was good to see a large well organized conference in Lille, the “capital of Northern France”. Lille is an industrial hub and university […]
Application users vs. Row Level Security
/15 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraA few days ago I’ve blogged about the common issues with roles and privileges we discover during security reviews. Of course, PostgreSQL offers many advanced security-related features, one of them being Row Level Security (RLS), available since PostgreSQL 9.5. As 9.5 was released in January 2016 (so just a few months ago), RLS is fairly […]
JSONB and PostgreSQL 9.5: with even more powerful tools!
/2 Comments/in Featured, Rubens' PlanetPostgreSQL /by Rubens SouzaPostgreSQL 9.5 has introduced new JSONB functionalities, greatly improving its already present NoSQL characteristics. With the inclusion of new operators and functions, now it is possible to easily modify the JSONB data. In this article these new modifiers will be presented together with some examples of how to use them.
Using Hibernate Query Language (HQL) with PostgreSQL
/5 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidIn my previous blog, I talked about using Java arrays to talk to PostgreSQL arrays. This blog is going to go one step further in using Java against the database. Hibernate is an ORM implementation available to use with PostgreSQL. Here we discuss its query language, HQL. The syntax for HQL is very close to […]
PostgreSQL-based application performance: latency and hidden delays
/2 Comments/in Craig's PlanetPostgreSQL, PostgreSQL /by craig.ringerIf 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 […]
Barman 1.6.1 is Released
/0 Comments/in Barman, Britt's PlanetPostgreSQL, International News /by Britt Cole2ndQuadrant is proud to announce the release of Barman version 1.6.1, a Backup and Recovery Manager for PostgreSQL.