SQl Database Server Request from the Browser
summary
Claims a working API that lets browser JavaScript issue real PostgreSQL SQL securely, demonstrates a hosted proxy that enforces per-query roles and parameterized preapproved queries, and shows integrations for emailing and payments via third‑party services. The demo uses a jQuery plugin and a Python module, stores files as blocks with backups to S3, respects CORS, logs every query, and includes account-specific whitelists — the demo runs and the features actually work.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 2:11Web dev evolution basics
- 6:50RESTful APIs client-server
- 10:45Third-party email payments
- 13:24Database roles security
- 17:51Parameterized queries SQL injection
- 20:01SEO AJAX static hosting
- 22:29CORS file access
- 25:21Testing deployment workflow
- 27:04Demo setup account
- 32:20Query execution errors demo
- 35:25Modifying data demo
- 43:15Troubleshooting Q&A
related talks
49mSQLPage — Building a full web application with nothing but Postgres and SQL queries
30mBuilding modern Python web apps with PostgreSQL
20mLeveraging PLV8 in Javascript heavy Web Applications
32mBecause SQL is everywhere but you don't want to use it
40mPoastgreSQL Auditing, Authentication, and Security
45mBuilding Scalable APIs: PostgreSQL Meets GraphQL
50mJS Inside PostgreSQL
44mPostgreSQL for Developers