Setting up Linux development environment on macOS
If you are moving onto macOS/OS X from GNU/Linux, you would probably find out that the command line tools shipped with OS X are not as powerful and easy to use as the tools in Linux. The reason is that macOS/Mac OS X uses the BSD version command line tools, which are different from the […]
Elementary OS as a replacement for super slow macOS Sierra on Macbook Air (2012)
My girfriend's Macbook Air (2012) got very slow lately. Slow to the extend that it's not useful anymore. It just makes you crazy. The mouse cursor does not move smoothly - the latency is up to 1s - and it's almost impossible to navigate in the UI and click on anything. The whole OS experience is so bad, that my girlfriend prefers using Android mobile rather then dealing with Mac, even when she needs to reply on long messages. I need to fix this.
Features Auto-completion Simple completions such as keywords and sql-functions. Smart-completion Table name completions after the 'FROM' keyword. Column name completions once a table is recogni...
Postgres in Docker: Modify Owner of all Tables + Sequences
The following script will help you change the owner of all tables and sequences in your Postgres database using the official postgres Docker image. It generates SQL with ALTER statements in the first postgres Docker container based on your DB tables and sequences and pipes the generated SQL to the second Docker container, where the modifications are run. export user="your_new_owner" export dbname="your_db_name" cat <<EOF | docker run -i --rm --link postgres:postgres postgres sh -c "psql -h \$POSTGRES_PORT_5432_TCP_ADDR -p \$POSTGRES_PORT_5432_TCP_PORT -U postgres -d $dbname" | grep ALTER | docker run -i --rm --link postgres:postgres postgres sh -c "psql -h \$POSTGRES_PORT_5432_TCP_ADDR -p \$POSTGRES_PORT_5432_TCP_PORT -U postgres -d $dbname" SELECT 'ALTER TABLE '||schemaname||'.'||tablename||' OWNER TO $user;' FROM pg_tables WHERE schemaname = 'public'; SELECT 'ALTER SEQUENCE '||relname||' OWNER TO $user;' FROM pg_class WHERE relkind = 'S'; EOF Also posted here: http://stackoverflow.com/a/36635029/38...