In our application, AgriLife People (ALP), one thing we needed was to be able to build a hierarchical chain of a unit and all its child units. This is primarily used for cascading down management rights and for building contact lists. In previous iterations of the application, we cheated by […]
Another quick post on a little MySQL function I learned about recently. As with many such things, its one of those things I discovered only when I needed it (it’s not like I go reading the MySQL manual for fun or anything LOL). So the issue in this case was […]
I initially planned my first actual post to be on setting up Zend in a hosted environment. I’ve done what I think is needed, but I haven’t actually tested it due to the lack of a true hosted environment to push to just yet (I’ll have it before the end […]
I needed to run a query to find out how many people in our user table had an email address on a domain within a set list from another table. Normally, I might have written a PHP script for this, pulling users that matched a loose LIKE statement of email_address […]
You may have heard recently that Psy's "Gangum Style" video "broke" YouTube due to the database using an signed integer that was 32 bits, never expecting a single video to ger more than 2.147 trillon views. So they upped it to a 64 bit integer. interestingly enough, they still left […]
A relatively quick post this week, but I discovered something new in MySQL (as in new to me). A common query one might need to run is to get a list of rows from one table and it's related rows in a connected table. For example, given these tables: Let's say I […]
On one of our application's databases, we have some triggers in place for row updates and deletes. These triggers fire off stored procedures that take care of making data snapshots for auditing purposes before changes are made. This week, we discovered that those triggers were not always firing, resulting in some gaps […]
So here's a fun little gotcha that I ran into today. One of my legacy apps, one of the first ones I built when I came to work at my current job, has graduated away from being in-house app to running on a third-party hosted e-commerce platform. As part of […]
One area I'm a little weak on, database wise, is in dealing with stored procedures, prepared statements, etc. Primarily because we've never really had apps before that were at the level of us thinking about them or really needing them. However, I'm now working on an application where using a […]
On install, MySQL has its default storage engine set to MyISAM. It's heavily used, but IMHO, a bad engine to use for most applications. MySQL does offer a variety of other engines, including Memory, Merge, Archive, Federated, and of course InnoDB. They each have their uses and their pros and […]