Skip to content

{ Category Archives } Databases

Posts about databases in general — not InterBase-specific content.

Embarcadero

The Embarcadero deal seems, from my outsider’s point of view, to be a great deal for CodeGear and for Embarcadero. There are so many different ways that the two companies’ products can work together that it just makes a great deal of sense to me. It’s less clear to me how it makes sense […]

SQL-to-Code Macro

OK, I’m not trying to steal Joe White’s thunder here on Delphi macros, but when I plugged Joe’s series, I mentioned that I use Delphi macros for converting SQL created in a query analysis tool into Delphi constants, and commenter Jack asked for more details on this. I thought it would make a better […]

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 […]

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 […]

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 […]

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.

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.

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 […]

Internationalizing InterBase at CodeRage

This coming Friday I’ll be presenting Internationalizing InterBase: Character Sets, Collations, and Encodings at CodeGear’s virtual conference, CodeRage[…]

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.

Close