Dashbase Blog

Paginating data in SQL databases with OFFSET and LIMIT to manage large datasets
Learn how to paginate data in PostgreSQL and MySQL databases using OFFSET and LIMIT to manage large datasets.
Published: 03/26/2024 | By: Dashbase Team
SQL
MySQL
PostgreSQL
Queries
Pagination
MySQL vs PostgreSQL: A Comparison of Two Popular Open-Source Databases
MySQL and PostgreSQL are two of the most popular open-source relational databases. This article compares the core aspects, similarities, and differences between MySQL and PostgreSQL to help you make an informed choice for your database requirements.
Published: 03/21/2024 | By: Dashbase Team
PostgreSQL
MySQL
SQL
Databases
Understanding Common Table Expressions (CTEs) in PostgreSQL
Learn about Common Table Expressions (CTEs) in PostgreSQL, how they simplify complex queries, and enable recursive operations with practical examples.
Published: 03/09/2024 | By: Dashbase Team
PostgreSQL
SQL
CTE
The 3 types of dashboards you need for business intelligence, KPI tracking and data drive decision making
Every business should use dashboards to track KPIs, make data-driven decisions and monitor business performance. Here are the 3 types of dashboards you need to use.
Published: 03/06/2024 | By: Dashbase Team
BI
KPIs
Strategy
Dashboards
Creating a Histogram in SQL Databases: MySQL, PostgreSQL, SQL Server
Learn how to create a histogram with SQL and better understand the distribution of your data.
Published: 03/04/2024 | By: Dashbase Team
SQL
Tutorial
PostgreSQL
MySQL
Build a KPI Dashboard for your PlanetScale Database with Dashbase
Learn how to use Dashbase to build a KPI dashboard for your PlanetScale database, leveraging Dashbase's MySQL support and AI powered query engine.
Published: 03/01/2024 | By: Dashbase Team
PlanetScale
MySQL
Tutorial
Getting Started
Build a KPI Dashboard for your Supabase App with Dashbase
In this tutorial, we will show you how to build a KPI dashboard for your Supabase app using Dashbase.
Published: 02/02/2024 | By: Dashbase Team
Supabase
Tutorial
Getting Started
Announcing Dashbase - the AI Powered KPI Dashboard
Introducing Dashbase, the AI powered KPI dashboard that helps you make better decisions with your data. Learn what you can do with dashbase today, and what's coming soon
Published: 02/01/2024 | By: Dashbase Team
Product Announcements
Dashbase
Features