Blog

Sep 25, 2023
Basedash launch week
I'm excited to launch our first ever launch week. We'll be announcing a number of major releases and improvements to Basedash today through Thursday.

Sep 8, 2023
How to filter on date ranges in Prisma
When fetching records from your database, it’s very common to want to filter records based on date ranges. Fortunately, the Prisma ORM makes this very easy with filter conditions and operators.

Jul 28, 2023
How Supabase became this generation’s database
Each generation of software has its own database company. It started with OracleDB in the 1980s, then you had MongoDB in the 2000s and Firebase in the 2010s. I think the database company of the 2020s is Supabase. I wanted to explore how they became so successful - this is what I found.

Jul 27, 2023
Report: The 2023 State of Databases
We're excited to release the 2023 State of Databases report. If you’re looking to learn what backend to use for your new project, thinking about how to make your company more productive, or merely curious to learn what developers value in data products, this report is for you.

Jul 24, 2023
Basedash on the main stage at Collision 2023
Basedash was invited to Collision - one of the largest technology industry conferences in the world - as one of the “breakout startups” of 2023. There were a lot of impressive companies, so we were flattered to have the chance to present.

May 17, 2023
Basedash raises $4.5M led by Matrix
I’m excited to share that Basedash has raised $4.5M in seed funding. The round was led by Matrix with participation from Y Combinator, Form Capital, and Worklife, along with many prominent angels including the founders of Figma, Notion, and Bloom Tech.

May 8, 2023
Everything you need to know to ace the YC interview
This post is part of a series talking about my experience applying to and taking part in the Summer 2020 batch of Y Combinator with my company, Basedash.

Apr 11, 2023
How to add Code blocks & Markdown to the Framer CMS
Learn how we switched from Webflow to Framer for our website, and improved our blog workflow using a custom markdown component and Notion integration.

Apr 4, 2023
The 2023 State of Databases Is Now Open
The Basedash survey for the 2023 State of Databases is now open. The report will cover the most commonly used databases, fastest-growing internal tools, and popular ORMs. Fill out the survey to enter a draw for a 27" Apple Studio Display.

Mar 31, 2023
Our TypeScript monorepo setup
Learn how we setup our TypeScript monorepo with yarn workspaces, shared configs, tRPC, and Turborepo to allow for code sharing and efficient builds.

Mar 10, 2023
6 Retool Alternatives for 2023 - A Comprehensive Guide
Discover the best alternatives to Retool for creating internal tools in 2023. Explore 6 platforms including Basedash, Internal.io, Airplane.dev, Budibase, Jetadmin.io, and DronaHQ, and learn about their features, pricing, and pros and cons to make an informed decision for your business needs.

Mar 9, 2023
Implementing Re-Ordering at the Database Level: Our Experience
Learn about the challenges faced by Basedash in implementing re-ordering at the database level, and the solutions they tried out. Discover how they ultimately used floating point numbers to move a page between two other pages, and the possible improvements to ordering at the database level.

Jan 20, 2023
Why you need a collaborative database admin panel
Kris explains how collaborative admin panels for databases can help teams work more efficiently, increase control over data, and improve collaboration. Admin panels allow non-technical team members to easily access and modify customer data while maintaining security. Centralizing data management can prevent errors and ensure everyone has access to the latest information.

Jan 11, 2023
Database table joins with and without foreign-key constraints
Learn about how to unify related datasets using SQL when a Foreign Key is and isn't present in the tables you're looking to unify.

Jan 3, 2023
How to write a successful YC application
The first part of a series talking about my experience applying to and taking part in the Sumer 2020 batch of Y Combinator with my company, Basedash.

Dec 16, 2022
Creating a MariaDB database on DigitalOcean
Learn how to set up your own instance of a MariaDB database on a DigitalOcean droplet by following these step-by-step instructions. Includes information on creating a Ubuntu droplet, setting up MariaDB on the server, and connecting to the database from a remote server.

Dec 9, 2022
Strong Foundations Create Large Companies
A startup's primary focus is to build a foundation of core components that are resilient, adaptable, and can be combined to create an innovative and useful product, according to a blog post by Basedash. This is often misunderstood as being about creating a product people love.

Dec 2, 2022
Basedash - 2022 Wrapped
Basedash reflects on their year of shipping dozens of changelog updates, connecting thousands of tables with hundreds of thousands of columns, and helping users save six and a half years of time building and maintaining internal tools.

Oct 10, 2022
How to call a GraphQL endpoint with plain HTTP
If you have a means for constructing a plain HTTP request, and if you know how to transmit your query within it, you can work with a GraphQL server using plain HTTP.

Sep 29, 2022
Internal Software Development: Pros/Cons of Building Internal Tools
Internal software development can be a powerful tool for businesses, especially if you have specific needs that widely-available software can’t address. This article will explain the advantages of a company taking an in-house approach, and whether the negatives outweigh them. While it’s not the right choice for every company, the benefits are hard to ignore.

Sep 28, 2022
Advantages of Building an internal tool
Keeping track of the numerous processes that take place within your organization and promptly reporting on them can be challenging, especially since those processes are distributed across several systems. So why not build an internal tool and connect your data sources under one user interface (UI) to simplify and speed up your work processes?

Sep 28, 2022
phpMyAdmin Alternatives: A Comprehensive Guide
PhpMyAdmin is a free and open-source administration tool for MySQL and MariaDB, but as your needs scale, you might be looking for alternative products that help stay on top of your database's needs.

Sep 26, 2022
A simpler way to make flowcharts in Notion and Github
Sooner or later in development work, there comes a time where you just need a flowchart. Recently we started using Mermaid, a markdown syntax supported by Notion and Github to document and share and annotate new features in-line rather than having to use a design tool or draw them out by hand.

Sep 21, 2022
How to recruit your own users as research participants
Doing user research is difficult in and of itself, but no matter how good your are at asking the right questions, gathering data, taking insights from research, and putting that data to use, one of the most important parts of user research is finding the right users to talk to in the first place.

Sep 14, 2022
Product analytics tools are failing startups
Product analytics tools are failing startups. At an early stage (pre-product-market fit), aggregate data is a distraction.The cure? Entity-level data.

Sep 1, 2022
Internal tools are a waste of time
Internal tools take time, resources, effort, and often get very little resources to build, and less to improve and grow over time. Learn how our designer, Tom Johnson, has seen and felt the pain of building internal tools over his career and how Basedash solves those issues.

Aug 29, 2022
Best Practices For Product Management of Internal Tools
Internal tool product management is identifying a need for, creating, and managing internal tools that will fulfill the needs of multiple people at your company. It's one of the most intimidating product roles in tech startups, but it doesn’t need to be.

Aug 16, 2022
What are the benefits of internal tools?
It's challenging to keep track of dozens, if not hundreds, of different business processes at any given moment, let alone provide a timely report on them. It’s always tricky because of how many processes across other systems are involved.Internal tools solve this business problem by integrating all the data sources they use under one user interface. In doing so, these tools streamline and speed up work for your employees and your business. This article will go into several benefits of building internal tools, what you need to consider, and how to build them.

Aug 15, 2022
How to rename a table or column using Prisma migrations
Prisma’s migration system is great because it’s able to automatically generate SQL migrations based on changes to your schema.prisma file. However, it’s not always possible to understand your intentions when you make a change. In these cases, you have to manually edit the generated SQL migration. Most commonly, this happens when you want to rename a table or column in your database.

Jul 25, 2022
Why we had to move away from React Query
Last year we started using React Query for all of our API calls (and we talked about it in this article about optimizing API calls). However, the more we were using it, the more obvious it became that React Query was not providing the ideal structure for our data. We ended up moving away from React Query, and are much happier with our new setup.

Jul 25, 2022
Building an internal content moderation app with Basedash in 5 minutes
Quick video showing how to build an internal app from scratch using Basedash.

Jul 20, 2022
How to keep your healthcare data HIPAA compliant with rich edit history
With HIPAA and privacy laws becoming more and more stringent over the years, data security has become a critical factor in maintaining compliance. Implementing databases with robust edit history functions can play a pivotal role in protecting the integrity of medical data.

Jul 20, 2022
Why you need to move away from outdated custom internal tools
It’s likely you and your company have custom internal tools that are beginning to show their age. Here are some reasons to consider replacing them.

Jul 12, 2022
What is a collaborative database admin panel?
Choosing or building an admin panel can be hectic. Startups can leverage tools like Basedash to get a collaborative admin panel that anyone at the company can use.

Jul 11, 2022
Optimizing REST API calls
Recently, we refactored our codebase at Basedash to fetch our server data with React Query and optimize our REST API calls in the process. The transition to React Query allowed for better code readability and the optimization of our API calls resulted in half the number of data fetching API calls...

Jul 9, 2022
How to handle ownership in an early stage startup
In a startup, one of the most important qualities in the first team members is ownership—having incredibly bright, kind people who join you.

Jul 8, 2022
What is a No-Code SQL GUI?
A no-code SQL GUI is a user interface that allows you to interact with a database without using code—in the case of most relational databases, this would be Structured Query Language (SQL). No code SQL GUIs are an excellent way for both newbies and SQL veterans to speed up and simplify the process of querying data.

Jun 13, 2022
Is a lack of technical database knowledge gatekeeping internal data?
Technical database knowledge can be a hurdle. Education can go a long way, but the solution primarily lies in creating user-friendly databases.

Jun 7, 2022
Why a collaborative SQL editor is right for your business
We’re no longer in the times when database manipulation, management, and interpretation were only to be done by admins. It's the 21st century, and both technical and non-technical users should be accommodated when planning database design and access.

May 10, 2022
It’s time to stop mocking data
There aren’t many designers out there who would advocate for working with less or no information about the product they’re building. We want to know who is using our product, what their motivations are, what kind of frustrations they might have, what work environment are they in, and what other tools...

May 6, 2022
How do SQL database indexes work?
An index is a data structure you can add to your SQL database that allows for quick retrieval of certain information. For example, if you have a database of names and phone numbers, an index might be created on the name column so that the database could quickly be searched for a particular student's phone number. You can think of this in the same way that a physical phone book works.

May 3, 2022
The future of internal tools
If you're working on a startup, chances are you've got a lot of internal tools that you've built or are in the process of building. And if you're like most startups, those tools are probably a hot mess. What tools will startups use in the next few years? We have a prediction on trends, tech, and emerging ideas in the space.

Apr 26, 2022
How virtualization increased our table performance by 500%
Refactoring our tables to be virutalized was a huge undertaking, with a huge upside. It sped up table performance by 500% and allowed Basedash to load tables that had previously caused the app to crash.

Apr 22, 2022
The Quickest Ways To Build an Internal Tool in 2022
Internal tooling can be a quick solution to satisfy requirements for colleagues that lack the technical knowledge to build their own custom software. Let's look at how we can beyond simply viewing admin panels, audit logs, and simple CRUD operations -- and into the world of building for the end users that work alongside us each day.

Mar 30, 2022
Make Your SQL Database work for you by building an internal tool
There are many different types of internal tools that you can build. You might want to create a reporting tool for your marketing team, or maybe you need a way to quickly get customer data visible for your customer support team. Or, any number of business apps to help your colleagues manipulate data.

Mar 28, 2022
How to model inheritance in Prisma
Inheritance is a design pattern commonly used in object-oriented programming which allows you to model entities that inherit certain properties or functions from a parent class. This can be incredibly useful for modeling entities which have multiple types, such as different types of activities to show in a feed.

Mar 28, 2022
How to create a database for non-technical users
You've built a solid DB, but your colleagues need to edit data without knowing SQL. Here's how to enabler them to make edits:

Mar 17, 2022
Using Typescript to recursively convert dates to strings
How we wrote our own utility with Typescript to take the Date primitive and transform it into a string for use inside of Basedash.

Mar 16, 2022
Using SQL to check data connectivity in Basedash
In customer support cases, we use Basedash to help get to the bottom of issues. With a bit of browsing, we can pull up Views, find user details, schema, table information, and take a look to see what the issue is.

Mar 14, 2022
How we developed domain-based access for Basedash
A breakdown of the process of how the engineers at Basedash added the feature to allow workspaces to restrict signups based off of user email address.

Mar 10, 2022
Dogfooding. Using Basedash to build Basedash
Using our own product to query our databases speeds up our development time and gives us more opportunities to spot new ideas for features and improve our user's experience.

Jan 5, 2022
How to style console log messages
We recently added an easter egg to Basedash which shows ASCII art of our logo in the browser console. Here's how we we able to style our console.log message with CSS.

Dec 16, 2021
How we manage feature flags at Basedash
At Basedash we use Basedash itself for managing, adding, and removing feature flags for our product. These help use beta test new features, catch bugs, and get feedback before shipping new features.

Oct 4, 2021
How Mobbin moved from Firebase to Supabase
I had the opportunity to chat with Liau Jian Jie, CTO & co-founder of Mobbin and talk about their migration from Firebase to SQL on Supabase earlier this year. Mobbin is a tool for designers to see and track UI flows from mobile applications to help with real-world inspiration for their own design work. I used it personally...

Jun 15, 2021
Essential startup software
Startups can use whatever tools they want to do their job. We're not burdened by legacy contracts, enterprise-wide procurements, existing monolithic workflows, or the burden of training hundreds or thousands of staff for a new tool. We can change workflows on a dime. We can try something new...