Learn about Linux
Download Linux
Get Linux helpSpecial Offers
NewsVac: News from around the Web
-
Embedded Linux SQL database adds Java, C# bindings
1 week, 1 day 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
1 week, 4 days 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
3 weeks 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
3 weeks, 3 days 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. -
Choosing the right database
3 weeks, 3 days ago
SourceForge’s discussion forums are a terrific way to connect with community members, get feedback, and help others with questions they have on a variety of topics. Someone recently asked some great questions about databases — let’s break it down a bit and also get thoughts on what you’d recommend. -
Navicat MySQL GUI for Linux version 8.0.24 is released.
1 month, 2 weeks ago
By Premiumsoft. Navicat MySQL GUI Manager is a powerful yet easy to use MySQL client provides extensive functionality for managing and developing MySQL. It features an intuitive interface and provides a set of useful tool to import/ export, backup/ restore data, Synchronize database and connect to remote MySQL server, etc. -
Sun Announces MySQL Bundle
1 month, 3 weeks ago
Ahead of the completion of its MySQL acquisition, the vendor releases a bundle with the database. -
Did anybody notice Microsoft’s SQL Server Data Services Announcement?
2 months ago
About a week ago Microsoft announced something they are calling SSDS. According to their web site “SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing web services. Businesses use storage resources as needed transforming large upfront capital and operations expenditures into much smaller on-demand costs.” In other words - cloud computing. -
TechBookReport on 'Oracle Essentials'
3 months ago
Oracle may or may not be the best RDBMS in the world, but it's certainly not the simplest. For the first time user, the Oracle landscape is a scary place to be. There are so many layers, tools, terminologies and technologies crowding the Oracle eco-system that it's all too easy to get that dazed and confused feeling. Add to that the moving targets created by each of the main releases (10g, 11g etc) and you'd be forgiven for seeking out some kind of guide book. Which is what Oracle Essentials pretty much sets out to be. -
The seven largest Open Source deals ever
3 months, 1 week ago
To say that there were some noise on the Web when Sun recently bought MySQL for $1 billion would be an understatement, to say the least. It’s the largest open source deal ever, and the latest in a series of large open source acquisitions. -
Why MySQL sold out
3 months, 1 week ago
It’s good to see MySQL’s CEO, Marten Mickos, explaining his reasons for abandoning the company’s IPO in favor of being acquired by Sun. What made him and the open source database company’s top brass change their minds (apart from $1bn)? Mickos lists ten factors that convinced him that Sun was the better option: -
Secrets of the MySQL Client Command Line
3 months, 1 week ago
Graphically oriented MySQL administration tools abound, but for true speed and no-frills management perhaps nothing is more effective than the command-line driven MySQL client. However, the inordinate amount of typing due to executing common queries, determining what database you're currently logged into, and monitoring database server performance quickly can become tedious. In this article, I'll unveil a few of MySQL's command-line hidden features that can eliminate those extra keystrokes and along the way make you a much more efficient user of this powerful client. -
PostgreSQL 8.3 Gets HOT
3 months, 1 week ago
Speed is important in all aspects of computing, especially with databases. -
Sun, MySQL users ponder blockbuster acquisition
3 months, 1 week ago
In Sun's purchase of MySQL, the goal to grab a piece of the database pie is clear. But what does the acquisition mean for existing users running on Linux and non-Sun hardware? -
PostgreSQL 8.3 designed for better speed
3 months, 1 week ago
Programmers behind the PostgreSQL project released the new version 8.3 of the open-source database software Monday, saying they've boosted improved performance 5 percent to 30 percent and added several useful features. - More News
Linux.com : Databases
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.
