René's URL Explorer Experiment

Title: WIP: Discovery API by lmangani · Pull Request #12 · Query-farm/httpserver · GitHub

Open Graph Title: WIP: Discovery API by lmangani · Pull Request #12 · Query-farm/httpserver

X Title: WIP: Discovery API by lmangani · Pull Request #12 · Query-farm/httpserver

Description: Discovery API ⚠️ This is just an experiment and will most likely end up in a different extension The optional discovery API offers an easy hook for servers to advertise and discover each other (flock) Endpoints POST /subscribe/{secretHash} - Register a peer GET /discovery/{secretHash} - Get list of active peers DELETE /unsubscribe/{secretHash}/{peerId} - Remove peer Start Server w. DUCKDB_HTTPSERVER_DISCOVERY=1 D SELECT httpserve_start('0.0.0.0',9999, ''); ┌──────────────────────────────────────┐ │ httpserve_start('0.0.0.0', 9999, '') │ │ varchar │ ├──────────────────────────────────────┤ │ HTTP server started on 0.0.0.0:9999 │ └──────────────────────────────────────┘ Register a Peer under a secret hash CURL curl -X POST "https://localhost:9999/subscribe/secretHash" \ -H "Content-Type: application/json" \ -d '{ "name": "service1", "endpoint": "http://192.168.1.100:8080", "ttl": 300 } SQL INSTALL http_client FROM community; LOAD http_client; LOAD json; WITH __input AS ( SELECT http_post( 'http://localhost:9999/subscribe/secretHash', headers => MAP { }, params => MAP { 'name': 'quackpipe1', 'endpoint': 'https://1.1.1.1', } ) AS res ) SELECT res->>'reason' as res, res->>'status' as status FROM __input; Check peers table D SELECT name, endpoint, source_address as sourceAddress, peer_id as peerId, metadata, ttl, strftime(registered_at, '%Y-%m-%d %H:%M:%S') as registered_at FROM peers WHERE hash = 'secretHash'; ┌──────────┬───────────────────────────┬───────────────┬──────────────────────────────────┬──────────┬───────┬─────────────────────┐ │ name │ endpoint │ sourceAddress │ peerId │ metadata │ ttl │ registered_at │ │ varchar │ varchar │ varchar │ varchar │ varchar │ int64 │ varchar │ ├──────────┼───────────────────────────┼───────────────┼──────────────────────────────────┼──────────┼───────┼─────────────────────┤ │ service1 │ http://192.168.1.100:8080 │ xxx.xx.xx.xxx │ 0872c98634ce7e608e19aa1a1e6cf784 │ {} │ 300 │ 2024-11-14 19:44:23 │ └──────────┴───────────────────────────┴───────────────┴──────────────────────────────────┴──────────┴───────┴─────────────────────┘ Discover Peers CURL curl "http://localhost:9999/discovery/secretHash" SQL D SELECT * FROM read_ndjson_auto('http://localhost:9999/discovery/secretHash'); ┌──────────┬──────────────────────┬────────────────┬──────────────────────────────┬──────────┬─────────┬─────────────────────┐ │ name │ endpoint │ source_address │ peer_id │ metadata │ ttl │ registered_at │ │ varchar │ varchar │ varchar │ uuid │ varchar │ varchar │ timestamp │ ├──────────┼──────────────────────┼────────────────┼──────────────────────────────┼──────────┼─────────┼─────────────────────┤ │ service1 │ http://192.168.1.1… │ 127.0.0.1 │ 0872c986-34ce-7e60-8e19-aa… │ │ 3600 │ 2024-11-15 14:13:50 │ └──────────┴──────────────────────┴────────────────┴──────────────────────────────┴──────────┴─────────┴─────────────────────┘ D ⚠️ minor issue with peer_id being a UUID and python hating it

Open Graph Description: Discovery API ⚠️ This is just an experiment and will most likely end up in a different extension The optional discovery API offers an easy hook for servers to advertise and discover each other (fl...

X Description: Discovery API ⚠️ This is just an experiment and will most likely end up in a different extension The optional discovery API offers an easy hook for servers to advertise and discover each other (fl...

Opengraph URL: https://github.com/Query-farm/httpserver/pull/12

X: @github

direct link

Domain: patch-diff.githubusercontent.com

Links:

Viewport: width=device-width