Just wanted to add in there that you could use MongoDB instead of MySQL, which gives you additional opportunities to do stuff like real time analytics and live in a SQL-free world.
Documents are stored in a binary JSON format, so there's no conversion needed. You could almost look at your PHP scripts as a simple REST interface to MongoDB, which would scale very gracefully and be very quick to prototype. -- Mitch On Thu, Dec 3, 2009 at 2:48 PM, Anthony Papillion <[email protected]> wrote: > Thank you Jake! > > On Thu, Dec 3, 2009 at 1:29 PM, Jake McGraw <[email protected]> wrote: >> >> On Thu, Dec 3, 2009 at 2:19 PM, Gary Mort <[email protected]> wrote: >> > >> > >> > On Thu, Dec 3, 2009 at 2:11 PM, Anthony Papillion <[email protected]> >> > wrote: >> >> >> >> While this seems (and indeed is) a rather simple task, it's also fairly >> >> tedious. Is there anything out there that can help me auto-format them >> >> in >> >> one of those formats? Something that takes a standard results set then >> >> transforms it into either XML or JSON? >> >> Here is how I would do it (using json_encode or simplexml): >> >> http://snipt.net/jakemcgraw/mysql-to-json-or-xml >> >> - jake >> >> >> >> > >> > json_encode >> > >> > http://www.php.net/manual/en/function.json-encode.php >> > >> > -- >> > ---- >> > Hudson Valley Sudbury School >> > What GPL is for application users >> > Our school is for students >> > Help your children grow, change, and learn >> > Let your child direct, control, amend >> > Check out http://www.sudburyschool.org >> > >> > _______________________________________________ >> > New York PHP Users Group Community Talk Mailing List >> > http://lists.nyphp.org/mailman/listinfo/talk >> > >> > http://www.nyphp.org/Show-Participation >> > >> _______________________________________________ >> New York PHP Users Group Community Talk Mailing List >> http://lists.nyphp.org/mailman/listinfo/talk >> >> http://www.nyphp.org/Show-Participation > > > > -- > Anthony Papillion > OpenEMR HQ, Inc > (918) 533-9699 > > _______________________________________________ > New York PHP Users Group Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > http://www.nyphp.org/Show-Participation > _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
