openmaptiles/openmaptiles-tools

Make Postserve watch for SQL file changes

Open

#57 opened on Oct 24, 2019

View on GitHub
 (0 comments) (0 reactions) (0 assignees)Python (148 forks)github user discovery
enhancementhelp wantedpostserve

Repository metrics

Stars
 (471 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

When a layer SQL file changes, make Postserve automatically start using it. If prepared statement is used (preferable), Postserve should close and re-open the connection.

Contributor guide

Research direction
Implement a file watcher for .sql files, detect changes, and automatically reload the database connection in Postserve. Use a library like watchdog for cross platform file monitoring. When a prepared statement is used, close and reopen the connection to ensure the new SQL is loaded.
Tech stack
pythonsql
Domain
backendtooling
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
PythonSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60