barryf + sql   19

SQL for Web Nerds
Useful basics for database newbies, plus reminders for experienced developers
sql  tutorial  web  dev 
january 2011 by barryf
Sphinx 0.9.9-rc2 - with SphinxQL
It now pretends to be a MySQL database so you can write SELECT queries
database  mysql  sql  sphinx  search 
april 2009 by barryf
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
mysql  tuning  performance  index  database  application  dev  logging  sql 
august 2008 by barryf
Using A Quick & Easy SQLite Database
Example uses PHP and PDO to connect to SQLite
sqlite  php  pdo  database  sql  dev 
july 2008 by barryf
SQLEditor
Slick database diagrammer for Mac. Will also generate DDL and other database functions
database  sql  mac  mysql  entity  er  editor  diagram  design 
june 2008 by barryf
PostGIS
PostGIS adds support for geographic objects to PostgreSQL for geographic information systems (GIS)
gis  database  postgresql  sql  opensource  dev  geo 
april 2008 by barryf
Roll your own SQL session store
A more efficient Rails session storage than ActiveRecordStore - avoids overhead of Model.save
database  mysql  rails  server  sessions  performance  sql  dev  web 
january 2007 by barryf
Project Starfish
ColdFusion profiler - stores execution times, arguments and SQL statements. Report tool integrates into CF administrator.
coldfusion  profiling  monitoring  server  performance  sql  web 
december 2005 by barryf

Copy this bookmark:



description:


tags: