My Blog
contains PHP, Web and business/entrepreneurial related content. Please join in the conversation!
Tag Archives: mysql
Split Read/Write Connections in Zend Framework Database on the Application Level
I’m no sys admin, so I can’t be sure, but I’ve seen lots of issues with using things like MySQL Proxy to fully separate the write and read queries in an application. Maybe it works, I don’t know… but I … Continue reading
Using MySQL Bit Field as a Flag Field: Not a Good Idea
The last time I created a char(1) for a flag field, I remembered the MySQL BIT field – so I did a bit of investigation. I thought, well if I can make a bit field of one bit that is … Continue reading
How about profiling your mysql queries… later?
So the other night I was thinking about using xdebug on my PHP code. I then totally had a brain explosion: I’m always forgetting to profile my MySQL queries. ‘Explain’ is a great command for this. However, as the lazy … Continue reading
Exploring MySQL in Eclipse PDT
As you probably know by now, I’m a huge fan of Eclipse PDT. Well, I wanted to stop using MySQL GUI tools for a bit and explore Eclipse tools. Get the SQL Explorer Plugin The first thing to do is … Continue reading
Display unix timestamp in a date format in MySQL
Every once in a while, I forget about the built in awesomeness of MySQL. Today, I was looking at a unix timestamp from PHP in one of the fields and was wondering what that date was. Derr, use from_unixtime function! … Continue reading
Quick Reference: Simple MySQL Performance Monitoring
There are a few quick ways to monitor MySQL performance. This isn’t much of an in-depth reference, just a quick reminder. Lets look: mysqladmin status Shows a quick status: mysqladmin status Uptime: 102594 Threads: 1 Questions: 39 Slow queries: 0 … Continue reading
PHP Bitwise User Authorization
After looking at the Windows model for controlling file access, I realized I could also do that for user authorization control. The code is pretty self explanatory, but after, you’ll find a quick rundown. ?View Code PHP1 2 3 4 … Continue reading
PDO – can you handle identical prepared statements?
I’ve been wondering if I should be concerned about re-preparing a prepared statement when using PDO. Right now, I use code like this when preparing a statement: ?View Code PHP1 2 3 4 5 6 7 8 9 10 … Continue reading