1. Introduction Being a web application, OmniDB is composed of many webmethods. A webmethod is a special kind of function hosted on the server side (the web server), called from the client side (the web browser), when the user performs some action on OmniDB web interface. For instance, OmniDB has several webmethods that know how to […]
The Barman is ready for PostgreSQL 10
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniToday our Devops team at 2ndQuadrant, led by my dear friend and trusted colleague Marco Nenciarini, released version 2.3 of Barman.
OmniDB: Average execution time of PostgreSQL webmethods
/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski1. Introduction Being a web application, OmniDB is composed of many webmethods. A webmethod is a special kind of function hosted on the server side (the web server), called from the client side (the web browser), when the user performs some action on OmniDB web interface. For instance, OmniDB has several webmethods that know how to […]
JOOQ Object Oriented Querying (jOOQ)
/2 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 […]
Kanban & devops culture at 2ndQuadrant – Part 3
/0 Comments/in DevOps, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniIn Part 3 of this series (here are Part 1 and Part 2), I would like to demonstrate how the development of a new feature for Barman would flow through the Kanban board.
PG Phriday: Smooth Operator
/3 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasOne of the handy things Oracle does with dates is allow manipulation with standard arithmetic. Want tomorrow's date? Add one. Want a week ago? Subtract seven. Postgres does something close with its INTERVAL syntax, under the explanation that we don't necessarily want to make assumptions about what is being added to a date or timestamp. […]
Barman 2.2 and the magic of parallel copy
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniBarman 2.2 introduces support for parallel copy, by improving performance of both backup and recovery operations in your PostgreSQL disaster recovery solution.
PG Phriday: Crazy Correlated Column Crusade
/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasFor a long time, the Postgres query planner has sported a huge blinking neon blind-spot that frustrated and enraged DBAs throughout the universe to a level just shy of murderous frenzy. How is this even possible? What terrible lurking horror could elicit such a visceral response from probably the most boring and straight-laced people ever […]
News and Roadmap for BDR (Multi-master PostgreSQL)
/28 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsPostgres-BDR is an open source project from 2ndQuadrant that provides multi-master features for PostgreSQL. We have pursued a joint strategy of providing both working code available now and also submitting the features into core PostgreSQL. Postgres-BDR 1.0 runs on a variant distro of PG9.4. This is in Production now and receives regular maintenance and security […]
News and Roadmap from Postgres-XL 10
/6 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeWe expect Postgres-XL 10 to be released in the next few months, with the new features of partitioning and logical replication. You’ll be able to load Postgres-XL directly from PostgreSQL. For the first time, you’ll be able to run massively parallel queries both across the datanodes and within the datanodes to give huge performance gains. […]
PG Phriday: Uptown Func
/5 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasOne of the coolest things about Postgres functions is that they can return rows as if they were a table. Not only is it possible, but creating a set-returning function in Postgres is almost frighteningly trivial when compared to other database engines. In fact, some Oracle users are probably rolling their eyes and muttering “Just […]