MySQL

Devolio

Search

Twitter

    MySQL stuff.

    Thursday, July 10. 2008

    Projects abound

    I apologize for the lack of updates recently. Between work, meetings, and fun little side projects, I've practically been coding in my sleep. I'll be back to a full time posting schedule soon, I promise. In the mean time, here's a little bit of a description of the projects I've been working on.

    Magus - An old school web based RPG / Collectible card game. Collect, buy, sell and trade cards to build powerful decks to duel your opponents. Nearly feature complete, in final testing before our first invite-only release.

    Semantic IO - A flexible semantic input/output engine. Enter a file, text, or a URL and pull out an array of useful information. Quickly find phone numbers, addresses, names, or custom searches. Summarize long articles. Find keywords. Automatically tag bodies of text. Full i18n support.

    And lastly, I'll be slowly updating and adding (literally) hundreds of research scripts, snippets, and documents to my resources. So - If there's anything specifically that you'd like to improve at or have an idea you want to share or explore - leave a comment. I'd love to hear from some of you lurkers.

    Tuesday, May 20. 2008

    How to install Apache, MySQL and PHP (LAMP) in Ubuntu 8.04

    Just like our Ubuntu 7.10 LAMP how to, this guide will cover the installation of Apache, MySQL and PHP on Ubuntu 8.04. I assume you're already running Ubuntu 8.04 for this guide. If you're still running 7.10, you can use this guide.
    Continue reading "How to install Apache, MySQL and PHP (LAMP) in Ubuntu 8.04"

    Monday, January 7. 2008

    How to install Apache, MySQL and PHP (LAMP) in Ubuntu 7.10

    This guide covers the installation of Apache, MySQL, and PHP on Ubuntu 7.10 (More commonly referred to as LAMP, or Linux Apache MySQL PHP). Optionally, you can also install phpMyAdmin as a front end for MySQL. We assume that you already have Ubuntu 7.10 running on the machine as well. That said, let's get right into it.
    Continue reading "How to install Apache, MySQL and PHP (LAMP) in Ubuntu 7.10"

    Saturday, November 17. 2007

    67 Killer Resources for Web Developers and Designers

    As a designer or developer, efficiency, proficiency, and timeliness are of the essence. The quicker we can implement our ideas, and go from a mock up to fully documented, functional code, the better. Here are 67 killer resources to help you get the job done quicker, and easier than ever. All of my favorite (mostly) open source tools, with some Ajax, PHP Frameworks, Palette tools, Icons and layouts, MySQL tools and managers, RSS parsers and more. And there's plenty more where that came from.
    Continue reading "67 Killer Resources for Web Developers and Designers"

    Thursday, November 15. 2007

    Automating MySQL Backups with Cron

    Thousands of web applications use MySQL for their databases, and almost all of them store some sort of valuable information. You never know when a hard drive will fail, a server will die, or in the absolute worst case, when someone will find a vulnerability that allows them to delete your databases. Sometimes we just take for granted how well everything just... works. We're going to look at two simple ways to backup your databases, and how to automate them using crontabs.
    Continue reading "Automating MySQL Backups with Cron"