Portable DB Suggestions?
-
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• My personal 24/7 webcam - Always live ;-) • Zeta Producer Desktop CMS - Intuitive, completely easy-to-use CMS for Windows. • Zeta Helpdesk - Open Source ticket software for Windows and web. • Zeta Uploader - Easily send large files by e-mail. Windows and web client.
-
• My personal 24/7 webcam - Always live ;-) • Zeta Producer Desktop CMS - Intuitive, completely easy-to-use CMS for Windows. • Zeta Helpdesk - Open Source ticket software for Windows and web. • Zeta Uploader - Easily send large files by e-mail. Windows and web client.
ummmmmm how is paying that much going to make sense for a personal project? im just curious :confused:
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
-
ummmmmm how is paying that much going to make sense for a personal project? im just curious :confused:
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
They have a free edition, also. http://vistadb.net/vistadb3/vistadb-editions.aspx[^]
• My personal 24/7 webcam - Always live ;-) • Zeta Producer Desktop CMS - Intuitive, completely easy-to-use CMS for Windows. • Zeta Helpdesk - Open Source ticket software for Windows and web. • Zeta Uploader - Easily send large files by e-mail. Windows and web client.
-
Well... the app I'm currently working on has to index meta-data for 10,00 to 100,000 files. The excess XML garbage would be insane where as a SQLite DB is only 3-10MB
// Steve McLenithan
I'm with Todd. Steve, if you are sure that future releases of the program will maintain the DB the same simple way as you described I will say XML. But keep in mind, as you know that accessing data in XML is less efficient than normal DB engine. So your decision is about "portability" VS "peace of mind" ;) .
Redwan Al-Bougha
-
They have a free edition, also. http://vistadb.net/vistadb3/vistadb-editions.aspx[^]
• My personal 24/7 webcam - Always live ;-) • Zeta Producer Desktop CMS - Intuitive, completely easy-to-use CMS for Windows. • Zeta Helpdesk - Open Source ticket software for Windows and web. • Zeta Uploader - Easily send large files by e-mail. Windows and web client.
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"
-
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 111111Harvey 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
-
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
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.
-
If you want portable, go with SQLite. 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 TorvaldsIs 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
-
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 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 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.
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.
-
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