Skip to content

Instantly share code, notes, and snippets.

View Turbo87's full-sized avatar

Tobias Bieniek Turbo87

538 followers · 67 following
View GitHub Profile
@Turbo87
Turbo87 / query.sql
Created February 15, 2024 10:23
crates.io database bloat
-- from https://github.com/ioguix/pgsql-bloat-estimation/blob/8fde3c9e0e015ece51e10c1450228d23f7747db1/table/table_bloat.sql
SELECT tblname, bs*tblpages AS real_size,
(tblpages-est_tblpages)*bs AS extra_size,
CASE WHEN tblpages > 0 AND tblpages - est_tblpages > 0
THEN 100 * (tblpages - est_tblpages)/tblpages::float
ELSE 0
END AS extra_pct, fillfactor,
CASE WHEN tblpages - est_tblpages_ff > 0
THEN (tblpages-est_tblpages_ff)*bs
@Turbo87
Turbo87 / save_downloads.rs
Created January 26, 2024 17:41
use anyhow::Context;
use chrono::NaiveDate;
use crates_io_cdn_logs::DownloadsMap;
use diesel::prelude::*;
use diesel::PgConnection;
table! {
temp_downloads (name, version, date) {
name -> Text,
version -> Text,
@Turbo87
Turbo87 / skylines-aircraft.json
Last active December 26, 2023 11:56
SkyLines aircraft list with WeGlide IDs
{
"models": [
{
"id": 219,
"name": "AFH 22",
"index": 98,
"type": "glider",
"weglideId": 283
},
{
@Turbo87
Turbo87 / codes.md
Last active December 20, 2023 09:55
Aldi LED Panel IR codes

Aldi LED Panel

Tastenwiederholung

[20:21:00][I][remote.pronto:237]: Received Pronto: data=0000 006D 0002 0000 015D 0056 0017 0181 06C3
[20:21:00][I][remote.pronto:237]: Received Pronto: data=0000 006D 0002 0000 015D 0056 0017 0181 06C3
[20:21:00][I][remote.pronto:237]: Received Pronto: data=0000 006D 0002 0000 015D 0056 0017 0181 06C3
@Turbo87
Turbo87 / num_features.csv
Last active October 11, 2023 16:18
name num num_features
leptos_icons 0.0.11 21966
icondata 0.0.5 21961
icondata 0.0.7 21961
icondata 0.0.4 21961
icondata 0.0.6 21961
icondata 0.0.1 21960
icondata 0.0.2 21960
icondata 0.0.3 21960
leptos_icons 0.0.16-alpha 21944
@Turbo87
Turbo87 / crate-files-with-missing-manifest.md
Last active August 28, 2023 14:10

Empty tarballs

  • /se/rv/servo/servo-0.0.1.crate

cargo.toml (lowercase)

  • /3/q/qmu/qmu-0.1.0.crate
  • /3/q/qrl/qrl-0.1.0.crate
  • /3/r/rpc/rpc-0.0.1-dev.1.crate
  • /an/im/animality/animality-0.1.0.crate
@Turbo87
Turbo87 / app.js
Created February 15, 2015 04:05
webpack + font-awesome test
require('font-awesome/css/font-awesome.css');
document.body.innerHTML = '<i class="fa fa-fw fa-question"></i>';
@Turbo87
Turbo87 / squatted-crates.csv
Created July 3, 2023 11:21
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
aahing
aahs
aal
aah
aahed
aam
aardvarks
aardwolf
aaronic
aaronite
@Turbo87
Turbo87 / algorithm.md
Last active September 15, 2020 15:21
OLC Algorithm
@Turbo87
Turbo87 / api.md
Created May 14, 2015 11:18
Skylines API

Skylines API

Overview

Schema

  • API is only available over HTTPS at https://api.skylines.aero/
  • HTTP will show 404 Not Found
  • All data is sent and received as JSON
  • Blank fields are included as null