Skip to content

Instantly share code, notes, and snippets.

View Turbo87's full-sized avatar

Tobias Bieniek Turbo87

531 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 / 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 / filter.csv
Created January 6, 2020 11:04 — forked from wildedan/filter.csv
wwgc
ID CALL CN TYPE
06DD517F UKE
06DDABCD J1
06DD51AD AJ
06DDB6E5 KW
06DDEE58 BI
D01038 BM
06D0017F V57
06DDB6FB MF
86DDF05C SC
@Turbo87
Turbo87 / algorithm.md
Last active September 15, 2020 15:21
OLC Algorithm
@Turbo87
Turbo87 / controllers.application.js
Created June 13, 2019 06:45
New Twiddle
import Ember from 'ember';
export default Ember.Controller.extend({
appName: 'Ember Twiddle'
});