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
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
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, [...]
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.
Welcome to an introduction for the beginner to the basic
manipulation of the MySQL database with free software. The purpose of
this article is to show how universally straightforward it is to get
started with installing and applying a high-grade enterprise ready
database like MySQL, and to learn how to manipulate it via numerous
free software approaches.
Since version 5, MySQL comes with built-in support for master-master
replication, solving the problem that can happen with self-generated
keys. In former MySQL versions, the problem with master-master
replication was that conflicts arose immediately if node A and node B
both inserted an auto-incrementing key on the same table. The
advantages of master-master replication over the traditional
master-slave replication are that you don’t have to modify your
applications to make write accesses only to the master, and that it is
OpenOffice.org Base is
undoubtedly a powerful database application, but when it comes to its
built-in reporting engine, words like "underpowered" and "outdated"
come to mind. Fortunately, you don’t have to put up with this situation
any longer: with the Sun Report Builder (SRB) extension, you can add nifty reporting features based on Pentaho reporting engine — assuming you can figure out how to use it without any help.