Feature

Databases

Browse in :

All > Topics > Databases

Options :: View Archives

Note: when you create a new publication type, the articles module will automatically use the templates user-display-[publicationtype].xd and user-summary-[publicationtype].xd. If those templates do not exist when you try to preview or display a new article, you'll get this warning :-) Please place your own templates in themes/yourtheme/modules/articles The templates will get the extension .xt there.

A graphical way to MySQL mastery

Lee Schlesinger

November 21, 2008 9:00:00 AM

MySQL GUI Tools is a suite of graphical desktop applications for working with and administering MySQL servers. The suite consists of three tools: MySQL Query Browser, MySQL Administrator, and MySQL Migration Assistant (available only on Windows). We'll look at the first two to see how well they let us manage MySQL without using the command line.

Gollem: A Web-based file manager for back-end data

Lee Schlesinger

November 07, 2008 4:00:00 PM

There are many ways to share files with teams of people, but few require only a Web browser for access and let you choose from tens of different ways of authenticating user access to the files. Such lightweight and universal access is the promise of Gollem, a file manager that runs in your Web browser. With it you can connect to and manage your files on a WebDAV, FTP, or traditional filesystem or SQL database.

Protecting your MySQL database from SQL injection attacks with GreenSQL

Lee Schlesinger

August 25, 2008 4:00:00 PM

SQL injection attacks can allow hackers to execute arbitrary SQL commands on your database through your Web site. To avoid these attacks, every piece of data supplied by a user on a Web form, through HTTP Post or CGI parameters, or other means, must be validated to not contain information that is not expected. GreenSQL is a firewall for SQL -- it sits between your Web site and MySQL database and decides which SQL statements should and should not be executed. At least that's the idea -- in execution, I found some open doors.

Getting Mono and MySQL to play together politely

roblimo

August 21, 2008 4:00:00 PM

When I first used Mono, shortly after its first appearance in 2004, one of my most important requirements was to get connected to a MySQL back end. This was quickly achieved at the time with the ByteFX data connector. Following the basic Mono tutorial quickly had me up and running, with access to MySQL databases. Last week I needed to reopen and modernize my application and found that there have been several important changes in Mono between 2004 and 2008. First, I found some "then and now" differences with the installation of the data connector. Second, I needed to make some modifications to my programming.

phpMinAdmin is a powerful minimalist MySQL editor

Lee Schlesinger

August 21, 2008 9:00:00 AM

If you've ever worked with and manipulated MySQL databases, chances are you've used phpMyAdmin to manage your databases from a Web interface. But phpMyAdmin can be a little complex; if you want a lightweight alternative, try phpMinAdmin. It's easier to install than its more robust cousin and has an easy-to-navigate graphical user interface for most important MySQL functions.

Quickly put data from MySQL to the Web with DrasticGrid

Lee Schlesinger

August 15, 2008 9:00:00 AM

With DrasticGrid, you can easily put a MySQL database table or view on a Web page, complete with editing, sorting, and pagination capabilities, and support for adding and deleting records.

Xataface lets non-technical users edit MySQL data

Lee Schlesinger

July 28, 2008 4:00:00 PM

Xataface is a framework for the LAMP stack designed to allow non-technical users to edit the contents of MySQL databases through a Web interface. While phpMyAdmin is a great tool for database administrators and those who are familiar with SQL and database design, Xataface aims at allowing less technical people to modify the database.

Explore your database with Talend Open Profiler

Lee Schlesinger

July 18, 2008 7:00:00 PM

Over time, organizations replicate, migrate, or add complexity within database systems, often times losing control of the quality of their data. When applications begin to fail because of invalid, corrupted, or out-of-date data, the free, GPL-licensed Talend Open Profiler can give data analysts, database administrators (DBA), and business users the ability to research data structures and improve data quality. Through the use of Open Profiler, users can be alerted to hidden inconsistencies and incompatibilities between data sources and target applications. Through data analysis, business users and technical analysts can communicate both data structure and content needs.

Synchronize your databases with SqlSync

Lee Schlesinger

May 08, 2008 4:00:00 PM

SqlSync lets you compare two databases to see which tuples have been added, removed, and changed. You can also use SqlSync to make one database a clone of another and maintain its contents to be that way. One benefit of using SqlSync to perform synchronization is that you can perform heterogeneous syncs -- for example, from MySQL to PostgreSQL.

Meet Monica Kumar, Oracle's senior Linux and open source marketing director (video)

roblimo

April 25, 2008 9:00:00 PM

Oracle may be making a little less noise recently about Unbreakable Linux, but it's going strong -- and Monica Kumar is in charge of marketing for it. She's a consistent (and engaging) IT trade show speaker, but since only a tiny percentage of the world's population (or even of Linux.com readers) will ever have a chance to meet her in person, the next best thing is to "meet her" in this video interview.

Manage MySQL remotely with phpMyAdmin

Lee Schlesinger

March 25, 2008 8:00:00 AM

Odds are, if you design Web sites with a database back end, you've worked with MySQL. You can manage this database from the command line, but it's not very user-friendly. Using the graphical tool phpMyAdmin helps, but not all Web hosting providers offer it or allow you to install it on the server. Fortunately, you can install it on your own box and manage several MySQL databases remotely at the same time, without having to install anything anywhere else.

phpMyBackupPro: No simpler backup for MySQL

Lee Schlesinger

March 05, 2008 4:00:00 PM

Backing up data stored in a MySQL database is an important issue for anyone running a blog, wiki, or any Web-based application that relies on the popular database engine. Many MySQL management solutions allow you to export database data as an SQL query, but if you are looking for a dedicated MySQL backup tool, phpMyBackupPro (pMBP) is your best bet.

Using MySQL as a filesystem

Lee Schlesinger

February 15, 2008 4:00:00 PM

With MySQLfs you can store a filesystem inside a MySQL relational database. MySQLfs breaks up the byte content of files that you store in its filesystem into tuples in the database, which allows you to store large files in the filesystem without requiring the database to support extremely large BLOB fields. With MySQLfs you can throw a filesystem into a MySQL database and take advantage of whatever database backup, clustering, and replication setup you have to protect your MySQLfs filesystem.

Create an AJAX Web site using dhtmlxGrid to present data

Lee Schlesinger

January 28, 2008 7:00:00 PM

dhtmlxGrid is a JavaScript grid control that you can use to create an AJAX interface to a relational database server. The grid view provided by dhtmlxGrid offers actions that one would expect from a desktop grid control, such as sorting by columns by clicking on them, resizing columns, rich cell rendering, keyboard navigation, themes, and drag and drop.

Create an AJAX Web site using dhtmlxGrid to present data

Lee Schlesinger

January 28, 2008 7:00:00 PM

Video interviews with Sun's James Gosling and MySQL's Monty Widenius, David Axmark, and Brian Aker on Sun's MySQL acquisition

roblimo

January 17, 2008 1:05:18 AM

ORLANDO, FLORIDA -- This morning Sun Microsystems announced that it was purchasing MySQL AB for $1 billion, $800 million of which is supposed to be paid in cash. This is a huge deal in the open source community. Two minutes after I heard the news, I begged an invitation to the "no press" MySQL company meeting at which the announcement had been made, drove two hours to Orlando, and sat down for lunch with Sun vice president (and Java creator) James Gosling and MySQL AB cofounder David Axmark. After lunch I corraled MySQL CTO (and original MySQL creator) Michael "Monty" Widenius and MySQL chief database architect Brian Aker, and got their opinions about how the acquisition might work out and what it means for both companies.

Sun buys MySQL for $1 billion

Joe Barr

January 16, 2008 1:39:46 PM

According to a post on the MySQL blog site last night, by MySQL's Vice President for Community Kaj Arno, Sun Microsystems plans to purchase MySQL AB, the commercial firm selling enterprise database products built atop the ubiquitous open source database which represents the M in the LAMP open source software stack.

Creating simple charts with Gambas 2.0

Lee Schlesinger

December 12, 2007 4:00:00 PM

About three years ago we had a look at how Gambas speeds database development. Now that Gambas 2.0 is being prepared for release, it's time to see what the new version can do now. One cool feature is its ability to create a chart.

PhpPgAdmin: The Web developer's client tool for Postgres

Lee Schlesinger

November 16, 2007 9:00:00 AM

There are three well-known open source clients for managing PostgreSQL databases: psql, pgAdmin, and phpPgAdmin. If you use Postgres in a collaborative team, however, you should get to know phpPgAdmin, which is expressly designed for such environments. It lets users and administrators create user accounts, databases, tables, sequences, functions, and triggers.

Back up and print your blog with OpenOffice.org Base

Lee Schlesinger

November 01, 2007 8:00:00 AM

If you are running a blog (or any Web publishing system, for that matter) that relies on a database back end, you will sooner or later face the problem of backing up the content stored in the database. One way to go about it is to build a backup tool using OpenOffice.org Base. Since Base can pull data from a MySQL or any ODBC-compliant data source, you can create a simple database that connects to the blog's back end and extracts content from it, which you can then export in different formats.

Sort by Date Title Hits