Mitchell McKenna - tagged with database http://mitchmckenna.com/feed en-us http://blogs.law.harvard.edu/tech/rss LifePress mitchellmckenna@gmail.com Database Backup Manager for PHP http://mitchmckenna.com/post/15702/database-backup-manager-for-php

Database backup manager for dumping to and restoring databases from S3, Dropbox, FTP, SFTP, and Rackspace Cloud. Supports MySQL and PostgreSQL. A laravel specific package is also available for easy integration.

]]>
Fri, 04 Sep 2015 18:24:00 -0400 http://mitchmckenna.com/post/15702/database-backup-manager-for-php/database-backup-manager-for-php
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
Sequelize - Mysql ORM for NodeJS http://mitchmckenna.com/post/13811/sequelize-mysql-orm-for-nodejs

The Sequelize library provides easy access to MySQL, MariaDB, SQLite or PostgreSQL databases by mapping database entries to objects and vice versa. To put it in a nutshell, it's an ORM (Object-Relational-Mapper). The library is written entirely in JavaScript and can be used in the Node.JS environment.

]]>
Mon, 16 Dec 2013 17:49:00 -0500 http://mitchmckenna.com/post/13811/sequelize-mysql-orm-for-nodejs/sequelize-mysql-orm-for-nodejs
neo4j: Graph / Hierarchy NOSQL Database http://mitchmckenna.com/post/10483/neo4j-graph-hierarchy-nosql-database

Neo4j is an open source graph database, storing data in the nodes and relationships of a graph.

An intuitive graph-oriented model for data representation. A disk-based, native storage manager completely optimized for storing graph structures for maximum performance and scalability. Neo4j can handle graphs of several billion nodes/relationships/properties on a single machine and can be sharded to scale out across multiple machines. A powerful traversal framework for high-speed traversals in the node space. Can be deployed as a full server or a very slim database with a small footprint (~750k jar). A simple and convenient object-oriented API.

Unlike twitter's FlockDB, neo4j can handle multiple levels of hierarchy. However where FlockDB is better is it's low latency, high throughput and inherent distributed nature.

]]>
Mon, 28 Nov 2011 16:44:00 -0500 http://mitchmckenna.com/post/10483/neo4j-graph-hierarchy-nosql-database/neo4j-graph-hierarchy-nosql-database
= priceless database http://mitchmckenna.com/post/8047/mitchellmckenna-httphowfuckedismydatabasecom-priceless-database-humour

http://howfuckedismydatabase.com = priceless #database humour.

]]>
Thu, 26 Aug 2010 13:07:00 -0400 http://mitchmckenna.com/post/8047/mitchellmckenna-httphowfuckedismydatabasecom-priceless-database-humour/mitchellmckenna-httphowfuckedismydatabasecom-priceless-database-humour
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