Portable DB Suggestions?
-
Harvey Saayman wrote:
I want it to be portable but I have no idea which portable database
Confused here.. You will be building it in C# under DotNet 3.5, so by portalbe you mean still in the Windows world, or are you trying to look down the road to Mono?
Rocky <>< Recent Blog Post: Texas Deputy Sheriff vs New York Lawyer! Thinking about Silverlight? www.SilverlightCity.com
-
If your record count is < 5k record then store data as u$ compliant xml that can be read by u$ dataset reader (db's <5k are table scan anyway). > 5k sql lite. But if your db is internet acessable then use u$ sql server and expose your data using web services. Good Luck
MrPlankton (bad guy)"Fear is a hammer, and when the people are beaten finally to the conviction that their existence hangs by a frayed thread, they will be led where they need to go." (good guy)"Which is where?" (bad guy)"To a responsible future in a properly managed world." Dean Koontz, The Good Guy
what does "u$" mean?
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
-
If your record count is < 5k record then store data as u$ compliant xml that can be read by u$ dataset reader (db's <5k are table scan anyway). > 5k sql lite. But if your db is internet acessable then use u$ sql server and expose your data using web services. Good Luck
MrPlankton (bad guy)"Fear is a hammer, and when the people are beaten finally to the conviction that their existence hangs by a frayed thread, they will be led where they need to go." (good guy)"Which is where?" (bad guy)"To a responsible future in a properly managed world." Dean Koontz, The Good Guy
I'm with Lauren. what is "U$"
Never underestimate the power of human stupidity RAH
-
what does "u$" mean?
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
-
SQLite hands down. There's a complete .net connector for it.
// Steve McLenithanI didn't know about it, and it looks great!! I'll keep it handy for my next projects. What .NET provider do you use? I found two: ADO.NET Provider for SQLite[^] System.Data.SQLite[^] Apparently the second one looks better, but I have yet to try them. [EDIT: It seems both are the same. When I click the files link for the second one, I go to Sourceforge] Regards,
Luis Alonso Ramos Intelectix Chihuahua, Mexico My Blog!
modified on Sunday, October 19, 2008 2:37 AM
-
I took it as "portable" in the sense of "can be moved to another machine / given to another user without a lot of work". Something like XML or SQLite fit those needs pretty well; an Access database or some flavors of SQL Server might work, provided you're willing to impose the cost of installing the supporting libraries. A server-based database OTOH, would be rather painful, as you'd need to configure the connection in addition to installing the server binaries.
----
You're right. These facts that you've laid out totally contradict the wild ramblings that I pulled off the back of cornflakes packets.
You got it Shog, i intend for this app to be on my flash disk or external HDD
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111 -
Hey guys I'm working on a little personal project, a code snippet manager. I want it to be portable but I have no idea which portable database to use. I'm writing it in C# under DotNet 3.5 Any suggestions?
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111Embedded Firebird [^]. There are a couple of articles about it on CP, like this one [^]
Work @ Network integrated solutions | Flickr | A practical use of the MVC pattern
-
+1. The combination of speed and lack of dependencies is a huge win.
----
You're right. These facts that you've laid out totally contradict the wild ramblings that I pulled off the back of cornflakes packets.
Shog9 wrote:
lack of dependencies
To get it running in C++, all you have to do is to download two (maybe three depending on how much you'd like to extend it) files, and add them to your project. Talk about It Just Works!
-
Hey guys I'm working on a little personal project, a code snippet manager. I want it to be portable but I have no idea which portable database to use. I'm writing it in C# under DotNet 3.5 Any suggestions?
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station.... _________________________________________________________ My programs never have bugs, they just develop random features.
-
Is there a decent wrapper for multithreaded C#/.NET 3.5 apps for SQLite? I did a search and saw a number of different projects around the net, but is there one you have used that is stable and no headaches?
Rocky <>< Recent Blog Post: Texas Deputy Sheriff vs New York Lawyer! Thinking about Silverlight? www.SilverlightCity.com
Not having used SQLite with C#, unfortunately I can't. I've used it with C++ though and it's pretty speedy :) Regards, --Perspx
"I've got my kids brainwashed: You don't use Google, and you don't use an iPod." - Steve Ballmer
"Some people have told me they don't think a fat penguin really embodies the grace of Linux, which just tells me they have never seen an angry penguin charging at them in excess of 100mph." - Linus Torvalds -
Shog9 wrote:
"portable" in the sense of "can be moved to another machine / given to another user without a lot of work"
That would be a very strange use of the term "portable". It usually means able to port to another compler/OS/hardware.
Nemanja Trifunovic wrote:
That would be a very strange use of the term "portable". It usually means able to port to another compler/OS/hardware.
-
u$ dataset reader what types of dataset readers are there?
Todd Smith
-
what does "u$" mean?
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
u=micro $oft
MrPlankton (bad guy)"Fear is a hammer, and when the people are beaten finally to the conviction that their existence hangs by a frayed thread, they will be led where they need to go." (good guy)"Which is where?" (bad guy)"To a responsible future in a properly managed world." Dean Koontz, The Good Guy
-
oooops sorry my bad... i looked around but couldnt find that :)
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
I have used the free version of this for a project of my own and it is good, plus their support is pretty speedy. There is a provider that **should** be a drop-in replacement for the SQL Server provider, and they are constantly working on ensuring that their flavour of SQL matches SQL Server, to make upgrade / crossgrade easier.
Stuart R
-
Hey guys I'm working on a little personal project, a code snippet manager. I want it to be portable but I have no idea which portable database to use. I'm writing it in C# under DotNet 3.5 Any suggestions?
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111 -
Hey guys I'm working on a little personal project, a code snippet manager. I want it to be portable but I have no idea which portable database to use. I'm writing it in C# under DotNet 3.5 Any suggestions?
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111 -
Hey guys I'm working on a little personal project, a code snippet manager. I want it to be portable but I have no idea which portable database to use. I'm writing it in C# under DotNet 3.5 Any suggestions?
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111If you're so concerned with having the application portable, write your own database format for the application, that way you can keep the dependencies to a minimum and have full control as to how the data is stored. (just my 2cents)
The worst thing about the darkness is the light at the end - DX-MON
-
I didn't know about it, and it looks great!! I'll keep it handy for my next projects. What .NET provider do you use? I found two: ADO.NET Provider for SQLite[^] System.Data.SQLite[^] Apparently the second one looks better, but I have yet to try them. [EDIT: It seems both are the same. When I click the files link for the second one, I go to Sourceforge] Regards,
Luis Alonso Ramos Intelectix Chihuahua, Mexico My Blog!
modified on Sunday, October 19, 2008 2:37 AM
-
Take Access - one file, fast and handy Read http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx[^]for details
cwp42
Access isn't portable though, it's windows only and this guy wants his software to be able to run on all platforms.
The worst thing about the darkness is the light at the end - DX-MON
-
Hey guys I'm working on a little personal project, a code snippet manager. I want it to be portable but I have no idea which portable database to use. I'm writing it in C# under DotNet 3.5 Any suggestions?
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111SQLite is horrible with respect to features. There aren't even foreign keys on this thing, transactions and all. If you go with something that small, you could as well do binary serialization to file and then use Linq to object + some data structures to query things. I'd go for SQL Compact for which you can even do Linq to SQL using sqlmetal. It works very well, and it's deployable easily on Windows CE and clickonce applications. If performance doesn't cut it (because both SQLite and SQLCE are very very slow) I'd go with Firebird and hand coded queries. Firebird is actually fantastic when you look at the feature list. A very complete DBMS.