Overview
Learn how to create simple APIs directly from PostgreSQL databases in this 14-minute tutorial video. Discover the fundamentals of PostgREST, a tool that automatically serves APIs based on database definitions. Follow along to set up a read-only API, execute PostgREST, perform data queries, implement write access functionality, and utilize the Python client. Master the process of defining APIs within a Postgres database structure and understand why PostgREST offers an efficient solution for API development. Gain practical experience through hands-on demonstrations that progress from basic read operations to more complex write access implementations.
Syllabus
Intro
Defining a Read Only API
Running PostgREST
Querying Data
Adding Write Access
Using the Python Client
Conclusion
Taught by
Ian Wootten