Redis (Remote Dictionary Server) is an in-memory key–value database that runs as a background service and is widely used as a distributed cache and message broker. It is open-source and provides extremely high-performance data storage and retrieval with optional durability, making it ideal for applications that need to reduce latency and minimize I/O operations. 1. Quick & Basic Installation Before integrating Redis with PostgreSQL (Aurora-compatible), let’s set up everything locally using Docker. This gives you a full development environment that can later be migrated to AWS with minimal changes. 1.1…
Month: November 2025
Building a Semantic Search API with MySQL Vector Search, Oracle Cloud, and an NBA Kaggle Dataset
Semantic search enables users to ask for “a 3-and-D wing who can guard multiple positions” (as described in The Kings Beat article) and retrieve the correct NBA players, rather than simply a keyword match on “3,” “wing,” or “defense.” By combining MySQL Vector Search, Oracle Cloud’s Generative AI Embeddings, and a real NBA dataset from Kaggle, you can build a powerful natural-language search API that understands the meaning behind a query.As I love sports, I think this would be a great demonstration. In this tutorial, you’ll build: We’ll use the…
Java vs. Python: Which Language Is Faster? A Quick Experiment Inspired by an Interview Question
During a recent interview, I was asked a question that seemed simple but actually touches on deeper concepts in programming-language theory and system design: “Which programming language is faster: Java or Python?” At the time, I didn’t know the exact answer. I understood the general differences between the two languages, and I assumed that Python might use fewer computational resources than Java. Ultimately, I responded that performance would depend on the type of data being processed, the context, and the purpose of the program, and I admitted that I wasn’t…
Hands-On Implementation: Building Big Data and Analytics Solutions with Oracle Autonomous AI Database and Oracle Analytics Cloud (OAC)
Modern data analytics projects often take place in shared or restricted Oracle Cloud Infrastructure (OCI) environments, where not all users have administrative privileges. In such cases, demonstrating an end-to-end data pipeline from data ingestion and transformation to visualization can seem challenging. This post uses Oracle Autonomous AI Database (AADB) , the evolution of Autonomous Data Warehouse (ADW) and ATP, along with Oracle Analytics Cloud (OAC). It highlights how users can still build and test data engineering workflows without elevated IAM permissions or access to Oracle Data Flow or Big Data…