Simplify your API
summary
A small C++ service called Sticks exposes PostgreSQL functions as HTTP endpoints so a function returns multiple format outputs (JSON, XML, CSV, XLSX, ODS) by appending an extension or calling a format endpoint. It supports named and positional parameters, parameterized calls and chaining of many functions into one HTTP request, traps DB exceptions, and enforces access via GRANT EXECUTE. First JSON-only prototype appears five years ago; deployed in several production apps (including money-handling) for years without crashing. Installation uses FastCGI on Ubuntu 16.04.
AI-written summary · about
chapters (15)
- 0:00Simplify your API
- 3:11The problem
- 5:20Wouldn't it be great if...
- 6:29Synopsis
- 9:18Result types
- 11:35Parameters
- 12:42Chaining function calls
- 13:34Errors
- 14:12Access control
- 17:39Installation
- 22:33Database connection
- 26:04Availability
- 26:47Ok, but what about ...?
- 31:50Roadmap
- 35:06Key insights
related talks
01h 01mOur Adventures With REST API in C++ : Making it Easy
46mPostgreSQL, REST API's and Rapid Application Development for Legacy Data
21mBuilding APIs in Go The Stack Without a Framework
40mSticky API: Connect Bricks and enter a global IT-ecosystem
47mAPI Tips from the Frontline
47mBuilding APIs your users will want to use
28mYou need an API: Now what? — Erin McKean
30mGenerating docs from APIs