Drizzle is a Free Software/Open Source database management system (DBMS) that was forked from version 6.0 of the MySQL DBMS. Like MySQL, Drizzle has a client/server architecture and uses SQL as its primary command language. Drizzle is distributed under version 2 of the GNU General Public License.
Drizzle is written in the C++ programming language, and [...]
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 9.04 server with PHP5 support (mod_php) and MySQL support.
I do not issue any guarantee that this will work for you!
1 Preliminary Note
In this tutorial I use the hostname server1.example.com with the IP address [...]
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.
It’s key to remember that MySQLTuner is a script which can assist you with your [...]
Setting up a LAMP server is a common task for systems administrators, and FreeBSD is one of the most reliable and stable operating systems available. Why not combine both LAMP and FreeBSD to build a fast and reliable Web server?
Read more at Linux.com
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 [...]
Databases are the key repository for critical data. If you are storing information that needs to be kept secure from prying eyes, especially credit card or personally identifiable information (PII) you might be required to control access using two-factor authentication. This tutorial demonstrates how to secure Postgresql with two-factor authentication from WiKID.
Read more [...]
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 by Djoni Darmawikarta shows some of them by way of an example. We’ll build a physical data model [...]
MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries.
Read more at Ubuntu Geek
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, [...]
Getting data into and out of an OpenOffice.org Base database
The ability to import and export data is crucial to any database management system, and OpenOffice.org Base is no exception. While you may be surprised to discover that OpenOffice.org lacks a dedicated import/export feature, it does allow you to get data into and out of a database in a variety of ways.
Let’s start with the [...]
Zmanda Recovery Manager (ZRM) for MySQL
simplifies life of a database administrator who needs an easy to use
yet flexible and robust backup and recovery solution for MySQL server.
Read more at HowtoForge
PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), [...]
Is there anyone who
doesn’t collect something? I, for instance, have a sizable collection
of books. Remembering who gave me which ones, and keeping track of ones
I’ve currently lent to friends, is a nightmarish chore. Happily, the Tellico
collection manager can catalog all sorts of collections, including
books, movies, games, cards, coins, comic books, and even wine.
With AptOnCd you can backup and restore your .deb packages and store them in a CD or DVD or just in an ISO image in your USB Drive.
aptoncd, will help you still be able to use apt, aptitude or synaptic even, with no, or poor Internet conection.
Connecting OpenOffice.org to MySQL has been well-documented for some
time. For those who use PostgreSQL, however, finding good documentation
on using OpenOffice.org with it has been like finding a needle in a
haystack. Fortunately, it’s much easier now.