Teable is a no-code database that gives a spreadsheet-like interface for getting into knowledge and creating functions from that knowledge. It consists of all the options you’d anticipate from a spreadsheet utility, however with the efficiency of a database.
Some frequent use instances embrace constructing a CRM, an utility for workplace stock administration, or an worker listing — all of which Teable has templates for getting began rapidly from.
“Databases and spreadsheets are like brothers, one is severe and high-performing, providing glorious efficiency and offering highly effective knowledge help for functions, however requiring builders to drive by way of code. The opposite is versatile and straightforward to make use of, a basic infrastructure for knowledge processing within the trendy workplace system, virtually a fundamental ability for everybody. We created an natural mixture of the 2, not solely changing unusual modifying operations right into a what-you-see-is-what-you-get expertise but additionally organically inheriting the mechanism of column knowledge sorts, making it the muse for creating highly effective and secure functions,” the undertaking’s creators wrote in a weblog submit.
In accordance with the creators, whereas Teable seems to be just like the favored software Airtable, below the hood it’s fairly completely different, leading to higher efficiency and superior capabilities. Airtable has a restrict of 100,000 database rows, however due to Teable’s structure, it has no higher restrict as a result of each desk is an actual database desk and has the question and storage capabilities of 1. They’ve examined a desk of 1 million rows of knowledge and have been capable of do advanced filtering and statistical queries in round 200 milliseconds.
Visually, customers can work together with knowledge in a lot of several types of views, together with a grid view the place knowledge is displayed like a traditional spreadsheet, a type view the place knowledge might be collected by way of a type, or a Kanban board. The maintainers are additionally engaged on a number of different view sorts, together with calendar view for monitoring dates and occasions, gallery for displaying media, Gantt view for monitoring undertaking schedules, and a timeline view for monitoring occasions over time.
It additionally supplies collaboration options the place a number of crew members can collaborate on the info and have the database be up to date in real-time.
Teable is constructed on PostgreSQL, which permits it to simply interface with different BI, low-code, and ETL instruments, and helps SQL querying.
Some upcoming options which are being labored on embrace extensions, the flexibility to deliver your personal database, and an AI copilot.
“Whether or not you’re a seasoned developer or a newbie who desires to finish your personal utility however doesn’t perceive databases, you may simply handle knowledge and implement advanced database functions in Teable,” the creators wrote.