DB: using MySQL

Discussion in 'Helium Music Manager Feature Requests' started by hubertk, Feb 11, 2004.

  1. hubertk New Member

    DB: using MySQL

    Speaking of databases: why can't we use mysql? Frogive me, I don't know much about databases, it is just a question since I read that mysql is one of the best db engines out there.

    Hubert.
  2. Mikael Stalvik Administrator

    We are evaluating the possibilities, but at the moment we havent found a version of MySQL that supports everything we need.

    The main problem with MySQL is that the different versions are good on separate things, but no one (yet) is good at all.

    That's just a question of time anyway.
  3. seaeye New Member

    by the way - i believe postgreSQL is far better than mySQL (even it's more popular). foreign keys and constraints in mySQL simply suck.
  4. Mikael Stalvik Administrator

    Yes, but postgreSQL isn't free (afaik).
    MySQL is also much more widely used.
  5. seaeye New Member

  6. H2O New Member

    MySQL would be MUCH better. Specially for us budding PHP coders. The possibilities will be endless if Helium's database were using MySQL.
  7. henc Member

    :arrow: My vote would be for MySQL also.
  8. rover New Member

    db

    My vote would be an Oracle 10g database :lol:
  9. kittelmann New Member

    And I'd vote for MsSQLServer. It isn't free either, but neither is Helium2...
    MsSQLServer has a SQL syntax that is really close to MsAccess, so it is perhaps the easiest database to start with...

    Well, we can see that there are many different opinions here, but it feels like we all agree on that it would be good to have Helium2 use at least some good database...

    /Nicklas
  10. Wabiloo Member

    Can't believe that.
    I'm a PHP programmer as well, and I always go for Postgres, rather than shitty-MySQL.
    You can do exactly the same things at the PHP level, but at least you've got a _real_ relational database with Postgres, so much more powerful!
  11. Mikael Stalvik Administrator

    Why not Interbase/Firebird. It's free, it adds a lot of overhead just as Oracle/MsSQL/etc etc :twisted:
  12. H2O New Member

    I do prefer Postgres. Still MySQL has been accepted and used universaly as an outstanding free database. And because of that, more people use it and you can find much more support for it.

    Either way, MySQL can do what Helium 2 needs. That's what matters. Not nessesarily which database is the best overall.
  13. Wabiloo Member

    Postgres _is_ free
    Postgres _can_ do what Helium2 needs

    Postgres _is_ much more powerful than MySQL
    MySQL _is not_

    Anyway, not exactly the forum to discuss that sort of things.
    I don't see why people want MySQL for Helium2, unless there is a plan to offer Helium2 under Linux
  14. Mikael Stalvik Administrator

    At the moment it cannot. It still have some issues with sub-selects and some join operations. But, it's probably just a matter of time.

    Yes, but I haven't found any (free) ADO driver for it. No time to look at it at the moment any way.
  15. Wabiloo Member

  16. Mikael Stalvik Administrator

    Thanks, but that's and ADO.NET driver. Helium 2 is not yet ported to .NET :)
    (...which would mean that we had to include a bloated framework in the installer, something like 50+ Mb.. But, probably needed someday)
  17. H2O New Member

    Yes, but I haven't found any (free) ADO driver for it. No time to look at it at the moment any way.[/quote:1x1gxinv]

    OK! Let's use Postgres then. I just want to see Helium 2's database in way that is accesible to me with PHP. Thanks for the help Waloo.

    Hum...
  18. Mikael Stalvik Administrator

    It should be possible to create an ODBC connection to Helium 2's database today (since it's an Access database this should be an easy task)
  19. vanbuuren New Member

    I am using Helium 2 1.7 EVAL and there is something I don't understand. When I open the file: helium2.mdb. There is no data inside of it (I have include 2 volumes in Helium2).

    Actually almost all the tables have been modified the last time in 2001... When I open the program Helium2 I notice there is : helium2.ldb and dbe.ldb so it means helium2 is using this database..

    So I am wandering myself:
    How can I use ASP or PHP to have a web front end ? Is it because I am using a eval version of this app? I am planning very soon to buy the registered version, but I would like to know more about this.

    Thanks. :wink:
  20. Fredrik Heidgert Administrator

    Helium 2's database is the .hdf file. Rename it to .mdb or open it directly in Access to view its contents.

Share This Page