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…
Category: Python
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…
Implementing the Model Context Protocol (MCP) in Oracle Database 26ai
As applications using AI evolve, databases are no longer just data stores since they are becoming intelligent endpoints that can interact directly with large language models (LLMs) and AI agents. The Model Context Protocol (MCP) is the key standard that makes this possible: it provides a uniform way for AI agents to query, reason, and act on data sources such as relational databases. In this post, I will walk through two practical implementations of MCP: Finally, we will take a look at a concise rundown of what changed from Oracle…
Fixing “Streamlit Requires Raw Python (.py) Files” When Running .ipynb Notebooks
If you’re building a data app using Streamlit inside a Jupyter Notebook environment and run into mysterious errors or warnings—you’re not alone. Here’s a quick guide on two common issues and how to fix them. Error: Streamlit requires raw Python (.py) files, not .ipynb. Fix: Convert .ipynb to .py. by running the following in your terminal to convert your notebook to a proper Python script: This will create a file like: Once the .py script is ready and you launch it with: Streamlit will start serving your app and provide…
Minimal Working Test script for Oracle Generative AI using the cohere.command-text-v14
To verify that your Oracle Cloud Infrastructure (OCI) environment is correctly configured to use Generative AI services, it is essential to test API access, model permissions, and request formatting. The Python snippet below provides a minimal working example that sends a prompt to the cohere.command-text-v14 model using Oracle’s generateText endpoint. This test isolates the most common failure points—such as invalid compartment access, unsupported models, or malformed requests—and allows you to confirm that your OCI SDK and credentials are functioning correctly. If the script returns a generated response, you can integrate…
From Stockholm Marathon to Multi-cloud (OCI, AWS, Azure, GCP) Strategy
Running a marathon is a monumental undertaking. Even though I had been preparing for 1.8 years, it wasn’t until a few weeks ago that I truly grasped the significance of this feat. The turning point came when I made the decision to run for a charity organization in Brazil, specifically Casa da Crianca Paralítica de Campinas (https://www.ccp.org.br/web/). This organization provides vital medical, dental, and pedagogical support to children with physical and mental disabilities in Campinas, Sao Paulo State, Brazil. Moreover, during my preparations, I delved into the origin of the…
Storing Information from ChatGPT in Oracle Database Container using Python and Jupyter Notebook
In this post, I will be creating Python code using Jupyter Notebook to store information from ChatGPT in an Oracle Database within a Docker container. The objective is to showcase how an application can retrieve various types of data from an AI-based tool. Additionally, the idea behind this is to illustrate how the implementation of supercomputers can further optimize this infrastructure. By utilizing the Python programming language and Jupyter Notebook, we can develop code that captures and stores information generated by ChatGPT. This code will serve as a demonstration of…
Error Forbidden: 403 Forbidden 453 while building a dataset from Twitter using Python tweepy
I am developing an application to collect information from Twitter social media to provide some analysis through big data analytics. Therefore, the first step was creating a dataset with all the information collected from the platform, coding (I chose Python programming language), and then applying all machine learning techniques that I thought would be helpful in my project. However, while working on the first step to collect the data, I received the following error from the Twitter platform: To solve this problem, after googling. I discovered that there is a…
Comparing files to be used by an Oracle External tables using Python3
Since I started to work using Python to automate some tasks on my Since I started working with Python to automate some tasks in my environment. I also started to think about what I can get from it. Python is powerful and there are a lot to be explorered from it and I am a DBA person and I am slowly getting to know this programming language. I started to create some scripts for fun and that is the topic of this post . Remember that on this blog you…