什么是C ++的最佳数据库 [英] what is the best database for C++

问题描述

我从未使用C ++进行数据库编程，但是我需要从事一个我正在从事的业余项目.经过很少的研究，我已经选择了SQLite.还有更好的建议吗?

i''ve never done database programming with C++ but i need to for a hobby project i''m working on. with very little research i have settled for SQLite. any better suggestions?

推荐答案

我确信唯一有效的答案是这样的:http://en.wikipedia.org/wiki/Comparison_of_database_tools [ ^ ].

这是您从此表中选择的完全由您的目的定义的表:-)
老实说.

—SA

I''m sure the only valid answer would be this: http://en.wikipedia.org/wiki/Comparison_of_database_tools[^].

That leaves for your choice from this table, which is entirely defined by your purpose :-)
Honestly.

—SA

您可以将C ++与大多数数据库引擎一起使用，以确定哪种数据库引擎适合您，您需要查看它的功能和行为.

引擎是否需要处理并发(多个并发用户)?

您需要大物件的支持吗?

您的解决方案会涉及广泛的分析功能吗?

您需要什么样的支持才能确保参照完整性-了解删除级联"在各种引擎上的工作原理.

您想进行服务器端编程，需要什么语言功能?

安全?

您可能认为SQLite是最适合您的，也许是这样-但诸如PostGreSQL，Oracle RDBMS，IBM DB2，MS SQL Server和Firebird之类的数据库引擎各自提供了其独特的功能组合.

我不知道您的爱好-无法就什么数据库引擎最适合您的需求提供真正的建议.

如果您想要最强大的开源选项，PostGreSQL适合您-据我所知，就受支持的功能和扩展而言，没有其他开源引擎会出现问题.

Oracle RDBMS，IBM DB2和MS SQL Server具有不同的优点和缺点-要确定它们之一是否适合您，您必须定义您的需求.

最好的问候
Espen Harlinn

You can use C++ with most database engines, to determine what database engine is right for you, you need to look at it''s features and behaviour.

Does the engine need to handle concurrency (multiple concurrent users)?

Will you need support for large objects?

Will your solution involve extensive analythic functionality?

What kind of support du you need for referential integrity - check out how "on delete cascade" works for the various engines.

Would you like to do server side programming, what language features do you need?

Security?

You may think that SQLite is right for you, and maybe it is - but database engines like PostGreSQL, Oracle RDBMS, IBM DB2, MS SQL Server, and Firebird each offer their unique blend of functionality.

As I don''t know your hobby - it''s impossible to offer a real advice on what database engine may suit your needs best.

If you want the most powerful open source option, PostGreSQL is for you - as far as I know, no other open source engine commes even close in terms of supported features and extensions.

Oracle RDBMS, IBM DB2 and MS SQL Server have different strengths and weaknesses - to determine if one of them is right for you, you have to define your needs.

Best regards
Espen Harlinn

SAKryukov是正确的方法.

如果您正在寻找可以验证sqlite使用的人，我可以说这是我们在跨平台框架中使用的东西.也有一个不错的内置r树空间索引器，只是有一点好处.

SAKryukov has the right approach.

If you''re looking for someone to validate the use of sqlite for you, I can tell it is what we use in our cross-platform framework. Has a nice, built in r-tree spatial indexer too, just as a little bonus.

这篇关于什么是C ++的最佳数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！