PostgreSQL
PostgreSQL | News, how-tos, features, reviews, and videos
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.
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.
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.
AWS is changing
Announcements at AWS re:Invent show a kinder, gentler Amazon, ready to integrate its own services and third-party data sources.
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.
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.
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.
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.
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.
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.
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.
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.
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.
JSONB in PostgreSQL today and tomorrow
PostgreSQL was the first relational DBMS to introduce JSON support, and its JSONB index search capability is unique. More is on the way.
How SQL can unify access to APIs
PostgreSQL foreign data wrappers are a great way to expose APIs to SQL. And SQL is a great way to reason over the data.
PostgreSQL 14 brings performance boosts
Query pipelining, query parallelism, and other optimizations help speed heavy, high-connection, and distributed workloads.
PostgreSQL benefits and challenges: A snapshot
PostgreSQL continues to improve in ways that meet the needs of even the most complex, mission-critical use cases. It also presents certain challenges.