Baastronaut – open-source Airtable alternative built on PostgREST
Hi HN, sharing a project that my friend and I are working on - Baastronaut (https://github.com/baastronaut/baastronaut) - an open-source Airtable alternative. While looking for Airtable-like tools for my work, I realised that existing tools don't suit what I need. They are either too technical for non-technical users or do not have good developer APIs. For example, to filter for certain rows in Airtable, you need to use filterByFormula, which is clunky. Our main design principle is "projects and spreadsheets should represent database relations but don't make it technical"…
What it does
In the maker’s words, at launch
Hi HN, sharing a project that my friend and I are working on - Baastronaut (https://github.com/baastronaut/baastronaut) - an open-source Airtable alternative. While looking for Airtable-like tools for my work, I realised that existing tools don't suit what I need. They are either too technical for non-technical users or do not have good developer APIs. For example, to filter for certain rows in Airtable, you need to use filterByFormula, which is clunky. Our main design principle is "projects and spreadsheets should represent database relations but don't make it technical" (e.g., spreadsheets == tables, projects == schemas, links to other spreadsheets == foreign-key references). This is in contrast with other tools that use a wide table to store user's columns, type, and data. By sticking to the "represent database relations" principle, we are able to use PostgREST to generate flexible GraphQL-like REST APIs (plus, I play with PostgREST a lot, so i thought why not build something with it.) For users that are managing the spreadsheets, we make it non-technical-friendly by hiding certain details, e.g. only basic data types, instead of all the data types in Postgres, are shown to users. Users manage spreadsheets and not databases in our app. We spoke to a few people and we understand that it is common to build this (database + server to auto-generate APIs + simple crud interface) in-house to replace Airtable. We are still very early and there are a lot of features we want to build, e.g. a good fuzzy search. It’s not for production use yet but we hope people can try it and/or give us their comments. Please share with us your feedback on anything. Thank you!
Does the same job
all alternatives →
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, March 2023
the whole month →
- BI
I'm a big fan of the BBC podcast In Our Time -- and (like most people) I've been playing with the OpenAI APIs. In Our Time has almost 1,000 episodes on everything from Cleopatra to the evolution of teeth to plasma physics, all still available, so it's my starting point to learn about most topics. But it's not well organised. So here are the episodes sorted by library code. It's fun to explore. Web scraping is usually pretty tedious, but I found that I could send the minimised HTML to GPT-3 and get (almost) perfect JSON back: the prompt includes the Typescript definition. At the same time I…
AI · 2023 · genmon.github.io