Relational Databases
Relational Databases | News, how-tos, features, reviews, and videos
Oracle adds machine learning features to MySQL HeatWave
In addition to updating MySQL HeatWave’s AutoML and Autopilot, Oracle will now offer a small shape for the service, targeting customers with smaller volumes of data.
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 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.
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.
5 key new features in SingleStoreDB 8.0
The latest release of the unified database for transactional and analytical processing brings real-time analytics for JSON data, Wasm support, dynamic scaling, and security and UX improvements.
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.
How vectorization improves database performance
Although a serious engineering challenge, database vectorization delivers orders-of-magnitude performance boosts for a real-time analytics engine such as StarRocks. Here’s how we did it.
10 more essential MySQL performance tuning tips
Schema design, indexes, queries, configs, I/O... what could go wrong? Follow these 10 essential tips to keep your MySQL servers humming.
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.
Oracle debuts MySQL HeatWave Lakehouse to take on rivals
The new lakehouse service, designed to quickly load and query up to 400TB of data, will compete with offerings from Oracle rivals that have also jumped on the lakehouse concept, including Snowflake, Google, AWS and Microsoft Azure.
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.
Oracle MySQL HeatWave comes to AWS
Oracle’s MySQL database service supporting mixed analytical, transaction processing, and machine learning workloads is now available on Amazon Web Services.
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.
Why database design choices matter to developers
Rather than punt database design decisions to a cloud service or third-party provider, understand what you want to achieve and how best to deliver on that goal.