Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Translates data in SQL based storage to CouchDB documents.
branch: master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
sag-0.3.0
.gitignore
LICENSE
README
TODO
example.json
sql2couchdb.php

README

sql2couchdb
===========

Version: PROOF OF CONCEPT 

At the moment this project is a proof of concept, meaning it has poor code
design, no architectural thought, a lot of duct tape and hacks, but still
functions. The eventual program will look little like it does now.

The idea is that you feed it a JSON object that has an SQL SELECT statement and
the JSON that you want your documents to look like. The values of your
document's properties map to the column headers that you SELECT from your
tables.

This allows you to easily migrate data stored in SQL to CouchDB JSON documents.

Currently only MySQL is supported, but support for other SQL stores is planned.

Compatability
-------------

PHP 5 (requires MySQL libraries)

Running It
----------

sql2couchdb takes all of the connection info on the command line, with the last
argument being the path to the JSON file. For example,
 
./sql2couchdb.php --mysql-user=john --mysql-pass=l337 --mysql-db=s2c --couchdb-db=s2c example.json

Host and port information defaults to 127.0.0.1 and the server's default port.
CouchDB does not require authentication information unless your database
requires an account to write.

See example.json for an example of how to format your JSON file.
Something went wrong with that request. Please try again.