ASP.NET comes with ASP.NET Develepment Server, which can be embedded into ASP.NET application for running the test instead of deployment to IIS alike.
Does ASP.NET/ADO.NET provide an embedded RDBMS for development purpose instead of access to MS-SQL server alike? Where can i find some popular embedded RDBMS which are open source, implemented by .NET C# and well-integrated with ASP.NET/ADO.NET? thx!
thx for your info, i also just came cross these below incl. what you mentioned.
- sqlite, open source, inherent embedded db engine implemented by c/c++ unmanged code and
its ado.net provider are both actively being developped.
- firebird, open source, with a flavor as embedded db engine implemented by c/c++ unmanged code and
its ado.net provider are both actively being developped.
I rarely use VS for database tasks, even with SQL Server, and my VS experience with the mentioned RDBMS:es are even more limited. SQLite has been my choice most of the time, but I've used the
Firefox SQLite extension to handle management.
There are many problems with ScimoreDB as embedded database.
The most horrible problem is that unlike Sqlite, Firebird, SQLCE,
and VistaDB it does not create a single file (which is expected from an embedded engine) but a directory with many files. each file corresponds to either a system table or a user table. If one wants to use that many files, perhaps
some client server database is better.
I used ScimoreDB for testing purpose and created 3 tables with nvarchar, bit and biginteger fields. I was very disappointed to see that even the empty database (schema but no data) took 22.5 MB space which is really a waste of space if you compare it to
the files that other embedded database engines create.
I think I would go for Sqlite or SQLCE for embedded database option.
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Hi Mercede</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden;
overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Yep we do create more than one file. If you need a single file database, we
are not an option.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x:
hidden; overflow-y: hidden;" id="_mcePaste">The initial size of the database is configurable at creation. So you dont need to start with a empty 22Mb preallocated database.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height:
1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">I would suggest you try add a bunch of data to the
different databases and watch the sizes. As of version 3.0 we have many size-optimizations. Last customer I helped with free text search, the ms sql table on 25Gb data used 4Gb on ScimoreDB.</div> <div style="position: absolute; left: -10000px; top: 0px; width:
1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Compared to some of the other we do
have some advantages.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Multi process access</div> <div style="position: absolute; left: -10000px; top: 0px; width:
1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Concurrent reads, insert and writes</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">*
Replication (including bi-directional)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Compression of text</div> <div style="position: absolute; left: -10000px;
top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Supporting high levels of concurrencies</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;"
id="_mcePaste">* Free-text search</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* "No" database size restrictions</div> <div style="position: absolute; left:
-10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* T-SQL subset</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div>
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">You write about many problems. We would be _very_ happy to hear from you on support@scimore.com, maybe there are features
we need to add, or things we could help you with.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px;
width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">/thomas</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div>
Hi Mercede
Yep we (Scimore) do create more than one file. If you need a single file database, we are not an option.
The initial size of the database is configurable at creation. So you dont need to start with a empty 22Mb preallocated database.
I would suggest you try add a bunch of data to the different databases and watch the sizes. As of version 3.0 we have many size-optimizations. Last customer I helped with free text search, the ms sql table on 25Gb data used 4Gb on ScimoreDB.
Compared to some of the other we do have some advantages.
Multi process access
Concurrent reads, insert and writes
Replication (including bi-directional)
Compression of text
Supporting high levels of concurrencies
Free-text search
"No" database size restrictions
T-SQL subset
You write about many problems. We would be very happy to hear from you on support@scimore.com, maybe there are features we need to add, or things we could help you with.
I've finally decided to give scimore db a try for a certain web application. We would be using scimore embedded + asp.net 3.5.
The application is a typical multiple reader / multiple writer application on a shared hosting.
Let's see if it works.
Where can i find the limitations of scimore db embeded?
Another question, Is it really free? I mean once the testing is over and provided that scimore performed well we would be making the application live so I want to know if there are any requirements for using it free?
Member
3 Points
3 Posts
Embedded RDBMS for ASP.NET/ADO.NET?
Jul 18, 2009 05:54 AM|fans asp|LINK
ASP.NET comes with ASP.NET Develepment Server, which can be embedded into ASP.NET application for running the test instead of deployment to IIS alike.
Does ASP.NET/ADO.NET provide an embedded RDBMS for development purpose instead of access to MS-SQL server alike? Where can i find some popular embedded RDBMS which are open source, implemented by .NET C# and well-integrated with ASP.NET/ADO.NET? thx!
All-Star
15920 Points
3297 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Jul 18, 2009 08:51 AM|gunteman|LINK
SQLite
Firebird
Vista DB (not open source)
SQL Server Compact (not open source)
Member
3 Points
3 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Jul 18, 2009 03:03 PM|fans asp|LINK
thx for your info, i also just came cross these below incl. what you mentioned.
- sqlite, open source, inherent embedded db engine implemented by c/c++ unmanged code and its ado.net provider are both actively being developped.
- firebird, open source, with a flavor as embedded db engine implemented by c/c++ unmanged code and its ado.net provider are both actively being developped.
- vistadb, free express version, c# managed code engine
- sqlce, free, but seems issue existing on integration with asp.net??? engine tyoe???
- scimoredb, free, c/c++ unmanaged code engine
- #hsql, open source, c# managed code engine but seems unstable, dormant for long time.
- #H2, open source, java engine, converted into .net runtime by ikvm.net, seems little activity.
Could you share the experience that you have with them on VS integration? thx!
All-Star
15920 Points
3297 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Jul 18, 2009 05:51 PM|gunteman|LINK
I rarely use VS for database tasks, even with SQL Server, and my VS experience with the mentioned RDBMS:es are even more limited. SQLite has been my choice most of the time, but I've used the Firefox SQLite extension to handle management.
Member
10 Points
1 Post
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Jul 20, 2009 08:09 AM|thomashilbert|LINK
Just a quick follow up to clarify regarding scimoredb. Yes it does have a c++ client library. But it features more...
So what is the negative thing?
Regards,
Thomas
scimoredb
Member
3 Points
3 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Jul 20, 2009 11:41 AM|fans asp|LINK
thx for your info!
certainly, all the said engines above have ado.net providers. it's not yet opinionated for now. next, i'd like to see their design time support on VS.
None
0 Points
3 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Aug 06, 2010 05:58 PM|Mercede|LINK
There are many problems with ScimoreDB as embedded database.
The most horrible problem is that unlike Sqlite, Firebird, SQLCE, and VistaDB it does not create a single file (which is expected from an embedded engine) but a directory with many files. each file corresponds to either a system table or a user table. If one wants to use that many files, perhaps some client server database is better.
I used ScimoreDB for testing purpose and created 3 tables with nvarchar, bit and biginteger fields. I was very disappointed to see that even the empty database (schema but no data) took 22.5 MB space which is really a waste of space if you compare it to the files that other embedded database engines create.
I think I would go for Sqlite or SQLCE for embedded database option.
vistadb scimoredb Sqlce
None
0 Points
2 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Aug 08, 2010 05:38 PM|Thomas Hilbert Madsen|LINK
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Hi Mercede</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Yep we do create more than one file. If you need a single file database, we are not an option.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">The initial size of the database is configurable at creation. So you dont need to start with a empty 22Mb preallocated database.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">I would suggest you try add a bunch of data to the different databases and watch the sizes. As of version 3.0 we have many size-optimizations. Last customer I helped with free text search, the ms sql table on 25Gb data used 4Gb on ScimoreDB.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Compared to some of the other we do have some advantages.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Multi process access</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Concurrent reads, insert and writes</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Replication (including bi-directional)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Compression of text</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Supporting high levels of concurrencies</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* Free-text search</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* "No" database size restrictions</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">* T-SQL subset</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">You write about many problems. We would be _very_ happy to hear from you on support@scimore.com, maybe there are features we need to add, or things we could help you with.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">/thomas</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div>Hi Mercede
Yep we (Scimore) do create more than one file. If you need a single file database, we are not an option.
The initial size of the database is configurable at creation. So you dont need to start with a empty 22Mb preallocated database.
I would suggest you try add a bunch of data to the different databases and watch the sizes. As of version 3.0 we have many size-optimizations. Last customer I helped with free text search, the ms sql table on 25Gb data used 4Gb on ScimoreDB.
Compared to some of the other we do have some advantages.
You write about many problems. We would be very happy to hear from you on support@scimore.com, maybe there are features we need to add, or things we could help you with.
/thomas
scimoredb Embedded concurrent free-text search t-sql MVCC replication
None
0 Points
3 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Oct 28, 2010 02:44 AM|Mercede|LINK
Thomas,
I've finally decided to give scimore db a try for a certain web application. We would be using scimore embedded + asp.net 3.5.
The application is a typical multiple reader / multiple writer application on a shared hosting.
Let's see if it works.
Where can i find the limitations of scimore db embeded?
Another question, Is it really free? I mean once the testing is over and provided that scimore performed well we would be making the application live so I want to know if there are any requirements for using it free?
None
0 Points
2 Posts
Re: Embedded RDBMS for ASP.NET/ADO.NET?
Oct 31, 2010 07:12 PM|Thomas Hilbert Madsen|LINK
The are no restrictions on data size, memory restrictions, or cpu usage.
We do of course have restrictions, but those come from the implementation. Those are:
Page size: 8kb
Max table size: 16EB
Max columns pr. row: 255
Max blob size: 16Tb
ScimoreDB is written in C++, both server and client. Thus you must ensure your hosting provider allows running sites with full trust.
/thomas
scimoredb shared hosting scimore sql database embedded sql database multiple writer full trust multiple reader