Articles tagged in database

  1. Amazon SimpleDB

    Amazon SimpleDB -- released last week that provides access to a scalable storage of structured data via a REST API, which runs along side with EC2 and S3 to provide the "scalable backend" for online applications. Comments over the weekend have ranged from "it sucks" to "who needs Oracle/MSSQL/DB2?". I personally won't be using it. It won't scale down as much as FOSS DBs like MySQL or PostgreSQL which are virutally free with your shared hosting. It "might" scale up (which has not yet been proved), but it will soon become very expensive. 10GB/domain is a big show-stopper, latency sucks for database-intensive applications, query time limited to 5 seconds, and no inter-domain queries. Sounds like it's no good for any serious RDBMS-replacement work. It will also force you to code your applications specifically for that platform, just like S3. Vendor lock-in anyone?

  2. Jim Starkey Left Firebird for MySQL

    There has been a series of acqusitions amongst database companies. Oracle bought InnoBase Oy and Sleepycat, two makers of transactional storage engine for MySQL. MySQL AB has then acquired Netfrastructure, a web aplication development framework. However, what MySQL AB actually acquired is not just the company + its software, but the …
  3. Firebird Roadmap for 2006

    What to expect in 2006 for Firebird database. Looks like next year will be an interesting year for this open source RDBMS. 2.0 (query optimisation, removing annoying limitations) and Vulcan (fine grain locking + SMP) in Q1, and 3.0 in Q3 (merge of a few independent branches). Yum.
  4. Data integrity ain't that mythical

    Via lesscode. Alex Bunardzic, who might have recently found himself hated by many 'database geeks', quoted this interview with David Heinemeier Hansson and wrote another article on the myth of data integrity, where he debunked the 'sacred cows' of the corporate IT practices -- the data integrity of the relational database …
  5. Oracle bought Innobase Oy, for what?!

    Now everyone should know that Oracle, the big commercial RDBMS vendor, has recently acquired Innobase Oy, the development house behind InnoDB, one of the data storage backend for MySQL that provides ACID compliant transaction support, row-level locking and foreign key constraint. Jeremy Zawodny has this story well covered. You know …
  6. Simple MySQL backup

    Donncha shared his simple MySQL backup script that backs up individual WordPress tables into separate .sql.gz files, and keeps a week worth of them just in case something horrible happens. This is exactly what I did this morning! Write a simple Bash script that loops through 20+ databases, and …
  7. Free Firebird/Interbase GUI

    My day-time job involves software development using Firebird database (which happens to be 20 years old this month). While it's a great little database that is easy to deploy and scales well, there still lacks documentation for developers (unless you go and buy the book). There might be some commercial …
  8. Firebird Roadmap

    Firebird SQL RDBMS has released some information regarding to features in the next few major versions. Looks very interesting. Even though I am still frustrated that I cannot use stored procedure in a SELECT field.
  9. PostgreSQL goes beta

    PostgreSQL 8.0 is now beta, and it surely has many new features that make it one of (if not the most) favourite relational database engine amongst open source developers. Remember the good old days when FOCUS website was powered with PostgreSQL 6.5. Well, it was not that good …
  10. Die, You Abstract DB API!

    Jeremy Zawodny cursed the death of abstract database API because it is never easy to migrate anyway. Whole heartly agree. How many times that I would love to use features unique in Firebird, but was hindered by our potential database backend migration, which has never happened. But how can you …
  11. Benching marking Firebird 1.0 vs. 1.5

    Yesterday afternoon at work I was stressed in trying to tune some SQL queries, as clients complained Firebird taking up all the CPU time after our software upgrades. At the end, I figured out the issue lies in how Firebird 1.0 and Firebird 1.5 prepare the plan for …
  12. Firebird 1.5 Released

    From the Firebird website, Release 1.5 of the Firebird database has just been released over the weekend. From the CVS log of the "WhatsNew" file, it seems the final release is the same as RC9 released a week ago. I just back up a database from Firebird 1.0 …
  13. Getting Help with Firebird

    I have been having difficulty searching for reference documentations on the Firebird database. As I have mentioned in a previous entry, openly available documentation on Firebird is outrageously lacking, comparing to other open source databases. The only useful reference that I can lay my hands on is the much out-dated …
  14. LIMIT in SELECT statements in Firebird

    The question is, is there a MySQL/PostgreSQL equivalent of LIMIT clause in Firebird? It is very useful in situations where you don't get to keep the database cursor over multiple requests, i.e. in some web applications. In my scenario, I just want to the database to return the …
  15. MySQL AB has released MaxDB 7.5

    According to this announcement, sourced from Jeremy Zawodny's blog, MySQL AB's new product, MaxDB which is a re-branded and enhanced version of SAP DB, has just been released. It is a GPL'ed product offering both Free Software license, or a commercial license for those who do not wish to …