NewLeaf Vet veterinary software is powered by the Firebird SQL database engine. A first class database known for its stability and scalability. Widely used by companies, across the world, requiring guarantee of stability, such as businesses in finance, government and medical sectors.
We assessed several of the most prominent commercial and open source SQL databases before deciding on Firebird SQL database for NewLeaf veterinary software.
Of all the databases tested we found that Firebird SQL database had the fastest performance. Significantly.
Almost every function performed in veterinary software involves getting data from, or sending data to, the database. Therefore database performance directly affects how fast the software operates.
In our database design we make extensive use of SQL database procedures. A procedure, as the name suggest, is constructed to carry out a certain task. That could be to generate a consultation history report, or to list all outstanding invoices. Procedures often processes large volumes of data. The speed gain for procedures is therefore particularly noticeable.
Firebird database server utilises multiple cores in the computer processor. Processing simultaneous data requests in parallel. Veterinary clinics with many users retrieving and saving data simultaneously on networked computers will particularly benefit. Multi-core utilisation speeds up every operation. It also prevents the software becoming un-responsive as a result of one task having to wait for the previous task to finish.
Firebird has a small foot print, as this article on Firebird performance testing explains and emphasizes in its summary. Using few system resources means the database server operates with no overhead. It is conducive to the snappy and lightweight operation of NewLeaf Vet veterinary software. It also contributes to the system being reliable and stable, there is less that can go wrong.
Based on a commercial database Firebird has more than 30 years development. As the database engine for NewLeaf Vet veterinary software, it has proven itself to be a remarkable stable database. Living up to its reputation, it is virtually unbreakable.
Firebird SQL database is open source. No royalties and cost for us to pass on to veterinary clinics. That is reflected in our prices. It also enables us to offer a support subscription that is optional.
Commercial databases carry high costs. The software company pays for utilising the database. The end user (the veterinary clinic) pays for each deployed instance of the database. Networked computers are additional. On top of this both the software company and the end user pays a yearly royalty.
At the end of the day all costs will have to be passed on, directly or indirectly, to the veterinary clinic. NewLeaf veterinary software does not have such expenses to pass on, being powered by Firebird open source database.
Supported by a large, active community of developers it remains a cutting edge database. Development is managed by a core group of developers ensuring that Firebird SQL database continues to sustain its high quality.
Database server installation and connection is principally pre-configured by us. A few simple steps is carried out by the end user, the practice manager or IT technician at the veterinary clinic. Once set up there is no further administration to do.