Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.
$ python -m SimpleHTTPServer 8000
mdouchin
/ PostGIS_create_missing_spatial_indexes.sql
Last active
June 16, 2020 21:09
PostGIS - Function to create missing spatial indexes in your whole database
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Allow to list all layers with no spatial index | |
| -- To get the list | |
| -- SELECT * FROM create_missing_spatial_indexes(True); | |
| -- To create automatically the missing spatial indexes | |
| -- SELECT * FROM create_missing_spatial_indexes(False); | |
| DROP FUNCTION IF EXISTS create_missing_spatial_indexes(); | |
| DROP FUNCTION IF EXISTS create_missing_spatial_indexes( BOOLEAN ); | |
| CREATE OR REPLACE FUNCTION create_missing_spatial_indexes(simulate BOOLEAN DEFAULT FALSE) | |
| RETURNS TABLE ( |
willurd
/ web-servers.md
Last active
November 10, 2025 16:13
Big list of http static server one-liners