Labs Postgis Preview
A lightweight express app and leaflet frontend for previewing PostGIS queries
Overview
The CircleCIPostGIS Preview is a lightweight node API and frontend designed for efficiently previewing PostGIS queries. Created to address the need for testing PostGIS queries in a local environment with quick iteration, this tool simplifies the process by providing a SQL pane and map view for visualizing geometry results in real-time.
Features
- Express.js App: Single endpoint /sql for passing SQL queries to PostGIS.
- TopoJSON Transformation: Data transformation into TopoJSON format for frontend rendering.
- Bootstrap Layout: Simple layout with Leaflet map, CartoDB basemaps, table, and SQL pane.
- Easy Setup: Clone the repository, set up a PostGIS instance, configure .env file, install dependencies, and run the app.
Summary
The CircleCIPostGIS Preview tool offers a convenient solution for developers needing to test and visualize PostGIS queries locally. With its straightforward setup process and key features like TopoJSON transformation and a user-friendly interface, this tool facilitates efficient query testing and iteration. With further enhancements planned for serving mvt locally, it promises to enhance the user experience even more in the future.
- Express
Express.js is a simple Node.js framework for single, multi-page, and hybrid web applications.
- Eslint
ESLint is a linter for JavaScript that analyzes code to detect and report on potential problems and errors, as well as enforce consistent code style and best practices, helping developers to write cleaner, more maintainable code.