Skip to content

Instantly share code, notes, and snippets.

@msqr
msqr / year-partial-agg.sql
Created May 4, 2020 04:24
Year partial aggregate query
SELECT
datum.ts_start AS r_datum_ts_start
, datum.local_date AS r_datum_local_date
, datum.node_id AS r_datum_node_id
, datum.source_id AS r_datum_source_id
, datum.jdata AS r_datum_jdata
FROM (
(
SELECT
date_trunc('year', datum.ts_start::timestamp) AT TIME ZONE r.time_zone AS ts_start
@msqr
msqr / LoxoneSetupExample.java
Last active April 9, 2018 07:30
Spring Boot app configuration of WebsocketLoxoneService
// MIT License
//
// Copyright (c) 2018 Matt Magoffin
//
// Permission is hereby granted, free of charge, to any person obtaining a copy
// of this software and associated documentation files (the "Software"), to deal
// in the Software without restriction, including without limitation the rights
// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
// copies of the Software, and to permit persons to whom the Software is
// furnished to do so, subject to the following conditions:
@msqr
msqr / LICENSE
Last active January 23, 2023 05:38
d3 gauge
This code is released under the MIT license.
Copyright (C) 2012 Matt Magoffin
Permission is hereby granted, free of charge, to any person obtaining a
copy of this software and associated documentation files (the
"Software"), to deal in the Software without restriction, including
without limitation the rights to use, copy, modify, merge, publish,
distribute, sublicense, and/or sell copies of the Software, and to
permit persons to whom the Software is furnished to do so, subject to