if MySQL were like MSDE

MSDE, I can distribute it with 3rd party toold like Installshield (to
distribute means: to auto install without user interference, auto
execute SQL DDL ).

How can MySQL do that? ( MySQL Desktop Engine maybe :p )

Thank you

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

----- Original Message -----
From: "ody quraviharto"
To:
Sent: Wednesday, June 15, 2005 4:47 PM
Subject: if MySQL were like MSDE


> MSDE, I can distribute it with 3rd party toold like Installshield (to
> distribute means: to auto install without user interference, auto
> execute SQL DDL ).
>
> How can MySQL do that? ( MySQL Desktop Engine maybe :p )
>
> Thank you
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=greg@i-online.co.za
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

First, what's the point of having a database if your app use it
locally?! (except of course, for testing) Use file storage instead :P
Second, I could not see the point on your comment about a proprietary,
expensive and unportable DBE on this list, I find it rude and totally
off topic.
Third, I've seen NSIS Installs that install, configure and run MySQL
for testing purposes on a distributed app I developed last year. MySQL
Team made a wizard for Windows install, so, its possible.

On 6/15/05, ody quraviharto wrote:
> MSDE, I can distribute it with 3rd party toold like Installshield (to
> distribute means: to auto install without user interference, auto
> execute SQL DDL ).
>=20
> How can MySQL do that? ( MySQL Desktop Engine maybe :p )
>=20
> Thank you
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

if you want MSDE, then use it, MySql is excellent, and
cheap, and has a lot less bugs!!!!



--- Daniel da Veiga wrote:

> First, what's the point of having a database if your
> app use it
> locally?! (except of course, for testing) Use file
> storage instead :P
> Second, I could not see the point on your comment
> about a proprietary,
> expensive and unportable DBE on this list, I find it
> rude and totally
> off topic.
> Third, I've seen NSIS Installs that install,
> configure and run MySQL
> for testing purposes on a distributed app I
> developed last year. MySQL
> Team made a wizard for Windows install, so, its
> possible.
>
> On 6/15/05, ody quraviharto
> wrote:
> > MSDE, I can distribute it with 3rd party toold
> like Installshield (to
> > distribute means: to auto install without user
> interference, auto
> > execute SQL DDL ).
> >
> > How can MySQL do that? ( MySQL Desktop Engine
> maybe :p )
> >
> > Thank you
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
>
http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
>
>




__________________________________
Discover Yahoo!
Get on-the-go sports scores, stock quotes, news and more. Check it out!
http://discover.yahoo.com/mobile.html

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

> First, what's the point of having a database if your app use it
> locally?!

What kind of database would you use for an email client application that has
10000 email headers to pull out in a split second?

Do you think file storage would be fast enough for this? Also what about
needing joins across various file dbs? How can one do this?

Thanks


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

Hi,
What to do if your msde database is bigger than 2GB ? bye SQLServer ?
with mysql you can. So the choice is only yours.

depend on you have a lot of money or not.

Mathias

Selon Greg Quinn :

> > First, what's the point of having a database if your app use it
> > locally?!
>
> What kind of database would you use for an email client application that has
> 10000 email headers to pull out in a split second?
>
> Do you think file storage would be fast enough for this? Also what about
> needing joins across various file dbs? How can one do this?
>
> Thanks
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=mfatene@free.fr
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

I think people missed his point. His wording may not of been clear, but
I dont think he was insulting mysql, but simply asking how to intall
mysql using a simple distribution tool as can be done using MSDE



Mark Mchugh wrote:

> if you want MSDE, then use it, MySql is excellent, and
> cheap, and has a lot less bugs!!!!
>
>
>
> --- Daniel da Veiga wrote:
>
>
>>First, what's the point of having a database if your
>>app use it
>>locally?! (except of course, for testing) Use file
>>storage instead :P
>>Second, I could not see the point on your comment
>>about a proprietary,
>>expensive and unportable DBE on this list, I find it
>>rude and totally
>>off topic.
>>Third, I've seen NSIS Installs that install,
>>configure and run MySQL
>>for testing purposes on a distributed app I
>>developed last year. MySQL
>>Team made a wizard for Windows install, so, its
>>possible.
>>
>>On 6/15/05, ody quraviharto
>>wrote:
>>
>>>MSDE, I can distribute it with 3rd party toold
>>
>>like Installshield (to
>>
>>>distribute means: to auto install without user
>>
>>interference, auto
>>
>>>execute SQL DDL ).
>>>
>>>How can MySQL do that? ( MySQL Desktop Engine
>>
>>maybe :p )
>>
>>>Thank you
>>>
>>>--
>>>MySQL Windows Mailing List
>>>For list archives: http://lists.mysql.com/win32
>>>To unsubscribe:
>>
> http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>>>
>>
>>--
>>Daniel da Veiga
>>Computer Operator - RS - Brazil
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe:
>>
>
> http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
>
>>
>
>
>
>
> __________________________________
> Discover Yahoo!
> Get on-the-go sports scores, stock quotes, news and more. Check it out!
> http://discover.yahoo.com/mobile.html
>


--
David Patte
Relative Data, Inc.
http://relativedata.com/
24hr. Bus. Phone/Fax: 1 (613) 728-4240

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

Greg Quinn wrote:
>> First, what's the point of having a database if your app use it
>> locally?!
>
>
> What kind of database would you use for an email client application that
> has 10000 email headers to pull out in a split second?
>
> Do you think file storage would be fast enough for this? Also what about
> needing joins across various file dbs? How can one do this?
>
> Thanks
>
>
Databases are not magic they also store data in files. Anything MySQL
does your application can also do. In theory if you are writing a single
user app it will be faster to use a custom database local file solution
optimized for your application than to use a general use database
server. Using a database server is nice because the server is hopefully
mature code and it is already available.

That being said you have some options. Yes you can install MySQL with an
installer. Or you could use SQLLite. Or you can use local ISAM files or
hash tables or any combination of the above.
With modern machines you could probably just load 10,000 email headers
all in to memory and use STL to handle it as well. Even if each one k
you are only talking about 10 megs of data which these days is
nothing... CHOKE....
Of course I worked on system with 5k so it really hurts for me to say that.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

Yeah, David is right.
Besides, if you get the zipped version of MySQL, create a special
config file that will tell MySQL to use named pipes and skip
networking (and any other options), you can use an installer to unzip
the files, run the service or mysqld (deppending on OS version, you'll
either create a service or use the registry to run it everytime the
machine starts) that will get the options of the config file, and use
any MySQL library for your specific language that will connect to the
named pipe and deal with data. Simple, fast, portable and free.

On 6/15/05, David Siebert wrote:
> Greg Quinn wrote:
> >> First, what's the point of having a database if your app use it
> >> locally?!
> >
> >
> > What kind of database would you use for an email client application tha=
t
> > has 10000 email headers to pull out in a split second?
> >
> > Do you think file storage would be fast enough for this? Also what abou=
t
> > needing joins across various file dbs? How can one do this?
> >
> > Thanks
> >
> >
> Databases are not magic they also store data in files. Anything MySQL
> does your application can also do. In theory if you are writing a single
> user app it will be faster to use a custom database local file solution
> optimized for your application than to use a general use database
> server. Using a database server is nice because the server is hopefully
> mature code and it is already available.
>=20
> That being said you have some options. Yes you can install MySQL with an
> installer. Or you could use SQLLite. Or you can use local ISAM files or
> hash tables or any combination of the above.
> With modern machines you could probably just load 10,000 email headers
> all in to memory and use STL to handle it as well. Even if each one k
> you are only talking about 10 megs of data which these days is
> nothing... CHOKE....
> Of course I worked on system with 5k so it really hurts for me to say tha=
t.
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: if MySQL were like MSDE

My app use MySQL, so the question for me is, how do you go
about bundling MySQL into the installation of your app?

I'm using InstallShield to install the app and I'm not clear
on how to add the MySQL install to it so that MySQL is
installed with a minimum of customer intervention.

Fred


-----Original Message-----
From: mfatene@free.fr [mailto:mfatene@free.fr]
Sent: Wednesday, June 15, 2005 10:57 AM
To: Greg Quinn; Greg Quinn
Cc: win32@lists.mysql.com
Subject: Re: if MySQL were like MSDE

Hi,
What to do if your msde database is bigger than 2GB ? bye
SQLServer ?
with mysql you can. So the choice is only yours.

depend on you have a lot of money or not.

Mathias

Selon Greg Quinn :

> > First, what's the point of having a database if your app
use it
> > locally?!
>
> What kind of database would you use for an email client
application
> that has 10000 email headers to pull out in a split
second?
>
> Do you think file storage would be fast enough for this?
Also what
> about needing joins across various file dbs? How can one
do this?
>
> Thanks
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=mfatene@free.fr
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=fred_ballard@mverify.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: if MySQL were like MSDE

Well, if you already use MySQL, you can do as I wrote in my previous
email, use named pipes and skip networking to avoid people playing
with your MySQL server from the Internet and change a bit of code (the
connection string probably), and you're done.

(the first email should have been written in a way I couldn't think of
it as offensive and off topic, people really should read the "how to
ask questions guide")

Good luck,

On 6/15/05, Fred Ballard wrote:
>=20
> My app use MySQL, so the question for me is, how do you go
> about bundling MySQL into the installation of your app?
>=20
> I'm using InstallShield to install the app and I'm not clear
> on how to add the MySQL install to it so that MySQL is
> installed with a minimum of customer intervention.
>=20
> Fred
>=20
>=20
> -----Original Message-----
> From: mfatene@free.fr [mailto:mfatene@free.fr]
> Sent: Wednesday, June 15, 2005 10:57 AM
> To: Greg Quinn; Greg Quinn
> Cc: win32@lists.mysql.com
> Subject: Re: if MySQL were like MSDE
>=20
> Hi,
> What to do if your msde database is bigger than 2GB ? bye
> SQLServer ?
> with mysql you can. So the choice is only yours.
>=20
> depend on you have a lot of money or not.
>=20
> Mathias
>=20
> Selon Greg Quinn :
>=20
> > > First, what's the point of having a database if your app
> use it
> > > locally?!
> >
> > What kind of database would you use for an email client
> application
> > that has 10000 email headers to pull out in a split
> second?
> >
> > Do you think file storage would be fast enough for this?
> Also what
> > about needing joins across various file dbs? How can one
> do this?
> >
> > Thanks
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dmfatene@free.fr
> >
> >
>=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dfred_ballard@mverify.co m
>=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: if MySQL were like MSDE

=20
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

well,there're several ways...
- - run the mysql msi-setups as embedded packages from your =
install-shield setup, the mysql-setups can be run as =
unattended-installations (switches -quiet or -passive)
- - build a mysql-msm-merge module and merge it with your install-shield =
project (we choosed this approach for our applications - feel free to =
use our modules as a starting-point =
http://www.aegaeon.de/downloads/mysql
- - create a custom action within install-shield, that e.g. unpacks a =
mysql-zip-archive and creates a customized my.ini
install the mysql-service by help of install-shield functions.

regards,
armin.

> -----Original Message-----
> From: Fred Ballard [mailto:fred_ballard@mverify.com]=20
> Sent: Wednesday, June 15, 2005 6:35 PM
> To: win32@lists.mysql.com
> Subject: RE: if MySQL were like MSDE
>=20
> =20
> My app use MySQL, so the question for me is, how do you go=20
> about bundling MySQL into the installation of your app?
>=20
> I'm using InstallShield to install the app and I'm not clear=20
> on how to add the MySQL install to it so that MySQL is=20
> installed with a minimum of customer intervention.
>=20
> Fred
>=20
>=20
> -----Original Message-----
> From: mfatene@free.fr [mailto:mfatene@free.fr]
> Sent: Wednesday, June 15, 2005 10:57 AM
> To: Greg Quinn; Greg Quinn
> Cc: win32@lists.mysql.com
> Subject: Re: if MySQL were like MSDE
>=20
> Hi,
> What to do if your msde database is bigger than 2GB ? bye SQLServer ?
> with mysql you can. So the choice is only yours.
>=20
> depend on you have a lot of money or not.
>=20
> Mathias
>=20
> Selon Greg Quinn :
>=20
> > > First, what's the point of having a database if your app
> use it=20
> > > locally?!
> >
> > What kind of database would you use for an email client
> application=20
> > that has 10000 email headers to pull out in a split
> second?
> >
> > Do you think file storage would be fast enough for this?
> Also what=20
> > about needing joins across various file dbs? How can one
> do this?
> >
> > Thanks
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32 To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dmfatene@free.fr
> >
> >
>=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dfred_ballard@mverify.co m
>=20
>=20
>=20
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =20
> http://lists.mysql.com/win32?unsub=3Darmin.schoeffmann@aegae on.de
>=20
>=20
>=20
>=20
-----BEGIN PGP SIGNATURE-----
Version: PGP 8.1

iQA/AwUBQrBjbKNO89lN2K3lEQJGNwCgt5RZMpsqRuppEE3m+pyk10B02lIA niYv
PIgqGtRUN9JhEGyn3AVzyMca
=3D8y8+
-----END PGP SIGNATURE-----

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org