Last week's news that IBM is releasing a free version of its DB2 database software might be good news for system administrators seeking a low-cost (as in, no-cost) back-end server platform. But could the latest commercial database platform to go freebie be a bad omen for open source databases such as MySQL and PostgreSQL?
EnterpriseDB has released a new distribution of the PostgreSQL open source database, hoping to expand the use of the software and compete better with MySQL AB.
If the thought of diving into yet another hot new technology gives you a headache, I sympathize. I've stuck mainly to PHP and Perl for years, happily ignoring most other development fads.
The combination of Apache, PHP, MySQL, phpMyAdmin and Zend Optimizer (see editorial links for each) is a pretty powerful setup under Linux (hence the references to LAMP - Linux + Apache + MySQL + PHP/Perl/Python). That is given the maturity of each component and the huge amount of software (particularly open source) that relies on this configuration.
Analysts say that in the move to cut costs and drive efficiencies, enterprise users are starting to get more serious about open source products such as Jboss; and databases such as MySQL and PostgreSQL, the Apache Web server, the Samba file and print server, and OpenOffice desktop software.
I believe in open source and I believe that the results of open source projects are generally on par and often significantly better than those of commercial software. Why else would Linux and Apache be capturing server market share at such a rate? Why else would Java, Perl and Python be such remarkable forces in programming? Why else would tens of thousands of developers and hundreds of companies have selected the open source world as their chosen way to build business?
Next up in our series looking at open-source business applications is SQL-Ledger. This software package, written in the Perl scripting language, is a double-entry accounting system aimed at small and midsize organizations.
The PostgreSQL developers released updates for all major branches of the popular open-source database system on Thursday in order to address several vulnerabilities, including a high-risk one that could allow attackers to crash the server, modify configuration variables as superuser or execute arbitrary code if certain conditions are met.
CSV (comma-separated values) files represent a common standard for transmitting data between applications. Like the more generic "flat files", each line in a CSV file represents a record. Exporting or importing data from and to applications such as Excel in CSV format is standard practice for a lot of applications. Hand a CSV file to a tool such as awk, however, and you may run into some problems. Let's look at the problems and at a handy Perl module that takes the stress out of working with CSV files on U
If you get a secret thrill out of a well crafted Perl one-liner, but only have a few that you can pull out of your mental pocket and use, this book may be just what Santa should be leaving under your tree!
Amazon Relational Database Service on VMware automates database provisioning for customers running VMware vSphere 6.5 or later, and it supports Microsoft SQL Server, PostgreSQL, and MySQL.
Новый Год уже совсем на носу, а значит нужен свежий производственный календарь в базе данных PostgreSQL. Но как совершенно обленившийся IT-шник, заводить его руками не хочется. Хочется, чтобы вызовом...
В этой статье я хочу поделиться некоторыми наработками, которые мы используем в своих проектах, в частности, тем, как отправлять и обрабатывать HTTP-запросы непосредственно из/в PostgreSQL. Сразу...
На просторах интернета не нашел единого рецепта по установке и настройке такого, довольно нестандартного сервера. Решил написать свой рецепт. Принцип работы следующий: Статические данные (файлы)...
Расширение pg_variables Часто при разрабоке прикладного ПО можно столкнуться с проблемой такого рода — для промежуточных данных требуется получить несколько результирующих наборов, например, для...