jonico

import { connect } from '@planetscale/database'
import dotenv from 'dotenv'
import express from 'express'

import { ProxyAgent } from 'undici';
const agent = new ProxyAgent('http://localhost:5555');

global[Symbol.for('undici.globalDispatcher.1')] = agent;
process.env['NODE_TLS_REJECT_UNAUTHORIZED'] = '0';

jonico

import sys
from awsglue.transforms import *
from awsglue.utils import getResolvedOptions
from pyspark.context import SparkContext, SparkConf
from awsglue.context import GlueContext
from awsglue.job import Job
import time
from pyspark.sql.types import StructType, StructField, IntegerType, StringType

sc = SparkContext()

jonico

PLANETSCALE_DB=brandnewdb
PLANETSCALE_BRANCH=mybranch
PLANETSCALE_ORG=jonico
PLANETSCALE_SERVICE_TOKEN=pscale_tkn_loCzIH7NktDK-GWJ71eX97Qr5D3a9iEO_pgHCSHUtw  
PLANETSCALE_SERVICE_TOKEN_NAME=69xrlIwgs4ms

leemour

SELECT
    t.tablename,
    foo.indexname,
    c.reltuples AS num_rows,
    pg_size_pretty(pg_relation_size(quote_ident(t.tablename)::text)) AS table_size,
    pg_size_pretty(pg_relation_size(quote_ident(indexrelname)::text)) AS index_size,
	pg_relation_size(quote_ident(indexrelname)) as index_size_bytes,
    CASE 	WHEN indisunique THEN 'Y'
       		ELSE 'N'
    END AS UNIQUE,

mattlord

mysql> SELECT @@version;
+-----------+
| @@version |
+-----------+
| 8.0.25    |
+-----------+
1 row in set (0.00 sec)


mysql> SELECT UUID() INTO @myuuid;

samlambert

We want PlanetScale to be the best place to work. But every company says that, and very few deliver. Managers have a role in creating an amazing work experience, but things go awry when the wrong dynamic creeps in.

We have all seen those managers who collect people as “resources” or who control information as a way to gain “power.” In these cultures, people who “can’t” end up leading the charge. This is management mediocrity.

What will make us different? At PlanetScale, we won’t tolerate management mediocrity. We are building a culture where politics get you nowhere and impact gets you far. Managers are here to support people who get things done. They are as accountable to their team as their team is accountable to them.

We evaluate managers on the wellbeing and output of their team, how skillfully they collaborate with and influence others, and how inclusively and transparently they work.

You can expect your manager to:

• Perceive a better version of you and support you in getting there

lotharschulz

Publishing artifacts with AWS Codeartifact and GitHub Packages

• Blog Post: Publishing artifacts with AWS Codeartifact and GitHub Packages
• GitHub repository with full code details: reach-now/codeartifact-packages-publishing

AWS Codeartifact

Repository Setup

aws cli

mikebway

Using GraphQL to Remove GitHub Packages

This is easily done with GraphiQL installed as an application on your laptop but any tool that allows HTTP headers to be easily configured will work.

NOTE: You Remove Package Versions not Packages Themselves

GitHub provides no mechanism (at the time of writing) to remove packages as such, but removing all of the versions of a package has the equivalent effect. You may have to repeat the delete package version operation many times but in the end, the package will be gone and consume no more of your package space allocation.

barbietunnie

Useful Postgres Commands

1. Determine disk usage of a particular table/database

For a particular table,

SELECT pg_size_pretty( pg_total_relation_size('tablename') );

skwid138

#!/bin/bash

# must install JQ
# https://stedolan.github.io/jq/download/
# on OSX brew install jq

# must set Github Personal Access Token with full repo access only

### Set named arguments -t
while getopts ":t:" opt; do