Subscribe to this list via RSS Blog posts tagged in Databases

Posted by on in Blogs
Versioning DB Metadata Changes and Performance Here's yet another guy with more good ideas on how to version database metadata changes. Unfortunately, the ideal method of database metadata versioning remains to be discovered. The ideas discussed in K. Scott Allen's series are good from a version control point of view, but they will have serious, negative performance implications in the real world. In particular, this bit: Once a script is published into source control, it cannot be changed! Once someone updates their database with an upd...

Posted by on in Blogs
On Versioning DB Metadata Cary Jensen gave a presentation at today's CodeRage on versioning database metadata. In it, he showed a tool he had written which examines a database's metadata, converts it into a series of structured text files, and uses a version control system to record differences since the last check it. The presentation will eventually be available for download here, although it's not up at the time of this writing. Cary's tool was interesting to me since, some months ago, I had given serious thought...

Posted by on in Blogs
Comparing InterBase and BlackfishSQL Someone asked in the newsgroups for a comparison between InterBase and Blackfish SQL. So off the top of my head: Feature Blackfish SQL InterBase Connectivity ADO.NET 2.0, JDBC, dbExpress ADO.NET 1.1 and 2.0, JDBC (type 4), dbExpress, ODBC, native API, embedded SQL, OLE-DB via third parties Data recovery features Incremental backup with failover on Java platform only. Crash recovery via transaction log on both .NET and Java. Journaling, incremental backup, read-only live back...

Posted by on in Blogs
Optimizing UPDATE Statements Recently, I was asked to look at a bug in our software where editing a certain record with a certain customers database took far too long — an update which should have taken less than a second took two hours to complete. I debugged through the application to find the SQL statement in question. It was an UPDATE against a fairly simple view. This view joined a couple tables together, and had a WHERE clause restricting the returned records to those visible to the current logged in user. The vi...

Posted by on in Blogs
The Search for Jim Gray Wired has a lengthy and good story about the extensive, high-tech, and ultimately unsuccessful search for database pioneer Jim Gray, who disappeared on his 40' sailboat off the coast of California earlier this year. Don't miss the detailed timeline in the sidebar....
Tags: Databases

Posted by on in Blogs
You Already Know a Lazy Language In lazy languages such as Haskell, it can be difficult-to-impossible to predict the order in which certain statements will execute. That's fine, since in a purely functional language the order of execution doesn't matter, but people who are used to imperative languages such as Delphi sometimes find the concept difficult to get their heads around. But there's a very common lazy language which I'd guess just about everyone reading this blog already knows, namely SQL's SELECT statement. Perhaps man...

Posted by on in Blogs
Internationalizing InterBase at CodeRage This coming Friday I'll be presenting Internationalizing InterBase: Character Sets, Collations, and Encodings at CodeGear's virtual conference, CodeRage. I'll cover internationalization from a strictly database point of view; there will be no programming-language-specific content in my presentation at all. A significant part of the presentation will be explaining why developers whose software is English-language-only need to care about this, since it is a common misconception that they don't. Th...

Posted by on in Blogs
Turbo Delphi for .NET and InterBase Tutorial Here's a very detailed tutorial on the basics of writing an application which uses InterBase, WinForms, and Turbo Delphi for .NET, by Felix Colibri....

Posted by on in Blogs
Hawaiian Shirts and Booze My general take on The Register is that the only things it prints which are worth reading is the stuff explicitly identified as fiction, such as Verity Stob and the BOFH. The stuff they don't identify as fiction is generally fiction anyway, only less funny. But this morning they ran a story which, while a bit thinly-sourced, is at least funny. When Borland got shirtyHowever, another myth surrounds that self-same conference which says that a totally different group of Microsoft employees (in no w...

Posted by on in Blogs
Database Logging Tools Cheap This Week Thomas Steinmaurer of Upscene Productions requested a plug for their one week sale on their LogManager series products. The tool is available in versions for four different DB servers, including InterBase. You can download a free trial version, and if you find it useful you can purchase it for 75% off this week only....

Check out more tips and tricks in this development video: