$ grep -rl list-inactive-ecs?ref=v0.3.35 . | xargs sed -i '' 's/v0.3.35/v0.3.36/'
htop -p `{ unzip ~/Downloads/sample.zip > /dev/null & } && echo $!`
This guide is targetted at intermediate or expert users who want low-level control over their Python environments.
When you're working on multiple coding projects, you might want a couple different version of Python and/or modules installed. This helps keep each workflow in its own sandbox instead of trying to juggle multiple projects (each with different dependencies) on your system's version of Python. The guide here covers one way to handle multiple Python versions and Python environments on your own (i.e., without a package manager like conda
). See the Using the workflow section to view the end result.
Problem: You want to maintain multiple different versions of python and keep packages separated based on projects that you're working on.
Solution: Use the pyenv, virtualenv tools along with the pyenv-virutalenv plugin to manage multiple versions of python and seamlessly integrate them with your projects' virtual environments.
set serveroutput on; | |
declare | |
raw_guid raw(16); | |
guid varchar2(64); | |
begin | |
raw_guid := guid_to_raw ('88c6a267-65d2-48d6-8da2-6f45e2c22726'); | |
guid := raw_to_guid('67A2C688D265D6488DA26F45E2C22726'); | |
-- 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%' |