Learn about Linux
Download Linux
Get Linux helpSpecial Offers
NewsVac: News from around the Web
-
Creating a View with MySQL Query Browser
2 weeks, 1 day 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 month 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. -
Sun loses PostgreSQL lead
1 month ago
Sun has been supporting the PostgreSQL database since at least November of 2005. A few months later they hired Josh Berkus, PostgreSQL core team member, as PostgreSQL Lead for Sun's Database Technology Group. Since then a lot has happened at Sun -- notably it bought rival open source database MySQL for $1 billion. So now six months after the MySQL acquisition and two years after joining Sun, Berkus is leaving. -
What's Drizzle?
1 month ago
Today Brian Aker announced a fork of MySQL, called Drizzle. Drizzle is a slimmed-down MySQL, in a lot of ways what MySQL should have been before MySQL AB became more concerned about their deal with SAP than its core user base. -
OSCON : Open source database study has obvious results
1 month ago
The biggest conclusion of the EnterpriseDB open source database study is that PostgreSQL is the open source database of choice for transactional applications. Not a surprising conclusion given that EnterpriseDB is a sponsor of the PostgreSQL project and has its own supported distributions of it. While the open source database that often comes to mind for many is MySQL, the EnterpriseDB open source database press release surprisingly makes no mention of them. -
Microsoft tools address SQL injection attacks
2 months ago
On Tuesday, Microsoft issued new tools to assist Microsoft ASP and ASP.NET technologies against recent Web-based attacks. -
IBM says it has 'no plans' to open-source DB2 database
2 months, 1 week ago
IBM said today that it doesn't plan to open-source its DB2 database, despite a published report quoting a company executive in the U.K. saying that an open-source move might become necessary. -
Visual MySQL Database Design in MySQL Workbench
2 months, 2 weeks ago
MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database.MySQL Workbench has many functions and features; this article shows some of them by way of an example. We’ll build a physical data model for an order system where an order can be a sale order or a purchase order, and then, forward-engineer our model into an MySQL database.
-
MySQL Gives .NET High Five
2 months, 3 weeks ago
There was a lot of head scratching at this year's MySQL Conference and Expo when Microsoft was singled out for its contributions to open source development. "Seriously?" one attendee was overheard asking during the keynote address of Marten Mickos, who was CEO of MySQL AB until Sun Microsystems Inc. acquired the open source database developer for $1 billion in March. Mickos, who's now senior VP in Sun's new database group, pointed to Redmond's work with MySQL in naming Microsoft one of three companies to receive its Partner of the Year awards. -
DreamCoder for MySQL Free Edition ver 4.4 released
3 months ago
Mentat Technologies announces the launching of the DreamCoder for MySQL version 4.4. This version includes a new enhanceds in the SQL and stored procedure editor, which has several new characteristics that facilitate and reduce development time. This new version include schedule events and more than 30 improvements and bug fixed. -
NetBeans and MySQL - Tutorial
3 months, 1 week ago
A two-part tutorial on using NetBeans as a developer tool for interfacing and programming MySQL databases. -
Embedded Linux SQL database adds Java, C# bindings
3 months, 3 weeks ago
ITTIA has released a new version of its lightweight SQL R-DBMS (relational database management system) for embedded systems and mobile devices. Version 2.5 of the Linux-compatible DB-SQL R-DBMS adds language bindings for Java and C#, as well as VxWorks support, says ITTIA. -
Partnership to market embedded SQL database
3 months, 3 weeks ago
A Japanese embedded Linux development firm will market a Swedish embedded SQL database for the Japanese market. The partnership between Lineo and Mimer Information Technology includes plans for Lineo to distribute Linux versions of Mimer's SQL Embedded database. -
Building Queries Visually in MySQL Query Browser
4 months ago
MySQL Query Browser, one of the open source MySQL GUI tools from MySQL AB, is used for building MySQL database queries visually. In MySQL Query Browser, you build database queries using just your mouse—click, drag and drop! MySQL Query Browser has plenty of visual query building functions and features. This article shows two examples, building Join and Master-detail queries. These examples will demonstrate some of these functions and features. -
Back to the future for MySQL
4 months, 1 week ago
As I'm occasionally reminded, MySQL didn't start out as open source. In fact, MySQL's original license was very similar to what it is trying to achieve today: Free for noncommercial use, but not-so-free for commercial use. It didn't decide to go open source (GPL) until 1999. - More News
Linux.com : Databases
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.
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.
Searching database content with Sphinx
If you use Google or any other search engine, you already are a user of full text searching: the capability to search for a word or group of words within many texts for the best matches for your query. Sphinx is a full text search engine for database content, which you can integrate with other applications. (You can test it or use it with a command-line tool, but Sphinx is most useful as part of a Web site, not as a standalone utility.)
MySQL ends distribution of Enterprise source tarballs
MySQL quietly let slip that it would no longer be distributing the MySQL Enterprise Server source as a tarball, not quite a year after the company announced a split between its paid and free versions. While the Enterprise Server code is still under the GNU General Public License (GPL), MySQL is making it harder for non-customers to access the source code.
