2
13
+ 1
5

What is BaseDash?

Edit your database with the ease of a spreadsheet. Use it to manage users, provide customer support, or export raw data for analysis. It's like Airtable but for your product’s actual database.
BaseDash is a tool in the Database Tools category of a tech stack.

Who uses BaseDash?

Companies

Developers

BaseDash Integrations

MySQL, PostgreSQL, Microsoft SQL Server, MariaDB, and Amazon Redshift are some of the popular tools that integrate with BaseDash. Here's a list of all 5 tools that integrate with BaseDash.
Private Decisions at about BaseDash

Here are some stack decisions, common use cases and reviews by members of with BaseDash in their tech stack.

Max Musing
Max Musing
Founder & CEO at BaseDash · | 5 upvotes · 521 views
Shared insights
on
BaseDashBaseDash

You're right that there isn't a great way to join tables with Airtable's API. The closest you can get is to use a linked record field, which acts as a pointer to another record. You still end up with the problem you mentioned of having to run another query on the second table separately.

Your best bet is to stick with an actual SQL database. Using an ORM should make your life significantly easier so you don't actually have to write raw SQL. If you still want a graphical interface to your data, BaseDash lets you view and edit SQL databases just like Airtable. A full API with join support is coming soon, so that could be your perfect solution to this problem.

See more
Public Decisions about BaseDash

Here are some stack decisions, common use cases and reviews by companies and developers who chose BaseDash in their tech stack.

Max Musing
Max Musing
Founder & CEO at BaseDash · | 8 upvotes · 4.6K views

Socket.IO is great for building real-time systems like chat. It's effectively a nice wrapper around WebSockets, with the ability to fallback to other methods for browsers that don't support it. We just used it to implement real-time collaboration at BaseDash, including a chat system like you're looking to build.

Node.js is probably the correct choice, especially if you're already familiar with it You'll probably still need to build an API to send requests to your server, and then use Socket.IO to push messages to your clients. This will let you authenticate users and store messages on your database so you can retrieve them later. PostgreSQL and MongoDB are good options for your database, you should be fine either way. Don't worry about speed, they'll both be sufficient.

React on the front end makes it really simple to handle real-time updating data. Again, even better since you're already familiar.

See more
Max Musing
Max Musing
Founder & CEO at BaseDash · | 5 upvotes · 12K views

Node.js is a great option for real-time applications, especially in conjunction with Socket.IO.

In terms of databases, I'd go with PostgreSQL. MongoDB has its benefits (schema-less, sharding, map-reduce), but for most CRUD-based apps, it makes sense to store the bulk of your data in a relational database (of which PostgreSQL is the best IMO). You can throw in MongoDB if you have a specific need for it. There's certainly no need to use both MySQL and PostgreSQL.

As for GraphQL, it can be nice to work with since you don't need to predefine specific data endpoints on your backend, instead shifting the power to your frontend in requesting the data it needs. It's also useful for public APIs, when you don't know what data users want (see Github's API). It can be useful at the early stage when you're prototyping and want to be able to fetch data quickly, but certainly isn't necessary.

At BaseDash we use Node.js, ExpressJS, Socket.IO, PostgreSQL, and Sequelize to fit our use case of database management and real-time operations.

See more
Max Musing
Max Musing
Founder & CEO at BaseDash · | 5 upvotes · 521 views
Shared insights
on
BaseDashBaseDash

You're right that there isn't a great way to join tables with Airtable's API. The closest you can get is to use a linked record field, which acts as a pointer to another record. You still end up with the problem you mentioned of having to run another query on the second table separately.

Your best bet is to stick with an actual SQL database. Using an ORM should make your life significantly easier so you don't actually have to write raw SQL. If you still want a graphical interface to your data, BaseDash lets you view and edit SQL databases just like Airtable. A full API with join support is coming soon, so that could be your perfect solution to this problem.

See more
Max Musing
Max Musing
Founder & CEO at BaseDash · | 4 upvotes · 362 views

How are you managing your PostgreSQL schema? It doesn't have to be hard to add or remove fields. We're working on a SQL database client at BaseDash that lets you add/remove columns in a couple clicks.

If you decide to migrate some of your data to MongoDB, you can definitely manage the two databases in parallel. For any records that need to be linked, you can treat it just like a foreign key by creating a column that points to an ID in the other database. For example, you might store user settings in MongoDB, and include a UserId field that points to your User record in your Postgres database.

See more
Max Musing
Max Musing
Founder & CEO at BaseDash · | 3 upvotes · 2.5K views

Node.js and ExpressJS is a good choice for backend, the stack makes it really easy to build a REST API.

I'm not exactly sure what you mean by using ExpressJS as an admin panel. Express is a lightweight backend framework for Node.js that lets you build your endpoints quickly and with minimal code. If you're looking for an admin panel to manage the data on your mobile app, check out BaseDash. It lets you view and edit data from your SQL database with the simplicity of Airtable.

See more
Max Musing
Max Musing
Founder & CEO at BaseDash · | 0 upvotes · 220 views

Most front end frameworks these days are built around the concept of "reactivity" (not exclusive to React). This means that you describe the content of your UI in a declarative way, rather than imperative, as you would with plain JavaScript or something like jQuery.

For example, say you have a counter app, where clicking a button increases the count. With a traditional imperative coding style, clicking the button would trigger code to increment a variable, then update the value of the counter text with that variable. On the other hand, in a declarative style, clicking the button would trigger code only to increment the variable. Your framework would automatically detect that the value changed and update the counter text accordingly.

This makes your life much easier. You no longer have to worry about keeping the DOM in sync with your application state. Your framework does it for you.

Most web applications these days use a declarative framework, like Angular 2, React, or Vue.js. At BaseDash we use React — it's got a big community with wide support and lots of useful libraries. I've heard good things about Vue too.

See more

BaseDash's Features

  • Filter & sort
  • Schema management
  • Real-time collaboration
  • Dark mode
  • Edit history
  • Undo edits
  • Shared SQL queries
  • Data visualization

BaseDash Alternatives & Comparisons

What are some alternatives to BaseDash?
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Sequel Pro
Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
PostGIS
PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.
Microsoft SQL Server Management Studio
It is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It provides tools to configure, monitor, and administer instances of SQL Server and databases. Use it to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.
See all alternatives

BaseDash's Followers
13 developers follow BaseDash to keep up with related blogs and decisions.
rh-6
Ghislain Pitrat
Max Musing
Cody Coe
Lyman Meng
Annie D
Rohit Wadhwa
butteryoon
jeremyben
Brian Herron