obda.net

Ignore join/part/quit messages in WeeChat

Add a comment

cheat-sheet articles are about code snippets that I need every once in a while, and which I constantly forget about.

From the WeeChat FAQ:

With smart filter (keep join/part/quit from users who spoke recently):

/set irc.look.smart_filter on
/filter add irc_smart * irc_smart_filter *

With a global filter (hide all join/part/quit):

/filter add joinquit * irc_join,irc_part,irc_quit *

Ignoring the messages only in specific channels can be achieved by providing the full channel names (in a comma-separated list) after the filter name:

/filter add myfilter irc.freenode.#mychannel irc_smart_filter *

Use /filter disable myfilter or /filter del myfilter to disable or delete the filter.

Simple Local Web Server with Python

Add a comment

cheat-sheet articles are about code snippets that I need every once in a while, and which I constantly forget about.

Python’s standard distribution includes a simple HTTP server, which can be used to serve a local directory on the fly. Just open a terminal, change to the directory you want to share, and run:

python -m SimpleHTTPServer

Once the server is running, you will see the message:

Serving HTTP on 0.0.0.0 port 8000 ...

In your browser, you can now access the server by surfing to http://localhost:8000. Moreover, you can also access the server from other machines in your network, not only from localhost.

If you want to change the server’s port, just provide an additional argument when launching it:

python -m SimpleHTTPServer 8888

Note: The above solution works only for Python 2, as Python 3 has reorganized some modules. If you are working with the latest Python version, you need to run:

python -m http.server

or, with a different port:

python -m http.server 8888

Export Postgres Table to CSV

Add a comment

cheat-sheet articles are about code snippets that I need every once in a while, and which I constantly forget about.

PostgreSQL’s psql command line client features a \copy command that allows dumping a table to a CSV file:

\copy table_name to 'filename.csv' delimiter ',' csv header

The header argument at the end will add a header line with the column names to the CSV file. Use ; as delimiter if the CSV file shall be compatible with Microsoft’s Excel.