start new:
tmux
start new with session name:
tmux new -s myname
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| App configuration in environment variables: for and against | |
| For (some of these as per the 12 factor principles) | |
| 1) they are are easy to change between deploys without changing any code | |
| 2) unlike config files, there is little chance of them being checked | |
| into the code repo accidentally | |
| 3) unlike custom config files, or other config mechanisms such as Java |
| Windows Registry Editor Version 5.00 | |
| [HKEY_CLASSES_ROOT\Directory\Background\shell\open_msys2] | |
| @="Open MSYS2 here" | |
| [HKEY_CLASSES_ROOT\Directory\Background\shell\open_msys2\command] | |
| @="c:\\msys64\\usr\\bin\\mintty.exe /bin/sh -lc 'cd \"$(cygpath \"%V\")\"; exec bash'" | |
| [HKEY_CLASSES_ROOT\Folder\shell\open_msys2] | |
| @="Open MSYS2 here" |
| [alias] | |
| recent = "!git for-each-ref --sort=-committerdate refs/heads/ --format='%(committerdate:short) %(refname:short)' | head -n 10" | |
| co = checkout | |
| cob = checkout -b | |
| coo = !git fetch && git checkout | |
| br = branch | |
| brd = branch -d | |
| brD = branch -D | |
| merged = branch --merged | |
| st = status |
| /* ~/Library/KeyBindings/DefaultKeyBinding.Dict | |
| This file remaps the key bindings of a single user on Mac OS X 10.5 to more | |
| closely match default behavior on Windows systems. This makes the Command key | |
| behave like Windows Control key. To use Control instead of Command, either swap | |
| Control and Command in Apple->System Preferences->Keyboard->Modifier Keys... | |
| or replace @ with ^ in this file. | |
| Here is a rough cheatsheet for syntax. | |
| Key Modifiers |
| def generate_html_for_route(route_path) do | |
| conn = Phoenix.ConnTest.build_conn() | |
| conn = get(conn, route_path) | |
| resp = html_response(conn, 200) | |
| priv_static_path = | |
| Path.join([ | |
| :code.priv_dir(:dash_home), | |
| "static", | |
| route_path |
This article was first written during the Unity Fee-asco of 2023. As such, many Unity ECS community members were seeking alternative high-performance solutions, and were asking me about potential places to migrate some technology I have developed.
Unfortunately, most of the ECS solutions were inadequate for facilitating the technology, yet it hasn’t been easy to explain why. That’s why this series exists. I’ll explain several ECS concepts ideas that are often overlooked in