paskvilwiki

notes

reference cards, cheat sheets and how-tos i wrote over the years

programming

  • C/C++pthread cleanup, non-blocking sockets, shared libraries, singletons, move semantics
  • Emacs and SLIMEkey bindings for Emacs, SLIME and SLDB, plus swank setup and remote connecting
  • Flaskfile upload with Flask-RestPlus, "MySQL server has gone away" with SQLAlchemy
  • jQuery cheat sheetthe jQuery methods i keep forgetting - DOM, events, effects, a bit of AJAX
  • jQuery referencewhat's in the library, getting it, selectors
  • JSmapping, fetch, env vars in webpack, debugging in VS Code
  • PHPtransliteration, cURL upload, POST without cURL, disconnecting the client and carrying on
  • Pythondatetime and strftime, merging dicts, uWSGI + nginx + Flask, decorators, virtualenv, SQLAlchemy
  • RedBeanPHPsetup, CRUD, fluid and frozen schema, finding and raw queries, transactions
  • RESTful APIswhat REST is, my interface preferences, HTTP response codes i always forget
  • waveletsinteger Haar wavelets in Python, 1D and 2D, with lists and numpy
  • webmultiple submit buttons, stacking floats, file upload forms, IE width fix, filling the remaining space

databases & search

  • 4storebuild, start, load data, query it from Python, write Turtle files
  • Elasticsearchsetup, indexing, getting, updating, deleting, indices and mappings management, diagnostics
  • Elasticsearch query DSLthe queries and filters i use the most - match, bool, query_string, range, term, exists…
  • Elasticsearch searchrequest body and URI search, filters vs facets, pagination, sorting, fields, facets
  • Kyoto Cabinetbuilding Kyoto Cabinet and Kyoto Tycoon, Kyoto Tycoon's RPC API calls
  • MongoDBinstall on Ubuntu with the PHP driver, desktop troubles, using it from PHP
  • MySQLerror 1045, the on duplicate key update pitfall, shrinking ibdata1, indexing JSON columns
  • PostgreSQLdump and restore, deleting duplicates, resetting sequences, killing stuck queries
  • SPARQL, RDQLquery optimization, loading vs insertion, Turtle groupings

servers & admin

  • Apachelocal files gotcha, self-signed SSL, HTTPS vhost, .htaccess and mod_rewrite tricks
  • AWSEC2 connection checklist, Elastic Beanstalk auth header, Lambda, boto3, Chalice, Python layers
  • Bashfile name parts, file test operators, one-liners and shortcuts, lsof, cURL
  • Dockerinstall, an nginx + php-fpm + MySQL stack with docker-compose, data volumes, non-root use
  • Linuxsendmail, bad blocks, TLP, Ubuntu/GNOME bits, newer Python and node.js on Ubuntu
  • macOSasync execution in Objective-C, updating and cleaning up MacPorts
  • securitypassword generators, SSH login with public keys, rsync over SSH
  • Vimdelete lines by pattern, typing HTML entities, reformatting paragraphs, encryption

version control

  • creating an SVN reposet up a repo and serve it with svnserve
  • giteveryday commands, a typical branch flow, conflicts, meld as diff and merge tool
  • moving an SVN repodump on one host, load on the other - one repo or all of them
  • SVNthe SVN pages, changing a checkout's repo URL, patches and externals
  • SVN clientthe development cycle, managing files, branching and merging
  • SVN on shared hostingbuild SVN in your home, SSH keys, a named tunnel and svnserve - no root needed

video & PDF

  • ffmpegrip DVDs, still image + audio, concatenating, one-liners
  • PDFmerge, cut and convert PDFs with GhostScript
  • rip an unfinalized DVDlist the tracks with dvd+rw-mediainfo, rip them with dd