spec.txt

[2-3 weeks] For ur task, I want u to do an Airtable clone. Use https://create.t3.gg/, deploy on Vercel.

1. Use the TanStack table library for the table UIs.
2. Use PostgreSQL for DB.
3. Just focus on the main page with tables, columns, and cells.
4. UI needs to match 1:1 with Airtable
5. You don’t have to implement all functionalities.
6. Be able to log in via Google and create bases. In each base, I can create tables.
7. Be able to dynamically add columns.
    7.1 Text and Number type columns are fine for now
8. Editing cells, and the arrow keys + tab key should move me across the table smoothly
9. Creating a new table will show default rows and columns. User fakerjs for data
10. I want to see a table w/ 100k rows and scroll down without lag
    10.1 Add a button I can click that will add 100k rows to my table.
    10.2 Implement virtualized infinite scroll using TRPC’s hooks and TanStack virtualizer
11. I want to be able to search across all the cells. Make this act as a filter for the rows.
12. I want to be able to create a 'view' of a table and save the following configurations
    12.1 Filters on columns: for both numbers (greater than, smaller than) and text (is not empty, is empty, contains, not contains, equal to)
    12.2 Simple sorting on columns: for text A→Z, Z→A, for numbers, do decreasing or increasing
    12.3 Search, filter, and sort have to be done at the database level
    12.4 Can search through and hide/show columns.
13. Make sure there's a loading state
14. The ultimate goal - if there are 1m rows, it can still load without an issue!

Please send daily updates to the Slack channel and timestamp it with day 1, day 2, day 3 etc.

Disclaimer: Lyra will not be using your take home project for any commercial purposes.