我应该选择不担心大小限制的数据库?

我应该选择不担心大小限制的数据库?

问题描述:

我想做一个相当简单的数据库,该数据库应该存储视频文件和声音文件。我想使用MS Access数据库(mdb),但这仅限于 2 GB
我不想使用服务器-客户端解决方案,因为它应该是仅使用存储在本地硬盘驱动器上的本地数据库的单个应用程序。就是这个主意。

I want to make rather simple database, which should store videofiles, and soundfiles. I wanted to use MS Access database (mdb), but this is limited to 2 GB. I do not want to use server - client solution, cause it should be single application using only local database stored on local harddrive. That's the idea.

可以给我一个建议吗?

谢谢

我会使用嵌入式 Firebird 。您可以拥有免维护的桌面应用程序,并且如果需要,可以稍后将其扩展到完整的C / S系统。另外,您还有足够的库(免费或免费-Zeos,UIB,IBObjects,FIBPlus)可以在Delphi中使用它。更不用说最新的Delphi具有DBX驱动程序OOTB。

I'd go with embedded Firebird. You can have a maintenance-free desktop application and if you want you can scale it later on to a full C/S system. Also you have enough libraries (free or not - Zeos, UIB, IBObjects, FIBPlus) to use it from Delphi. Not mentioning that the latest Delphi has a DBX driver OOTB.

此外,数据库blob中的大量数据(如果设计正确)不会影响搜索速度。

Also, having large amounts of data in the database blobs (if you design it right) doesn't affect the search speed.

HTH