Databases Resources

The Difficulty of SQL Stems From Relational Algebra

This article explores how the fundamental difficulty of SQL actually stems from its theoretical foundation, namely relational algebra.

March 27, 2024

by Judy Liu

· 1,160 Views · 2 Likes

Long Tests: Saving All App’s Debug Logs and Writing Your Own Logs

Approach for software QA to troubleshoot bugs using detailed logging — custom and app's debug logs, using Python and Bash scripts for logging and debugging.

March 27, 2024

by Konstantin Sakhchinskiy

· 14,688 Views · 3 Likes

Cloud Computing Security: Ensuring Data Protection in the Digital Age

Cloud computing security is vital for protecting data, demanding robust measures to protect data stored and transmitted through cloud service.

March 26, 2024

by faboye michael

· 2,686 Views · 1 Like

Automating AWS Infrastructure: Creating API Gateway, NLB, Security Group, and VPC With CloudFormation

In modern cloud environments, Infrastructure as Code (IaC) has become a cornerstone for managing and provisioning resources efficiently

March 26, 2024

by Vijay Panwar

CORE

· 2,238 Views · 2 Likes

Performance Optimization in Agile IoT Cloud Applications: Leveraging Grafana and Similar Tools

Grafana is a vital open-source tool for real-time monitoring, offering customizable dashboards, proactive alerts, and seamless integration for IoT applications.

March 25, 2024

by Deep Manishkumar Dave

· 2,310 Views · 2 Likes

Organizing Knowledge With Knowledge Graphs: Industry Trends

In this article, learn more about why and how knowledge graphs are a promising candidate to become a cornerstone of modern software engineering practices.

March 22, 2024

by Stelios Manioudakis

CORE

· 39,738 Views · 4 Likes

A Deep Dive Into CDC With Azure Data Factory

Change Data Capture (CDC) in SQL Server is a powerful feature designed to track and capture changes made to data within a database.

March 22, 2024

by Oriol Sr

· 28,156 Views · 1 Like

Improved Debuggability for Couchbase's SQL++ User-Defined Functions

Explore two new features introduced in Couchbase 7.6 that provide visibility into the execution of SQL++ user-defined functions.

March 22, 2024

by Dhanya Gowrish

· 28,603 Views · 2 Likes

Securing Cloud Storage Access: Approach to Limiting Document Access Attempts

Explore how to secure cloud documents and images by limiting access attempts using GUIDs, tokens, and tracking, enhancing security for image rendering.

March 21, 2024

by Amol Gote

CORE

· 24,643 Views · 4 Likes

Time Data Series: Working With PHP Zmanim

Calculations you can't get with built-in PHP tools because there are so many ways to calculate the same religiously significant moment.

March 21, 2024

by Leon Adato

· 21,284 Views · 1 Like

Deploying to Heroku With GitLab CI/CD

In this article, learn how you can deploy your Heroku app automatically any time code is merged into your main branch by using GitLab CI/CD.

March 21, 2024

by Tyler Hawkins

CORE

· 11,557 Views · 2 Likes

How to Query XML Files Using APIs in Java

With XQuery, quickly filter and aggregate XML content with a simple expression. Learn how to easily query files with XQuery expressions at scale.

March 21, 2024

by Brian O'Neill

CORE

· 11,903 Views · 5 Likes

Do We Need Data Normalization Anymore?

Data normalization is supposed to be the way you optimize databases to ensure their integrity. But maybe with many databases, normalization becomes redundant.

March 21, 2024

by Jennifer Reif

CORE

· 9,321 Views · 6 Likes

An In-Depth Analysis of GraphQL Functioning Using GenAI Within a Monolithic Application Framework

In a monolithic application, where all components are interwoven into a single software unit, GraphQL offers a unique approach to manage and manipulate data.

March 21, 2024

by Elias Naduvath Varghese

· 7,171 Views · 1 Like

Data Processing in GCP With Apache Airflow and BigQuery

Efficient data processing is paramount. In this guide, we'll explore how to leverage Apache Airflow and BigQuery to create robust and scalable data pipelines.

March 20, 2024

by Sreenath Devineni

CORE

· 16,366 Views · 5 Likes

Securing Cloud Infrastructure: Leveraging Key Management Technologies

This article explores the world of secure key management, the intricacies of KMS and HSM, their benefits, use cases, key considerations, and best practices.

March 20, 2024

by Josephine Eskaline Joyce

CORE

· 10,120 Views · 4 Likes

API Governance: Ensuring Control and Compliance in the Era of Digital Transformation

This comprehensive article explores the significance of API governance, its key components, and best practices for implementation.

March 20, 2024

by Lakshmi Sushma Daggubati

· 9,019 Views · 1 Like

PostgresML: Streamlining AI Model Deployment With PostgreSQL Integration

By embracing PostgresML, organizations can tap into the power of AI-driven insights and gain a competitive edge in today's data-centric landscape.

March 20, 2024

by Pankaj Zanke

· 10,971 Views · 2 Likes

API Appliance for Extreme Agility and Simplicity

Use API Logic Server to create an API-based web app in minutes and add message-based integration, all with little knowledge of frameworks or Python.

March 20, 2024

by Val Huber

CORE

· 11,309 Views · 7 Likes

Design Principles-Building a Secure Cloud Architecture

To ensure cloud security, adopt key principles like least privilege, fail-safe design, and a zero-trust model for creating a robust and adaptive cloud architecture.

March 19, 2024

by Suhas Jangoan

· 11,962 Views · 3 Likes

The Latest Databases Topics