ilovejs

SELECT
	x,
	WIDTH_BUCKET(x, 1, 10, 9) AS "x In Which Bucket ?"
FROM
	generate_series(1, 10) x;

SELECT
	ROW_NUMBER() OVER(),
	*
FROM

ilovejs

rds-modify-db-parameter-group {param-group-name} \
--parameters="name=character_set_server, value=utf8, method=pending-reboot" \
--parameters="name=collation_server, value=utf8_general_ci, method=pending-reboot" \
--parameters="name=tmp_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
--parameters="name=max_heap_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
--parameters="name=query_cache_type, value=1, method=pending-reboot" \
--parameters="name=query_cache_size, value=131072, method=pending-reboot" \
--parameters="name=table_open_cache, value=2500, method=pending-reboot" \
--parameters="name=join_buffer_size, value={DBInstanceClassMemory/64}, method=pending-reboot" \
--parameters="name=thread_cache_size, value={DBInstanceClassMemory/12582880}, method=pending-reboot" \

ilovejs

#XLarge DBInstanceClassMemory = 15892177440 = 14.8GB
#/32 = 496630545 = 473MB
#/64 = 248315272 = 236MB
#/128 = 124157636 = 118MB
#/256 = 62078818 = 59MB
#/512 = 31039409 = 29MB
#/12582880 = 1263 #default same divisor as max_connections = 4041.6MB = 4237924762
#/25165760 = 623 # half of max_connections = 1993.6MB
#/50331520 = 315 # quarter of max_connections = 1008MB = 1056964608
#*(3/4) #default innodb pool size = 11922309120

ilovejs

--https://www.citusdata.com/blog/2018/05/15/fun-with-sql-recursive-ctes/
--Return: x
WITH RECURSIVE tens(x) AS (
	SELECT 10
	UNION
	SELECT x + 10 FROM tens WHERE x + 10 <= 100
)
SELECT x FROM tens;

--Without having to drop down to a procedural language like plpgsql or plv8.

ilovejs

/* Inferred Table */
CREATE TABLE users (
	id    serial PRIMARY KEY,
	email text
);

CREATE TABLE tasks (
	id         serial PRIMARY KEY,
	name  	   text,
	project_id NUMERIC,

ilovejs

--https://www.citusdata.com/blog/2018/05/15/fun-with-sql-recursive-ctes/
--Return: x
WITH RECURSIVE tens(x) AS (
	SELECT 10
	UNION
	SELECT x + 10 FROM tens WHERE x + 10 <= 100
)
SELECT x FROM tens;

--Without having to drop down to a procedural language like plpgsql or plv8.

ilovejs

#!/bin/bash 
if [ `uname` = "SunOS" ]; then
  alias grep='/usr/gnu/bin/grep'
fi

ilovejs

module.exports = {
  config: {
    // default font size in pixels for all tabs
    fontSize: 12,

    // font family with optional fallbacks
    fontFamily: 'Menlo, "DejaVu Sans Mono", Consolas, "Lucida Console", monospace',

    // terminal cursor background color and opacity (hex, rgb, hsl, hsv, hwb or cmyk)
    cursorColor: 'rgba(248,28,229,0.8)',

ilovejs

package main

import (
	"fmt"

	"gopkg.in/go-playground/validator.v9"
)

// Test ...
type Test struct {

ilovejs

package main

import (
	"fmt"
	"math"
)

func main() {
	var i interface{}
	describe(i)