Tag: DATABASE

Like many web developers, I use MySQL constantly. Sure I can just use the command line, but it is faster to use some kind of graphical client with a decent UI. There are many out there, but my favorite for a while was MySQL's own MySQL Control Center (which has now been discontinued for a while). The replacement for Control Center is Administrator, and I am just not a big fan of it. I loved ...

MySQL's VP of community relations Kaj Arno's he explains in his blog that MySQL has changed its license from "GPLv2 or later" to "GPLv2 only", so MySQL doesn't have to be forced to use the GPLv3, which as you know is not so widely adopted yet. MySQL may very well move to the new v3 license once it becomes more commonplace, but for now, they don't want to put users and developers in a tight spot ...

phpMyAdmin is one of the best and most heavily used (at least on my desk) MySQL management tools. It makes everything you do in MySQL simple, and can be either desktop or web-based. Even LAMP installs have a portable, USB drive friendly version, which is one of my favorites. Sure, I love SQLyog, MySQL Administrator and other desktop based clients too, but none is as versatile and useful as ...

I've never actually heard of SQLyog before (even though it claims to be the "most popular MySQL GUI for the last 4 years"), but its web site is making a big deal out of the fact that this GUI front-end for MySQL is now open source, ergo free, and I certainly won't complain about there being more free MySQL front-ends in the world. To be fair, it's the "Community Edition" that's gone ...

YouTube is on a quest to add a massive music video library to its extremely popular online database of videos, and is asking major labels to work with them. YouTube has been in talks with major record labels about posting their archives of music videos in their service. This is a drastic, but reasonable move away from a site where people share their own videos, moving towards a more mainstream ...

Trying to one-up Google, Yahoo has just acquired a Database genius. Yahoo hopes to beat out Google by specifically targeting social search. Raghu Ramakrishnan was formerly a professor of computer sciences at UW Madison, and will now be concentrating on studying links between computer and human search. With the help of Raghu, Yahoo is planning a social attack with its array of recent acquisitions ...

exeLibrary isn't the only site of its kind, but it's certainly the simplest and least cluttered. It's a database of executables that you might unexpectedly find in your task manager along with descriptions and , in the case of ones that shouldn't be there, threat levels. My one gripe with the site is that when you enter a process that isn't in its database, it give you a scary notice that says ...

Since getting out of the database business a few years ago, I haven't had to sully myself with things like foreign keys or even SQL for a while. But now that it looks like I'll be building a site using MySQL and PHP, it's back to the db again. Luckily, developer Thomas Mango sent in a tip about his PGnJ app. It's written in Java, and serves as a database manager for PostgreSQL and MySQL databases. ...

Lazybase is a web-based database app that fits the "simplest thing that could possibly work" paradigm. It's not flashy (or even AJAXy), but it's clean, easy to use, and it just works. It's a registrationless service, so to create a new database you just give it a name and enter your e-mail address. When you create a database you're given two URLs, one that lets people edit the database ...

I can't tell you how many times I've looked at somebody's self-developed scheduling application and said, "Man, wouldn't it be great if this was tied to Outlook so your events would appear in the Outlook Calendar?"   Then, the person says, "yeah" and we leave it at that, never realizing the benefit of what we'd just envisioned. Well, it's about to get a lot easier to ...

According to CNet, MySQL's Marten Mickos has confirmed that enterprise database vendor Oracle made a bid for the open source heavy-hitter, but was turned down. This news comes on the heels of yesterdays' report that Oracle is acquiring Sleepycat Software, makers of the open source Berkeley DB. No details of Oracle's offer have been disclosed, but Mickos says MySQL turned down the juggernaut's ...

Following rumors that it was shopping around for open source companies, database juggernaut Oracle has acquired Sleepycat Software, makers of the open source Berkeley DB. Berkeley DB is included in a number of open source products including many Linux distributions and OpenOffice.org. Last week Oracle was also rumored to have its eye on JBoss and PHP mother company Zend Technologies. The terms of ...

Mr. Stuff got tired of looking for decent homebrewing software and decided to write his own. BeerMeister is an all-in-one tool for making the perfect homebrew. It got a collection of pre-made recipe templates (for bock, ale, etc.), a log book, and XML recipe exporter. Could you roll your own version with Filemaker or Excel? Perhaps. But first you'd have to sober up, wouldn't you? Right now it's ...

Yeah, I know, there's a lot of you SQL types out there who just do it all in code. Unfortunately my brain doesn't work that way. Creating database connections from thin air was never my cup of tea, and don't get me started on inner joins. And the worst boss I ever had the pleasure of working with lived in SQLServer all day (maybe that was a personal problem)... But if you're needing a very simple ...