All geek questions in one place

Database Selection and Licensing for Delphi Application

We have Delphi XE2. We are looking for a database for our application. We have tried Absolute Database and support most of the SQL commands that we need. I see that most Delphi users choose Firebird, but it's hard to work with. I am so confused about databases and licenses. Here are my problems:

  • When we select a database, say Absolute database, Firebird, MySql, etc., and if we have, for example, 3000 clients, do we still need to pay database developers? Or is it a one-time fee? I am very confused because they say that when we buy, we can use it inside our building ( http://www.componentace.com/order/licenses.php ). But when we release our software, our customers will need to use the same database, of course.

  • Absolute DB is easy to install and supports most SQL queries. Firebird does not support most SQL queries. Is it correct?

  • When we try to use Firebird, we use FlameRobin to create the database. But when we try to connect using IB components, it says: "Unable to connect the database."

Many thanks...

+6
source share
4 answers

  • It depends on the database. Absolute database is a built-in database, everything is included in your exe. However, most database engines are self-contained, so they are installed as applications. It seems that if you are buying a commercial license for the Absolute Database, you do not need royalties: http://www.componentace.com/order/order_product.php?id=8

  • Firebird supports most SQL standards. According to this answer, most of the built-in databases that are compatible with SQL standards are Firebird: Which built-in database has the maximum SQL compliance and concurrency support?

  • You should have some configuration issues with IB components, it's hard to say more without further information. On the other hand, IB components are for Interbase, so you can find something even better, like UIB.

+8
source

  • Firebird has no licensing fees at all. However, he is smart to help support this wonderful project as soon as you rely on it. There are many ways to help the Firebird project:

    http://www.firebirdsql.org/#consider-your-contribution

  • Wrong. Firebird is very powerful and supports most SQL standards, as well as excellent SQL extensions for stored procedures and triggers.

  • Check the database connection string. Usually this is something like server_ip:full_db_path if you are connecting over a network, or just full_db_path if it is local. You can always use ALIAS instead of full_db_path . Make sure you use the Firebird server or, if you use the built-in, if it is installed correctly. Firebird has excellent and comprehensive documentation and one of the best open source project support groups.

+11
source

If you choose Firebird, see IBExpert . This is absolutely the best administration tool available for Firebird. But not cheap. = (

+1
source

You should also check out Interbase, also sold by Embarcadero, a Delphi supplier. Interbase is not the same as Firebird, and probably why the IB components you mentioned do not work.

Yes, each client usually has to acquire an IB base. However, Interbase has additional features depending on how you structure your application. Check how they work, and see if they can better match what you are trying to do.

0
source

Source: https://habr.com/ru/post/913922/

More articles:


All Articles