The content has been bookmarked!
There was an error bookmarking this content! Please retry.
Posted by Jonathan Allen on Aug 23, 2010
EffiProz is an embedded database written entirely in C# that can has both a disk-based and a memory-only mode. This has allowed its developers to port it to most environments that have CLR including .NET Compact, Mono, Windows 7, and Silverlight. The next version will extend this to mobile platforms.
When we asked Irantha Suwandarathna of EffiProz why we should use it instead of SQL Server Compact or SQLite he responded,
If someone is interested in features,
- Extreme Performance
- ACID compliant transactions
- Full blown standard compliant SQL support (More than what is supported by SQLite or SQLCE)
- Fully Managed code database engine
- Want the same database to work on .NET, Compact Framework, Silverlight, Mono, Windows Phone, Moonlight, ( in Future on Android and iPhone) applications (or Migrating database files between these platforms) (With basic HSQL compatibly you will be able to use the same database files even between .NET and JAVA applications interchangeably.)
In addition EffiProz supports Entity Framework and will have MonoTouch in the next version (1.3). Support for MonoDroid is planned for some time after that is released.
Since the quality of an application is largely dependent on the quality of the components it is built from, we made sure to ask about their testing and quality assurance procedures.
We have a regression test suite with over 10,000 Lines Of Code. In our current 1.2 release we have achieve about 74% code coverage. For 1.3 release bar is set for 80% coverage. We repeat the test suite for each of our storage layers. Again we rerun those test cases 2 times: once to test Transaction Log recovery and then to test Regular Shutdown. In addition to this automated regression test suite we also do extensive manual testing as well.
HSQLDB, an open source Java datatabase, formed the basis of this product.
EffiProz is started as a translation of HSQLDB to .NET framework. But EffiProz has now incorporated many more features that are not present in HSQLDB (for example SQL Server compatible UniqueIdentifier Data Type). HSQLDB is Licensed under a liberal BSD style license. EffiProz is free for none commercial use (Academic, Research, etc.). You are required to purchase a License for a commercial use.
Fair Trade Software Licensing - A Guide to Neo4j Licensing Options
Using Drools? See what you're missing! Get the Power of Drools with the Assurance of Red Hat
Attila Szegedi talks about performance tuning Java and Scala programs at Twitter: how to approach GC problems, the importance of asynchronous I/O, when to use MySQL/Cassandra/Redis, and much more.
One category of risk that project teams need to ensure they address is business value failure – delivering a product that fails to provide value for the business investor.
InfoQ spoke to the authors of Software Systems Architecture on a couple of new topics, the System Context viewpoint and Agile, which have been added to the second edition.
Alex Papadimoulis discusses ugly code, where it comes from, how to avoid it, and how to get rid of it.
John Davies examines Visa’s architecture and shows how enterprises have architected complex integrations incorporating Hadoop, memcached, Ruby on Rails, and others to deliver innovative solutions.
Sean Comerford unveils ESPN.com’s architecture, what components are used and why, and the current changes the website goes through.
Are there repeated patterns of failure on Enterprise Agile Enablement efforts? Sanjiv and Arlen discuss Seven Deadly Sins to avoid when adopting Agile in an enterprise.
Erik Dörnenburg answers: What is Enterprise and Evolutionary Architecture?, discussing 4 issues: Turning strategy into execution, Ensuring conformance, Where do the architects sit? Buying or building?
No comments
Watch Thread Reply