/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 joisig.com
Stellar way to roll back PostgreSQL during development | joisig gone awol
| | zevross.com
Use PostgreSQL's 'custom format' to efficiently backup and restore tables | Technical Tidbits From Spatial Analysis & Data Sc...
4.4 parsecs away

Travel
| | PostgreSQL allows you to easily dump tables for backup purposes into plain text files using code such as: pg_dump mytable > mytable_backup.sql But this process is not very flexible and can creat...
| | www.valentinog.com
A PostgreSQL cheat sheet
2.3 parsecs away

Travel
| | Learn to move your first steps with the PostgreSQL console with this cheat sheet.
| | kgrz.io
PostgreSQL backup notes
4.4 parsecs away

Travel
| |
| | andreabergia.com
Introduction to SQL Window Functions / 1 ยท Andrea Bergia's Website
29.7 parsecs away

Travel
| Window functions are an extremely powerful powerful part of the SQL 2003 standard, supported by most modern releases of databases such as Oracle 8+, Postgres 9.1+, SQL Server 2005+ and others. Sadly neither SQLLite or MySql seem to support them yet, but if you are working with a database where they are available, do use them: they can make your life a lot easier. Generally, with window functions, you can write simpler and faster code than you would without.