Barry Frost

This is Barry Frost’s personal website.

Tagged #sql

SQL for Web Nerds

Useful basics for database newbies, plus reminders for experienced developers

Why I think Mongo is to Databases what Rails was to Frameworks

Sphinx 0.9.9-rc2 - with SphinxQL

It now pretends to be a MySQL database so you can write SELECT queries

Steve.org.uk - asql - Apache SQL querying

Analyse log files using SQL via SQLLite

log_queries_not_using_indexes

Hugely useful MySQL parameter. The post’s author says he’ll often design an application without indexes and then use this parameter (in development) to add indexes where needed

Using A Quick & Easy SQLite Database

Example uses PHP and PDO to connect to SQLite

SQLEditor

Slick database diagrammer for Mac. Will also generate DDL and other database functions

EXPLAIN Cheatsheet (MySQL)

PostGIS

PostGIS adds support for geographic objects to PostgreSQL for geographic information systems (GIS)

MySQL Workbench

INFORMATION_SCHEMA Support in MySQL, PostgreSQL

Working with Flex, AIR, and SQL

Bamboo Blog - Database Optimization for Rails Apps

Joyeur: Quick wins with MySQL

Materialized Views (MV) with MySQL

Calculating Distance in Miles from Latitude and Longitude

Uses Google’s GeoCoding API and some simple maths in SQL

Roll your own SQL session store

A more efficient Rails session storage than ActiveRecordStore - avoids overhead of Model.save

Project Starfish

ColdFusion profiler - stores execution times, arguments and SQL statements. Report tool integrates into CF administrator.

SQL to Select a random row from a database table