Chris Luman khazaddim

There are a number of good introductory SQL resources available for free and online. There are also some paid resources which I recommend for beginners, that are very effective, and well worth expensing in my opinion.

A couple of notes:

I haven’t used all of these resources, but they come with strong recommendations around the web or myself/my peers.
You absolutely don’t need to use every single resource. Find a couple that work for you, and go to town.
You can always reach out to me if you have questions. I always paste this online when people are new to asking very technical questions – it’s not meant to be snarky – it's a gentle guide on how to compose your questions and gather necessary resources in order to best give technical people the information needed to get a quick/effective response: http://www.mikeash.com/getting_answers.html

Video/Class/Mini-course based:

Stanford Self-paced ‘Database’ course

The original Coursera

PSOBB Wine mipmap patch

For Phantasy Star Online: Blue Burst versions 1.25.10-1.25.13 and the Wine 1.7/1.8 series.

PSOBB tries to write all mipmaps at once on a single LockRect on mip level 0. This is undocumented behavior in Direct3D and PSOBB will clobber the implementation structs if this is not accounted for.

These patches, based on the PlayOnLinux League of Legends patch, do two

Starting Postgresql in Windows without Install

Problem

This is a question that comes up quite often by windows users, so thought we would share how we normally do it. The question is

Can you run a PostgreSQL server on your windows desktop/server box without having to install anything?

The answer is

	#!/usr/bin/python2


	# Copyright (C) 2016 Sixten Bergman
	# License WTFPL
	#
	# This program is free software. It comes without any warranty, to the extent
	# permitted by applicable law.
	# You can redistribute it and/or modify it under the terms of the Do What The
	# Fuck You Want To Public License, Version 2, as published by Sam Hocevar. See

	Dependences:

	sudo apt-get update
	sudo apt-get install build-essential
	apt-get install python-dev
	sudo pip install -U setuptools

	Steps:

	download from https://mrjbq7.github.io/ta-lib/install.html

	class Session:
	__init__(api_key)
	set_api_secret(api_secret)
	set_redirect_uri(redirect_uri)
	set_code(code)
	get_login_url(self)
	retrieve_access_token(self)


	class Upstox:

	import requests, talib
	import numpy as np
	import matplotlib.pyplot as plt
	import pandas as pd
	from mpl_finance import candlestick_ohlc as candles
	import csv
	import matplotlib.dates as mdates
	import time
	from db import Session, Signals
	from flask import Flask, request, url_for, jsonify