/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

jvns.ca
| | chriszetter.com

An update on writing a guide to building a database server about researching, surprising queries and naming things.
2.9 parsecs

Travel
| |
| | sophiabits.com

[AI summary] A developer explains how to use the pg_stat_statements PostgreSQL extension to identify slow queries and optimize database performance by analyzing execution metrics like rows per call.
3.2 parsecs

Travel
| |
| | antonz.org

Try a query anywhere from PostgreSQL to DuckDB.
2.9 parsecs

Travel
| |
| | willhaley.com

These instructions assume you have already installed a version of Python compatible with Flask. They also assume you have installed pip, a Python package manager. I've written instructions for this. Be mindful when copying and pasting the code below. Make sure you use Unix-style line endings in your text editor, as Michael Lee points out in the comments below. You will very likely encounter issues if you use Windows-style line endings.
19.1 parsecs

Travel
|