Skip to content

Instantly share code, notes, and snippets.

View arvsrao's full-sized avatar

Arvind ರಾವ್ arvsrao

View GitHub Profile
@arvsrao
arvsrao / randomSegments.py
Created May 14, 2014 08:23
code for generating the empirical distribution of max-segment lengths
from random import uniform
from numpy import array
from math import pi
def MaxArc(N):
cuts = [ uniform(0, 2*pi) for x in range(N) ]
cuts.sort()
other = [x for x in cuts]
other.insert(0, other.pop())
cuts[0]+=2*pi
@arvsrao
arvsrao / pi_day.py
Last active July 28, 2023 04:53
Monte Carlo Approximation of PI
from random import uniform
"""
Monte Carlo approximation of PI
Sample run:
person@pc-1 ~/> python pi_day.py
approximation of PI: 3.1427
"""
def generatePoints():
@arvsrao
arvsrao / odbc_setup_macos.md
Last active July 28, 2023 04:54
Guide to accessing MS SQL Server in Mac OS X via PyODBC

Since I spent essentially two full days figuring out how to access a corporate MS SQL database pythonicly, I figured I should leave some notes, for future reference and to aid other souls looking to do the same.

These instructions and the commands that follow, were executed on a MAC OS 10.8.3 system. Additionally, I found this blog [post][1] especially helpful during the debugging process.

On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these driver managers. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing [pyodbc][3] requires iODBC as its manager.

Start by installing freeTDS libraries. FreeTDS allows unix programs to talk natively with MS SQL and SyBase databases.

brew intsall freetds