How Copy a MySQL Database

Wouldn’t it be nice if it was as simple as “copy database1 to database2”? Or something like that? But that would be too easy! Although to be fair, copying a MySQL database is easier than many other databases. But the caveat is that if you do it wrong, it is easy to accidentally export the database names, and importing an improperly exported database potentially overwrite production data if you’re not careful.

Continue reading “How Copy a MySQL Database”

Dusting off A 20-Year-Old Delphi Documentation Generator

Proving that some Delphi code can be parsed by my 20-year-old doc generator.

Years ago I was told by an asshole boss at a company I worked for that I was going to be “fired” if I didn’t “document my code” (although it should be noted that I maintained a department library of dozens and dozens of white papers on our software design… but he was too much of an asshole to care).

To shut him up, I showed up to the scheduled meeting a month later with a stack of paper as tall as two dictionaries, full of detailed information about every single class, method, and function written by our six-person development team. I determined from the start that there would have been no way I could have done this manually, so I spent weeks of my personal time building a documentation generator to handle the chore with its own Pascal language compiler.

Although barely working, I have brought my old documentation generator back to life and built a barely-working barebones web front end for it online for the purpose of documenting my Delphi CommonX library, but don’t get too eager to read much of it because the documentation sitting on the documentation server is super sparse and simply for the purpose of testing a new searchable database of classes and symbols.

Continue reading “Dusting off A 20-Year-Old Delphi Documentation Generator”

After Nearly a Week of Pissing Around, I Finally Got Delphi to Display a Downloaded, Local PDF on iOS When Sandboxed

Computer programs have become more complex and connected to the world via “always-on” connections…. and due to the constant threat of new internet exploits, Operating systems are a frustrating, moving target.

As a result, certain things that worked on the last version of an operating system are banned in the next, and the churn is often miserable, especially if you’re a small company with limited resources. Simply keeping your app available on the Apple App Store requires regular maintenance, periodic updates, and frustrating amounts of your time.

I finally got my client’s PDF Reporting functionality restored in their iOS app and the solution was very simple, although it required trial and error. In fairness, the solution for iOS was much simpler than the Android solution that I had to figure out a few months back. If you need help with Android, fire me a comment and I’ll possibly update this blog.

Continue reading “After Nearly a Week of Pissing Around, I Finally Got Delphi to Display a Downloaded, Local PDF on iOS When Sandboxed”