Build dashboards & reports in minutes

  • Features
  • Pricing
  • Blog
  • What is Ubiq
  • Free Trial

How to Use Coalesce in MySQL

January 19, 2021June 11, 2025 Sreeram Sreenivasan Leave a comment MySQL
coalesce in mysql

Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.

Continue reading


How to Query JSON column in MySQL

January 18, 2021June 12, 2025 Sreeram Sreenivasan Leave a comment MySQL
extract json mysql

Sometimes you may need to search JSON array of objects, extract JSON data or retrieve JSON data in MySQL. In this article, we will look at how to query JSON column in MySQL.

Continue reading


How To Avoid Inserting Duplicate Records in MySQL

January 18, 2021June 12, 2025 Sreeram Sreenivasan Leave a comment MySQL
avoid duplicate records in mysql

Sometimes you may need to prevent duplicate insert while adding rows. Here is how to avoid inserting duplicate records in MySQL.

Continue reading


How to Update Array in PostgreSQL

January 15, 2021June 12, 2025 Sreeram Sreenivasan Leave a comment PostgreSQL
update array in postgresql

Sometimes you may need to update array in PostgreSQL with new data. In this article, we will look at how to change array in PostgreSQL, modify array in PostgreSQL, and merge arrays in PostgreSQL.

Continue reading


How to Convert datetime to UTC in MySQL

January 14, 2021June 12, 2025 Sreeram Sreenivasan Leave a comment MySQL
convert datetime to utc

Sometimes you may need to set timezone to UTC or change timezone to UTC. Here is how to convert datetime to UTC in MySQL

Continue reading


How to Insert into Array in PostgreSQL

January 5, 2021June 12, 2025 Sreeram Sreenivasan Leave a comment PostgreSQL
insert into array postgresql

PostgreSQL allows you to select into array, append to array and insert array of objects. Here is how to insert into array in PostgreSQL.

Continue reading


How to Convert UTC to Local Time in MySQL

January 1, 2021June 12, 2025 Sreeram Sreenivasan Leave a comment MySQL
convert utc to local time in mysql

Sometimes you may need to change UTC to local time in MySQL. Here is how to convert UTC to local time in MySQL.

Continue reading


Top 5 Dashboard Software For Your Business

January 1, 2021June 19, 2025 Sreeram Sreenivasan Leave a comment Dashboards
top dashboard software

Dashboard software help track KPI metrics and visualize data. Here are the top dashboard software tools.

Continue reading


How to Password Protect Directory in Nginx

December 29, 2020June 4, 2024 Sreeram Sreenivasan Nginx
NGINX password protect directory

Sometimes you may need to secure directories and files in NGINX. Here is how to password protect directory in NGINX.

Continue reading


How to Create Array in PostgreSQL

December 21, 2020June 12, 2025 Sreeram Sreenivasan Leave a comment PostgreSQL
create array in postgresql

PostgreSQL allows you to store array or create arrays with range. Here is how to create array in PostgreSQL.

Continue reading


Page 15 of 32« First«...10...1314151617...2030...»Last »

About Us



Ubiq is a business intelligence & reporting tool for small & medium businesses. Build business dashboards, charts & reports in minutes. Get insights from data quickly. Try it for free!




Data Reporting
  • MySQL Charts
  • MySQL Visualization Tool
  • Create Graph from MySQL Database
  • MySQL Report Builder
  • MySQL Report Maker
  • PostgreSQL Reporting Tools
  • MySQL Report Writer
  • SQL Reporting Tools
Business Intelligence
  • BI Solution
  • Online Business Intelligence
  • Online Reporting Software Tool
  • SaaS BI
  • MIS Reporting
Data Visualization
  • Data Analysis Tool
  • Data Visualization Tools
Dashboards
  • Dashboard Builder
  • Dashboard Reporting Software Tool
  • MySQL Dashboard Builder
  • Online Report Generator
  • Customer Service Dashboard
  • Insurance Dashboard
  • Retail Dashboard
  • Dashboard Creator
  • Online Dashboard
Quicklinks
  • Contact Us
  • Docs
  • Tech Blog
Resources
  • Security
  • Privacy
  • T&C
  • Sitemap
dazzling Theme by Colorlib Powered by WordPress