The 2018 StackOverflow survey has just been published, with good news for PostgreSQL. http://insights.stackoverflow.com/survey/2018/#technology-most-loved-dreaded-and-wanted-databases StackOverflow got more than 100,000 responses from people in a comprehensive 30 minute survey. PostgreSQL is the third most commonly used database, with 33% of respondents, slightly behind MySQL and SQLServer, yet well ahead of other options. Early in January, the DBEngines […]
Partition Elimination in PostgreSQL 11
/16 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David RowleyThe feature freeze for the PostgreSQL 11 release is now upon us. During the last few days my colleague Álvaro Herrera pushed two changes into the development branch of PostgreSQL: 1. Faster Partition Pruning 2. Partition Pruning at Execution Time These patches aim to improve the performance and usability of the declarative table partitioning feature […]
Using Java Database Interface (jDBI) with PostgreSQL
/0 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair ShahidjDBI is designed to be the middle ground between high level ORMs like JPA & Hibernate on one hand and raw JDBC on the other. You can think of it as a layer of convenience on top of JDBC that is still at a lower level than ORMs. When working with JDBC, you are exposed […]
Power of Indexing in PostgreSQL [Webinar Follow-up]
/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiGiven the massive size, complexity, and performance requirements of most databases, having an optimized database is critical for many organizations. A variety of different strategies are used for database performance enhancement – indexing being one of them. Since indexing is such a key component to database performance, 2ndQuadrant chose to highlight the power of indexing […]
PGConf APAC 2018 – bigger & better each year
/0 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair ShahidLast week saw the 3rd event in as many years in Singapore, and yet this time something was very different. For the last 2 years, we had been conducting the conference as a PostgreSQL track with FOSSASIA. This year, we were able to pull off an entirely independent, 2-day event completely focused on PostgreSQL! The event kicked […]
Don’t be hard-headed… Harden your PostgreSQL database to ensure security
/0 Comments/in 2ndQuadrant, Britt's Marketing /by Britt ColeWhen it comes to database security, the risk is definitely not worth the reward. Being hard-headed about database security procedures can not only disrupt your business and cost you millions, but it can make irreparable damage to your customer relationship and public identity. How important is the security of your data to your organization Nearly […]
Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
/5 Comments/in 2ndQuadrant, DevOps, Featured, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL /by Gulcin YildirimLast week, I was at Nordic PGDay 2018 and I had quite a few conversations about the tool that I wrote, namely pglupgrade, to automate PostgreSQL major version upgrades in a replication cluster setup. I was quite happy that it has been heard and some other people in different communities giving talks at meetups and other […]
Prague PostgreSQL Meetup
/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, International News, PostgreSQL, User Group /by Gulcin YildirimLast month, I was at 2ndQuadrant booth at P2D2, an annual conference organized in Prague by local user group called CSPUG (Czech and Slovak PostgreSQL User Group). The conference was certainly a huge success and more than 200 people showed up! Meeting a lot of PostgreSQL enthusiasts in town, I wondered why there are no regular meetups […]
Using EclipseLink with PostgreSQL
/0 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair Shahid1. Introduction EclipseLink was announced in 2008 as the JPA 2.0 implementation from the Eclipse Foundation. It is based on the TopLink project from which then Oracle contributed code to the EclipseLink project. The project delivers an open source runtime framework supporting the Java Persistence API standards. The EclipseLink project provides a proven, commercial quality […]
PostgreSQL – The most loved RDBMS
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsThe 2018 StackOverflow survey has just been published, with good news for PostgreSQL. http://insights.stackoverflow.com/survey/2018/#technology-most-loved-dreaded-and-wanted-databases StackOverflow got more than 100,000 responses from people in a comprehensive 30 minute survey. PostgreSQL is the third most commonly used database, with 33% of respondents, slightly behind MySQL and SQLServer, yet well ahead of other options. Early in January, the DBEngines […]
Using Java ORMs with PostgreSQL – MyBatis
/6 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair ShahidIn my previous blogs, I wrote about Hibernate Query Language (HQL) and Querydsl in detail, now I’m going to talk about MyBatis. While ORMs typically map Java objects to database tables (or vice versa), MyBatis takes a different approach by mapping Java methods to SQL statements. This gives you complete control over writing SQL and its […]