Software — Database — February 14th, 2025
Critical PostgreSQL bug tied to zero-day attack on US Treasury
High-complexity bug unearthed by infoseccers, as Rapid7 probes exploit further
February 14, 2025 — Source
PostgreSQL flaw exploited as zero-day in BeyondTrust breach
Rapid7's vulnerability research team says attackers exploited a PostgreSQL security flaw as a zero-day to breach the network of privileged access management company BeyondTrust in December.
February 14, 2025 — Source
Software — Database — February 10th, 2025
SQL Dynamic Data Masking for Privacy and Compliance
SQL Server Dynamic Data Masking helps protect sensitive data by obscuring it from non-privileged users, ensuring compliance with GDPR, HIPAA, and PCI-DSS.
February 10, 2025 — Source
Software — Database — February 7th, 2025
Control Your Services With OTEL, Jaeger, and Prometheus
In this article, we will combine OTEL, Jaeger, and Prometheus for faster, centralized observability and quick troubleshooting in distributed systems.
February 7, 2025 — Source
Data Management With PostgreSQL Partitioning and pg_partman
PostgreSQL table partitioning divides large tables into smaller segments to boost query performance, simplify maintenance, and enable scalable data management.
February 7, 2025 — Source
Software — Database — February 5th, 2025
Demystifying Sorting Assertions With AssertJ
Know the options for sorting assertions in AssertJ, including ascending/descending order, multiple attributes, null handling, and case-insensitive sorting.
February 5th, 2025 — Source
Software — Database — February 3rd, 2025
All You Need to Know About Apache Spark
Apache Spark is a fast, open-source cluster computing framework for big data, supporting ML, SQL, and streaming. It's scalable, efficient, and widely used.
February 3rd, 2025 — Source
Building RAG Apps With Apache Cassandra, Python, and Ollama
A brief introduction to Apache Cassandra for retrieval-augmented generation using Python and Ollama for developing applications free of cost locally or on a server.
February 3rd, 2025 — Source
'Forbidden Words': Github Reveals How Software Engineers Are Purging Federal Databases
A project called "Remove-DEI" shows the tweaks used to remove "forbidden words" from a database about childhood school readiness.
February 3rd, 2025 — Source
MuleSoft OAuth 2.0 Provider: Password Grant Type
Learn to configure MuleSoft as an OAuth 2.0 provider with the Password Grant type, securing APIs and managing user authentication with best practices.
February 3rd, 2025 — Source
Software — Database — January 22nd, 2025
Hybrid Search Using Postgres DB
This article explains how to implement hybrid search (lexical and semantic) in a single PostgresDB using full-text-search and pgvector.
January 22nd, 2025 — Source
Software — Database — January 20th, 2025
AWS declares it's Iceberg all the way until customers say otherwise
Cloud giant explains its thinking behind support for Apache open table format
January 20th, 2025 — Source
Troubleshooting Connection Issues When Connecting to MySQL Server
Resolve MySQL connection issues with step-by-step fixes for errors like access denied, host not allowed, and authentication protocol mismatches.
January 20th, 2025 — Source
Software — Database — January 17th, 2025
Business Logic Database Agent
A natural language agent to create database business logic using declarative rules: an admin web app, API, and database in 1 minute. Download to customize in your IDE.
January 17th, 2025 — Source
Schema Changes Are a Blind Spot
Schema changes and migrations can quickly spiral into chaos, leading to significant challenges. Let's see how to overcome these challenges.
January 17th, 2025 — Source
Software — Database — January 13th, 2025
Copy SQL Execution Plan from One Database to Another in Oracle 19c
In this step-by-step guide, we will cover SQL Plan Management (SPM), exporting or importing plans, and fixing execution plans for consistent query behavior.
January 13th, 2025 — Source
Software — Database — January 10th, 2025
Optimizing SQL Server Performance With AI: Automating Query Optimization and Predictive Maintenance
AI enhances SQL Server performance through query optimization and predictive maintenance, boosts efficiency, reduces latency, and improves system scalability.
January 10th, 2025 — Source
Software — Database — January 9th, 2025
10 Power BI Techniques to Take Your Reports to The Next Level
Have you ever found yourself staring at a mountain of data, wondering how to make sense of it all? Maybe you've already dipped your toes into Power BI and discovered its potential to transform raw numbers into meaningful insights. But now, you're ready to take things up a notch—to move beyond the basics and create reports that don't just inform but truly engage.
January 9th, 2025 — Source
Formulating a Robust Strategy for Storage in Amazon Relational Database Service PostgreSQL Deployments
This article explores understanding the key components of RDS storage, optimizing these storage factors, and capping storage growth by utilizing retention periods.
January 9th, 2025 — Source
High Performance Time - Series Database Design with QuestDB
Vlad Ilyushchenko discusses database design and focuses on geographical data distribution, simplifying data pipelines with HA writes, data visualization with SQL extensions, and providing data scientists with scalable data access.
January 9th, 2025 — Source
Software — Database — January 8th, 2025
UN's aviation agency confirms attack on recruitment database
Various data points compromised but no risk to flight security
January 8th, 2025 — Source
Software — Database — January 7th, 2025
Testing Is a Cross-Cutting Concern; So Are Databases
It’s essential to test all database changes cohesively throughout the pipeline. Let’s explore how this can be achieved with a modern approach.
January 7th, 2025 — Source
Software — Database — January 3rd, 2025
ToDoList 9.0 adds Attribute Editor and MySQL import support amid a host of feature additions
AbstractSpoon Software has unveiled a New Year's gift for fans of its portable Windows to-do manager with the release of ToDoList 9.0.
January 3rd, 2025 — Source
Software — Database — January 2nd, 2025
Optimizing Performance in Azure Cosmos DB: Best Practices and Tips
Optimize performance, minimize costs, and ensure scalability in Azure Cosmos DB with practices like selecting the right partition key and tuning queries.
January 2nd, 2025 — Source
Stop Being Afraid of Databases
Ensuring database reliability can be difficult. Our goal is to speed up development and minimize rollbacks. Achieving efficient processes requires database observability.
January 2nd, 2025 — Source
Software — Database — December 30th, 2024
Setting Up a ScyllaDB Cluster on AWS Using Terraform
This article will teach you how to set up, deploy, manage, and scale ScyllaDB clusters on AWS using Terraform with this comprehensive step-by-step guide.
December 30th, 2024 — Source
Software — Database — December 25th, 2024
The Future of Data Lies in Transformer Models versus Big Data Transformations
Last year witnessed the explosive rise of large models, generating global enthusiasm and making AI seem like a solution to all problems.
December 25th, 2024 — Source
Software — Database — December 13th, 2024
Which Flow Is Best for Your Data Needs: Time Series versus Streaming Databases
While both are used to handle time-related data, their underlying technologies and main purpose are built to serve different purposes.
December 13th, 2024 — Source
Software — Database — December 10th, 2024
In-Depth Analysis of MySQL 8.0 Performance Degradation
We've analyzed the causes of increased response latency in MySQL 8.0. Users can understand the performance decline from both read/write operations and the code level.
December 10th, 2024 — Source
Software — Database — November 21st, 2024
Build Autonomous SQL Databases in Microsoft Fabric
Microsoft Fabric is ushering in a new era of database management through its innovative autonomous SQL databases. These innovative databases are designed to streamline your management tasks while significantly enhancing application development capabilities. By seamlessly integrating operational and analytical data across various cloud environments, Microsoft Fabric is set to transform the way you handle and interact with data.
November 21st, 2024 — Source
Software — Database — November 18th, 2024
How Uber Sped up SQL-based Data Analytics with Presto and Express Queries
Uber uses Presto, an open-source distributed SQL query engine, to provide analytics across several data sources, including Apache Hive, Apache Pinot, MySQL, and Apache Kafka. To improve its performance, Uber engineers explored the advantages of dealing with quick queries, a.k.a. express queries, in a specific way and found they could improve both Presto utilization and response times.
November 18th, 2024 — Source
Software — Database — November 15th, 2024
GraphRAG: Improving global search via dynamic community selection
Retrieval-augmented generation (RAG) allows AI systems to provide additional information and context to a large language model (LLM) when generating a response to a user query. However, traditional RAG-based methods can struggle to retrieve information that requires high-level knowledge of the entire dataset, especially with abstract and global questions such as the keywordless query: "Catch me up on the last two weeks of updates."
November 15th, 2024 — Source
Software — Database — October 30th, 2024
Implementing LSM Trees in Golang: A Comprehensive Guide
Follow an implementation of an LSM tree in Golang, discuss features, and compare it with more traditional key-value storage systems and indexing strategies.
October 30th, 2024 — Source
Software — Database — October 22nd, 2024
Clock's ticking on PostgreSQL 12, but not everyone is ready to say goodbye
11% of databases still on aging version with a month of support left
October 23rd, 2024 — Source
Software — Database — October 18th, 2024
How to Use Self Join and WITH Clause in Oracle
The Oracle WITH clause is one of the most commonly used techniques to simplify the SQL source code and improve performance.
October 18th, 2024 — Source
Software — Database — October 16th, 2024
Event-Driven vs. Event-Sourced: A Common Misunderstanding
The terms “event-driven” and “event-sourced” are often used interchangeably, while in reality, the two are very different concepts.
October 16th, 2024 — Source
Software — Database — October 12th, 2024
How do you solve a problem like MariaDB? Cozy up to the community, says new CEO
The new CEO of MariaDB (Plc) says he wants closer-knit collaboration with the foundation behind the eponymous open source database project. He cites the corporation's newfound stability from its recent acquisition by a private equity firm as to why it should now be able to get on a firmer footing.
October 12th, 2024 — Source
Software — Database — October 7th, 2024
SAP offers different way to move SQL Server-based software to the cloud
Just don’t call it an alternative to RISE with SAP
October 7th, 2024 — Source
Software — Database — September 22nd, 2024
Transform Unstructured Data Effortlessly with LangGraph Templates
This week LangGraph has introduced templates to simplify the creation of applications for common use cases, with a particular focus on transforming unstructured research data into structured formats like CSVs or databases. These templates provide a solid foundation for users to build upon, offering extensibility and configurability without the need to start from scratch.
September 22nd, 2024 — Source
Software — Database — September 13th, 2024
MongoDB CEO says if AI hype were the dotcom boom, it is 1996
NoSQL database slinger attempts to reassure investors, kinda
September 13th, 2024 — Source
Software — Database — September 3rd, 2024
Configuring a Connection Pool
A connection pooler is a software component that manages database connections. In this post, learn what a connection pooler is and how to configure it.
September 3rd, 2024 — Source
Software — Database — August 27th, 2024
Debugging Low Cache Hit Ratio
Explore debug scenarios where we can't utilize cached data and need to read from the physical drive, why it's important, what to look for, and helpful tools.
August 27th, 2024 — Source
Software — Database — August 21st, 2024
PostgreSQL databases under attack
Poorly protected PostgreSQL databases running on Linux machines are being compromised by cryptojacking attackers.
August 21st, 2024 — Source
Software — Database — August 16th, 2024
What Is SQL Injection and How Can It Be Avoided?
Learn about SQL Injection, a security risk in which the attackers find ways to manipulate inputs that are not cleaned properly in order to gain access to data.
August 16th, 2024 — Source
Software — Database — August 6th, 2024
Develop With OCI Real-Time Speech Transcription and Oracle Database NL2SQL/Select AI To Speak With Your Data
Use a combination of real-time speech-to-text, natural language to SQL, and Gen AI, to talk with your data just as you would to a person and in real-time.
August 6th, 2024 — Source
Hyperspace is using 'domain-specific computing' to accelerate database searches
The growth in the demand for generative AI apps has led to a need for larger and larger databases to store the associated data (e.g. model training data). These databases tend to be resource-intensive from a hardware perspective and, depending on the algorithms used to orchestrate them, they can be high-latency.
August 6th, 2024 — Source
Idempotency in Data Pipelines: Overview
Idempotency is an important concept in data engineering, particularly when working with distributed systems or databases. Learn more here.
August 6th, 2024 — Source
Oracle: Migrate PDB to Another Database
Explore different approaches to move the pluggable database from source to target database such as plug/unplug, data pump, refreshable clone and DBCA relocate.
August 6th, 2024 — Source
Software — Database — July 31st, 2024
Just Use PostgreSQL, a Quick-Start Guide: Exploring Essential and Extended Capabilities of the Most Beloved Database
Tour some of PostgreSQL's most notable capabilities and use cases, including various extensions for generative AI.
July 31st, 2024 — Source
Outlier Identification in Continuous Data Streams With Z-Score and Modified Z-Score in a Moving Window
How do you spot outliers in continuous data streams? Learn to catch network performance hiccups effortlessly using z-score and modified z-score.
July 31st, 2024 — Source
Plot Your REST Endpoints Using grafana-infinity-datasource
Plotting straight from the database is convenient, but is not always the case. Sometimes you might need something more complex that your API can support.
July 31st, 2024 — Source
Software — Database — July 29th, 2024
Automating Databases for Modern DevOps Practices: A Guide to Common Patterns and Anti-Patterns for Database Automation Techniques
By embracing AI, automation, database DevOps, and other emerging trends, organizations can ensure robust, efficient, and future-proofed database management practices.
July 29th, 2024 — Source
Software — Database — July 28th, 2024
DB2 versus Oracle for IBM Maximo: A Comparative Analysis
This essay explores the differences between DB2 and Oracle in the context of their integration with IBM Maximo and specific features that benefit Maximo environments.
July 28th, 2024 — Source
Real-Time Streaming Architectures: A Technical Deep Dive Into Kafka, Flink, and Pinot
While individual components like Kafka, Flink, and Pinot are very powerful, managing them at scale across cloud and on-premises deployments can be operationally complex.
July 28th, 2024 — Source
Software — Database — July 26th, 2024
Introduction to Polymorphism With Database Engines in NoSQL Using Jakarta NoSQL
This tutorial covers setting up Helidon with Oracle NoSQL, defining polymorphic entities, and managing JSON data efficiently.
July 26th, 2024 — Source
Software — Database — July 24th, 2024
Consistency versus Availability: The Eternal Struggle in Distributed Databases
Since the CAP theorem dictates that systems can only guarantee two of the three properties, this article provides strategies to manage the trade-offs.
July 24th, 2024 — Source
Effortless API Mocking With Playwright
Automated testing of web applications often requires interaction with external APIs. However, relying on actual API responses can introduce variables beyond your control.
July 24th, 2024 — Source
Spring Microservice Tip: Abstracting the Database Hostname With Environment Variable
Secure database connection strings in Spring microservices using environment variables and placeholder expressions for the hostname using the properties file.
July 24th, 2024 — Source
Software — Database — July 18th, 2024
Boomi's API Control Plane: Simplifying API Management for Developers
Boomi's new API Control Plane simplifies API management with centralized discovery, federated control, and enhanced security, revolutionizing how developers handle APIs.
July 18th, 2024 — Source
Software — Database — June 28th, 2024
Fortra Patches Critical SQL Injection in FileCatalyst Workflow
Fortra has patched a critical-severity vulnerability in FileCatalyst Workflow leading to the creation of administrator accounts.
June 28th, 2024 — Source
Software — Database — June 21st, 2024
Embracing NoSQL: The Future of Data Storage and Retrieval
NoSQL databases handle unstructured data, provide scalability, and offer high availability, ideal for modern, big data, and real-time applications.
June 21st, 2024 — Source
Software — Database — June 16th, 2024
Custom Health Checks in Spring Boot
Spring Boot provides health indicators to monitor application health and database health with the help of Spring Boot Actuator.
June 16th, 2024 — Source
Software — Database — June 6th, 2024
Streamlining Data Integration
This article demonstrates integrating Salesforce and Oracle into Amazon Redshift using Python and stored procedures, leveraging the ELT approach.
June 6th, 2024 — Source
What are Cloud Databases and how do they work?
Cloud databases, also known as Database as a Service (DBaaS), offer a range of benefits for developers, particularly in terms of ease of use, deployment options, disaster recovery, and scalability. These databases are hosted by cloud providers with data centers distributed globally, allowing for efficient data management and accessibility. IBM outlines the core aspects and advantages of using cloud databases in the development and deployment of applications.
June 6th, 2024 — Source
Software — Database — May 21st, 2024
Running PostgreSQL in the Browser with WebAssembly
With the recently released PGlite, a Wasm build of Postgres that is packaged into a TypeScript client library, developers can run Postgres queries in the browser with no extra dependencies. PGlite is used for reactive, real-time, local-first apps.
May 21st, 2024 — Source
Software — Database — May 17th, 2024
Lords of May-hem: Seven signs it is Oracle's year end
How to handle sales pressure and licensing 'negotiations' to make sure it plays to your advantage
May 17th, 2024 — Source
UK competition cops say Microsoft's stake in Mistral is not a merger
Watchdog drops official probe but IT giant's deal with Inflection AI and Amazon's with Anthropic still in play
May 17th, 2024 — Source
Software — Database — May 1st, 2024
MongoDB aims to jumpstart AI app development with MAAP
The MongoDB AI Application Program will offer enterprises strategic advice, professional services, and an integrated end-to-end technology stack for building generative AI applications.
May 1st, 2024 — Source
Software — Database — April 28th, 2024
MongoDB CEO Dev Ittycheria talks AI hype and the database evolution as he crosses 10-year mark
A decade is a long time in tech
April 28th, 2024 — Source
Software — Database — April 24th, 2024
Graph databases speaking the same language after ISO gives GQL the nod
Standards body adoption could help ease portability between vendors
April 24th, 2024 — Source
Software — Database — April 11th, 2024
Exploring the Apache ecosystem for data analysis
How Apache Arrow, Apache Parquet, Arrow Flight, and DataFusion bring enhanced data processing capabilities to large volumes of time series and other data.
April 11th, 2024 — Source
Software — Database — March 27th, 2024
Steampipe dashboards and benchmarks for your data
Use Powerpipe to visualize and validate data in your own Postgres, SQLite, DuckDB, or MySQL database.
March 27th, 2024 — Source
Vitess Version 19 Released: Ends Support for MySQL 5.7, Improves MySQL Compatibility
Vitess v19 has been released. This latest version of the database management solution -- designed for the deployment, scaling, and administration of large clusters of open-source database instances -- provides several new features, including metrics for monitoring stream consolidations, improved query compatibility with MySQL for multi-table delete operations, support for incremental backups, and various performance enhancements.
March 27th, 2024 — Source
Software — Database — March 18th, 2024
Evaluating databases for sensor data
Sensor data and IoT applications have special requirements that might be better served by a specialized database. Here's what to consider.
March 18th, 2024 — Source
Securing AWS RDS SQL Server for Retail: Comprehensive Strategies and Implementation Guide
This article provides a detailed guide on securing AWS RDS SQL Server instances, tailored for retail stores, with practical setup examples.
March 18th, 2024 — Source
Software — Database — March 11th, 2024
How to Netflix Oracle's blockbuster audit model
Terms and conditions apply. Lawyers need not
March 11th, 2024 — Source
Software — Database — March 6th, 2024
The Hidden Cost of Using Managed Databases
In 2024, cloud computing is everywhere, often unnoticed (e.g., iCloud and Google Docs). Cloud computing has become as ubiquitous as real clouds. Many advantages of cloud computing, such as elasticity, scalability, and ease of use, are well understood at this point.
March 6th, 2024 — Source
Software — Database — March 4th, 2024
Streaming the Super Bowl: The Art of Scaling Across Multiple Cloud Regions
In this tutorial, learn to build multi-region applications that scale and tolerate all sorts of possible outages.
March 4th, 2024 — Source
Software — DataBase — Resources
A practical comparison of Map-Reduce in MongoDB and RavenDB
Over the past week I've been learning about MongoDB. in my adventures with Node.js I am now at the point where I need some kind of data store.
Provides Information — Source
Access database repair
Access database repair tool for the recovery of corrupt databases in Microsoft Access 95, 97, 2000, 2002 (XP), 2003, 2007, 2010 and 2013. It recovers all data from a corrupt mdb, mde, accdb or accde database even in the hardest cases.
Provides a Service — Source
Argentum Software
Argentum Corporation — Cataloging Software, Backup Software, Database Software.
Provides Products — Source
Convert MySQL to MSSQL
MS Access to MySQL converter tool safely converts the database tables or records with password protected records.
Provides Products — Source
Database DebunkIing
Site dedicated to dispelling fallacies and misconceptions prevailing in the database industry.
Provides Information — Source
Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form).
Provides Information — Source
Database Research at Waterloo
Research areas include traditional relational database systems, complex objects, geometric data, text, and real-time data.
Provides Information — Source
David Consulting Group
DCG services include software metrics, software process improvement and outsourcing.
Provides Information — Source
DecisionDatabases.com
DecisionDatabases.com is proficient in providing syndicated research report, customized research reports, company profiles and industry databases across multiple domains.
Provides Products — Source
Erlangen University Department of Database Systems
Research projects include data warehousing, scientific database management, workflow management, and distributed data.
Provides Products — Source
InfluxData
An open-source distributed time series database with no external dependencies.
Provides Products — Source
MySQL in Docker with Java Hibernate
Recently, I started working on a new server project at work, and wanted to be able to run a local dev environment with Docker. this has become my normal flow for a couple of server projects because of how easy Docker is to work with, and especially for the fact that I don't need to set up any of the supporting structure on my machine to run the server.
Provides Information — Source
TechnicalSharp
technical solution for you
Provides Information — Source
Temporal Database Concepts
Defines a wide range of terms and concepts specific to the temporal database research community.
Provides Information — Source