Treesoft Office: Electrical Cad · Crm · Erp – Use of a Shared Sql Database

Enter master data and information only once

The use of a shared Firebird SQL database enables a fast, secure, and consistent workflow across the electrical CAD, CRM, and ERP module boundaries: projects, addresses, emails, faxes, telephony, history, appointments, tasks, quotes, invoices, and documents. All shared master data, such as addresses, contact persons, materials, or services, only needs to be entered once and maintained in a central location.

What is Firebird?

Firebird is a free open-source database that is in no way inferior to expensive alternatives in terms of functionality. It is an SQL database that is used by programs to store data and filter, sort, and modify it according to any criteria. The advantage of an SQL database over a classic database—such as Paradox—is that users can create their own criteria for data processing, giving them a better overview and greater benefit from their data.

Robust thanks to stability and security

Firebird is one of the most stable databases in the world. Damage or loss of data is virtually impossible, even in the event of a crash. Data backup during operation is also possible without risk. Firebird uses proven technologies from the Interbase database, which is constantly being improved and is always state-of-the-art.

Firebird grows with your business

Firebird is designed to handle millions of records and databases up to several terabytes in size. At the same time, it can be used for small databases without any hassle or complicated installations. A server with minimal hardware requirements is sufficient to operate an average database with 20 simultaneous users.

Operating costs are kept to a minimum. If the number of users or the amount of data increases, only the server hardware needs to be expanded. No database upgrade or conversion is necessary. Firebird grows seamlessly with your business.

Lightweight with plenty of horsepower

A Firebird installation is less than 10 MB in size and has no software dependencies. No .NET framework, third-party software, or special Windows version is required. Firebird runs on all major platforms, including Windows, Linux, Mac OS, and UNIX. Firebird has no overlap with other SQL servers. This allows it to run smoothly alongside Microsoft SQL Server, Oracle, MySQL, or other SQL databases.

Open source = quality

Firebird is an open source project. This means that Firebird is free of charge and the source code can be viewed. Firebird thrives on its active community, which provides regular, high-quality updates. There are no manufacturer ties, no sudden changes in product policy, and no utopian licensing costs for software manufacturers using Firebird.

Conclusion

We use Firebird in our products because it is fast, stable, lean, uncomplicated, free of charge, and meets all our requirements for a consistent work process.

https://www.firebirdsql.org

Firebird upgrade: From 2.5.8 to 3.0

The upgrade to Firebird 3.0 has had a positive effect on performance. Here are the most important improvements:

1. Multithread architecture: 

   With Firebird 3.0, multiple instances of the server can run simultaneously on the same host. This enables better resource utilization and isolated database environments. The transition from a single-thread architecture to a multithread architecture enabled better utilization of modern multi-core processors. This resulted in higher overall performance and better scalability.

2. Encryption

   Firebird 3.0 integrates support for data encryption both at the stored data level and during transport (TLS/SSL). It also includes new tools and features that simplify the management of security certificates and private keys.

3. Enhanced SQL features

   JSON processing has been significantly improved, as Firebird 3.0 offers native functions for editing and querying JSON data.

4. Performance

   The new architecture and optimized query optimizer enable better parallel processing of queries, which can lead to a significant performance increase when dealing with large amounts of data.

5. Memory management

   Firebird 3.0 offers improved memory management with better handling of temporary tables and memory pages, resulting in more stable performance overall.

6. User and role management

   Firebird 3.0 offers much more flexible user and role management and enables various authentication methods, such as external authentication via the operating system or LDAP server.

7. Transactions

   Firebird 3.0 offers more options for managing transactions, resulting in better handling of parallel and long-term transactions.

8. Installation and administration

   There are improved tools for managing the server. This is particularly beneficial for our developers and administrators.

9. Support for 64-bit systems

   Improved support for 64-bit architectures on modern systems results in better performance and a larger memory space.

10. Advanced compatibility options

    Firebird 3.0 was developed to remain largely compatible with Firebird 2.x, but also offers new features and changes that make the system fit for modern requirements.

Conclusion: Compared to Firebird 2.5.8, Firebird 3.0 offers numerous performance and functional improvements, particularly in the areas of architecture, security, SQL functions, and parallel processing.