SQLite Blog and Membership/Role providers

Oct 14, 2007 at 3:49 PM
I've finished implementing BlogProvider and ASP.NET membership and Role provider interfaces to work with www.sqlite.orgSQLite/url databases. With SQLite you get the same "plug 'n play" feature of XML blog provider with the additional advantages such as transactions, scalability etc. while being much faster than MS SQL or MySQL.

Why I invested on SQLite the most is that my current website has a MSSQL server database quota limit of 50MB (yeah, I know :( and so wanted to run my blog without taking up any amount of it.

There are also downsides to using SQLite: one that comes to mind is that you don't have a way to interact with the db directly once you've uploaded it. Since SQLite isn't a client/server database, you cannot remotely connect to it. And there's no "SQLiteMyAdmin" web interface either. Even if there was you'd need a ASP.NET version wouldn't you? The good news is that I'm considering that as my next open-src project, the bad news is that I don't want to make any such commitments :)

I'm going to update my current website to run BlogEngine 1.2 with SQLite right now. In a couple of days, I hope to move the site to my new domain. I can make the code available once I'm done. Anybody interested?

cheers!
Sameera.
Oct 20, 2007 at 4:44 PM
BE.NET 1.2 with SQLite is running my blog now. You can see it live at: http://www.codoxide.com/
To download the modified code and find out more please see: http://www.codoxide.com/?tag=/blogengine.net

cheers!
Sameera