Here's a little script I made to make it easy to put a number of existing web sites residing under /var/www under version control by Git. Regarding security, it is obviously not a good idea to initialize the Git repository directly under the site directory, since from there it …
Update: PostgreSQL 9.5 has been released with INSERT .. ON CONFLICT UPDATE support.
PostgreSQL has no "upsert" or "replace" or "insert .. on duplicate key update" or "merge into" construct to conditionally either insert a new row, or if a row with the key already exists, to either update the existing …
SQLAlchemy has a nice reflection facility which takes for example a database table name as argument and produces a Table object out of it for manipulation. However, those objects do not behave like the objects produced by declarative classes, which are easier to work with. Here's a little class that …
Helpful settings for editing tabular data:
setlocal noexpandtab setlocal nowrap setlocal tabstop=16 softtabstop=16 shiftwidth=16
Noexpandtab disables expanding of inputted tabs to spaces. Adjust the number of spaces to your liking. Tabstop sets the visual appearance of tab stops (here 16 spaces).
Show tabs visually, disable cursor line …
From: Developer Mode for the Samsung Galaxy S4
Get to the phone's settings by tapping 'menu' from the home screen and then tapping 'settings'
Here's how to do it:
ALTER ROLE myuser IN DATABASE mydb SET search_path = myschema;
The same syntax works for any configuration parameter, such as localization parameters.
If an IPv6 address is unreachable, but you can reach the IPv4 one, you can set the preference to IPv4 for that particular address by adding a line such as this in /etc/gai.conf:
precedence ::ffff:198.145.11.105/128 100
That will set the preference for host …
Unlike IPv4, which uses DHCP for configuration, IPv6 uses the Neighbor Discovery Protocol to configure addresses and gateways. Unfortunately, originally the protocol had no means of providing addresses of DNS servers to clients, making it necessary to use DHCPv6 for that purpose. Modern Linux and Mac OS X machines are …
I had to migrate a pretty big database cluster from one server with PostgreSQL 8.4 to a new server with 9.2 There we multiple apps using the databases, and the downtime had to be minimal. Luckily, the databases were split to multiple schemas, and there were only a …
In this article I will show you how to use the Sonera CStream Messaging Web Service API to send an SMS using Python, and a library called SUDS. The CStream API is two-way service for both sending and receiving messages. You obviously need to pay for the service to get …
