Mitchell McKenna - tagged with sql http://mitchmckenna.com/feed en-us http://blogs.law.harvard.edu/tech/rss LifePress mitchellmckenna@gmail.com Phinx - Framework-Agnostic DB Migrations in PHP http://mitchmckenna.com/post/14844/phinx-framework-agnostic-db-migrations-in-php

Includes a neat feature called "reversible migrations" allows you to just define the up() in migrations. Integrates into deploy/CI tools easily. Supports MySQL, Postgres, SQLite, SQL Server.

]]> Fri, 17 Oct 2014 11:33:00 -0400 http://mitchmckenna.com/post/14844/phinx-framework-agnostic-db-migrations-in-php/phinx-framework-agnostic-db-migrations-in-php Managing Hierarchical Data in MySQL http://mitchmckenna.com/post/6357/managing-hierarchical-data-in-mysql

"Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table. In this article we will examine two models for dealing with hierarchical data in MySQL"

]]> Wed, 17 Feb 2010 14:54:00 -0500 http://mitchmckenna.com/post/6357/managing-hierarchical-data-in-mysql/managing-hierarchical-data-in-mysql Ajaxed MySQL Table Editor http://mitchmckenna.com/post/4219/ajaxed-mysql-table-editor

"Mysql Ajax Table Editor is an open source web application for easily editing MySQL tables & creating admin pages almost instantly. Besides the standard "add, edit, copy, delete, view" functionality, records can be paged, searched & exported to CSV. It is possible to JOIN multiple tables to generate a custom view with the help of a config file."

]]> Sat, 12 Sep 2009 15:00:00 -0400 http://mitchmckenna.com/post/4219/ajaxed-mysql-table-editor/ajaxed-mysql-table-editor SQLFormatter | Formats SQL Statements http://mitchmckenna.com/post/4103/sqlformatter-formats-sql-statements

"SQLinForm automatically cleans up the formatting of SQL code for all major databases i.e. MySQL, ORACLE, etc. with over 50 formatting options.

]]> Wed, 26 Aug 2009 19:14:00 -0400 http://mitchmckenna.com/post/4103/sqlformatter-formats-sql-statements/sqlformatter-formats-sql-statements