Post #137,723
1/25/04 8:59:22 PM
|
VB and MySQL
Oddly enough there is a web site devoted to both:
[link|http://www.vbmysql.com/|http://www.vbmysql.com/]
Interesting to me, as I want to find an alternative to Access and SQL Server/MSDE that can be used in VB products.
"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"
|
Post #137,725
1/25/04 9:01:52 PM
|
Re: VB and MySQL
Anyone here who knows (not me) will tell you that postgres is superior to MySQL. There's your alternative.
-drl
|
Post #137,726
1/25/04 9:15:06 PM
|
Postgres
Great but I cannot find a Win32 Native port of Postgres that does not require Cygwin or something to run it in.
I suppose I could install Cygwin, but it would require anyone running the VB program to install it to get the VB program to work. Also if I used MySQL they would have to download and install MySQL as I cannot redistribute that either. I think I have to buy a MySQL license to make closed apps that access it, as VB apps cannot be open sourced according to MS's EULA.
"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"
|
Post #137,727
1/25/04 9:21:11 PM
|
Re: Postgres
You've got 891 legacy machines, set up a Linux database server. I guarantee you Win32 databases are as good as dead.
-drl
|
Post #137,745
1/25/04 11:20:14 PM
|
Depends on who the target of the program is
if it is a single user, with one machine. It cannot be a Linux server too. If it is a small business, a Linux server can be set up for them.
"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"
|
Post #137,746
1/25/04 11:24:30 PM
|
Re: Depends on who the target of the program is
In any real world scenario, even for a small business, if a real database is needed it will live on its own machine.
-drl
|
Post #137,785
1/26/04 9:57:28 AM
|
? Um, don't think so.
deSitter pontificates:
I guarantee you Win32 databases are as good as dead.
MS Sql Server is hardly "as good as dead".
bcnu,
Mikem
I don't do third world languages. So no, I don't do Java.
|
Post #137,728
1/25/04 9:33:37 PM
|
The superiority is a function of what you're trying to do
MySQL is fast, very fast. MySQL is easy, very easy to set up.
However, the last I checked, it didn't have stored procedures, referential integrity, transaction processing, etc.... Though MySQL has stated that they are leaning in that direction.
I more valid comparison would be that MySQL is to PostgreSQL, as MSAccess is to SQLServer. In the MS world, there are times to use Access and times to use SQLServer.
|
Post #137,733
1/25/04 10:56:38 PM
|
A possibly more appropriate alternative for you
[link|http://www.ag-software.com/sqlite.aspx|http://www.ag-software.com/sqlite.aspx]
Its database is even worse than Microsoft Access, but it is free, setup is loads easier (even easier than MySQL), it doesn't require configuring a database server etc, and it can be stuck in proprietary products without worrying about license issues.
Cheers,
Ben
"good ideas and bad code build communities, the other three combinations do not"
- [link|http://archives.real-time.com/pipermail/cocoon-devel/2000-October/003023.html|Stefano Mazzocchi]
|
Post #137,749
1/25/04 11:28:53 PM
|
Thanks I will research it
I had an idea to create VB apps with a UDL file that can be set to access a certain different types of databases. Then create SQL code for each database and access them via Case statements to select the right SQL query to use. Store the type of database used in a global variable and use that to select the connection, the SQL statements, cursors used, etc. That way the user can start out with one database, migrate to another, set a switch and change a UDL file and start using a more powerful database. I might even put in code to do the migration for them. :)
"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"
|
Post #137,762
1/26/04 4:53:21 AM
|
<SIGH>...
[link|http://firebird.sourceforge.net/|http://firebird.sourceforge.net/]
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
You know you're doing good work when you get flamed by an idiot. -- [link|http://www.theregister.co.uk/content/35/34218.html|Andrew Wittbrodt]
|
Post #137,804
1/26/04 11:19:54 AM
|
Downloading it now
I was hoping for finding a resource on the web that talked about VB and the database like VBMYSQL.COM did. But now it seems like I have several databases to learn and use. :)
1.5 RC being downloaded. Hope it has good documentation and an ODBC driver. I may need the ODBC driver to synch databases with MobileVB and Hand Held devices like PalmOS, Windows CE, and Ericsson phones. MobileVB can synch with a database provided it has an ODBC driver on the host PC.
"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"
|
