free database server for desktop application with ado.net driver

  • Thread starter Thread starter Luminal
  • Start date Start date
L

Luminal

greetings

I need to develop an aplication that needs a database. The application
is small and the use of SQL Server is not a choice. Can anyone give me
hists about *free* database engines with ado.net support?

TIA

Lum
 
Patty O'Dors said:
MySQL is poor as it's GNU-based. This means you have to compile it yourself
from files that can only be downloaded from bizarre linux ftp servers. As
such, for most people it's not *actually* an option.

What are you talking about? Who said anything about Linux?

First of all, there are precompiled binaries available for MANY different OS's, including various flavors of Linux.
Might want to look at:
http://dev.mysql.com/downloads/mysql/4.0.html
before you make a statement like that. Of the probably over 50 different packages available for download there, only 3 are source.

Second, as this is a primarily windows-using newsgroup (Mono isn't quite that big yet), it is a safe assumption that, unless stated
otherwise, we are discussing Windows.

And, even if there WEREN'T any compiled binaries available... this is a DEVELOPMENT newsgroup... if you can't compile source code
you probably have some other problems to see to first.

Adam Clauss
(e-mail address removed)
 
Luminal said:
the application is commercial. on this scenation does mysql still free?

Most likely not, see:
http://www.mysql.com/products/licensing/commercial-license.html

How high performance does the database need to be?

There is JET (basically just using an Access database) that Ivan mentioned, also you could use MSDE (kind of a "free" version of SQL
Server). My guess (though I do not actually have any facts to base this on) is that JET is somewhat slower than MSDE, but is more
"self-contained" (simply an .mdb file).

For information on MSDE, try:
http://www.microsoft.com/sql/msde/default.asp
 
« How high performance does the database need to be?»

just a few records: less than 700. I think this is much for JET (.mdb
file) isnt it? Specially the text fields...
 
Luminal said:
« How high performance does the database need to be?»

just a few records: less than 700. I think this is much for JET (.mdb
file) isnt it? Specially the text fields...

With that many records, I would think either JET or MSDE would work just fine for you.
 
What are you talking about? Who said anything about Linux?

MySQL is widely known to be a GNU/linux-based project. Don't anybody be
fooled. I know.
First of all, there are precompiled binaries available for MANY different OS's,

If it's produced for many different operating systems, it's a bit like
saying it's "Jack of all trades, master of none".
The advert "works on many different operating systems" is a synonym for it
being largely linux-based - what with all these 'solaris' and 'OS/2' and 'arm
elf' builds, etc...eeeurgghh!!!
You do realise that the main pleasure people get out of these programs is
simply being able to get them to compile on their particular version of linux
on the particular processor they've got, and discussing the trials and
tribulations of their silly little compilation capers on various stupid
weblogs that clutter up google ?
Of course, many of the different versions of linux can each be worked on
many the weird hybrid processor varieties, further adding to the delight they
take in confusing windows users with the umpteen different combinations of
compilation settings that ensues.

including various flavors of Linux.
Might want to look at:
http://dev.mysql.com/downloads/mysql/4.0.html
before you make a statement like that. Of the probably over 50 different packages available for download there, only 3 are source.

I don't want to get into surfing these people's web pages. It's a bottomless
pit, that leads nowhere. If MySQL is that good, why are there FIFTY different
packages? I'll tell you why - they don't all work. You have to hunt for the
one that does. But then again, that's obviously what GNU fans think the fun
of computing revolves around.

Second, as this is a primarily windows-using newsgroup (Mono isn't quite that big yet), it is a safe assumption that, unless stated
otherwise, we are discussing Windows.

Well, maybe you shouldn't raise the topic of linux and GNU-based programs
like MySQL then. (Not saying YOU personally did... but someone did)
And, even if there WEREN'T any compiled binaries available... this is a DEVELOPMENT newsgroup... if you can't compile source code
you probably have some other problems to see to first.

I am perfectly capable of writing AND compiling source code, and complex
source code at that - but that doesn't mean I should be any good at building
GCC or MySQL or any other stupid GNU-based program. I don't have to be - if i
don't ENJOY downloading it and compiling it, I can't see where it's going to
actually GET me in anything less than a matter of years, that a windows
program won't in a few minutes...

After all, if a program's had salaried programmers working on it, who've
still got a wife and kids to feed if they get the sack for the program not
being good enough or not working, they're going to make damn sure it works
and that the version that works is the only one that gets released. These
open source - yes, ok anybody may be able to improve on it. But at the end of
the day, the ones that are going to be able to improve on it best have
probably got other, more lucrative things to do.

They don't have anybody to answer to if it doesn't work, as no-one's paid
them any money. Stands to reason that it's not going to work!
 
Patty O'Dors said:
MySQL is widely known to be a GNU/linux-based project. Don't anybody be
fooled. I know.
I've used MySQL on Windows since its 3.x days, it works just fine. So what if it is GNU and supports linux? It supports Windows
too. So what? What is it we are supposed to not be "fooled" about? And what is it that "you know" that apparently is so bad?
If it's produced for many different operating systems, it's a bit like
saying it's "Jack of all trades, master of none".
The advert "works on many different operating systems" is a synonym for it
being largely linux-based - what with all these 'solaris' and 'OS/2' and 'arm
elf' builds, etc...eeeurgghh!!!
Uh... that is the way software works on Linux. It needs to be compiled individually for the different ones. There simply isn't
"one" kind of linux executable. And again, so what if there are tons of different linux builds. We don't need them... just go to
the one that says "Windows", it really isn't that hard.
You do realise that the main pleasure people get out of these programs is
simply being able to get them to compile on their particular version of linux
on the particular processor they've got, and discussing the trials and
tribulations of their silly little compilation capers on various stupid
weblogs that clutter up google ?
Yes, people who have problems compiling it post about it because they want their own optimizations. Again, so what. That is
exactly what we are doing here, only with C# instead of MySQL.
Of course, many of the different versions of linux can each be worked on
many the weird hybrid processor varieties, further adding to the delight they
take in confusing windows users with the umpteen different combinations of
compilation settings that ensues.
You're missing the point - you do not have to compile it yourself. So who cares about different compilation settings. If one is
intelligent and cares to learn them, then they are there. If not, you take the precompiled binary labelled "Windows" and go with
it.
source.

I don't want to get into surfing these people's web pages. It's a bottomless
pit, that leads nowhere. If MySQL is that good, why are there FIFTY different
packages? I'll tell you why - they don't all work. You have to hunt for the
one that does. But then again, that's obviously what GNU fans think the fun
of computing revolves around.
"These people" LOL you act as if they are a bunch of criminals or something. What do you mean it is a bottomless pit that leads
nowhere? It most definately leads somewhere!
There are 50 different packages because they have taken the time to COMPILE it for many different platforms - so people do not have
to do it themselves!!! This is exactly what you wanted!

Point one out that does not work. There is no hunting involved. You go to the one for the platform you need and you download it.
Well, maybe you shouldn't raise the topic of linux and GNU-based programs
like MySQL then. (Not saying YOU personally did... but someone did)

Yes, someone did. You. MySQL is not "linux based". It is C++ source code. It is not based on anything until it is compiled. It
is just as much Windows, or Solaris, Mac, or FreeBSD based as it is Linux. Or "any-of-the-other-platforms-they-list"-based.
I am perfectly capable of writing AND compiling source code, and complex
source code at that - but that doesn't mean I should be any good at building
GCC or MySQL or any other stupid GNU-based program. I don't have to be - if i
don't ENJOY downloading it and compiling it, I can't see where it's going to
actually GET me in anything less than a matter of years, that a windows
program won't in a few minutes...
The MySQL source package comes with Visual Studio projects setup. You load it and click build. No GCC involved. If you cannot do
that, you probably should using C#.
Or like I said earlier, YOU JUST DOWNLOAD THE WINDOWS INSTALLER FOR IT!!! NO COMPILING REQUIRED!!
After all, if a program's had salaried programmers working on it, who've
still got a wife and kids to feed if they get the sack for the program not
being good enough or not working, they're going to make damn sure it works
and that the version that works is the only one that gets released. These
open source - yes, ok anybody may be able to improve on it. But at the end of
the day, the ones that are going to be able to improve on it best have
probably got other, more lucrative things to do.

They don't have anybody to answer to if it doesn't work, as no-one's paid
them any money. Stands to reason that it's not going to work!
If you truly knew anything about MySQL you would understand how pointless that last paragraph was. MySQL is distributed under the
GNU ONLY for applications which are also open sourced and free. If it is a commercial application, you have to pay for it!


Please, make sure you know what you are talking about before you start insulting software. Making baseless accusations is not going
to get you anywhere in this world.
 
I've used MySQL on Windows since its 3.x days, it works just fine. So what
if it is GNU and supports linux? It supports Windows
too. So what? What is it we are supposed to not be "fooled" about? And what is it that "you know" that apparently is so bad?

If it works at all on linux, it isn't optimized for windows. Like SQL server
is. Yes - it may be *OK* - and in some situations it can probably be proved
to work satisfactorily. But I like things to be more than just OK, thanks
very much.
Uh... that is the way software works on Linux. It needs to be compiled individually for the different ones. There simply isn't
"one" kind of linux executable.

Er... well that isn't windows's problem!
And again, so what if there are tons of different linux builds. We don't need >them... just go to
the one that says "Windows", it really isn't that hard.

Yes, people who have problems compiling it post about it because they want their own optimizations. Again, so what. That is
exactly what we are doing here, only with C# instead of MySQL.

Yes, but a lot of the people here, myself included, are working on business
applicaitons that are actually going to get them somewhere, or allow a
company to produce some information or that it didn't have before. The MySQL
"researchers" are basically just trying to reinvent the wheel in order to
pursue their vain attempt to prove that anything that windows can do, linux
can also do... I just don't see the point in doing that. Linux is fine for
some things, web servers for instance - Google runs on linux! Just not
hardcore databases and programming languages!
You're missing the point - you do not have to compile it yourself. So who cares about different compilation settings. If one is
intelligent and cares to learn them, then they are there. If not, you take the precompiled binary labelled "Windows" and go with
it.

They always make it clear though, that the precompiled binary is distinctly
worse, or an "old version".

"These people" LOL you act as if they are a bunch of criminals or something. What do you mean it is a bottomless pit that leads
nowhere? It most definately leads somewhere!

Er... no. It was a metaphor, for saying that it never actually *gets* you
anywhere useful. If you want to be be pedantic, I'll be exact - where it
actually gets you going is just round and round in circles.

There are 50 different packages because they have taken the time to COMPILE it for many different platforms - so people do not have
to do it themselves!!! This is exactly what you wanted!


NO it's not! I just want to see the back of these silly little "free"
schemes which aren't free at all. There's nothing wrong with the open source
movement - just can't there be some money in it? And can't they be a little
less moralistic - they're always banging on about how proprietary software is
immoral, and that 'freeware' isn't actually free as you don't get the source
code to it, well - their software is the LEAST free - who wants a program
that whenever you use it, you have to distribute THEIR sourcecode with your
program?

It's like working for a company that every evening, gets to open up your
guts and rummage around to make sure you haven't eaten any company property.
Point one out that does not work.

GCC.

There is no hunting involved. You go to the one for the platform you need
and you download it.
Yes, someone did. You. MySQL is not "linux based".


Well, you can deny it till you're blue in the face sunshine, but it won't
make it true.

It is C++ source code.

..... which is written for linux. It's probably not all written in C++, I
suspect there's a lot of delphi in there aswell.

t is not based on anything until it is compiled. It
is just as much Windows, or Solaris, Mac, or FreeBSD based as it is Linux. Or "any-of-the-other-platforms-they-list"-based.

...then that brings me back to my earlier point that it's jack of all trades,
master of none...

The MySQL source package comes with Visual Studio projects setup. You load it and click build. No GCC involved. If you cannot do
that, you probably should using C#.


But why would you, when MSDE is just as easy to install? And 1000 times
better, becuase it's not written by amateurs?
Or like I said earlier, YOU JUST DOWNLOAD THE WINDOWS INSTALLER FOR IT!!! NO COMPILING REQUIRED!!

If you truly knew anything about MySQL you would understand how pointless that last paragraph was. MySQL is distributed under the
GNU ONLY for applications which are also open sourced and free. If it is a commercial application, you have to pay for it!


"Open sourced and free" is a contradiction in terms! If it's open source, it
means you have to distribute their source code with it whenever you use
whatever component it is in your program, which means you have to live by
THEIR rules, which DOESN'T sound like freedom.
 
Patty O'Dors said:
If it works at all on linux, it isn't optimized for windows.
That is quite possibly the most ignorant statement I have ever heard in my life.
Er... well that isn't windows's problem!
And it isn't a problem FOR Windows either!
Yes, but a lot of the people here, myself included, are working on business
applicaitons that are actually going to get them somewhere, or allow a
company to produce some information or that it didn't have before. The MySQL
"researchers" are basically just trying to reinvent the wheel in order to
pursue their vain attempt to prove that anything that windows can do, linux
can also do... I just don't see the point in doing that. Linux is fine for
some things, web servers for instance - Google runs on linux! Just not
hardcore databases and programming languages!
You've yet to give any reason why MySQL won't get "get them there". All you've done is say it won't. I would love to actually see
some of your reasoning on this. And "it was designed for Linux" is not a reason - that is ignorance.
They always make it clear though, that the precompiled binary is distinctly
worse, or an "old version".
And where do you see this? This once again proves you do not know what you are talking about - it is exactly the opposite. If you
look at their source downloads, it has a statement right above it saying:
"For maximum stability and performance, we recommend that you use the binaries we provide."
Er... no. It was a metaphor, for saying that it never actually *gets* you
anywhere useful. If you want to be be pedantic, I'll be exact - where it
actually gets you going is just round and round in circles.
Again, how so? You make all these claims, but you have nothing to back them up!
NO it's not! I just want to see the back of these silly little "free"
schemes which aren't free at all. There's nothing wrong with the open source
movement - just can't there be some money in it?
There is - that is why the have the commercial license. It is only free for use with other software that is free. If you are using
MySQL with a commercial product YOU HAVE TO BUY IT!!!
And can't they be a little
less moralistic - they're always banging on about how proprietary software is
immoral, and that 'freeware' isn't actually free as you don't get the source
code to it, well - their software is the LEAST free - who wants a program
that whenever you use it, you have to distribute THEIR sourcecode with your
program?
Again, then purchase the product like you do other closed-source products and you get the right to not have to distribute the
source.
It's like working for a company that every evening, gets to open up your
guts and rummage around to make sure you haven't eaten any company property.
What in the hell are you talking about...

And I quote:
"Compiler Advisory: Several users have reported random crashes and table corruptions when using MySQL binaries compiled with gcc
2.96 on the x86 Linux platform. We suggest that you use gcc 2.95 or gcc 2.91 to compile your own binaries. It should also be safe to
use gcc 3.2."

If you cannot read instructions, then that is not MySQL's fault.
Well, you can deny it till you're blue in the face sunshine, but it won't
make it true. Likewise.

.... which is written for linux. It's probably not all written in C++, I
suspect there's a lot of delphi in there aswell.
Actaully, it is C/C++ w/ just a tad of assembly in there. I've compiled it.
..then that brings me back to my earlier point that it's jack of all trades,
master of none...
Being cross-platform capable does not automatically mean it is poor.
But why would you, when MSDE is just as easy to install?
Then don't - go get the binaries. And you were complaining about MySQL going in circles! Your argument is doing it!
And 1000 times
better, becuase it's not written by amateurs?
How do you assume MySQL is written by "amateurs"? There is no logic to that...
"Open sourced and free" is a contradiction in terms! How?

If it's open source, it
means you have to distribute their source code with it whenever you use
whatever component it is in your program, which means you have to live by
THEIR rules, which DOESN'T sound like freedom.
Then buy it, like you would have him do SQL server. Then you don't have to do that.
All this does is give you the OPTION. Option... thats a choice... freedom to make a choice... hmmm...
 
Back
Top