PostgreSQL packs record punch
190946
Speedy release The latest release of open source database PostgreSQL hit Monday, packing a claimed record number of new and improved features. That means 280 patches.â¦
114793
On his blog today, Lorenzo Alberton Talks about DBMS and the character sets they support and issues a call for help for anyone interested to help them (on the PEAR::MDB2 project) set up proper character set support for each database.    We're working on PEAR::MDB2 charset and collation support. That means that we're in the process of figuring out what's the best way to set the charset in each DBMS, and how to make it portable and consistent through all of them.   I'll try to explain how the various DBMS implement charset settings first, then describe the MDB2 status-quo regarding charset support. Finally, we'd like to get some feedback to implement a better charset support in MDB2.    He lists out the types of character sets - client, connection, database/table/field, and result - explaining each of their roles in the average connection. He then breaks out the different databases into the different settings they support for the different character set types.   The call for help comes in with him asking anyone out there with experience and skill in these areas to get in touch and help out if they can. Contact information is in the post. You can also check out some of Lukas Smith's comments over on his blog too.
704750
Realistic, or just a stick to beat vendors? Traditionally, enterprise data warehouses (EDWs) were regarded as systems of record. Thought of simplistically, queries were either run directly off the EDW or from a data mart that referred back to the EDW as and when necessary (hence its status as a system of record).â¦
268213
IBM&#39;s new top-end Power5-based Unix server has a commanding lead in a performance test of servers running a large database. A $16.7 million configuration of the company&#39;s eServer p5-595 performed 3.21 million
456868
New top-end Power5-based Unix server has commanding lead in performance test of servers running a large database.
200433
An enhanced multi-threaded syslogd, supporting reliable syslog over TCP and RFC 3195, writing to MySQL databases, fully configurable output formats (with great timestamps), ability to filter on anything, and on-the-wire message compression.   Hi all,  Rsyslog 3.11.2 has just been released. Now it has the ability to convert text files into syslog. This is done by the imfile plugin, which monitors text files. A new libdbi-based output plugin has been written. This adds six additional databases (including Firebird and Oracle) to the supported database set. Also contains small bug fixes. Version 3.11.2 is a recommended release for all version 3 users.  Doc for new Modules:    http://www.rsyslog.com/doc-omlibdbi.html    http://www.rsyslog.com/doc-imfile.html  Changelog:    http://www.rsyslog.com/Article175.phtml  Download:    http://www.rsyslog.com/Downloads-req-getit-lid-79.phtml  I hope this release is useful. As always, feedback is appreciated.  Best regards, Rainer Gerhards
586205
In a new blog entry from Sebastian Bergmann, he looks at some of the issues and bugs that have been submitted to him about the phpOpenTracker project. He takes on one in particular - the database schema.   The biggest problem with phpOpenTracker 1.x is that its database schema is normalized. Even simple phpOpenTracker API calls result in (possibly multiple) SQL queries that involve multiple tables. [...] While the denormalization should eliminate the JOIN-related performance problems, temporal partitioning of the data can further increase the performance.   He talks about what kind of support MySQL currently has for it (5.1) and how, unfortunately, it might not work for his situation (the maximum number of partitions).
497147
Yesterday the The Inquirer linked  to me talking about the performance of hsqldb .  "One noteworthy addition to this upcoming 2.0 OO.o release is the HSQL Embedded database engine a fast Java-based embedded database engine that once surprised everyone by beating IBM's Cloudscape (now also open sourced) and even C++ databases. Also included is a user friendly database application dubbed "OpenOffice Base" which allows you to effortlessly create both databases, queries and reports using helpful "wizards". Current 1.x versions of OpenOffice lack an embedded database and only the commercial StarOffice product includes one in the form of the bundled "Adabas D" licensed from Software AG, but even t ...
9867
PC Magazine - The open-source embeddable database now boasts multi-version concurrency control, no-downtime upgrades and a pre-built replication framework to simplify development of highly available applications.
257428
It couldn't happen to a better set of people. As 'BusinessWeek' reports, MySQL is well on its way to an IPO. The interesting thing is what it's doing to get there. From CNET's Blogs network.
560877
Adam Bosworth complains  about the current lack of quality and scalable databases in our industry.  "About five years ago I started to notice an odd thing. The products that the database vendors were building had less and less to do with what the customers wanted."  "It is this. Users of databases tend to ask for three very simple things:"  "1) Dynamic schema so that as the business model/description of goods or    services changes and evolves, this evolution can be handled seamlessly in a    system running 24 by 7, 365 days a year ..."  "2) Dynamic partitioning of data across large dynamic numbers of machines. A    lot people people track a lot of data these days. ..."  "3) Modern indexing. ...
765546
On the Zend Developer Zone, there's a new tutorial looking at one of the unsung heroes of the web development world - one that, when you need it, it does what it does well - SQLite.   Is a full-blown database server even necessary for most PHP applications? What about a data-driven website like a blog or a simple family photo album or message board? In these and may other cases, the small, simple, and extremely powerful SQLite may be all you need. Let's take SQLite out for a test drive and see how it performs, find some of the quirks you might run in to, and how to get the most use out of it.   They talk about SQLite being a "staple" in PHP for a while now and how PDO plays so well with it. They move on to the code quickly, giving a simple example of how to create a database, and table, and inserting content into the latter.    Other more advanced features are discussed - data types, speed of queries, using transactions, and cleaning up the code to really make it fly. They even talk about "user defined aggregate functions", a method to make running a set of data through the same processes over and over a snap.
155136
IBM&#39;S Blue Gene supercomputer, which is still being installed at Lawrence Livermore National Laboratory, has set an unofficial performance record.
575210
Popular posts from PHPDeveloper.org for the past week:PHP-Coding-Practices.com: How I Turned A Slow Array Sort Into A Quick One Using Quicksort AlgorithmZend Developer Zone: PHP Abstract Podcast Episode 4: Planning ProgrammingWeb Development Blog: Save bandwidth with PHProxy and ip2nationJob Posting: Assembleron Ltd Seeks PHP 5/MySQL/Ajax Developers (Reading, UK)PÃ¡draic Brady's Blog: Complex Views with the Zend Framework - Part 6: Setting The TerminologyThe Bakery: Four New Articles - Load Balancing, Request Info, UUID Behavior & Upload ThumbnailsCommunity News: PEAR Installer version 1.6.0 releasedChristopher Kunz's Blog: Building PHP with cURL and libmysqlclient5DevShed: Working with Prepared Queries with PDO Objects in PHP 5Secunia.com: rPath update for gd, php, php-mysql, and php-pgsql
638724
Latest PHPClasses.org Releases:pop3-streamUserActionMySQLWrapperPHP AjaxOutput Buffering handlerSite Map GeneratorRandom HTML GeneratorPaginationsGoogle GraphProcess ImagesgCurlRobots_txtProgressODBC-ABMNewsletter QueueProgress ODBC ABM
439401
InfoWorld - The PostgreSQL Development Group on Wednesday is releasing PostgreSQL 8.0, an upgrade to the open source object-relational database featuring native support for Windows.
86929
In a new post to his Oracle blog today, Christopher Jones talks about a bug that's been found in the OCI8 extension involving statement caching and a fix he's presenting.   As part of some testing we were doing, we found that PHP's OCI8 extension had a bug in the way it used Oracle's statement caching. The fix is already in CVS and will be generally available in PHP 5.2.4. After a short period for you to send me comments, Antony Dovgal will also build a new PECL snapshot of OCI8.   He explains the issue, a problem attributed to the switching of a "hard pause" and "soft pause" when the script caching connects to the Oracle database server. This caching feature is enabled by adding an "oci8.statement_cache_size" value in your php.ini file (and has a default size of 20).    If you've been having issues with this request caching and want to get the fix right away, grab it from the CVS. Otherwise, keep an eye out for PHP 5.2.4 coming soon to correct the issue.