Databases Resources

Using AWS Data Lake and S3 With SQL Server: A Detailed Guide With Research Paper Dataset Example

The integration of AWS Data Lake and Amazon S3 with SQL Server provides the ability to store data at any scale and leverage advanced analytics capabilities.

June 7, 2024

by Vijay Panwar

CORE

· 7,109 Views · 1 Like

When Should You Use Distributed PostgreSQL for Gen AI Apps?

In this article, explore when gen AI applications should use distributed PostgreSQL deployments.

June 7, 2024

by Denis Magda

CORE

· 4,221 Views · 1 Like

How To Build a Simple GitHub Action To Deploy a Django Application to the Cloud

In this article, we’ll demonstrate how GitHub Actions and Heroku can be used to quickly deploy a Django application to the cloud.

June 7, 2024

by Michael Bogan

CORE

· 5,366 Views · 2 Likes

ChatGPT: Your Guide to SQL Query Translation Between Databases

ChatGPT offers a solution for SQL translation by accurately translating queries, handling data types, and suggesting alternatives for proprietary features.

June 7, 2024

by Dmitry Narizhnykh

CORE

· 3,062 Views · 2 Likes

GenAI-Powered Automation and Angular

Learn how GenAI-Powered microservice automation provides a prompt-driven way to create and deliver a complete end-to-end Angular API-enabled application.

June 6, 2024

by Tyler Band

· 6,684 Views · 10 Likes

Mocking Dependencies and AI Is the Next Frontier in Vue.js Testing

Mocking dependencies in Vue.js tests is crucial for isolating components, and ensures reliable, efficient, and comprehensive testing in controlled environments.

June 6, 2024

by Anton Lucanus

CORE

· 12,700 Views · 2 Likes

Streamlining Data Integration

This article demonstrates integrating Salesforce and Oracle into Amazon Redshift using Python and stored procedures, leveraging the ELT approach.

June 6, 2024

by Rajesh Remala

· 4,962 Views · 2 Likes

Best Practices for Batch Processing in IBM App Connect Enterprise as a Service

In this article, we make recommendations for designing flows that use batch processing and include guidance on how to troubleshoot issues.

June 5, 2024

by Doina Klinger

· 3,965 Views · 2 Likes

Mock The API Data (Request and Responses) With Playwright

Mocking API responses refers to the practice of creating simulated responses from an API without actually interacting with the real API.

June 5, 2024

by Kailash Pathak

CORE

· 4,417 Views · 2 Likes

Add Flexibility to Your RAG Applications in Amazon Bedrock

Knowledge Bases for Amazon Bedrock is a fully managed capability that helps you implement the entire RAG workflow from ingestion to retrieval and prompt augmentation.

June 5, 2024

by Abhishek Gupta

CORE

· 3,937 Views · 1 Like

Take Your First Steps for Building on LLMs With Google Gemini

Learn to build an LLM application using the Google Gemini API and deploy it to Heroku. This guide walks you through setup, code, and deployment step-by-step.

June 5, 2024

by Alvin Lee

CORE

· 6,266 Views · 2 Likes

How To Perform Data Migration in MongoDB Using Node.js

Explore effective MongoDB data migration methods using Node.js, including manual migration, MongoDB drivers, and the Mongoose library.

June 5, 2024

by Sanjay Singhania

· 6,205 Views · 1 Like

Optimizing Cloud Spend in the New Era: Strategies and Frameworks for Cost Management

Effective cloud cost management is not just about cutting costs but also about optimizing cloud usage in a way that aligns with organizational goals and strategies.

June 5, 2024

by Marija Naumovska

CORE

· 4,002 Views · 2 Likes

Protecting PII Data With JWT

Use JWT tokens for fine-grained access control while avoiding direct inclusion of PII-like account numbers. Use non-PII identifiers and perform server-side lookup.

June 5, 2024

by Abhishek Goswami

· 5,070 Views · 3 Likes

Efficiently Transforming JDBC Query Results to JSON

Buffering query results introduces overhead and delay. Use the Pipe class provided by the Kilo framework to stream them instead!

June 4, 2024

by Greg Brown

· 2,396 Views · 1 Like

New Ways for CNAPP to Shift Left and Shield Right: The Technology Trends That Will Allow CNAPP to Address More Extensive Threat Models

Because of the evolving threat landscape and complexity of modern organizations, the evolution of the CNAPP model yields both significant challenges and opportunities.

June 4, 2024

by Laurent Balmelli, PhD

· 3,900 Views · 1 Like