Topic
PostgreSQL guides covering schema design, querying, and operating Postgres in production.
34 posts
Robert Cooper 
Robert Cooper Senior Engineer at Basedash · January 31, 2025
PostgreSQL is not only a robust open-source object-relational database system but also an essential tool for developers looking to manage complex data.
Robert Cooper Robert Cooper Senior Engineer at Basedash · January 31, 2025
PostgreSQL views act as virtual tables representing the results of stored queries. They simplify complex queries, improve readability, and ensure data.
Robert Cooper Robert Cooper Senior Engineer at Basedash · January 31, 2025
Postgres offers two distinct types of views: standard views and materialized views. Standard views operate as virtual tables that reflect real-time data.
Robert Cooper Robert Cooper Senior Engineer at Basedash · January 31, 2025
PostgreSQL, a sophisticated open-source relational database, supports complex queries, including joining multiple tables.
Robert Cooper Robert Cooper Senior Engineer at Basedash · January 31, 2025
PostgreSQL is a powerful, open-source relational database system. One of the essential operations any developer or DBA will perform is updating existing.
Robert Cooper Robert Cooper Senior Engineer at Basedash · January 31, 2025
Describing a view in PostgreSQL is essential for understanding its structure, such as the columns and their data types.
Robert Cooper Robert Cooper Senior Engineer at Basedash · January 31, 2025
Secondary keywords: mysql workbench MySQL Workbench is an integrated development environment (IDE) designed specifically for MySQL, one of the most widely.
Max Musing 
Max Musing Founder and CEO of Basedash · August 2, 2023
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.
Robert Cooper Robert Cooper Senior Engineer at Basedash · March 10, 2023
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.
Tom Johnson 
Tom Johnson Former Head of Design at Basedash · October 4, 2021
Discover why Mobbin’s CTO switched from Firebase to Supabase for a more flexible, SQL-based stack. Explore benefits, challenges, indexing, and open-source.
Browse other topics
We can help you migrate your data and dashboards from any other tool.