Optimize Maxmind database loaded on Redshift using Analytical functions

If you need to associate an IP address to a country or a city probably you will use MaxMind data. If you load it in a relational database you will write a SQL statement that joins your traffic data with MaxMind data, which can be really heavy. This is an attempt to optimize queries by reducing the number of MaxMind data rows.

AWS
SQL

Redshift tips

I am using Redshift since two years ago, and as every database it has its SQL dialect and its secrets. I will write here everything I discover and it is worth to be annotated.

AWS
SQL

Getting started with PostGIS

PostGIS is a PostgreSQL extension that adds support for geographic objects allowing location queries to be run in SQL.

SQL

AWS Redshift compatible PostgreSQL client

How to install a PostgreSQL client (psql) that is compatible with AWS Redshift

AWS
SQL

S3 to RedShift loader

Load data from S3 to RedShift using Lambda, powered by apex. Our goal is: every time the AWS Elastic load balancer writes a log file, load it into RedShift.

AWS
SQL

How to drop a user on Netezza

You are trying to drop a user but Netezza complains cause it "owns objects"? This article shows how to solve this problem.

SQL

How to collect Netezza history

Collecting your Netezza query history is a mandatory step before optimization. Read this article to know how to collect Netezza history easily.

SQL

Use nzpassword!

How to authenticate securely on Netezza.

SQL

sqlplus tips

Tricks and tips about your everyday Oracle sqlplus usage.

Oracle
SQL

How to install DBD::Oracle

I am going to put here all the steps required to install DBD::Oracle CPAN module, which is not a straightforward installation. The purpose is to reduce headache and turn it into a repeatable process.

Perl
SQL