Last 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...
When 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...
Last 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...
Last 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...
1. 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 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...
In 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...
Two serious security vulnerabilities (code named Meltdown and Spectre) were revealed a couple of weeks ago. Initial tests suggested the performance impact of mitigations (added in the kernel) might be...
PostgreSQL uses error context callbacks to allow code paths to annotate errors with additional information. For example, pl/pgsql uses them to add a CONTEXT message reporting the procedure that was...
Various limits on the PostgreSQL database are listed here: http://www.postgresql.org/about/ One of those limits is the Maximum Table Size, listed as 32TB. It’s been that way for many years now...
