PostgreSQL

PostgreSQL | News, how-tos, features, reviews, and videos

elephant sunlight forest africa tusk ivory sasint via pixabay
Two figures within a data center / server maze, strewn with clouds.

elephant sunlight forest africa tusk ivory sasint via pixabay

PostgreSQL 16 advances query parallelism

Next major release of the major open source relational database, now in beta, brings performance improvements to query execution and to logical replication.

black footed ferret american polecat steve tsang unsplash

Open source FerretDB offers ‘drop-in replacement’ for MongoDB

FerretDB 1.0 is a stateless proxy that converts MongoDB protocol queries to SQL, using PostgreSQL as the database engine.

elephant desert tusk ivory postgresql

Google ambushes on-prem PostgreSQL with AlloyDB Omni

Google is previewing a downloadable, ML-tuned version of its PostgreSQL-compatible AlloyDB, which it claims is 2x faster than standard Postgres for transactional workloads and 100x faster for analytical queries.

networking abstract

EDB’s Postgres Distributed 5.0 boosts availability, performance

The distributed version of the open source, object-relational database system is available as an add-on, dubbed EDB Extreme High Availability, for EDB Enterprise and Standard plans, the company said.

Google Cloud

Google makes AlloyDB for PostgreSQL available in 16 new regions

The PostgreSQL-compatible, fully managed database-as-a-service will come with a new feature called cross-region replication, which is currently in private preview.

digital screen with encryption data background big data with binary picture id1332211233

EnterpriseDB adds Transparent Data Encryption to PostgreSQL

The new Transparent Data Encryption (TDE) feature will be shipped along with the company’s enterprise version of its database.

13 small business security

How Steampipe enables KPIs as code

CMD Solutions built tools for continuous controls assurance by using open-source Steampipe to define information security performance metrics as SQL statements.

error neon mistake

10 common PostgreSQL mistakes and how to avoid them

PostgreSQL was built to handle a wide range of use cases, but flexibility also has a flip side. Make sure you’re not making these all-too-common design, configuration, tuning, and other mistakes.

Computerworld's 100 Best Places to Work in IT [2017] - Welcome to the Club

AWS is changing

Announcements at AWS re:Invent show a kinder, gentler Amazon, ready to integrate its own services and third-party data sources.

elephant desert tusk ivory postgresql

3 key features in EDB PostgreSQL 15

Thoroughly tested on PostgreSQL 15.1, EDB’s new tools optimize performance, scalability, reliability, and operability. Here are the highlights.

easy simple pixel hand computer pointer

Postgres is eating relational

It’s hard to compete with easy. PostgreSQL has a lot of great qualities, but being easy to use seals the deal for companies and consultants.

networking abstract

PostgreSQL 15 streamlines workload management, improves performance

The new features of the most popular open-source database include improved sort and compression, the MERGE command, and other workload management tools.

datacenter servers warehouse database

Materialize offers early release of its streaming database as a service

The startup's managed, distributed database service is designed to run queries against real-time data in a more cost-efficient manner than batch processing systems.

Binary stream passing over rows of monitors, each also displaying binary streams.

Visualizing the Hacker News API with HCL and SQL

Use Steampipe and GitHub Actions to create a ‘dashboard as code’ for exploring thousands of Hacker News stories, right up to the current hour.

database abstract network innovation

Yugabyte adds Voyager migration service to its 2.15 database update

With the latest update, the company claims it is the first and only distributed SQL database to offer all three PostgreSQL isolation levels.

A lost businessman wanders amid conflicting directional signs through the fog.

Tired of searching Slack, GitHub, and Google Drive separately? Do it all at once in SQL

When APIs are automatically database tables, it’s easy to combine search results from diverse APIs.

Google Cloud

Why Google Cloud is battling AWS, Azure, in the red-hot PostgreSQL market

Google Cloud's AlloyDB for PostgreSQL has moved into public preview, and as a Postgres-compatible, fully managed DBaaS (database-as-a-service), will take on offerings from AWS and Microsoft in the hot PostgreSQL market.

mismatched shoes

Do your AWS deployments match your Terraform definitions? Use SQL to find out.

For belt-and-suspenders security and compliance, use SQL to query your Terraform files in the same way you query your AWS, Azure, or GCP services.

Load More