Help me choose a database engine... -...

User 772771 Photo


Registered User
15 posts

Here's the current situation;
Desktop app written in VB6/VB.NET with a proprietry BTREE indexing system linked to Random Access files.
Has worked flawlessly for ages.

A requirement has arisen whereby I need to have a browser interface to the data. I have written my own HTTP server in VB.NET and it runs on the desktop serving up content nicely

It is now becoming aparent that I need to leave VB.NET behind and jump to an Apache based server and database solution.

Any suggestions. MySQL looks popular but it is expensive

Cheers
User 187934 Photo


Senior Advisor
20,181 posts

Mysql is open source so it's free.:)
http://www.mysql.com/
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 603315 Photo


Registered User
938 posts

Yeah Eric is right on that Nigel. Apparently MySQL and PHP according to Web Designer mag we have over here Nigel so you may know it, suggests that 2014 is really going to be something for these technologies. I've coded in PHP, but no way an expert, but not to use it as Database.
User 772771 Photo


Registered User
15 posts

Eric, MySQL is not free for commercial deployments. I had a long conversation with MySQL, their Enterprise solution starts at $5000.00 per year!

Unless you know otherwise...

Nigel
User 187934 Photo


Senior Advisor
20,181 posts

Where are you using it? I get it on my host included.:)
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2147626 Photo


Ambassador
2,958 posts

Nigel, this says it all. This is from http://mysql.com
http://gunsmoke.me/cloud/mysql.png

MySql is open source. Free for everyone. But, there are many many tools that you can 'purchase' to make working with MySql easier. There are also a lot of free tools. You just have to use Google and look around. There should never be a reason to purchase anything to use MySql. It's just up to you. :cool:
Graphics for the web, email, blogs and more!
-------------------------------------
https://sadduck.com
User 474778 Photo


Registered User
215 posts

Be sure to look into MariaDB, too. It's a drop-in replacement for MySQL, even down to the level of working properly with management tools originally created for MySQL, such as phpMyAdmin. Neither the tools nor your application will know the difference, except that they will run at least as quickly and efficiently.

For a nice development stack right on your desktop, please look into WAMP (for Windows) and lamp-server^ (for Debian Linux and its descendants). However, each of these provides a MySQL server rather than MariaDB.
halfnium -AT- alum.mit.edu
Yes, I looked just like that in 1962.

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.