New SQLite provider for ELMAH

I bet you know what ELMAH is, don't you? ELMAH stands for Error Logging Modules and Handlers, and its main and only purpose is to log exceptions occurring in ASP.NET web applications, within which it integrates with just a couple of entries in the Web.config file. It's got a lot of documentation and it's open source, so for any additional information check out its website.

Until yesterday it let you log exceptions in memory, on xml files and SQL Server, but a highly requested feature was to use SQLite as a backing store. Although I didn't know SQLite much it has a cool .NET wrapper published on Sourceforge which exposes its features to the managed world, so I took on the reported feature request and implemented it. SQLite doesn't offer all of the features provided by SQL Server, but it's almost completely SQL92 compliant so it has all that's needed, and much more.

So why to use SQLite instead of SQL Server or xml files? SQLite is a relational database engine, so it's much faster than xml files, and compared with SQL Server at the moment our tests didn't show any performance penalty; plus, it's free! Paging through about 15.000 stored exceptions via ELMAH user interface resulted to be lightning fast!

Since SQLite syntax isn't widely documented, if anyone's interested I will blog about it and the steps I went through to integrate it with ELMAH. Otherwise, the source code is available on ELMAH Subversion repository.

kick it on DotNetKicks.com

Published 06 September 2007 03:05 AM by simoneb
Filed under: , ,

Comments

# DotNetKicks.com said on 05 September, 2007 07:05 PM

You've been kicked (a good thing) - Trackback from DotNetKicks.com

# Sonu said on 07 September, 2007 09:26 AM

Good work Simone. I am sure that many will profit from your implementation.

# simoneb said on 07 September, 2007 12:36 PM

Thank you Sonu, I hope so. Btw, I'm ready with another cool provider for db4o, which I hope can be as useful.

# Lee said on 11 October, 2007 05:07 PM

I hadn't run across elmah until reading your article - thanks for the heads up. There's a side project I'm in the middle of that elmah is perfect for.

# simoneb said on 11 October, 2007 06:15 PM

Glad you find it useful. Actually, ASP.NET 2.0 provides out of the box features for controlling the health of your applications, it's called Health Monitoring, but ELMAH is very easy and straightforward to use and seamlessly integrates with ASP.NET.

# Sonu on .NET said on 16 November, 2007 10:07 AM

Simone Busoli , published a nice article on DotNetSlackers showing a detailed overview of the ELMAH open

# Buspar. said on 29 July, 2008 07:46 PM

Buspar depression. Buspar experience.

# Aquarium cephalexin. said on 29 July, 2008 09:33 PM

Cephalexin antibiotic. Cephalexin.

# Vicodin. said on 30 July, 2008 09:50 AM

Vicodin. Legal meds online usa vicodin.

# Buy propecia. said on 31 July, 2008 08:31 PM

Propecia and male infertility. Side effects from taking propecia. Propecia. Pill propecia. Tadalafil and proscar propecia success. Natural herb reverse impotence from propecia. Buy propecia.

# Cheap zolpidem persriptions. said on 03 August, 2008 11:34 PM

Cheap zolpidem. Zolpidem tartrate. Zolpidem overnight. Zolpidem without prescription. Zolpidem fedex. Zolpidem.

# Diazepam. said on 09 August, 2008 08:24 AM

Diazepam link messageboard aimoo com freecat us. Diazepam no prescription. Diazepam.

# Ultracet. said on 16 August, 2008 08:04 AM

Extracting acetaminophen from ultracet. Ultracet vs vicodin. Ultracet.

# Zolpidem overnight. said on 18 August, 2008 04:10 AM

Cheap zolpidem. Zolpidem fedex. Zolpidem overdose. Zolpidem.

# Lexapro. said on 25 August, 2008 04:04 PM

How take together wellbutrin lexapro. Lexapro and weight gain. Lexapro. Lexapro and drinking.

This site

Search

Go

This Blog

News

Syndication

Sponsors

  • MaximumASP