BowerStudios.com

Big Deletes by Rick James

Mysql Internal Locking

View processes locking tables in Mysql

Create temporary tables in mysql

Getting the disk size of a table in mysql

Specifying index to use for a query in mysql

Interpreting Explain Query output in mysql

Performing online updates with mysql

From stackoverflow

Boils down to adding a couple of Java switches to the start script:
-Dswing.plaf.metal.controlFont=Tahoma-18 -Dswing.plaf.metal.userFont=Tahoma-18

For example, in squirrel-sql.sh, modify this line to include the above:
$JAVACMD -Xmx256m -Dswing.plaf.metal.controlFont=Tahoma-24 -Dswing.plaf.metal.userFont=Tahoma-24 -cp "$TMP_CP" $MACOSX_SQUIRREL_PROPS -splash:icons/splash.jpg net.sourceforge.squirrel_sql.client.Main --log-config-file "$UNIX_STYLE_HOME"/log4j.properties --squirrel-home "$UNIX_STYLE_HOME" $NATIVE_LAF_PROP $SCRIPT_ARGS

Link is a little older, but looks interesting: From enterprisedb.com

Postgres stores time in UTC, if you want to see the value of a date for a particular timezone, use one of the following:

SELECT now() AT TIME ZONE current_setting('TimeZone');
SELECT now() AT TIME ZONE 'EST5EDT';
SELECT now() AT TIME ZONE 'UTC';

From David Larochelle's blog

You can use:
COPY TABLE_NAME TO STDOUT WITH CSV HEADER
to push the output to a csv file.

thatJeffSmith.com

First we need to find out what cluster we're working with:
$ pg_lsclusters
Result:
Ver Cluster Port Status Owner Data directory Log file
9.3 main 5432 online postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log
Now, reload it using the version and cluster name
$ sudo pg_ctlcluster 9.3 main reload

1. First, add the Postgres driver to Oracle Sql Developer:

   Tools > Preferences > Database > "Third Party JDBC Drivers" > Add Entry

   Navigate to a save location of the Postgresql JDBC driver from jdbc.postgresql.org

2. Next, In Oracle Sql Developer, crate a new connection. Give it a Connection Name, Username, HostName, and Port. Now Save.
3. Exit Sql Developer
4. Open ~/.sqldeveloper/system4.0.3.16.84/o.jdeveloper.db.connection.12.1.3.2.41.140908.1359/connections.xml
5. Update the customUrl for the connection you just created to something like:

   <StringRefAddr addrType="customUrl">
   <Contents>jdbc:postgresql://localhost:5432/mydatabasename?ssl=true</Contents>
   </StringRefAddr>

   Basically, we're adding the ?ssl=true parameter to the connection string.

You can direct a statement to output to a file, with "\o"

Example from stackoverflow.com
db=>\o out.txt
db=>select * from mytable;

DbForge looks like a nice candidate, though it is only available in windows