database
Postgresql 8.3 released
This 8.3 release of Postgresql announced today includes several performance features like Asynchronous Commit, Spread Checkpoints and L2 Cache Protection as well as features useful for DBAs (CSV Logging, SQL/XML, ENUMs, etc). A look at the features matrix also show that other features made their way in the release, such as
- Autovacuum enabled by default
- Order by nulls
- loadable plugin infrastructure for monitoring the planner
- updatable cursors
- Full Text Search
Sun to acquire Mysql AB
Sun announced an agreement to acquire Mysql AB, the company behind the popular open source database, in a transaction worth $1 billion, $800 million of it being cash, the rest being in options.
Until now Sun supported only Postgresql, but it will propose global enterprise support for the Mysql solutions rapidly.
Test your database performance with Bristelcone
Bristlecone is a tool written in Java providing "tools for testing database performance:
- Evaluator generates mixed loads of inserts, updates, deletes, and selects. Output can be built-in graphics, HTML, XML, or CSV.
- Benchmark runs performance test cases with systematically varying parameters. Output can be HTML or CSV.
Britlecone has been tested with Postgresql, Mysql and HSQLDB.
Downloads are proposed in source and binary forms.
Synchronising databases? Try SymmetricDS
SymmetricDS reached version 1.0 early november. It is a "web-enabled, database independent, data synchronization software. It uses web and database technologies to replicate tables between relational databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage.". Database triggers can be used for synchronisation, garanteeing atomicity of operations, but push and pull of data at intervals is also possible. Advanced features such as data filtering and re-routing are also available. Mysql and Oracle are supported out of the box, but other adapters can be developed.
As seen on The Server Side.
Cybercluster: multimaster synchronous replication for Postgresql
Cybertec released Cybercluster 1.0, their multimaster synchronous replication solution for Postgresql, also supporting load balancing, and available on multiple operating systems, under the BSD license. It is available for download as source archive, Debian package and windows installer.
Talend Open Studio 2.2 available
Open Studio, the Eclipse based data integration tool, has reached version 2.2 and features numerous improvements such as a graphical expression builder, exporting jobs as Java Web Services and support for Groovy.
Source: Linuxfr
Mondrian 2.4 released
Pentaho has released version 2.4 of Mondrian, an open source OLAP project. Mondrian is proposed by Pentaho as its Analysis Service. This is the second major release of the project this year.
DB Designer Fork 1.4 available
DB Designer Fork, as its name shows, is a fork of fabFORCE DB Designer, which is also an Open Source product but is optimised for Mysql, whereas the DB Designer Fork supports Firebird/InterBase, Microsoft SQL Server, MySQL, Oracle and PostgreSQL. These tools ease the modeling, querying and SQL scripting tasks.
Source: Linuxfr
Ingres Icebreaker database appliance
Ingres has launched its Project Icebreaker, which consists of a minimal GNU/Linux operating system featuring only what is needed to run the Open Source Ingres 2006 database server. All the package is licensed under the GPL, and annual support contracts are proposed. More questions about the product are answered by the FAQ. It should be available for download shortly.
Ingres is one of the most mature RDBMS, having spawned other systems such as Postgresql
Clover.GUI ETL tool released
Clover.GUI, a graphical tool for the Open Source Clover.ETL data integration tool, has been released.
Clover.ETL is a tool that helps you manipulate and transform data, for example during a database migration. The base concept is that of a graph, in which nodes can transform the data, and edges are pipes transporting the data to the different nodes. This is the perfect tool if you're looking to migrate your data from a proprietary server to an Open Source server.
