IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Delphi
Search Delphi Group:

Advanced
-Collapse +Expand Delphi To/From
To/FromCODEGuides
-Collapse +Expand Delphi Store
PRESTWOODSTORE

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► KBProgrammingDelphi for W...Tool Basics   Print This     

 
Delphi Tool Basics:
So Many Great Databases: Can It Get Any Better?
 
Posted 13 years ago on 6/16/2007
Summary: Contemporary databases provide incredible features, and supporting tools. Even so, there is one "add on" you should know about.

KB100579

As Delphi developers, we probably have the opportunity to work with more databases than virtually all other developers.  Delphi was, after, designed to be deliciously promiscuous when it came to playing nice with databases.

Depending on the database your project uses, there is one Delphi add-on you should definitely know about: Context Database Extensions Suite.  I'll call it DES for short, here.

This product is nothing short of amazing.  I've used it with stunning success in a couple of ambitious projects. With that experience behind me, you'd probably have a hard time talking me out of adding it to my future projects' data modules.

At the heart of the product is a "Schema" object.  Drop one on your data module.  Add the DES version of your database's TDababase, set the appropriate properties, then go to work in the schema.  Simply double-click on the schema object to open its fabulous schema editor.

Within the DES schema editor, you can design and update your database's tables and indexes.  A too-easy-to use ER diagrammer makes it a snap to not only diagram your design, but to also specify relationships - and their rules.

That done, you use the DES versions of your database's TTable, TQuery, etc. components in place of their native counterparts.  They will "know" all about your schema and rules - and automatically enforce them.

You may be thinking, "Well, that's great for databases that lack relational abilities, but why would I care if my database is already fully relational?"

Well, think about your end users.  Are your database's exception messages very helpful to end users? The exception messages from DES are clear and meaningful.

Visit the link, above, read all about it - even download a free trial.  I think you are in for a pleasant surprise.

As Delphi developers, we probably have the opportunity to work with more databases than virtually all other developers.  Delphi was, after, designed to be deliciously promiscuous when it came to playing with databases.

Depending on the database your project uses, there is one Delphi add-on you should definitely know about: Context Database Extensions Suite.  I'll call it DES for short, here.

This product is nothing short of amazing.  I've used it with stunning success in a couple of ambitious projects. With that experience behind me, you'd probably have a hard time talking me out of adding it to my future projects' data modules.


Comments

1 Comments.
Share a thought or comment...
Comment 1 of 1

Since originally postsing this, I discovered a very informative page on Context's web site,  "ScreenCasts."

Each of these is a step-byu-step presentation demonstrating many of the features of the Context Database Extension Suite.

"Must see" great stuff.

 

 

Posted 13 years ago
 
Write a Comment...
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1132A1
Enter key:
News Contributed By Wes Peterson:

Wes Peterson is a Senior Programmer Analyst with Prestwood IT Solutions where he develops custom Windows software and custom websites using .Net and Delphi. When Wes is not coding for clients, he participates in this online community. Prior to his 10-year love-affair with Delphi, he worked with several other tools and databases. Currently he specializes in VS.Net using C# and VB.Net. To Wes, the .NET revolution is as exciting as the birth of Delphi.

Visit Profile

 KB Article #100579 Counter
5865
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]