MySQL CSV’s with column headings — Part 1

By Colleen, on August 4th, 2009%

mysql In a previous post I discussed the stumbling blocks and security concerns that the mysql documentation doesn’t tell you about having a mysql user create csv files on the filesystem.

I ran into yet another issue. In order to do what I want with these csv’s, they have to have column headers. I thought surely by now MySQL must have come up with some syntax in the query to do this, but Paul DuBois assured us all in a 2006 forum post, that there is no such thing.  I thought maybe Zend Framework might have such a thing in it’s DB class, but I didn’t locate one.  Correct me if I’m wrong–Zend Framework is huge, and I might have missed it.

So, what to do? We have several options:
Continue reading MySQL CSV’s with column headings — Part 1

3 comments - (Comments are closed)   Geek Stuff, Hacking and Security, SQL   , , , , , , , , , , , , , , , , , ,  

Memcached Test

By Colleen, on February 5th, 2009%

Warning: Hard Core Dorkage!

Here’s a little simple memcached test you can have to test memcached on your system. I am working on an app that, while the server load is not huge, the datasets that you are presenting to a visitor are larger than normal for a web app, and so I ultimately plan to break them into subsets and only load the subset the user is focusing on and cache the rest.  Hopefully most users will confine their activities to items from the same subset so we won’t be thrashing too much. Anyway we’re a long way from that day. I just installed the memcached and tested it with telnet, and I got it all hooked into the whole PHP Apache tangle.  So now we’re going to cache some data and see if it works.
Continue reading Memcached Test

9 comments - (Comments are closed)   Geek Stuff   , , , , , ,