pg.ddx.io  pgsql-announce@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: myDBR.com via PostgreSQL Announce <announce-noreply@postgresql.org>
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
Subject: myDBR 7.7 brings web reporting to PostgreSQL
Date: Thu, 05 Nov 2026 14:40:20 +0000
Message-ID: <179388962066.595142.64332706283306281@wrigleys.postgresql.org> (raw)

**Helsinki, Finland, 2026-10-28** - myDBR.com announced PostgreSQL support in myDBR, its web-based reporting platform for SQL databases. PostgreSQL 12 or later can now hold both myDBR's own objects and the reports, alongside the MySQL, MariaDB and Microsoft SQL Server support that myDBR already has.

## What is myDBR?

myDBR turns SQL into a finished reporting portal. A developer writes the report logic in the database. myDBR supplies the web interface: parameter forms, tables, charts, maps, drill-downs, scheduling, user management and export to Excel, PDF and CSV. Users need only a browser, and there is no separate report designer or proprietary query language to learn. If you can write a query, you can publish a report.

## What PostgreSQL support covers

* **Reports as PL/pgSQL functions.** A report is a function that returns one cursor per result set. Titles, charts, tables, tabs and maps are each a result set, so one function can build a full report page.
* **Simple installation.** The web installer creates the role and database, and runs the creation script as a single transaction, so a failure leaves nothing half installed. myDBR can live in its own schema next to your data, which suits PostgreSQL's one-database-per-connection model.
* **Row-level security.** myDBR can pass the logged-in user to PostgreSQL, or run each report as that user's database role. The database itself then decides which rows a user sees, and a copied or modified report cannot show more than the user is allowed to see.
* **Report timeouts and a running-reports view.** Administrators can set global or per-report limits using `statement_timeout` and `lock_timeout`. They can also see the reports running now and cancel them.
* **Developer tools.** The SQL Editor, query plan viewer (`EXPLAIN`), data browser, query builder, synchronization between servers, Git version control and the AI report assistant all work with PostgreSQL.

## Requirements

PostgreSQL 12 or later (14 or later recommended), PHP 8.0 or later with the `pgsql` extension, and the `citext` contrib extension.

## Availability

PostgreSQL support is included in myDBR 7.7. Documentation, including an installation guide and a PL/pgSQL report tutorial, is available at [https://www.mydbr.com/doc](https://www.mydbr.com/doc). To learn more and download a trial, visit the [https://www.mydbr.com](myDBR).

## About myDBR

myDBR is developed by myDBR.com. It has been used for database reporting since 2004 and is used by organizations of all sizes to publish reports from their SQL databases to the web.

Message-ID: <179388962066.595142.64332706283306281@wrigleys.postgresql.org>
Permalink:  ../179388962066.595142.64332706283306281@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/179388962066.595142.64332706283306281@wrigleys.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-announce@postgresql.org
  Cc: announce-noreply@postgresql.org, pgsql-announce@lists.postgresql.org
  Subject: Re: myDBR 7.7 brings web reporting to PostgreSQL
  In-Reply-To: <179388962066.595142.64332706283306281@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox