EMENOH

I was recently asked about optimizing an existing Database and existing web application SQL queries. I had some answers but afterwards wanted to make sure I was up-to-date. Here is what I had to say and what I found out.

So I'm working on this Real Estate project and need to create boundary maps with cickable regions for an arbitrary list of cities... looked high and low for GeoData (shapefiles, KML, GIS, Arc, whatever) and finally struck gold, at least for California that is.

I just finished writing up a tutorial on the ModX Wiki for how to add reCAPTCHA to the ModX Jot snippet (it's a blog like commenting system).

A database at it's simplest is a structured record of information. It is a place to store and retrieve data from about very specific topics. Your email contact list is a database, your bank account is a database and your appointment calendar is a database. Any type of information can be stored in a properly designed database. Web applications use databases for such things as online product catalogs, registered user account systems and blog posts and comments.

So you need a Flash based ticker of some sort? It needs to load items dynamically you say? Oh, well in that case let me give you a hand (well me and Tweener).

After looking everywhere for the answer to what mouse event was the right one to use in Flash on a TouchScreen, I had to discover it through trial and error.

One technique for providing keyboard input support in Flash is to emulate mouse events using the DispatchEvent method.