No need to panic over #MySQL – are other open source databases available. #PostgreSQL, #Firebird, #HSQLDB, even Apache #Derby

MySQL users are nervous about Oracle’s takeover of Sun Microsystems, according to InfoWorld. You can see their point: Why would a company whose main product is a proprietary database be interested in maintaining an open source competitor to it?

There are other open source databases available. PostgreSQL, Firebird, HSQLDB, even Apache Derby can all be called into service, depending on your needs. The developer communities behind any of these projects would be more than happy to help scores of ex-MySQL users migrate to their particular platform. They almost certainly already have tools to do it

DbBench 0.6.0 Release

Tsutomu Hayashi released DbBench 0.6.0.

List of changes :

* Move development environment to Delphi2010.
* Add “ENGINE INNODB” to MySQL CREATE TABLE script.
* Firebird now use dbExpress driver for firebird by Embarcadero.
* Add “WaitOnLocks = True” for each drivers parameter.
* Change processed transaction count method, now include rollbacked transaction.

IBSurgeon starts Twitter, Blog, Facebook and SlideShare social outlets

We are glad to announce that we have just started set of our social outlets:

Twitter:
IBSurgeon Twitter
Blogger:
IBSurgeon Blog

and Facebook.

We plan to release to public our internal “library of drafts”: short articles, corruption stories, tips and tricks, etc, which are too small to be published as article or whitepaper in our knowledgeable, but seems to be valuable enough for community, so we’ll release them as tweets, blog posts, etc.

Also we plan to share a lot of presentations we (as well as our colleagues, with their kind permission) have presented of different events, conferences, seminars and webinars, on the great resource SlideShare (it also allows following and social networking):
View ibsurgeon's profile on slideshare

So please join us in any social network you prefer and we will do our best to do not disappoint you!

Embarcadero Change Manager Now Supports Firebird

Change Manager 5.1.1 is now released live with full support for Firebird 1.5 and 2.0. Check out a six minute YouTube introduction I recorded to get you folks up and running with Change Manager, and if you think it can be useful to you or your team you can download a 14 day evaluation. Change Manager compares and versions schema objects, compares, synchronizes, and masks database data, and helps manage database configurations. Version 5.1.1 also adds InterBase 2007 and 2009 in addition to our current support for Microsoft SQL Server, Sybase, DB2 for LUW, and Oracle.

CPU suggestions for Interbase/Firebird SQL db server

I work for a small company (fewer than 10 employees). We want to upgrade our primary server hardware this year.

Current server is a HP ML330 G3 with a single Xeon @ 2.8 Ghz, 3GB ram, Raid5 consisting of three 15krpm Ultra320 SCSI drives. OS is Windows 2000 Server.

Our current CPU features hyperthreading, which is enabled. The motherboard is a dual socket board, so initially I was shopping for a second identical CPU (because they’re as cheap as $15 on eBay). But after running some tests, I don’t think it would benefit us.

Our ERP software uses Interbase version 5.6, which does not appear to be multi-threaded based on my tests. I contacted the developer of our ERP package, and they confirmed this: Interbase will NOT utilize multiple physical or logical CPUs. More recent revisions of our ERP software have switched to Firebird db server, which I’ve learned is not multi-thread aware either. This sounds terribly old-fashioned, since modern CPUs are trending toward higher core-count.

Read full post and make your suggestions here.

1 144 145 146 147 148 201