life is too short for a diary



Posts Tagged: database

Getting Started with Redis: Concepts, Commands, and Monitoring

## Introduction Redis is a in-memory NoSQL database mainly used for caching. It's a key-value store which means each unique keys map to a value which could be either a stirng, list, set, hash, blob, JSON or any other data. Each keys are unique and can be queried...

Continue reading → redis nosql database python



Optimizing SQL Queries - Understanding and Refreshing Materialized Views

When to use a materialized view? And how does it perform against a normal view. Benchmarking using docker...

Continue reading → sql database python docker



Connecting to Oracle database form Scala using JDBC for large data

I was looking to write a scala script to fetch large data from Oracle database. I was earlier using the Alteryx software to fetch data (around 1 million rows) from oracle which took around 7 minutes. Licensed softwares like Alteryx or Informatica, etc are great, but I was looking for a free solution...

Continue reading → jdbc scala oracle database