Teable – SD Times Open-Source Project of the Week

Teable is a no-code database that gives a spreadsheet-like interface for coming into knowledge and creating purposes from that knowledge. It contains the entire options you’d count on from a spreadsheet software, however with the efficiency of a database. 

Some frequent use instances embody constructing a CRM, an software 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 severe and high-performing, providing wonderful efficiency and offering highly effective knowledge assist for purposes, however requiring builders to drive by means of code. The opposite is versatile and simple to make use of, a basic infrastructure for knowledge processing within the trendy workplace system, nearly a primary ability for everybody. We created an natural mixture of the 2, not solely changing extraordinary enhancing 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 muse for creating highly effective and steady purposes,” the undertaking’s creators wrote in a weblog put up.

Based on the creators, whereas Teable seems to be just like the favored device 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 information and have been in a position to do advanced filtering and statistical queries in round 200 milliseconds. 

Visually, customers can work together with knowledge in a variety of various kinds of views, together with a grid view the place knowledge is displayed like a standard spreadsheet, a type view the place knowledge could be collected through 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 staff 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 power to convey your individual database, and an AI copilot. 

“Whether or not you’re a seasoned developer or a newbie who desires to finish your individual software however doesn’t perceive databases, you may simply handle knowledge and implement advanced database purposes in Teable,” the creators wrote.

Examine different latest Open-Supply Initiatives of the Week:

Penpot | Dioptra | Semantic Kernel’s Agent Framework | Hoppscotch