Gadgetopia

MySQL raises $19.5 million | CNET.com: Good news out of Sweden today: "MySQL announced Tuesday that it raised $19.5 million in a second round of funding led by Benchmark Capital. ... MySQL, which recently inked a deal with business application software giant SAP...." That last bit refers to MySQL's deal ...

MySQL Administrator: This looks like MySQL Control Center on steriods. I said that product was "enterprise manager for MySQL," so I'll need to whip up a whole new batch of superlatives for this. MySQL Administrator is a powerful visual administration console so you can now easily administer your MySQL environment ...

ONLamp.com: MySQL FULLTEXT Searching: A good article about a great feature of MySQL: full-text indexing.

MySQL Gets Functions in Java: Neato. First step down a long road to making MySQL just as functional as other options. Eric Herman and MySQL's Brian "Krow" Aker have released code to allow the DBMS MySQL to run Java natively inside of the database.

MySQL Administrator Downloads: MySQL has an alpha release for the new MySQL Administrator. It's very polished for an alpha, and the entire app looks first-rate. However, it differs from MySQL Control Center in that it's for management of the server, not for development of the database. There doesn't seem to ...

Chu Yeow rounds up a couple of sites that have a bone to pick with MySQL. They outline a couple of them that I didn t know about that sound like real scalability problems, like: Making changes to a table definition causes a temporary copy of the table to be created. ...

MySQL prepares for version 5.0: MySQL 5 is coming, with some long-awaited features. Version 5.0 of the Uppsala, Sweden-based company's MySQL database will include support for stored procedures, triggers, and views, making it more suitable for existing enterprise applications.

Mysql Backup: Here's a good-looking program and a relatively rare example of an open-source Windows program, Mysql Backup is a program to backup your mysql databases. You can backup multiple databases and or tables all saved to a SQL file. It also has an scheduler so you can backup your ...

MySQL reserves features for paying customers; open-source community up in arms: This is interesting, and perhaps not surprising given the acquisition. Open-source darling MySQL is facing a new uprising within its customer base over plans disclosed this week to reserve some key upcoming features, and their source code, for paying ...

CNN.com - MySQL: A threat to bigwigs?: A good article on MySQL: "Yahoo's Zawodny makes a different analogy: 'MySQL is to Oracle as Linux is to Windows. It will slowly but steadily creep up the food chain, just like Linux has.' ... Mickos is already seeing real headway. 'I estimate ...

Oracle tried to buy open-source MySQL: I guess if you can't buy them, screw them instead. MySQL Chief Executive Marten Mickos confirmed the acquisition attempt in an interview at the Open Source Business Conference here but wouldn't provide details such as when the approach was made or how much money ...

Changes in release 5.0.0 (Development): MySQL has released an alpha of version 5.0. They include support for stored procedures, but no views yet.

Why the light has gone out on LAMP: This guy eloquently tears up MySQL and PHP. IMO, MySQL once filled a niche (cheap data store) that today is better filled by SQLite but has moved out of it into a area where it doesn't compete nearly as well (that of ...

Quick Merge in MySQL: I wished for this functionality in SQL Server for years. There are so many situations when this would come in handy. Using the GROUP_CONCAT function though, I no longer need to loop through them. I concatenate the list on the MySQL side, which returns me one ...

MySQL Teams With Pogo Linux: You'll soon be able to buy "MySQL in a box." A "database appliance," if you will. "Dubbed the DataWare 2600 Server, the turnkey appliance will be preconfigured and geared to deliver an open-source option in places where throughput and performance are paramount concerns, such as ...

Oracle Acquisitions are not about MySQL: He refutes my theory. Trying to put MySQL out of business would be a fairly short-term tactical move. I think Oracle is looking 5 years down the road and seeing what the world looks like as the commoditization of enterprise scale infrastructure software components ...

MySQL - Dynamically Insert and Update Values In a MySQL Database Using OOP: Good stuff, because I hate writing admin interfaces. Just hate it. We will make a class that goes out and looks for the values for us and builds a SQL statement on the fly. All we have ...

Oracle buys Innobase. MySQL between rock and hard place?: This is interesting. Oracle bought Innobase, which is a close partner of MySQL, that company having used InnoDB as a storage architecture for years. MySQL is now faced with the prospect of licensing technology they cannot ship without from their biggest ...

Navicat - the World's Best MySQL GUI: I worked with a lot of MySQL clients, but this is by far the best I've seen. Gorgeous interface, and support for all the cool upcoming features of MySQL 5. It's $95, but if you work with MySQL a lot, this ...

'Most important ever' MySQL reaches beta: I found this stat in this article about MySQL 5.0, and I'm amazed by it: [MySQL] accounted for 40 percent of open source database deployments, while Firebird and PostgreSQL accounted for 39 percent and 11 percent of deployments respectively. Firebird has a 39% share ...

As will surprise nobody who knows me, the shininess of the Firebird database server had been blinding me since I posted that interview yesterday. It was calling my name, so I just had to download and install it. I'm extremely happy with what I found it's a free database ...

There can be no doubt now: Oracle is trying to destroy MySQL. Consider: They buy Innobase, the company responsible for the back end data format that makes MySQL go. They forge a partnership with Zend, the company responsible for PHP, which is the lanuguage most often used with MySQL on ...

Sokkit - Install Apache and PHP on Windows: A while back, we mentioned FoxServ as a great way to get Apache, MySQL, and PHP (AMP) running on Windows. It was really nothing more than an installer that got all those pieces working together for you, but this was still a ...

phpMyAdmin is usually installed quickly, out of acute necessity. You need to do something with your database, and you can't do it via telnet or SSH or anything else, so you download the latest version, FTP it up, and away you go. More often than not, the install is forgotten ...

Using MySQL 4.0 with .NET: An article you don't see much of these days: using MySQL in a .Net environment. Aside from Oracle, I've never heard of a non-Microsoft product being used with .Net, but maybe I haven't been paying attention.

As I become a more experienced developer, I'm learning when you should and shouldn't break the rules. While following every rule of programming and data modeling is wonderful, sometimes you need to bend the rules for the sake of simplicity and expediency. Always remember, an app in the hand is ...

WordPress : Looks like a good blogging platform built on PHP / MySQL, which is just so much more hackable than the Perl / MySQL backend Movable Type uses. GPL, even. WordPress is a state-of-the-art semantic personal publishing platform with a focus on aesthetics, web standards, and usability. What a ...

PHP version 5.0.0 has now officially been released, bringing a large number of long-overdue changes to PHP. The Zend Engine II with a new object model and dozens of new features. XML support has been completely redone in PHP 5, all extensions are now focused around the excellent libxml2 library ...

opensourceCMS: This site has several dozen installed CMSs for you to play with: "This site was created with one goal in mind. To give you the opportunity to 'try out' some of the best php/mysql based free and open source software systems in the world. You are welcome to be ...

SQLite Database Speed Comparison: If you ever wanted to know which Linux database option was the fastest, the guys over at SQLite have done some tests. No surprises: SQLite wins, MySQL is second, with PostgreSQL trailing the pack. Note to Access users: MySQL can do 25,000 inserts in two seconds. ...

Eventum Issue / Bug Tracking System: I don't know how long this has been out there, but the MySQL team wants to give you their trouble ticket tracking app, which I imagine has to be pretty good. Eventum is a user-friendly and flexible issue tracking system that can be used ...

Oracle and Zend announce general availability of Zend Core for Oracle: So, let's see, first Oracle buys a company responsible for a critical piece of MySQL, the database most commonly used with PHP. Now, Oracle and Zend -- the company behind PHP -- release a PHP platform tuned specifically for ...

PHPRunner - PHP code generator for your MySQL database: A few weeks ago, I talked about ASPRunner, which is a code-generation engine to build ASP pages to manage ODBC databases. At the end of that post, I whined that I wanted something similar for PHP/MySQL. Well... PHPRunner creates set of ...

Here's a command line switch for MySQL that's both funny and pretty handy: --i-am-a-dummy Synonym for option --safe-updates, -U. Yes, there is a MySQL switch called "i-am-a-dummy". It's an alias of another switch, which provides more information: --safe-updates Only allow UPDATE and DELETE that uses keys. Now, that's handy. This ...

Freetag - an Open Source Tagging / Folksonomy module for PHP/MySQL applications: Found this via a trackback to my previous post about tagging. It's a ready-made API for implementing a tagging system in your app. Freetag is an easy tagging and folksonomy-enabled plugin for use with MySQL-PHP applications. It allows ...

When it comes to AMP (Apache; MySQL; Perl, Python, or PHP) installers, we at Gadgetopia started with FoxServ. That project kind of died, so a few weeks ago, we touted the benefits of Sokkit. That product, while very good, wasn't free, which was a drag (though, at $24.95, it's still ...

Some time ago, my company was maintaining information in an Access database that we also wanted to use as Web content. We were on a Windows host at the time, so we just FTPed the database up to the server every day. A little kludgy, but it worked well. Then ...

Alex King just released Photos 4.0 (formerly known as Gallery). It's a web-based photo database for storing, cataloging, and retrieving photos, but NOT for publishing web galleries. It can import photos by the folder or one at a time, and stores a thumbnail of each image. It's designed for "Anyone ...

I worked on improving the search on this site today. Search has been through a number of iterations. First, I used the basic Movable Type search. But it was slow and I wanted to do some interesting things with search. So last year, I switched to using a SQL "LIKE" ...

PHP5: Coming Soon to a Web server Near You: A comprehensive look at the masterpiece that is PHP5. The author details all the changes with copious amounts of code to browse. Big changes are coming, including a complete revamp of XML handling that includes the ability to say, Make an ...

InfoCentral: A log time ago (like, four years), I wrote a piece of software called InfoCentral. It's a PHP/MySQL app to manage church congregations. "InfoCentral is a church management database written in PHP, using MySQL as its database backend. It is currently the only viable Open Source package for this ...

NuSphere phpED: Products: NuSphere: Here's a sharp-looking development package for PHP/MySQL. It includes an IDE, debugger, GUI for the database, etc. Nicely done for $299.

Create ASP code for your database with ASPRunner: This is pretty good software. I downloaded the demo, walked through the wizard, and within 3 minutes (from download to finished interface) I had a complete set of pages to view, edit, add, print, search, and export a database table on my ...

Given that Microsoft products appear to be full of security holes, more and more thought is being given to migrating to other platforms. However, this has problems of its own. Macs are expensive, and Linux isn't quite ready as a desktop platform. This leaves a lot of people in limbo ...

PostgreSQL 8 Released: I noticed this the other day. There's a Windows installer for Postgres with this new release. [Version 8] is the first PostgreSQL release to natively run on Microsoft Windows as a server. So add Postgres to (at least) MySQL and Firebird as enterprise-level open source database servers ...

PHP Apps on Mobile using PAMP: This looks really cool. If you’d like to work on your favorite PHP apps on your S60 phones, here’s PAMP - Personal Apache, MySQL and PHP. This is implemented on the Symbian OS using Open C, which is a set of industry-standard POSIX and ...

Packt Book Store :: Mastering phpMyAdmin for Effective MySQL Management: We've talked about Packt Publishing before, but now it looks like they're really hitting high gear. Here's a book about PHPMyAdmin, which I never thought we'd see but which is badly needed. You may think you know PHPMyAdmin, but if ...

fabFORCE.net: Here's a really fantastic MySQL administration tool. Open source, even. DBDesigner 4 provides powerful features to create a visual model of any database. Starting from a reverse engineering engine to automatically retrieve a model from existing databases, extensive modeling tools and editors to a syncronisation function which will apply ...

Comparison of relational database management systems: I found this Wikipedia page at the bottom of the SQL comparison I linked to yesterday. It's a comparison of major database platforms and their support of various features. It doesn't get into the SQL like the other page, but there are more platforms ...

miniBB :: Evolution of bulletin boards: A neat little bulletin board system I've been using over at the WordPress support area. PHP / MySQL. miniBB ("minimalistic bulletin board") is flat linear (non-tree) version of highly customizable bulletin board. It inherits most popular features from the bulletin boards the planet has ...

The time for my custom-built blogging app is over, I think. This site runs off a PHP/MySQL-based app that I wrote, but I'm tired of dealing with it. It's stable and everything, but to get to the functionality that, say, MoveableType offers would be more work than I'm interested in ...

Everyone's favorite Web-based database management interface has released a new version with some snazzy improvements. Some highlights: * Displays results for multi-statement SQL requests * Saves export files to the server on which it's running (previously, you had to save them locally) * Displays the last-inserted auto-increment field (handy for ...

Scoop: Job Cuts at PHP Startup Zend Could Be Aimed With An Eye Towards a Sale: Very interesting. [Zend s] job cuts could be an attempt to pretty itself up for a sale. Back in 2006, Oracle wanted to buy it for $100 million to $200 million. It might still be ...

Werkema.com: Software: SpaceMonger: This is a great little freeware app which I found on the Pricelessware site. SpaceMonger examines your hard drive to see where you're using space, and displays this analysis to you in the form of rectangles the bigger the rectangle, the more space that directory is ...

Oracle Buying Open Source Companies?: Some good commentary about Oracle's aquisition spree. We've talked before about how Oracle is seriously trying to screw MySQL. How much damage would they do if they just went and bought Zend? All of these moves prompt one question, will Oracle start to play hard ...

PHP Programming Marathon Sponsored by Zend: They're giving away an illuminated keybord, a copy of Zend studio, and a year of hosting, to say nothing of the geek cred that would go along with winning this. "The Marathon organizers will send a PHP problem [...] which must be solved using ...

You Never Forget Your First Web Server: Zawodny gets nostalgic about his first Web server. -- a 486DX2 machine. It's nice piece, full of memories. That application led to the student government paying me $400 a year or so later to build the first on-line voting system. That's right, back ...

Apple has beefed up its .Mac service in several ways, but it's still way too expensive. $99.95 a year for a gigabyte of storage space (combined Mail and iDisk), .Mac Backup software, .Mac Groups, your own Homepage, yadda, yadda, yadda... Who needs it? I guess I'm still hacked that Apple ...

Amazon.com e-Books & Docs: Programming: Here's an interesting trend in programming books: cheap little PDFs that show you how to do one very specific thing. Consider some of the titles on this page: Creating a DataGrid and Updating Its Records on the Fly Accessing a MySQL Database with a VB.NET ...

So I'm in New Orleans at this convention with a little Toshiba laptop running XP Home. To my horror, I have no development platform (XP Home won't run IIS). That hasn't stopped me from coding as I have EditPlus and I can upload from dial-up the hotel, but still. This ...

Homeland Security Survey Takes First Pass at LAMP: Some good news, though I think the bug density would skyrocket once they moved passed the top 1% of projects and into the second and third-tier of open source stuff. First results are in for the Department of Homeland Security's vulnerability survey ...

Mambo Open Source: Mambo server is a PHP/MySQL-based content management system. The marketing material doesn't reveal much: "Mambo Open Source is the finest open source Web Content Management System available today. Mambo Open Source makes communicating via the Web easy. Have you always wanted to have your own site but ...

FoxServ Project: I'm surprised we haven't talked about FoxServ here before. FoxServ is an Apache / mySQL / PHP installer package for Windows. Unlike NuShpere or PHPTriad, FoxServ features the latest version of all included pacakges, user defined configuration during installation, PHP as a module, PEAR, and the Zend Optimizer. ...

10 Best Intranets of 2005: I actually purchased this full report back in 2001. The price has gone way up it was $44 then; $128 now. However, if you're in the middle of an intranet rebuild like I was at the time, it's worth it for the screenshots alone. ...

InfoCentral was a piece of software I wrote for my church about two years ago. They had been tracking congregational information (people, families, group attendance, etc.) using multiple AppleWorks databases (which are really just flat spreadsheets anyway), and it was getting out of hand. InfoCentral was meant to get everything ...

Much like my selfish use of this space to ask for a GMail invite, I'm now asking for a software recommendation. I'm building a Web site for our local Christian school, and we need a Web calendar. I'm not going to roll my own, so we're looking for open-source or ...

IBM sets DB2 database free: This slipped under the radar about a week ago: there's now a free version of DB2. DB2 Express-C is the same database as IBM's commercial offerings but the company places limits on what kind of hardware it can run on. It can be deployed on ...

At the Rational User Conference in Vegas, a guy from IBM got all condescending about LAMP. Businesses that run on the Linux, Apache, MySQL, Perl/PHP/Python (LAMP) model will have to grow up to avoid reliability issues in future, an IBM executive said. According to Daniel Sabbah, general manager of IBM s ...

One of the continuing quandries I've had with XML is the management of multiple XML documents. If I have one, big XML document, then it's easy to work with to parse with an API, to transform with XSLT, to query with XPath. But what if I have many documents? ...

I stumbled across Escapade while looking through the EditPlus Yahoo! group. It's a very (very) lightweight server-side scripting language. It provides for include files, database access, variable assignment and retrieval, and not much else. But I had it installed in about two minutes and I was pulling data from a ...

IBM is planning to announce that they'll be donating the Java-based Cloudscape database to the Apache foundation, to be released as open source. Most business applications require some database functions like storing and looking up price or customer information, whether in a Web page or a laptop program. Cloudscape is ...

Here's an idea for a good service: a database of products, and some way to match them up with their chief competitors. I was looking for a certain type of product today. I found an example of one, and I wanted to find others. But how do you do that? ...

I've complained off and on about the lack of user-defined fields in Movable Type. Today was finally the day I got off my high-horse and messed with some code. Here is a method to add a new field to the MT database. The field can store whatever you like, can ...

SQLite: An Embeddable SQL Database Engine: I'm just tickled with this little program. I'm not a client applications programmer, but if I was... SQLite is a tiny, file-based database engine. The Windows exectuable is only 280KB and it's statically compiled, so it needs nothing else to run (read: no install). ...

We unleashed our new search page over the weekend. To make it work correctly, we had to retroactively keyword all past entries (a endeavor about which I will write more later). but with that done, it seems to be working quite well. The engine returns terms in two groups ...

InfoCentral: About five years ago, I wrote an application for my church to track people and families. I wrote about it here. I open-sourced it, and it got adopted by quite a few organizations. I went to check on it today, and I find that the site is still around, ...

Qcodo - PHP Development Framework: I think you're going to see that phrase a lot in the future: "Rails for [insert language here]." I had heard that Cake was "Rails for PHP," but after watching some demos, I think the QCodo guys have actually obtained that title. It is a ...

Yeah, I'm pissed. Really pissed. When does comment spam become a DDOS attack? There's a fine line, and some a**hole crossed it this morning. I knew there was a problem when I sat down to eat my cereal and read the news this morning and the Windows XP Home login ...

Announcing FogBugz On Demand: Fog Creek moves into the world of hosted software. I’m happy to announce that FogBugz On Demand is now available. This is a professionally-hosted version of FogBugz 5.0, previously only available as a download. In the end, $21 per user per month is not a phenomenal ...

Thoughts on Content Management: This guy and I think alike. In the beginning of the article he touches on the same things I talked about when I compared open and closed content management systems. Then, he runs into the same problem: there are too many types of content, each storing ...

Rob left a comment on a previous entry about the site Pocket PC Thoughts. This site is doing something I've been thinking about for a while: running a blog-type site off of discussion board software. I first investigated the idea in this posting to the Movable Type support forum where ...

Essentials : Mark Pilgrim has listed his "essential" software tools for doing his job. I always like to see these the absolute, "can't live without" tools of people who do the same work as me. As the risk of being self-indulgent, here's mine: Email: Thunderbird or Mozilla Mail via ...

Here's the problem with taxonomies and content categorization schemes: no one will maintain them. You can set up the greatest content tree or grouping structure in the world, but sooner or later, content authors (yourself included) are going to get complacent. That's because the value-add is on the reader's end ...

Movable Type doesn't have a content review system. You can write an entry and leave it in "Draft" status, but no one knows about it unless they go looking for it. In practice, this can be a pain. New authors to Gadgetopia are told to leave their first dozen or ...