free relational database airtable filemaker

UPDATE: From the looks of your data, it seems that these are log entries being generated from an app of some sort. Failing to develop data use requirements and envision how information must be employed is how many solutions wind up painted into a corner. I recommend you share with us how the data needs to be consumed before asking us how the data model should be designed. Queries are designed to act on tables and views and the only way to blend or merge queries across multiple tables or bases is to build a query app that can proxy your data stores into a unified view. If the posts are segregated by table or base, you will never get to see the results of such a query. You mentioned a query of all posts between two dates. Your question cannot truly be answered in a helpful way until we know more about how the data needs to be used. It’s not as bad as a table for each day, which is simply a lesser bad idea. But in case you really want a new base for every day, that is a really bad idea. I think you are conflating table with base. Should I create a new base for each date or should I continue updating the same base with hundreds of thousands of entries?

Feel free to contact me if you need professional consulting/development work. My 3 platform specialities are Airtable, FileMaker, and Integromat. For example, FileMaker can support billions of records, and it costs a tiny fraction of what Airtable’s enterprise plan costs (i.e. has also come up with some cool ways of storing old records as JSON data within a long text field, which would workaround the record limitations.Īlthough if you’re really looking for an enterprise-level system that supports hundreds of thousands (or millions) of records, I would urge you to explore other platforms as well. I assume you could automate this with a custom JavaScript as well. This is typically done with an automation tool like Integromat.

So once you hit the limit, you would need to figure out some way of deleting old records, or moving old records to another base. There is a maximum of 50,000 records per base (not per table) if you’re on the Pro plan, and a maximum of 100,000 records per base (not per table) if you’re on the Enterprise Plan - which costs $3,000 per month. However, you can’t have hundreds of thousands of entries in Airtable in a single base. Welcome to the community, all of your daily entires should be in the same table.

Free relational database airtable filemaker