cpursley

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

joelonsql

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

bertt

public static double[] ToSphericalMercatorFromWgs84(double Longitude, double Latitude)
{
    var x = Longitude * 20037508.34 / 180;
    var y = Math.Log(Math.Tan((90 + Latitude) * Math.PI / 360)) / (Math.PI / 180);
    y = y * 20037508.34 / 180;
    return new double[] { x, y };
}

public static double[] ToWgs84FromSphericalMercator(double x, double y)
{

stucka

My Python initial setup:
python -m pip install --upgrade pip

Is it sqwaking about managed configuration? If you're on Unix and feeling dumb:
cd /.config
mkdir pip
cd pip
nano pip.conf
...
Add this:

kelvinn

How-To: Install GDAL Python Bindings

I've found two ways to install the GDAL Python bindings on Mac.

Via GDAL Framework / QGIS

First, you can install the GDAL Framework via QGIS (or get it directly), and then do...

mbostock

license: bsd-3-clause

mbostock

*.png
*.gif

bmcbride

Wiring up a Google Form to GitHub is not that difficult with a little bit of Apps Script automation. All you need is a Google account, a GitHub account, and a web browser...

Set up your GitHub Personal Access Token

Personal access tokens provide an easy way to interact with the GitHub API without having to mess with OAuth. If you don't already have a personal access token with repo or public_repo access, visit your GitHub settings page and generate a new token.

Be sure to copy your token some place safe and keep it secure. Once generated, you will not be able to view or copy the token again.

Set up the Form & Spreadsheet

1. Create a Google Form.

Robinlovelace

# # # # # # # # # # # # # # # # # # # # 
# Simplify sp objects w. mapshaper    #
# Needs https://nodejs.org installed  #
# Tested on Windows and Linux         #
# # # # # # # # # # # # # # # # # # # # 

# # # # # #
# R setup #
# # # # # #

mmohiudd

DROP TABLE IF EXISTS test_table;
CREATE TABLE test_table(
    id bigserial NOT NULL,
    latitude double precision,
    longitude double precision,
    geom geometry,
    geog geography,
    updated_ts double precision,
    CONSTRAINT test_table_unique_key UNIQUE (id)
);