Optimizing PostgreSQL View Performance: A Practical Guide
PostgreSQL views act as virtual tables representing the results of stored queries. They simplify complex queries, improve readability, and ensure data.
Robert CooperSenior Software Engineer- Robert CooperSenior Software Engineer
Overview: MySQL Last 30 Days
MySQL, a widely-used open-source relational database management system, often requires querying data based on time intervals.
Robert CooperSenior Software Engineer
Percent in MySQL: An Overview
Dealing with percentages in MySQL involves various operations like formatting data as a percent, calculating percentiles, and determining the top.
Robert CooperSenior Software Engineer
Pivot Tables in MySQL
A pivot table in MySQL will transform rows into columns. It’s a solid way to generate reports. This post dives into how it works so you can display.
Robert CooperSenior Software Engineer
“We evaluated Omni and other BI tools, but the speed to insight with Basedash is unmatched.”
Greg Demoge
Co-founder & CPO · FullEnrich
Read case study →
“For a security-conscious company like ours, Basedash instantly clicked. Reports that took weeks are ready in hours.”
Claudio Godoy
AI Agents Lead · Taxfyle
Read case study →
Postgres: View vs Materialized View - Choosing the Right One
Postgres offers two distinct types of views: standard views and materialized views. Standard views operate as virtual tables that reflect real-time data.
Robert CooperSenior Software EngineerRedshift vs MySQL
Redshift and MySQL are both popular databases, but they serve different purposes. Redshift is a fully managed, petabyte-scale data warehouse service by.
Robert CooperSenior Software Engineer
Rolling Average in MySQL
A rolling average, also known as a moving average, is a statistical technique used to analyze time-series data by creating a series of averages of.
Robert CooperSenior Software Engineer
Standard Deviation in MySQL
MySQL offers several functions for statistical analysis. One of them is the standard deviation, which measures the amount of variation or dispersion in a.
Robert CooperSenior Software Engineer
Is YC worth it?
Learn how YC’s $500K offer—$125K at 7% and a $375K MFN SAFE—benefits startups. From mentorship to funding and an unparalleled network, discover why Y Combinator often outweighs its equity cost.
Max MusingFounder and CEO of Basedash
How Supabase became this generation’s database
Discover how Supabase pivoted from a real-time Postgres tool to a full-fledged open-source Firebase alternative. Learn how rapid product launches, community-driven features, and savvy positioning propelled its success.
Max MusingFounder and CEO of Basedash
Basedash on the main stage at Collision 2023
Discover how Basedash automates internal admin panels with AI, removing the need for custom code. Learn why they presented at Collision 2023 and how their solution saves development time for any company.
Max MusingFounder and CEO of Basedash
Basedash raises $4.4M led by Matrix
Basedash secures $4.4M seed led by Matrix to develop AI-based internal tools, starting with a modern, universal admin panel solution for any company’s data.
Max MusingFounder and CEO of Basedash
Everything you need to know to ace the YC interview
Discover how a solo founder tackled two YC interviews, including real questions, in-person and remote tips, and the importance of concise answers. Learn to impress YC partners and land your spot.
Max MusingFounder and CEO of Basedash
How to add Code blocks & Markdown to the Framer CMS
Discover how Basedash optimized their blog workflow by transitioning from Webflow to Framer, leveraging a custom markdown component, and integrating Notion for seamless content management.
Tom JohnsonHead of Design
Our TypeScript monorepo setup
Discover how Basedash uses a TypeScript monorepo with yarn workspaces, shared configs, tRPC, and turborepo to enable code sharing and efficient builds.
Robert CooperSenior Software Engineer
Implementing Re-Ordering at the Database Level: Our Experience
Learn how Basedash simplified sidebar page re-ordering by switching from integer indices to floating-point values. Discover the challenges, solutions, and best practices they uncovered.
Robert CooperSenior Software Engineer