SQL queries?
Community Forums/General Help/SQL queries?
| ||
| What SQL queries software should I look for when come storing data? |
| ||
| Do you mean "which RDBMS should I use"? An SQL query will be very similar whether it's for SQL Server, Oracle, MySQL or whatever else. Anyway, to give an answer based on the extent of the question - MySQL. |
| ||
| 100% depends on what you want to do with it. There's $$$$ enterprise solutions like Oracle, there's free open source solutions like MySQL, and for quick and dirty small databases there's even SQLite, which is feature-limited but nice because you don't need any 3rd party database software installed. A stand-alone blitzmax app can create & maintain its own SQLite database with Bruceys modules, without additional external dependencies. |
| ||
| which one is easiest to used? MySQL or SQLite? |
| ||
| Again, depends on what you want to do with it. SQLite is 'easier' in that it has less commands and therefore easier to learn. SQLite is 'harder' because it doesn't have the full feature set that MySQL and the others do, so you may need to work around some of the limitations. That said, if all you need is a BASIC database, SQLite is nice -- especially since you don't need any 3rd party engines installed to actually make use of the database, it's all self-contained. (You still have the option of course, e.g. you can install the SQLite manager tool which will be able to open/change your DBs) |
| ||
| From my (limited) experience MySQL Community Edition is the most obvious choice: It will scale. It's free It has an enterprise version It's fully featured. It's well supported and has plenty of connectors. It is well tested with millions of real world instances. Really does depend what you are doing with it though. Darkheart |
| ||
| Download Xampp. http://apachefriends.org It's easy to install, easy to setup, and comes with PHPMyAdmin & MySQL. |
   |