I don’t know why I haven’t been using this for ages. But Zend’s DB Profiler is fun. Only to be used in development so you can see what your database is doing and how fast/slow it’s doing it. Enable it in your application’s config.ini (or .xml) [development] db.profiler.enabled = true db.profiler.class = “Zend_Db_Profiler_Firebug” And as [...]
Posts Tagged ‘mysql’
It’s alive: Moments Like Today
January 8th, 2010
1 Comment
It’s finally alive! You can read Magaret’s announcement here. What it is: ‘Moments Like Today’ is a collaborative project that aims to inspire people to post “moments” of their lives in three sections: mornings, afternoons, and evenings. What I did: While the concept and design came from Margaret and Myra, the functionality and everything back-end [...]
Adding an Auto Increment Column After The Fact…
September 29th, 2009
No Comments
Yep, I pulled a ‘whoops’ today. I made a table, filled it with data, then realized I forgot my standard ‘id’. My primary key, auto incrementing column that makes me feel good about myself. Once I noticed it was gone, it was easy to add it back. Right? Right? Well, not so fast. You can [...]
Summer Project: Initial Setup and more Details
May 27th, 2009
No Comments
I’m still chugging along with the common elements on the project. So, for the basics of what I have decided to do: Yep, it’s an image gallery. It’s not too exciting and definitely nothing original. There’ll be a basic authentication system (login/logout) with web based uploading and tagging. That’s pretty much it. The images that [...]
Summer Project: Setup PostgreSQL
May 23rd, 2009
No Comments
Using my shiny new upgraded Ubuntu 9.04, I’ve gotten around to installing PostgreSQL. Note: this is not a tutorial. The installation was simple, as are most installations with Ubuntu. The initial “get going” was a bit odd for PostgreSQL though. The one thing you have to remember when initially trying to get things going is [...]
