Header banner
Revain logoHome Page
Carlos Burrows photo
1 Level
839 Review
68 Karma

Review on Empress RDBMS by Carlos Burrows

Revainrating 5 out of 5

Great open source database for logging purposes

I like that it has easy to use SQL interface as well as support of many different languages such as C++/Java or Python programming language which makes development easier compared with other DBs available in market at present time (MySQL). It also supports multiple threads allowing faster execution speed than any single threaded dbms out there. Also have some nice features where you can set up data integrity checks alongwith triggers so if something goes wrong while insertion into table then system will alert user about error by sending email etc. So far no issues were found but sometimes due to its nature of being realtime db we cannot afford downtime unlike traditional databases hence this one needs more testing period before going live. In our case it was used only to store application logs generated from various devices using log4j library and send those records via mail when certain events occur.

Pros
  • Good performance
  • Relational DB Management System supporting both relational tables, views & stored procedures.
  • Multithreaded processing
  • Stored procedure creation for better maintenance ease is good feature too especially now days lot's business logic are getting executed through SP instead main query itself making code maintaince much simpler thus reducing bugs significantly
Cons
  • Minor Issues