Sreeram Sreenivasan, Author at Ubiq BI

How To Enable Slow Query Log in PostgreSQL

PostgreSQL allows you to log slow queries in your database. Here’s how to enable slow query log in PostgreSQL.

MySQL GUI Clients support database development, management and administration. Here are the top 5 MySQL GUI Tools, free and paid.

It is important to speed up SQL queries. Here are top 10 tips to speed up database query and improve SQL query performance.

MySQL database have latin1 character set by default. Here’s how to change character set from latin1 to UTF8 in MySQL.

MySQL supports limited number of connections. Here’s how to increase max connections in MySQL.

MySQL allows you to store UTF8 characters and convert all tables to UTF8. Here’s how to store UTF8 data in MySQL databases.

Materialized view allows you to store data physically and auto refresh view periodically. Here’s how to create materialized view in PostgreSQL.

Sometimes you may need to get last row of table or last row per group in PostgreSQL. Here’s how to get last record of each group in PostgreSQL.

Sometimes you may need to rank over partition in MySQL or do grouped ranking in MySQL. Here’s how to do it with MySQL Rank partition function.

Sometimes you may need to convert time from one timezone to another. Here’s how to change MySQL timezone in query.