Posts Tagged ‘database’

Importing Apache Logs into MySQL

Importing Apache Logs into MySQL

Apache, a wonderful bit of software, can be configured to collect and record all sorts of wonderful information. But what can we do with it? Well … why not shove it into a MySQL table and massage it for reporting purposes? I’ll even show you how.

Creating a Simple REST API With VB, PHP and MySQL

Creating a Simple REST API With VB, PHP and MySQL

The internet is an interesting place.  A few weeks ago I had posted an article showing people how to make Crystal Reports play nice with SQL Server Compact Edition.  Since then, I’ve had a few people contact me with questions
Read More →

Merging WordPress Databases

Merging WordPress Databases

This post is the second in a short series outlining how anyone can take measures to simplify WordPress installations on shared or private hosting solutions, improving security and reducing maintenance time. Yesterday I showed one possible way to host multiple
Read More →

Helping Out With Some (My)SQL

Helping Out With Some (My)SQL

How many times have you had the luxury to create a database from scratch?  If you’re like me, the answer is probably “not enough.”  But, regardless of how often we can flex our mental muscles with the complete design and
Read More →

Re-Tooling the Database (Part II)

Re-Tooling the Database (Part II)

It’s interesting how something seems so simple at first, and then baloons into a seemingly-impossible task within hours. Take, for example, my recent decision to make some database modifications to the core WordPress tables. While this seemed relatively straight-forward, it
Read More →

Re-Tooling The Database?

Re-Tooling The Database?

For the sake of expediency I’ll keep this post short and sweet. Over the last few days I’ve been working pretty heavily with the back-end of WordPress in an effort to relieve some of the bloating that I’ve seen take
Read More →