Teable is a no-code database that gives a spreadsheet-like interface for getting into knowledge and creating functions from that knowledge. It contains all the options you’d count on from a spreadsheet utility, however with the efficiency of a database.
Some frequent use circumstances embody constructing a CRM, an utility for workplace stock administration, or an worker listing — all of which Teable has templates for getting began shortly from.
“Databases and spreadsheets are like brothers, one is critical 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 elementary infrastructure for knowledge processing within the fashionable workplace system, nearly a primary talent for everybody. We created an natural mixture of the 2, not solely changing extraordinary modifying operations right into a what-you-see-is-what-you-get expertise but in addition organically inheriting the mechanism of column knowledge sorts, making it the inspiration for creating highly effective and secure functions,” the mission’s creators wrote in a weblog put up.
In keeping with the creators, whereas Teable seems just like the favored instrument Airtable, below the hood it’s fairly totally 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 standard spreadsheet, a kind view the place knowledge might be collected by way of a kind, 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 mission schedules, and a timeline view for monitoring occasions over time.
It additionally supplies collaboration options the place a number of group members can collaborate on the information 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 embody extensions, the flexibility to convey your individual database, and an AI copilot.
“Whether or not you’re a seasoned developer or a newbie who needs to finish your individual utility however doesn’t perceive databases, you may simply handle knowledge and implement advanced database functions in Teable,” the creators wrote.
Examine different current Open-Supply Tasks of the Week:
Penpot | Dioptra | Semantic Kernel’s Agent Framework | Hoppscotch
