Building a simple-to-use Database Management tool

on YouTube ↗41m

" summary

Jublia builds a two‑way sync that treats Google Sheets as a live mirror of an SQL backend, using the Google Sheets API plus a central middle layer to batch updates (chunks of ~10 rows) and resume after errors; it generates IDs/passcodes for new rows, runs a scraper to enrich company data, and reports progress via Server‑Sent Events backed by AWS DynamoDB. The system handles real events (300 done, ~30/month) and scales to sheets with tens of thousands of rows (50,000 tested) and it works in production.

AI-written summary · about

" chapters (20)

1. 0:00Introduction
2. 2:00About me
3. 2:55What we do
4. 3:58Our booth
5. 4:32Data management
6. 5:17Example
7. 6:00Solution
8. 6:45Data Sync
9. 8:15Lets get started
10. 9:30Creating the Google Sheets
11. 11:53Copying data from the database into the Google Sheets
12. 13:50Simple sync
13. 18:00Middle layer
14. 25:31Creating a sheet
15. 27:22Wrapper functions
16. 29:08Sink endpoint
17. 32:43Processing Data
18. 33:36Dictionary
19. 34:56Dynamic Database
20. 36:14Conclusion

" related talks

• 32mWork Less and Do More: Google Sheets for JavaScript DevelopersFranziska Hinkelmann, Leah Cole · Node+JS Interactive 2019
• 51m30 Ways Google Sheets Can Help Your Company Uncover and Share Data InsightsDaniel Gundrum, Ryan Weber · Google Cloud Next '18
• 16mDo It For Yourself: Creating a data input platform using RHezi Buba · rstudio::conf 2019
• 30mImproving a Developer’s Life with Distributed SQLSrinivasa Vasu · Distributed SQL Summit Asia 2023
• 22mAutomating Custom Reports from JIRA to GoogleSheetsVladymyr Prymakov · QA Fest 2015
• 17mBuilding a Scalable and Performant SaaS Platform with YugabyteDBMANOJ MATHEW · Distributed SQL Summit Asia 2023
• 33mDynamoDB Essentials and Integration for Java DevelopersAndrew Rubalcaba · Commit Your Code 2024
• 22mUsing BigQuery as a data warehouse in B2B startupDenys Tkalich · DevFest Ukraine 2018