Learn about Linux
Download Linux
Get Linux helpSpecial Offers
NewsVac: News from around the Web
-
Administering MySQL Databases on the Web Using PHP
11 months, 2 weeks ago
Inserting new items into the database is remarkably similar to getting items out of the database. You follow the same basic steps: make a connection, send a query, and check the results. In this case, the query you send is an INSERT rather than a SELECT. -
MySQL 5.1 released with crashing bugs
11 months, 3 weeks ago
Wow. Talk about your disgruntled employees. Michael 'Monty' Widenius, MySQL's founder and, for the moment, still Sun's CTO for its MySQL division, greeted the GA (general availability) of the latest version of the popular open-source database system MySQL 5.1 by writing, "I am asking you to be very cautious about MySQL 5.1 is that there are still many known and unknown fatal bugs in the new features that are still not addressed." -
MySQL 5.1 goes GA, Monty not happy
11 months, 3 weeks ago
MySQL 5.1 is now out, but not everyone is happy about this oft-delayed open source database release. I've been hearing about MySQL 5.1 since at least 2006 and over the last two years there have been a few dates I've been told when it would be released. "One would have thought that MySQL AB (now the MySQL department at Sun) should have learned something from our too early release of MySQL 5.0 but unfortunately this is not the case," Widenius stated. -
Check Your Mysql Server Performance with MySQLTuner
11 months, 3 weeks ago
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. -
Check Your Mysql Server Performance with MySQLTuner
12 months ago
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. -
Check Your Mysql Server Performance with MySQLTuner
1 year ago
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. -
Python Data Persistence using MySQL
1 year ago
Among other merits, Python is an ideal language for writing server-side scripts, allowing you to integrate interactive behavior with HTML. Persisting dynamic content to an underlying database is fairly straightforward. By installing an appropriate Python DB module, you get the ability to interact with the database of choice from within Python code, moving your application data in and out of the underlying persistent store.This article will walk you through the process of building a simple Python application that interacts with a MySQL database. In a nutshell, the application picks up some live data from a web site and then persists it to an underlying MySQL database.
-
State of Storage Engine for MySQL and Drizzle
1 year, 1 month ago
Brian Aker blogs about the state of storage engines for the MySQL and Drizzle projects. Brian Aker, the Directory of Archive for MySQL, has a written up a status on the available storage engines for the MySQL and Drizzle projects. He goes through the major contenders and the upsides and downsides of what is available. -
Comparing Cursor and Set Approaches in Processing Relational Data
1 year, 2 months ago
MySQL introduced cursor in its release 5. You create a cursor to define a set of rows from one or more table that you want to access row-by-row sequentially. If your need is really to access the rows one at a time then use cursor. But a lot of data processing is actually set processing, and set processing is what relational database is best for.This article compares cursor approach and set approach using various examples.
-
Preventing SQL Injection Attacks on your Joomla Websites
1 year, 2 months ago
Joomla!, a very popular content management system (CMS) is as you may know an easy-to-deploy-and-use content management system. This ease of use has lent itself to rapid growth of both the CMS and extensions for it. You can install it on almost any host, running Linux or Windows. This highly versatile software has found itself in such lofty places as large corporate web portals, and humble places such as the simple blog. -
New Holdup in SAP-Oracle Lawsuit
1 year, 2 months ago
After months of sparring, the squabbling takes a backseat to legal maneuvers. -
PostgreSQL's Transaction Model
1 year, 2 months ago
A database must always be ACID (Atomicity, Consistency, Isolation, and Durability) compliant. Databases comply with ACID requirements through the concept of transactions. In this article by Jonathan Gardner, we will see the differences in the transaction model of PostgreSQL and Oracle. We will look into the details of how PostgreSQL handles transactions and how it can be advantageous over Oracle's Transaction Model. -
Has the head of MySQL left Sun?
1 year, 2 months ago
It's not easy going from being number one of a small company, MySQL, even one worth a cool billion, to being one of many number twos in an even bigger company, Sun. Many former CEOs in that position quickly quit and it sounds like Monty Widenius, founder of MySQL, will be the next to leave his company's new owner. -
Creating a View with MySQL Query Browser
1 year, 3 months ago
When you’re creating a query for non-technical users and you don’t want them to see the complexity of the query, you can create a view from the query. Your users can then use the view as a table; for example, they can double-click the view, which will effectively execute its complex query behind the scene. In MySQL Query Browser, you have two ways to create a view, which I will demonstrate in this article: From an existing query and writing from scratch, manually. -
Web 2.0 fuels open source database boom
1 year, 4 months ago
The market for open source databases is booming due to new workloads such as RFID projects, rich Web applications and small portals, despite the unwillingness of enterprises to replace their Oracle, DB2 or SQL Server systems with open source, according to new figures from Forrester Research. - More News
Linux.com : Databases
A graphical way to MySQL mastery
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
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
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
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
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
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
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
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
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)
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
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
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
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
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
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.
Video interviews with Sun's James Gosling and MySQL's Monty Widenius, David Axmark, and Brian Aker on Sun's MySQL acquisition
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
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
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
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
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.
