 |
| Screenshot of Google consent screen |
 |
| Screenshot of the StorCenter Pro 150d's Alerts Interface |
 |
| Arsenal SAM7R-61 |
The smalldb would then contain a subset of largedb's data.
createdb smalldb
pg_sample largedb | psql smalldb
See also: pg_sample Github source repository
-a
--data-only
Output only the data, not the schema (data definitions).
-E *encoding*
--encoding=*encoding*
Use the specified character set encoding. If not specified, uses the
environment variable PGCLIENTENCODING, if defined; otherwise, uses
the encoding of the database.
-f *file*
--file=*file*
Send output to the specified file. If omitted, standard output is
used.
--force
Drop the sample schema if it exists.
--keep
Don't delete the sample schema when the script finishes.
--limit=*number*
The maximum number of rows to initially copy from each table
(defaults to 100). Note that sample tables may end up with
significantly more rows in order to satisfy foreign key constraints.
--random
Randomize the rows initially selected from each table. May
significantly increase the running time of the script.
--schema=*name*
The schema name to use for the sample database (defaults to
_pg_sample).
--trace
Turn on Perl DBI tracing. See the DBI module documentation for
details.
--verbose
Output status information to standard error.
The following options control the database connection parameters.
-h *host*
--host=*host*
The host name to connect to. Defaults to the PGHOST environment
variable if not specified.
-p *port*
--port=*port*
The database port to connect to. Defaults to the PGPORT environment
variable, if set; otherwise, the default port is used.
-U *username*
--username=*username*
User name to connect as.
-W *password*
-password=*password*
Password to connect with.
DESCRIPTION
Resolves IPs to hostnames in web server logs. This is a faster, drop-in
replacement for the logresolve utility distributed with the Apache web
server.
CHANGELOG
ip2host 1.11
* Silence warnings thanks to Andrew McNaughton and Gunnar Wolf
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=563129
This worked for me on Ubuntu 9.10. Please let me know if you try it on other Ubuntu releases or otherwise have trouble with it.
wget http://sites.google.com/site/mlawire/installing-adobe-air-1-5-on-64-bit-ubuntu-linux/install-adobe-air-ubuntu-64bit.sh
chmod a+rx install-adobe-air-ubuntu-64bit.sh
sudo ./install-adobe-air-ubuntu-64bit.sh
$ apt-get install doxygenNext. enter the source directory of a project you're working on and run:
$ doxygen -gThat will create a config file named Doxyfile in the current directory. You can customize it, but we'll accept the defaults for now.
#include <iostream>
using namespace std;
/**
* @brief Example class to demonstrate basic Doxygen usage
* @author MLA
*
* This is a simple class to demonstrate how Doxygen is used.
* It implements the Euclidean algorithm to compute the greatest
* common divisor of two numbers.
*/
class Euclid {
public:
/**
* Compute the greatest common divisor of two integers.
*
* @param a first integer
* @param b second integer
* @return greatest common divisor of a and b
*/
static const int gcd(const int a, const int b) {
if (0 == b) return a;
return gcd(b, a % b);
}
};
$ doxygenFor more details, see the Doxygen homepage.
Output:
#include <iostream>
#include <cmath> // M_PI is not standard
using namespace std;
class MathConst {
public:
static const long double PI;
};
const long double MathConst::PI = acos((long double) -1);
int main() {
cout.precision(100);
cout << "PI ~ " << MathConst::PI << endl;
}
That is accurate to 18 decimal places.
$ g++ MathConst.cpp -o pi
$ ./pi
PI ~ 3.14159265358979323851280895940618620443274267017841339111328125
#include <math.h>
#include <stdio.h>
double pi() {
const double pi = acos((double) - 1);
return pi;
}
int main() {
printf("%.20f\n", pi());
return 0;
}
/*
Look for foreign key constraints that are missing indexes on the
referencing table.
Orders results by the size of the referencing table, largest first,
on the assumption that, all else being equal, they are the most likely
to benefit from the addition of indexes.
This is only meant as a starting point, and isn't perfect.
It's possible, for example, that it will report a missing index
when in fact one is available. e.g., it won't realize that an index on
(f1, f2) could be used with a fk on (f1). However, it will recognize
that an index on (f1, f2) can be used with a fk on (f2, f1).
Usage: psql -q dbname -f pg-find-missing-fk-indexes.sql
*/
CREATE FUNCTION pg_temp.sortarray(int2[]) returns int2[] as '
SELECT ARRAY(
SELECT $1[i]
FROM generate_series(array_lower($1, 1), array_upper($1, 1)) i
ORDER BY 1
)
' language sql;
SELECT conrelid::regclass
,conname
,reltuples::bigint
FROM pg_constraint
JOIN pg_class ON (conrelid = pg_class.oid)
WHERE contype = 'f'
AND NOT EXISTS (
SELECT 1
FROM pg_index
WHERE indrelid = conrelid
AND pg_temp.sortarray(conkey) = pg_temp.sortarray(indkey)
)
ORDER BY reltuples DESC
;
Next, find the YouTube video you want to download and pass it to the script:
sudo apt-get install youtube-dl
Command-line options:
youtube-dl -b -t "http://www.youtube.com/watch?v=aEXFUbSbg1I"
See also: youtube-dl Homepage
Usage: youtube-dl [options] video_url
Options:
-h, --help print this help text and exit
-v, --version print program version and exit
-u USERNAME, --username=USERNAME
account username
-p PASSWORD, --password=PASSWORD
account password
-o FILE, --output=FILE
output video file name
-q, --quiet activates quiet mode
-s, --simulate do not download video
-t, --title use title in file name
-l, --literal use literal title in file name
-n, --netrc use .netrc authentication data
-g, --get-url print final video URL only
-2, --title-too used with -g, print title too
-f FORMAT, --format=FORMAT
append &fmt=FORMAT to the URL
-b, --best-quality alias for -f 18
#1 expand/unexpand utilities
expand < input.txt > output.txt
#2 Sed
sed 's/\t/ /g' < input.txt > output.txt
#3 Awk
awk '{ gsub(/\t/, " "); print }' < input.txt > output.txt
#4 Perl
perl -pe 's/\t/ /g' < input.txt > output.txt
#5 Ruby
ruby -pe '$_.gsub!(/\t/, " ")' < input.txt > output.txt
#6a Vim editor
:set expandtab
:%retab!
#6b Vim editor
:%s/\t/ /g
#7 Emacs editor
Set 'indent-tabs-mode' to nil to have tabs automatically converted to spaces.
To convert a region, "M-x untabify" will change tabs to spaces and "M-x tabify" will do the inverse.
#8 cut
cut -f1- --output-delimiter=' ' < input.txt > output.txt
This page will convert HTML special characters into HTML entities. The encoded text can then be inserted into another HTML document or blog posting and the reserved characters (such as < and &) will show up normally.
Enter your text in the form field below. The encoded result will be displayed in the lower field as you type.
Enter HTML to Encode:
HTML Encoded Result: (Click to Select All)
The HTML encoding is performed with this Javascript function:
/* encode html entities */See also: handy shell function for html encoding.
var char2entity = { '"' : '"', '<' : '<', '>' : '>', '&' : '&', "'" : ''' }; /* IE can't handle ' */
function encode_entities(str) {
var rv = '';
for (var i = 0; i < str.length; i++) {
var ch = str.charAt(i);
rv += char2entity[ch] || ch;
}
return rv;
}
firefox -P -no-remoteThat will bring up a dialog box that lets you select a profile or create a new one.
Usage: firefox [ options ... ] [URL]
where options include:
X11 options
--display=DISPLAY X display to use
--sync Make X calls synchronous
--no-xshm Don't use X shared memory extension
--xim-preedit=STYLE
--xim-status=STYLE
--g-fatal-warnings Make all warnings fatal
Mozilla options
-height <value> Set height of startup window to <value>.
-h or -help Print this message.
-width <value> Set width of startup window to <value>.
-v or -version Print Firefox version.
-P <profile> Start with <profile>.
-ProfileManager Start with ProfileManager.
-no-remote Open new instance, not a new window in running instance.
-UILocale <locale> Start with <locale> resources as UI Locale.
-safe-mode Disables extensions and themes for this session.
-jsconsole Open the Error console.
-g or --debug Start within /usr/bin/gdb (Must be first)
I've submitted a patch that's been accepted by the author; it should be in the next release.
t/50hopbyhop........1/28
# Failed test 'Hop-by-hop Foo'
# at t/50hopbyhop.t line 38.
# got: undef
# expected: 'foofoo'
# Failed test 'Hop-by-hop Bar'
# at t/50hopbyhop.t line 39.
# got: undef
# expected: 'barbar'
# Failed test 'Connection header removed'
# at t/50hopbyhop.t line 45.
# got: 'foofoo'
# expected: undef
# Failed test 'Connection header removed'
# at t/50hopbyhop.t line 46.
# got: 'barbar'
# expected: undef
javascript:pageTracker._setVar('notrack');alert('cookie set');That will set a "notrack" cookie on your browser.Google Analytics should now begin ignoring your visits.
Filter Type: Custom filter > Exclude
Filter Field: User Defined
Filter Pattern: notrack
Case Sensitive: No
sudo apt-get install torNext, install the LWP::Protocol::socks Perl module to add support for the "socks" scheme. Installing from CPAN:
sudo cpan LWP::Protocol::socksYou should now be able to use LWP with Tor:
#!/usr/bin/perl
use strict;
use LWP::UserAgent;
my $ua = LWP::UserAgent->new(
agent => q{Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; YPC 3.2.0; .NET
CLR 1.1.4322)},
);
$ua->proxy([qw/ http https /] => 'socks://localhost:9050'); # Tor proxy
$ua->cookie_jar({});
my $rsp = $ua->get('http://www.yahoo.com/');
print $rsp->content;
javascript:resizeTo(1024, 768)Enter that into your browser's location bar and it should resize your window to 1024x768 (the most common resolution, currently). The first value is the width in pixels. The second is the height.
#!/bin/bash
print_arguments () {
idx=1
for arg; do
echo " param $idx: $arg"
let idx++
done
echo
}
echo "\$* - arguments with spaces are split"
print_arguments $*
echo "\$@ - same"
print_arguments $@
echo "\"\$*\" - expands to single value"
print_arguments "$*"
echo "\"\$@\" - preserves arguments exactly as passed"
print_arguments "$@"
$ ./test-param-expansion orange 9 "Bringing Up Baby"
$* - arguments with spaces are split
param 1: orange
param 2: 9
param 3: Bringing
param 4: Up
param 5: Baby
$@ - same
param 1: orange
param 2: 9
param 3: Bringing
param 4: Up
param 5: Baby
"$*" - expands to single value
param 1: orange 9 Bringing Up Baby
"$@" - preserves arguments exactly as passed
param 1: orange
param 2: 9
param 3: Bringing Up Baby
#!/bin/sh
# loop over all args
for arg in "$@"; do
echo $arg
done
# short-cut; same as above
for arg; do
echo $arg
done
# create a 10M file $ dd if=/dev/urandom of=testfs bs=1M count=10 # associate it with the loop device $ losetup /dev/loop0 testfs # encrypt it (will ask for password to use) $ cryptsetup luksFormat /dev/loop0 # open the encrypted loop device $ cryptsetup luksOpen /dev/loop0 testfs # format it with ext2 (or whatever you prefer) $ mkfs.ext2 /dev/mapper/testfs # mount it $ mount /dev/mapper/testfs /mnt/test # confirm mount $ df -h /mnt/test Filesystem Size Used Avail Use% Mounted on /dev/mapper/testfs 9.2M 88K 8.7M 1% /mnt/test
# unmount it $ umount /mnt/test # close encryption $ cryptsetup luksClose /dev/mapper/testfs # release loop device $ losetup -d /dev/loop0
# associate file with the loop device $ losetup /dev/loop0 testfs # open the encrypted loop device $ cryptsetup luksOpen /dev/loop0 testfs # mount it $ mount /dev/mapper/testfs /mnt/test
To escape/encode all unsafe characters in a query parameter:
alias urlencode="perl -MURI::Escape -ple '\$_=uri_escape(\$_); s/%20/+/g'"
alias urldecode="perl -MURI::Escape -ple '\$_=uri_unescape(\$_); s/\+/ /'"
And to unescape/decode a parameter:
$ echo "blue socks?" | urlencode
blue+socks%3F
These aliases depend on Perl and the URI::Escape module which are standard on most modern Unixes.
$ echo blue+socks%3F | urldecode
blue socks?