I ran across a pretty old “hack” that grabs a list of all the tables and forces
them to optimize. Its generally a pretty useful script to schedule and run once
a week. For those of you playing the home game, you’ll need to tap into your own
database class or adjust it to use the normal db connect functions, but that’s really
simple to do.
Optimizing PHP with the by using quotes properly in echo statements is a pretty easy
thing to do, and it will also enhance the security of your script ever-so-slightly.
No real knowledge in this post, just a link to something cool someone else did. A researcher/professor has come up with some really novel uses of the Wiimote (and the code’s downloadable and in C#). I’m still trying to figure out a fun application for a Wiimote, but rest assured that I’ll find an application for it. This is just some amazingly cool stuff that never really crossed my mind. Here’s a link Wiimote uses with C# code.
Ever have performance issues with your queries even after you’ve optimized them? You
can do a few mySQL specific tricks using keywords in order to force certain behaviors.
I’m learning the hard way how to estimate development time, and much to the frustration
of everyone around me it seems like the answer to “How long will it take to do this?” is
more often than not “I’ll get back to you.”
Here’s a useful (and easy) regular expression.
Problem: Internally, people continue to cut and paste from dozens of different and
very unique programs. This often includes special and non-printable characters
that break either web presentation or xml feeds.
Here’s a code snippet for turning classes into “Singleton” objects. Basically,
this is for when you have a class and you don’t want to create a bunch of instances
of that class.
Here’s a query I use to find find the closest X locations to a particular latitude and longitude. I usually end up combining it with a lot of other query business, but in this case I’ve tried to remove everything that isn’t related to the proximity
query.
I’m the first to admit that I don’t know Bash very well. I spent a week on it
in college and then quickly moved on…It just isn’t a language that I’ve had
a huge need for in my personal or professional life.
This website isn’t written to impress. It is, in concept, a notebook. A place for me
to make notes that I can look back on. I do hope that it helps other programmers out
and makes things easier for them then they were for me.