This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
Isaac Peña repson
repson
/ ghdb_ripper.py
Created
April 8, 2016 08:44
— forked from tecknoh19/ghdb_ripper.py
Python Google Dork Hacking Database Extraction Tool. Script will crawl exploit-db.com and copy the google dork database into a csv file
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
| #!/usr/bin/python | |
| # Exploit-db.com Google Dork Hacking Database Replicator written by Andy Bricker | |
| # Proof of concept. You shouldnt use this script without prior consent from Exploit-db.com | |
| # http://andybricker.com | |
| # Contact: andy at andybricker.com | |
| # Requirements | |
| # Python 2.7 (Has not been tasted on later versions) | |
| # Usage: |
repson
/ Flatten JSON or a nested dictionary
Created
July 14, 2017 18:04
— forked from higarmi/Flatten JSON or a nested dictionary
This python recursive function flattens a JSON file or a dictionary with nested lists and/or dictionaries. The output is a flattened dictionary that use
dot-chained names for keys, based on the dictionary structure. This allows for reconstructing the JSON structure or converting it to
other formats without loosing any structural information.
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
| """ | |
| example: The following JSON document: | |
| {"maps":[{"id1":"blabla","iscategorical1":"0", "perro":[{"dog1": "1", "dog2": "2"}]},{"id2":"blabla","iscategorical2":"0"}], | |
| "masks":{"id":"valore"}, | |
| "om_points":"value", | |
| "parameters":{"id":"valore"}} | |
| will have the following output: | |
| {'masks.id': 'valore', 'maps.iscategorical2': '0', 'om_points': 'value', 'maps.iscategorical1': '0', | |
| 'maps.id1': 'blabla', 'parameters.id': 'valore', 'maps.perro.dog2': '2', 'maps.perro.dog1': '1', 'maps.id2': 'blabla'} |
repson
/ PostgreSQL_PostGIS_Cheatsheet.md
Last active
September 30, 2019 15:04
— forked from clhenrick/README.md
PostgreSQL & PostGIS cheatsheet (a work in progress)
repson
/ README.md
Created
March 24, 2023 20:58
— forked from crypticmind/README.md
Setup lambda + API Gateway using localstack
Example on how to run locally an AWS Lambda via API Gateway using localstack.
Based on...