Ganeshan Venkataraman ganeshan

Backend as a Service

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.

NOTE: This is a question I found on StackOverflow which I’ve archived here, because the answer is so effing phenomenal.

If you are not into long explanations, see [Paolo Bergantino’s answer][2].

	import requests
	from bs4 import BeautifulSoup


	def get_table_from_slickcharts(url: str) -> List[Dict[str, Union[str, float]]]:
	# parse table for symbols from slickcharts
	headers = {'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36'}
	response = requests.get(url, headers=headers)

	data = []

	import json

	print('Loading function')

	def lambda_handler(event, context):
	print('------------------------')
	print(event)
	#1. Iterate over each record
	try:
	for record in event['Records']:

	# The NYC Taxis Dataset - https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page

	pip install parquet-cli

	parq data/yellow_tripdata_2022-01.parquet

	parq data/yellow_tripdata_2022-01.parquet --schema

	parq data/yellow_tripdata_2022-01.parquet --head 10

	-- A method for storing and retrieving hierarchical data in sqlite3
	-- by using a trigger and a temporary table.
	-- I needed this but had trouble finding information on it.

	-- This is for sqlite3, it mostly won't work on anything else, however
	-- most databases have better ways to do this anyway.

	PRAGMA recursive_triggers = TRUE; -- This is not possible before 3.6.18

	-- When creating the Node table either use a primary key or some other

	import java.util.Arrays;
	import org.apache.commons.cli.CommandLine;
	import org.apache.commons.cli.CommandLineParser;
	import org.apache.commons.cli.DefaultParser;
	import org.apache.commons.cli.HelpFormatter;
	import org.apache.commons.cli.Option;
	import org.apache.commons.cli.Options;
	import org.apache.commons.cli.ParseException;

	public class Application {