Skip to content

Instantly share code, notes, and snippets.

View sanand0's full-sized avatar

S Anand sanand0

View GitHub Profile
@sanand0
sanand0 / defog-approach.md
Created November 1, 2025 16:08
Defog's approach to Text-to-SQL

Generated via GitHub Copilot + Claude 4.5 Sonnet on 1 Nov 2025 on https://github.com/defog-ai/defog/ with the prompt: "Summarize the defog approach to text-to-SQL clearly with examples and links to source."

Defog's Approach to Text-to-SQL

Defog provides a comprehensive toolkit for converting natural language questions into SQL queries and executing them against databases. Here's how their approach works:

Core Architecture

1. Multi-Provider LLM Integration

@sanand0
sanand0 / README.md
Last active June 6, 2022 16:04
Song List (2022)

This is my music library (Jun 2022). See

@sanand0
sanand0 / My Lab.POWERPOINT.yaml
Created November 10, 2019 06:24
Create a new snippet from a blank template.
name: My Lab
description: Create a new snippet from a blank template.
host: POWERPOINT
api_set: {}
script:
content: |
$("#run").click(run);
function run() {
Office.context.document.getSelectedDataAsync(Office.CoercionType.Text, (asyncResult) => {
@sanand0
sanand0 / manhattan.py
Created July 15, 2019 16:09
Manhattan Coffee Shop location scraper
import geopandas
import os
import pandas as pd
import requests
def mcdonalds():
url = 'https://www.mcdonalds.com/googleapps/GoogleRestaurantLocAction.do'
data = requests.get(url, params={
'method': 'searchLocation',
@sanand0
sanand0 / .gitignore
Last active December 30, 2015 16:24
Extract actors / actresses acting in a movie from the IMDb dumps
*.7z
*.list
*.txt

Automating news discovery in real-time

Talk outline

  • How media works
    • There's a difference in positioning: in-depth vs breaking news
    • Crunch in talent, margin pressures. Not enough staff to 'break news'
    • Sources of breaking news: agencies, in-house, competition, social media
    • Increasingly, social media is a dominant source
  • How can we source social media data at scale
@sanand0
sanand0 / .gitignore
Last active August 29, 2015 14:00
A simple website monitor
*.pyc
@sanand0
sanand0 / stock.py
Last active October 5, 2020 04:22
Pull currency and stock data
#! /usr/bin/env python
"""
Author: Bastin Robin
"""
import os
import logging
from urllib import urlencode
import datetime
import pandas as pd
@sanand0
sanand0 / README.md
Created April 29, 2013 06:54
Convert topojson file into SVG via Albers projection using node.js

Convert topojson file into SVG via Albers projection using node.js

@sanand0
sanand0 / gitlab.sh
Last active December 28, 2020 20:13
Installing Gitlab
# Gitlab 5.1: https://github.com/gitlabhq/gitlabhq/blob/5-1-stable/doc/install/installation.md
# Set up an AWS EC2 Ubuntu 12.04 LTS Server.
# Use ap-southeast-1b: spot pricing is smoother
# Log in as ubuntu@
sudo apt-get -y update
sudo apt-get -y upgrade
# Install the required packages.