Borland Database Engine

Borland Database Engine

Question:
Many companies offer Borland Database Engine replacements claiming to be smaller and faster. What does the BDE offer that these replacements don’t? Is there a good reason to keep the BDE?

Answer:
Yeah, the BDE is big, and it adds two extra floppies to an install. But there are things inherent to the BDE that are incredibly powerful, and most of all, very convenient.I’ve looked at several of the “BDE Replacements” out there, and what they don’t really talk about are the things that they DON’T support that the BDE does. For example, many of them don’t fully support ANSI SQL92, which means you can’t do things like subqueries (incredibly necessary for doing two-table updates). Some of them have file size limitations (most only support up to 4K block sizes in tables), and that means forget about creating tables with millions of records in them. Others don’t do BLOBs very well. In other words there are tradeoffs. So what you have to do is evaluate the various packages to see which one(s) fit your particular needs.

However, in their defense, I’ll say that they’re great replacements for real simple database applications that won’t have big tables. For instance, a PIM comes to mind where the table sizes will be measured more in the hundreds of records as opposed to thousands.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several