Skip to content

Instantly share code, notes, and snippets.

View owocki's full-sized avatar

Kevin Owocki owocki

1k followers · 41 following
View GitHub Profile
@owocki
owocki / mysql disk space cleanup
Created June 3, 2013 05:53
```
SELECT CONCAT(table_schema, '.', table_name),
CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx,
CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
ROUND(index_length / data_length, 2) idxfrac
FROM information_schema.TABLES
ORDER BY data_length + index_length DESC
LIMIT 10
@owocki
owocki / invite-all-slack-members-to-a-channel.js
Created March 13, 2018 02:52
function sleep(ms) {
return new Promise(resolve => setTimeout(resolve, ms));
}
var letters = ["a","b","c","d","e","f","g","h","i","j","v","k","l","m","n","o","p","q","r","s","t","u","v","z"];
async function inviteAllUsers() {
for(var i = 0; i < letters.length; i++){
await sleep(300);
$('#channel_actions_toggle').click();
@owocki
owocki / get_grants_by_category.py
Created April 1, 2019 16:20
nav_options = [
{'label': 'All', 'keyword': ''},
{'label': 'Security', 'keyword': 'security'},
{'label': 'Scalability', 'keyword': 'scalability'},
{'label': 'UI/UX', 'keyword': 'UI'},
{'label': 'DeFI', 'keyword': 'defi'},
{'label': 'Education', 'keyword': 'education'},
{'label': 'Wallets', 'keyword': 'wallet'},
{'label': 'Community', 'keyword': 'community'},
{'label': 'ETH 2.0', 'keyword': 'ETH 2.0'},
@owocki
owocki / keybase.md
Created April 27, 2020 13:13

Keybase proof

I hereby claim:

  • I am owocki on github.
  • I am owocki (https://keybase.io/owocki) on keybase.
  • I have a public key ASCmJgmrGMEAQL3u-qhh0q1tW9B0NYo6Jzm-rVPvlNahNQo

To claim this, I am signing this object:

@owocki
owocki / attestation.txt
Created September 3, 2021 00:07
Attestation
I contributed to the clr.fund Trusted Setup Multi-Party Ceremony.
The following are my contribution signatures:
Circuit: qvt32
Contributor # 15
Hash: c088d83c 65d0ecd9 f366b4a1 bd8a37d7
ccde7aab 4a410011 3dea068f 9af0c773
166996ea b99c1792 cdbe50f3 d19046d3
523782b0 c1023f10 22cc7010 e5322e9c
@owocki
owocki / greenpill_books.md
Created April 23, 2023 21:12
@owocki
owocki / maci-v2-trusted-setup-ceremony_attestation.log
Created August 15, 2024 19:48
Attestation for MACI v2 Trusted Setup Ceremony MPC Phase 2 Trusted Setup ceremony
Hey, I'm owocki-513929 and I have contributed to the MACI v2 Trusted Setup Ceremony.
The following are my contribution signatures:
Circuit # 1 (processmessages_14-9-2-3)
Contributor # 48
Contribution Hash:
afccf359 3af76f5d e0c96b43 93f7245a
b1d6a8ff d28169c8 1a86de1a 9431cdf5
72f921fc 3d15252c 9fdde23b d678c127
1456e26d 567d66eb d0744cee da0f60bd