It all started when I wanted to check the performance of JSON of MYSQL and JSONB of PostgreSQL I am a big fan of PostgreSQL for its power and I have read N number of articles showing why PostgreSQL is better than MySQL Various Benchmarks and research done to prove[...]
Read more
Apache Drill is a revolutionary product that identifies itself as a Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage - While it was often represented or perceived as a tool for Data Engineers or Analysts. It is not just for Data Engineers In this article, we are going[...]
Read more
In this brief article, I want to share a few tricks and lessons I have learnt on Converting Latin1 Encoded rows to UTF8 I had a table with a field named username with millions of records and we recently converted that table from latin1 charset to UTF8 First, let's start[...]
Read more
In this article let me share some SQL queries for RDS MYSQL troubleshooting It is true that when you are choosing RDS or any managed database, you cannot fully control or customize your database. There are few granular restrictions and constraints But AWS RDS is not a complete black box,[...]
Read more
I have recently migrated a self-hosted MySQL from an EC2 instance to another using AMI copy and restore. and I have seen this error on the newly launched EC2 instance. Coming from a no-DBA background, I spent a day finding the root cause of this I am putting it here[...]
Read more