数据库连接Delphi [英] Database connectivity Delphi
问题描述
我已经使用delphi多年了，但是从没有用过数据库的东西，但是最近开始研究和测试.
I'm using delphi for years, but never for database stuff, but recently started researching and testing.
我必须说，给我留下深刻的印象，大多数事情都是自动发生的，我习惯于用php和python手工编写.
I must say, i'm impressed, most of things happens automatically, i'm used to write by hand in php and python.
我将为朋友开发一个商业系统，(两层)5台用户计算机，1台数据库服务器.
i'm going to develop a commercial system for a friend, (2 layers) 5 user computers, 1 database server.
数据库服务器将是一台运行(raid-1)2个硬盘驱动器的体面的机器(MySql5.1或Postgre或Firebird，建议公开).
Database server will be a decent machine with (raid-1) 2 hard drives running (MySql5.1 or Postgre or Firebird, open to suggestions).
ADO
- 易于使用
- 易于部署(仅mysqlconnector安装程序)
- 慢一点?
DbExpress
- 需要提供4个文件[dbxconnections.ini，dbxdrivers.ini，mysqldll，driverdll]
- 越复杂(越难使用)
- ClientDataSet增加了复杂性，但看起来确实很有用
- 没有免费的Postgre驱动程序?
Zeos
- 轻松部署(1 dll)
- 易于使用
您可以看到所需的功能是:
As you can see the desired features are:
- 快速
- 易于使用
- 易于部署
我无法在真实的场景(客户端，服务器)中进行全部测试，所以我希望有经验的人可以帮助我选择哪个以及为什么.
I can't test all in a real scenario (clients, server), so i hope that you guys with experience can help me out in which one to choose and why.
谢谢大家，我想我会使用ADO(可能是)或Zeos
预先感谢
亚瑟
推荐答案
我已经在使用ADO的许多商业大容量系统上工作，而没有任何问题.部署相对简单，因为它包含在OS中.由于它的受众如此广泛，因此大多数主要问题已得到识别和纠正.获得有关ADO连接的帮助非常容易.数据库的支持非常深入( connectionstrings.com )，这使得对其他数据库引擎的支持变得微不足道(您可能仍然需要安装客户端驱动程序，但是几乎所有解决方案都一样.
I have worked on many commercial high volume systems using ADO without any problems. Deployment is relatively simple since its included in the OS. Since it has such a wide audience, most of the major issues have been identified and corrected. Getting help with ADO connectivity is very easy. The database support is very deep (connectionstrings.com) which make supporting additional database engines almost trivial (you may need to still install the client drivers, but that would be the same for almost any solution).
性能并不是什么大问题，它实际上将取决于数据库体系结构和引擎选择.
Performance isn't much of an issue, it really will come down to database architecture and engine selection.
这篇关于数据库连接Delphi的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
