Log in Basedash Legacy

Menu

Topic

Engineering

Engineering posts from the Basedash team: deep dives, lessons learned, and dev tooling we love.

24 posts

Tom Johnson · June 5, 2025
How to use Framer AI to make a right click to download logo menu
How to use Framer’s AI features to create a right click to download logo menu for the Basedash website.
Robert Cooper · May 19, 2025
How We Built Light Mode Without Tailwind’s dark: Class
Skip Tailwind’s dark: modifier. Learn how Basedash uses CSS variables, global state, and zero-flicker theming for a scalable light/dark mode system.
Robert Cooper · January 31, 2025
How to automate Prisma migrations in a CI/CD pipeline
Automating Prisma migrations in a Continuous Integration and Continuous Deployment (CI/CD) pipeline ensures that any new changes to your database schema.
Robert Cooper · January 31, 2025
How to Debug MySQL Stored Procedures
Debugging MySQL stored procedures is tricky, mostly because MySQL’s native debugging tools have some limitations.
Robert Cooper · January 31, 2025
How to Display View Definitions in PostgreSQL
Retrieving and understanding the definition of database views in PostgreSQL is not only essential but can significantly enhance your database management.
Robert Cooper · January 31, 2025
How to Fix: MySQL Failed to Open File Error 2
When working with MySQL, encountering the "failed to open file error 2" can be a frustrating experience.
Robert Cooper · January 31, 2025
How to Fix MySQL Workbench Crashing When Writing a Query
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. However, users sometimes encounter crashes while writing queries.
Robert Cooper · January 31, 2025
How to reset and seed a Prisma database
Prisma is an open-source database toolkit that simplifies database workflows, making them more efficient and type-safe.
Robert Cooper · January 31, 2025
How to Resolve Error Code 1064 in MySQL
Error code 1064 in MySQL is a syntax error, commonly encountered when writing SQL queries. This guide explains how to identify and fix this error, which.
Robert Cooper · January 31, 2025
How to Simulate a Print Statement in MySQL
MySQL, primarily a database management system, does not inherently support a direct print statement like some programming languages.
Robert Cooper · January 31, 2025
MySQL Port Numbers
MySQL, one of the world's most popular open-source relational database management systems, communicates over a network using a standardized port.
Robert Cooper · January 31, 2025
UUID vs GUID vs CUID vs NanoID: A guide to database primary keys
When you're working on database design, how you uniquely identify each record matters—a lot. The ID type you choose can have implications on performance.
Max Musing · September 8, 2023
How to filter on date ranges in Prisma
Learn to filter database records by date using Prisma’s gt, gte, lt, and lte operators. Master common scenarios like fetching data before, after, or between specific dates.
Tom Johnson · April 11, 2023
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.
Robert Cooper · April 7, 2023
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 Cooper · March 10, 2023
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.
Jeremy Sarchet · January 11, 2023
Database table joins with and without foreign-key constraints
Learn how SQL JOINs work, the importance of foreign-key constraints, and how to correctly structure and query related tables. Explore practical examples using Basedash.
Jeremy Sarchet · September 26, 2022
A simpler way to make flowcharts in Notion and Github
See how to generate flow charts in Notion and Github with mermaid.js
Robert Cooper · July 21, 2022
Why we had to move away from React Query
Discover how Basedash left React Query behind for a more robust Redux setup. Explore the benefits of normalized state, fewer bugs, and improved scalability.
Robert Cooper · April 26, 2022
How virtualization increased our table performance by 500%
Learn how Basedash overcame table-performance challenges using React optimizations, virtualization, and strategic rendering. Discover their 4–5x speed improvements and key takeaways.
Jeremy Sarchet · March 29, 2022
How to model inheritance in Prisma
Learn how to effectively use inheritance and polymorphic relationships in Prisma ORM through practical examples. Understand Class Table Inheritance and Delegated Types.
Max Musing · January 5, 2022
How to style console log messages
Discover how Basedash, Linear, and Facebook spice up console.log output using ‘%c’ placeholders. Learn to apply custom fonts, colors, ASCII art, and more to create an engaging console experience.
Tom Johnson · October 4, 2021
How Mobbin moved from Firebase to Supabase
Discover why Mobbin’s CTO switched from Firebase to Supabase for a more flexible, SQL-based stack. Explore benefits, challenges, indexing, and open-source.
Robert Cooper · June 11, 2021
Optimizing REST API calls
How we migrated to React Query and reworked our API routes to reduce data-fetching calls by half and cut initial page-load data by 3x.

Browse other topics

Get started in under 30 minutes

We can help you migrate your data and dashboards from any other tool.

Start free Book a demo