database posts

Filed under: Utilities, E-mail, Web services

Backup2Mail: automatically back up your site's database to email

by Jay Hathaway Jul 8th 2009

It's a good idea to back up your website's databases periodically, in case of unforeseen server catastrophes, but it can be hard to remember to do it manually. One automated backup process you might consider is Backup2Mail, which sends backups of your MySQL databases to an email address on a schedule you specify using cron jobs. As long as you can run PHP apps, you're set to go.

A lot of free email accounts - I'm thinking of Gmail, here, specifically - offer enough storage space to keep from filling up too quickly with backups. If you're a privacy-conscious person, you could have Backup2Mail back up to an account on your own server. If you were really ambitious, you could probably set up a simple script or filter for the email account to have it clear out the oldest backups to make room for me.

Tags: backup, database, email, mysql, php

Filed under: Utilities, Windows, Macintosh, Freeware

Home Inventory: track your belongings, have peace of mind

by Todd Ritter Jul 23rd 2008

Home Inventory is a free program for Windows or Mac that lets you create a home inventory complete with product photo and receipt scan. A home inventory is an important protective measure for any home owner, renter, or insurance-policy holder as it can be invaluable in times of disaster to help prove to a claims adjuster that you really did have a 50" wall-mounted plasma TV.

The program is easy to use: create rooms to organize your stuff and then add items to each room. For items, you can add information like purchase price/location, serial number, make, and model. You should also add a picture of the item in your house (not just from the manufacturer website), and a scanned receipt proving you paid for the item.

You can print your entire inventory room by room, export to .csv, or save to the Vault24 service (a secure, offiste backup service offered by the makers of Home Inventory). If, for instance, a fire takes your home (and you've been good and backed up your Home Inventory files offsite), you can make life easy for yourself and the insurance people by providing them a complete, organized inventory of all of your significant belongings.

Tags: database, disaster recovery, DisasterRecovery, insurance, inventory

Filed under: Audio, Utilities, Windows, Shareware

CaTraxx music management application brings your music collection together

by Simon Kerbel Apr 18th 2008

CaTraxx is a music management tool that aims to catalog all of your music, from digital media to CD's, cassettes, and vinyl.

CaTraxx will automatically scan your computer for any supported audio files and import them into its music database. Additionally, you can insert your CD's and CaTraxx will scan and download the audio tracks automatically. The program has a direct connection with the CDDB database; track and album information are instantly downloaded as you import your files.

CaTraxx also functions as a basic jukebox/media player, though iTunes and Windows Media Player would be better options if all you want to do is play your music.

So what good is CaTraxx? In our minds, it's beneficial to think of the program as a database rather than a music collection. So why do you need a database of your music? Well, for example, you might need a database for insurance purposes, in case your beloved vinyl collection is usurped by a thief (or vengeful ex). The database can also keep records of who borrowed pieces from your collection and when they borrowed it, so you never lose track of a CD.

CaTraxx is available as a fully functional trial; after that, it'll set you back $40. In our minds (can we say that twice in a post?), you'd have to be pretty obsessive of your collection to shell out that kind of dough.

[via AppScout]

Tags: caTraxx, database, jukebox, music

Filed under: Audio, Business, Internet, P2P

RIAA website gets hacked by SQL injection

by Todd Ritter Jan 21st 2008

Yesterday a Reddit user posted a link that supposedly runs a time-consuming SQL query on the RIAA'a website. Of course the Reddit community began trying to stick it to the RIAA, and eventually someone may have deleted all of the site's content by exploiting a poorly configured web/database server with an SQL injection attack.

The site appears to be operating fine now, but we noticed it certainly wasn't fine yesterday (and TorrentFreak has screenshots of the site, sans content). Is it ironic that the RIAA uses free open-source software (OSS) such as PHP to run their website while hunting down people who allegedly don't pay for music? You'd expect something more sinister, like Karl Rove hand typing HTML pages in a dimly lit sarcophagus or, at least MS SQL/IIS.

If only they spent more time working to save themselves from cross-site scripting attacks and SQL injection instead of going after college students for downloading "My Humps."

[Via TorrentFreak]

Tags: database, hacked, mysql, php, riaa

Filed under: Utilities, Macintosh, Freeware

Lizenzen: organize your Mac's software licenses

by Todd Ritter Jan 18th 2008

Lizenzen is a free app for Mac OS 10.4+ that lets you easily organize your software license keys. The program has a sidebar showing the titles of all of the apps you add and a main screen showing detailed information like license key, software version, support contact information, date purchased, and the computer to which the license is assigned. You can also export a simple PDF of all of your software licenses (although the PDF has no column headings for some reason).

The Lizenzen .zip also comes with two other programs: a portable version of the software for taking your licenses with you on a USB drive, and grabbICON. grabbICON is included so that you can extract an app's icon to use for your software license entry in Lizenzen.

A word of caution: your license data is stored in an unencrypted text file.

[Via MacUpdate]

Tags: database, license, manager

Filed under: Business, Developer, Internet, Utilities, Open Source

Sun Microsystems purchases MySQL

by Jason Harris Jan 16th 2008

Sun Microsystems has made a huge leap into the open-source market by purchasing MySQL AB, the company behind the wildly popular MySQL database, for $1 Billion in stocks and cash. In a humorously named blog post titled "Helping Dolphins Fly", Sun Microsystems CEO Jonathan Shwartz stated that Sun would not only support MySQL once the transaction is finalized, but they'll be throwing their engineering support behind making MySQL more efficient on Sun's software platform.

MySQL is a widely used database product. It is the database used behind many popular sites -- Facebook, Digg, and Google, among others. Sun has long been a proponent of open source software, up until this point Sun has promoted PostgreSQL as a favored database.

MySQL AB was about to seek an IPO offering. We think Sun got a good deal by giving MySQL AB a cool billion, but just hope the MySQL database continues to innovate and carry on it's reputation as a fantastic database platform.

Perhaps with the influx of $800 Million, MySQL can make the leap from your favorite website into the enterprise where the real money is. Some large corporations wouldn't touch a database product that doesn't have support behind it, but if MySQL has a good system in place -- and a sales team who've marketed inside the enterprise for years -- new customers are more likely to take the bait and ditch Oracle or Microsoft's SQL Server.

Tags: database, mysql, open source, OpenSource, sun

Filed under: Utilities, Macintosh, Commercial

FileMaker announces new organizing application for Leopard

by Christina Warren Nov 13th 2007

FileMaker, Inc. a company best known for the cross-platform database app, FileMaker Pro, has just released a public preview of Bento, their new personal database program for Leopard users -- which to quote the press release -- "[is] as easy to use as your Mac." The program, which is expected to ship early next year, is available as a free, full-functioning time-limited Preview (it expires in February) from FileMaker's site. The shipping version will be $49 for individual licenses and $99 for a family license. Bento is a Leopard-only application.

We got a chance to play around with Bento prior to today's public pre-release, and are really impressed with both the interface (which is very similar to iTunes and the rest of the iLife series) and the actual power of the program. Bento automatically links itself with iCal and Address Book (so a change made in Bento will show up in the corresponding applications, and vice versa), while also taking advantage of some of Leopard's new features, like being able to play a media file without having to open QuickTime or iTunes, from within the database. This is really helpful if trying to organize a multi-media project, because everything is accessible from one place, and the files can be quickly viewed or opened on the spot.

Bento is also very customizable, both in Library types and in overall appearance. FileMaker provides 20 different "themes" that can be applied to a Library or Collection, and they look very, very Mac, which is to say aesthetically pleasing. Our pals over at TUAW have also previewed Bento, and provide some great screenshots of the program itself and some thoughts on the application as a whole.

Tags: bento, database, filemaker, filemaker pro, FilemakerPro, leopard, organization

Filed under: Internet, Office, Web services, web 2.0

Zoho launches an online database app

by Brad Linder Oct 3rd 2007

While Google gets a lot of attention every time it launches a new online Office application, and Microsoft earned a few laughs with its announcement of online storage and collaboration features for MS Office, Zoho continues to out-pace the competition.

Zoho's latest accomplishment is a full-featured online database application. Zoho DB lets you create, edit, and share databases. You can organize your data as if it were a spreadsheet, but run queries like you would with a database. There's supports for queries in pretty much any SQL format.

You can create a variety of charts and reports, and you can even embed your database in a web page. If you really want to see what it Zoho DB can do, check out the promotional video after the jump.

Tags: access, database, spreadsheet, zoho, zoho-db

Filed under: Internet, Web services, Beta, Search, web 2.0

Download Squad's Invite-a-palooza: Day 8

by Lisa Hoover Aug 2nd 2007

Eight days into our Invite-a-palooza, we want to give a shout out to all readers who have taken the time to check out all the neat sites we've featured. We're having a great time giving out invitations, and we're not done yet.

Freebase, a collective knowledge database, is a terrific twist on information Web sites like Wikipedia. The creators of Freebase describe it as an "almanac" that sorts and organizes information so it is easily searched by people and software. Once it's opened to the public, users will be able to structure, contribute, search, and organize data for themselves. Since all the data in Freebase is licensed Creative Commons Attribution, users can also copy data for their own use as long as it's linked back to Freebase.

Though the site it still closed to the public, we have some invitations that will let you get in the door early. If you're among first 100 people to leave us a note in the comment section, we'll send one your way (make sure to activate it if you get an email confirmation). If you don't get in under the wire today, be sure to check back to see who's featured next.

If you know of a site you'd like us to consider for the Invite-a-palooza, drop us a note.

UPDATE: We've given away all 100 invitations for today's featured site but check back tomorrrow to see who's up next!

Tags: creative commons, database, freebase, invite-a-palooza, wikipedia

Filed under: Design, Developer, Internet, Utilities, Web services

Google Gears takes online applications, offline

by Chris Gilmer May 30th 2007

Online applications are great, but what happens when you can't get a connection to the internet? Whether it is because you are on an airplane, or in the middle of nowhere camping, and have to get certain emails, calendar items, or files, you are quite possibly out of luck. Its sure a bummer, and one of the reasons why so many people are hesitant about using online applications for their most important information.

Now Imagine being able to take your online applications, offline, and store that data locally in a completely searchable database? Google is making this possible with Gears. Google Gears is an open source browser extension that enables web applications to provide complete offline functionality. Google hopes that developers will use this new toolset to create offline web applications using JavaScript APIs to store and serve the applications resources locally, as well as store data in searchable databases. All of the syncing runs in the background without burning out the browsers memory usage, or slowing anything down.

The Google Gears Beta is currently available for installation on Windows XP,Vista, as well as on Mac and Linux machines. The plug-in works with Firefox 1.5+ and IE 6+. Google's first stop with Gears is Reader, with JavaScript APIs getting released shortly for data storage for use in applications like Docs and Spreadsheets.

The official Google Gears announcement will be made tomorrow to over 5,000 developers at Google's Developer Day gathering.

Tags: api, applications, data, database, docs, feeds, firefox, gears, google, ie, internet explorer, InternetExplorer, javascript, mac, offline, online, pc, read, reader, search, spreadsheets, storage

Filed under: Developer, Linux, Blogging, Freeware

Want a portal? Just add Geeklog

by Victor Agreda, Jr. Jan 26th 2007

There's no shortage of CMS or "portal" building tools out there. Drupal is one I've come to trust and its feature set is hard to beat. But many require a certain amount of heavy lifting or at least tweaking to get running. Enter Geeklog-- a so-called "portal in a box," or to hear them say it, "The Ultimate Weblog System." I don't know about ultimate, but I will say the installation and configuration process is pretty darn simple. The most cumbersome aspect will be creating a SQL database (wish I had a nickel for every time I've said that). After you've got your database mojo, it's a straight shot to unpack and install and start working.

Geeklog is no slouch in the added functions, as there are apparently a large number of plugins and add-ons. It's not all sunshine and roses, as there are limited templates and the usual quirks and gotchas. Linux.com has an excellent review, and brief guide to getting started. Geeklog might not be everything you've been looking for, but if you want something quick and dirty (and at some point, don't we all?), it might be a good fit. I should mention they're working to improve the tool by using bounties: a small sum paid to developers (courtesy of sponsor AOE media GmbH) for implementing user-requested features. So with any luck, Geeklog will flourish in the coming months.

[thank Dolores for sending this in!]

Tags: apache, blog, cms, database, drupal, geeklog, portal, sql, weblog

Filed under: Business, Developer, Utilities, Windows, Macintosh, Linux, Freeware

Oracle's Free SQL Developer upgrade

by Ryan Carter Jan 20th 2007

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 Control Center because it allowed query browsing and database management, and you'd be hard-pressed to find both features in Administrator which is why I don't like it as much. There are third-party alternatives as well, many of which are not free, which is a sticking point for me? Why, because I am cheap. I currently use (and love) SQLyog community edition (free and full-featured).

Oracle also has a SQL development client, called SQL Developer (oddly enough). They just upgraded it in fact. Now it does easy import and export data in many popular formats. Not retyping all that data, priceless. Oracle's client will manage MySQL, SQL, and Oracle databases, which is rare to find a free tool that handles all three.

I will stick to SQLyog for my database management needs however, since Oracle's java-based solution needs to be configured to work with MySQL's JDBC drivers apparently. Often I don't have the time to install third party drivers, and configure them, that is what a client should be responsible for. Ease of use, and dummy-proofing your app, even more priceless.

Tags: database, MySQL, Oracle, SQL

Filed under: Developer, Internet, Utilities, News, Open Source

MySQL's license is now GPL 2 only

by Ryan Carter Jan 4th 2007

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 with a new license, so they are opting to use the older version exclusively for now. Seems like a good move to stay put but help with the future license progress as well.

[Via Slashdot]

Tags: change, database, GPL, license, Mysql

Filed under: Developer, Utilities, News, Productivity, Open Source

phpMyAdmin 2.9.0.2 is available

by Ryan Carter Oct 6th 2006

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 phpMyAdmin. 2.9.0.2 is a setup script distribution that addresses issue in 2.9.0.1, so nothing majorly new here, but you can download it, so we are all over it. Security fixes and bug fixes are good things.

Tags: admin, database, management, my, MySQL, php, phpmyadmin

Filed under: Developer, Windows, Open Source

SQLyog: Open source MySQL manager for Windows

by Jordan Running Sep 5th 2006

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 OSS--Enterprise will still cost you--but it does tout a solid feature set, including a favorites manager, a tabbed query/result set editor, SQL templates, export to CSV/XML/HTML, user management, and more. With the recent death of MySQL-Front, SQLyog is a very welcome addition to the open source family.

Tags: database, db, dbms, frontend, mysql, mysqlfront, opensource, sql, sqlyog, windows

The World's Hardest Game 2.0 - Time Waster

So, just how good at time waster games are you? Think you've got the stuff? Well, The World's Hardest Game 2.0 doesn't think you do. Yes, amazingly, it's possible to have a sequel to a game called "The World's Hardest Game". It doesn't seem logically possible, since if the first one was actually the world's hardest, how could another one come along and share the moniker? It made me doubt the name in the first place. That is, until I tried the game. The mechanics of the game are very simple. You are a small red square, ...

View more Time Wasters

Featured Galleries

Defective by Design, London: Protest Pictures

Download Squad at the Crunchies After-Party

Android First-look: Amazon.com MP3 Store

Flickr Pool

www.flickr.com

Download Squad bloggers (30 days)

#	Blogger	Posts	Cmts
1	Jay Hathaway	110	5
2	Lee Mathews	82	24
3	Sebastian Anthony	69	249
4	Brad Linder	39	4
5	Jason Clarke	23	0
6	Dolores Parker	8	2
7	Grant Robertson	6	2
8	Victor Agreda, Jr.	5	1
9	Nik Fletcher	4	0
10	Matt Heerema	4	2
11	Paul O'Brien	2	0
12	John Burke	2	0
13	Download Squad Staff	1	0

More Tech Coverage

Control Shift It's all about the experience
Somewhat Frank Perspectives on tech as it fuses in everyday life
Switched Gadgets, web news and commentary
Urlesque Exposing bits of the web

Download Squad