![]() Another example is that you can't automatically generate slugs. You don't have as much freedom when it comes to validation and connecting models through relationships.Īn example is that you can't have a 1 to 1 or a 1 to many relationship. Working with the Airtable API won't be the same as working with a custom API. Using a static site generator mitigates this problem as it fetches all data when the site is deployed. Unless you have a site with a lot of traffic this should be sufficient. The API has a rate limit of 5 requests per second. This is the reason I chose to use a static site generator over a SSR framework like Nuxt. This means the API has to be called from a server, to avoid the token being public. Unfortunately it's not possible to make endpoints public. If you are using another language to power the site you can hit the endpoints directly.Īuthentication is done with a token. There is an official JS client that can be utilised. This adapt as you add or remove tables or fields from the base. Using a static site generator like Gridsome or Gatsby will allow you to fetch content from difference sources.Īfter creating a base on Airtable, they auto generate API documentation for that base. If you plan on adding other content like blog posts, I would still recommend using Airtable for the list part. ![]() This could be a job board like Cryptocurrency Jobs, a database like Nomad List or a directory like Made with Vue.js. I would recommend using Airtable for list or directory sites. The free plan is sufficient for most small sites. It's also nice not having to worry about setting up and maintaining the server. The asset handling is convenient for Conference HQ because I store a logo for each conference. It's easy to set up, especially if you have experience working with databases. ![]() I would estimate that I've spend around 3 hours setting up the base itself. A custom API solution was overkill and instead of spending time maintaining the API, Airtable allowed me to focus on other things. At it's core, Conference HQ is a list of conferences. But for various reasons I dropped the project for a while and when I revived it I wanted a simpler solution.Īirtable was the right solution for that. I had originally built a Laravel API as the backend. Lastly you can link to other records or read a value from another record and use it in a formula. The attachment field can be used to store images or files to display or download. Rating, duration, barcode, select and attachment fields are also available. You can have a email, phone number or url field if you are storing data about customers. But more advanced fields are available as well. Standard options like text, number and date fields are available. Where Airtable really shines are the field types you can have for each column in a table. Inside tables is where the content lives. It's the equivalent of a database or a spreadsheet. It's simpler than Firebase but has some convenient features like asset handling that makes it better for managing content than Google Sheets.Īt the core of Airtable are bases. ![]() I'll come back to that later.Īirtable is a mix between a spreadsheet and a database. I originally built my own API in Laravel but I had dropped the project at that point. An interesting part of the project is the backend which is powered by Airtable. I recently launched the first version of Conference HQ.
0 Comments
Leave a Reply. |