Brenton Cleeland sesh

Django URLs 2.0

TIL from reading an early Jan post on the Django mailing list. Turns out that PyPI is making a whole bunch of data available on Google BigQuery.

In a subsequent post, Alex Gaynor gave us a query that extracts Python versions used to download a package on PyPI in the previous two weeks:

SELECT
  REGEXP_EXTRACT(details.python, r"^([^\.]+\.[^\.]+\.[^\.]+)") as python_version,
  COUNT(*) as download_count,
FROM

Why shouldn't i use mysql? / mongo?
Should I use jinja, I read it's faster?
Should I use sqlalchemy, I read it's superior?
How do i make this thing happen in parallel/not wait for xxx to finish?
Why does django ask for a default? (But my table has no data in it wtf django!?!)
- FunkyBob | I think, perhaps, it's time I wrote a blog post on "why does a migration adding a field need a default?"
Why do I need to commit my migrations? Why can't I just run makemigrations on the server?
migrations are source, makemigrations is a helper which takes you part way
i've seen people accidentally lose their migrations on production… oops now what?

	from django.contrib import admin
	from django.contrib.auth.admin import UserAdmin
	from django.utils.translation import ugettext_lazy as _

	from .models import User


	class CustomUserAdmin(UserAdmin):
	fieldsets = (
	(None, {'fields': ('email', 'password')}),

	// Pace your settings in this file to overwrite the default settings
	{
	"python.linting.enabled": true,
	"python.linting.pylintEnabled": false,
	"python.linting.flake8Enabled": true,
	"window.zoomLevel": 0,
	"files.insertFinalNewline": true,
	"editor.insertSpaces": true,
	"files.trimTrailingWhitespace": true,
	}

	#!/usr/bin/env python3

	"""
	Download audio files from youtube links in a reddit thread.
	Works a treat on /r/music/

	Usage:
	./TUNE.py <url>

	Requirements: youtube-dl, beautifulsoup4, python>=3.5

	#!/usr/bin/env python

	from urllib import urlopen


	content = urlopen('http://markets.brntn.me').read().decode()

	clinton = float(content.split('Clinton:<span class="text-right">')[-1].split('%')[0])
	trump = float(content.split('Trump:<span class="text-right">')[-1].split('%')[0])
	updated = content.split('Updated: ')[-1].split('\n')[0]

	{% load static %}<!doctype html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta http-equiv="x-ua-compatible" content="ie=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">

	<title>{% block title %}base.html via @sesh{% endblock %}</title>

	<!-- Favicons in 32x32 and 16x16 -->