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 -
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 111111You could go with SQL Server CE or FireBirdSQL.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
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 hands down. There's a complete .net connector for it.
// Steve McLenithan -
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 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 Torvalds -
SQLite hands down. There's a complete .net connector for it.
// Steve McLenithanSteve McLenithan wrote:
SQLite
This looks like just what I've been looking for. Thanks.
Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems
I'm on-line therefore I am. JimmyRopes -
SQLite hands down. There's a complete .net connector for it.
// Steve McLenithan -
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 111111XML file. I mean how much data can you really create? Go LINQ!
Todd Smith
-
XML file. I mean how much data can you really create? Go LINQ!
Todd Smith
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
-
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
But he's working on "a personal little project for code snippets".
Todd Smith
-
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