ajlai

WITH date_series_bounds AS (
	SELECT date('2012-12-21') as start, date('2013-08-23') as end
), date_series AS (
	select date(days.start + days.interval)
	from (
		select bounds.start, generate_series(0, bounds.end - bounds.start) AS interval from date_series_bounds bounds
	) as days
)
select * from date_series
-- 2012-12-21

ewheeler

/*
This is an example Overpass query to view administrative boundaries.

1. Visit the OpenStreetMaps wiki (http://wiki.openstreetmap.org/wiki/Tag:boundary%3Dadministrative) and see which levels are present for your country. If admin_level = N/A, that level is missing.

2. Go to http://overpass-turbo.eu and centre the map on the country of interest. 

3. Delete the text on the left side of the overpass-turbo page and replace with the contents of this file

4. Edit the admin_level to the level you want to check - in the example above, the "admin_level" = "8". Press 'Run' to highlight and outline all boundaries for that level.

xoseperez

Raspberry Pi 3 IoT Home Server

Presentation

http://tinkerman.cat/rpi3_iot_server.pdf (Catalan)

Get the latest image and flash the SD card

• download the latest image

abmantis

esphome:
  name: m5-atom-matrix
  platformio_options:
    upload_speed: 115200
  on_boot: 
    priority: 700
    then: 
      - output.turn_on: wifi_fix_output

esp32:

denisgolius

#!/bin/bash

set -e

system_set_hostname "$HOSTNAME"

apt update && apt upgrade -y && apt install -y curl wget net-tools traceroute jq
# Generate files
mkdir -p /etc/victoriametrics/single
mkdir -p /var/lib/victoria-metrics-data

kaspergrubbe

#!/usr/bin/env ruby
require 'open3'
require 'fileutils'

def run_command(command)
  puts("+: " + command)

  Open3.popen2e(command) do |stdin, stdout_stderr, wait_thread|
    Thread.new do
      stdout_stderr.each {|l| puts l }

bmweiner

Sonos Airplay

Stream audio to any Sonos component via AirPlay using a Raspberry Pi (Model B, Raspbian Jessie) and the following software:

• Shairport Sync: configures the Raspberry Pi as an AirPlay audio player.
• DarkIce: encodes audio received from AirPlay (system audio) and sends it to Icecast2.
• Icecast2: serves streaming audio from DarkIce at a network URL.

Azuritul

# IDEA Ignores #
################
*.iml
*.ipr
*.iws
.idea/
out/
local.properties

# Generic Android ignores #

nitaku

A minimal HTTP server in python. It sends a JSON Hello World for GET requests, and echoes back JSON for POST requests.

python server.py 8009
Starting httpd on port 8009...

curl http://localhost:8009
{"received": "ok", "hello": "world"}

ChipCE

READ THIS FIRST

Adaptive bed mesh is merged into klipper master branch. You can use this feature without this custom macro. Official klipper adaptive bed mesh

Klipper mesh on print area only install guide

What this macro do

• This macro will dynamically changing the bed mesh area based on the size of the parts will be printed. The fw will only probe on the area that the part will be printed (plus mesh_area_offset value)