Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Finally Gave Up on MySQL

Finally Gave Up on MySQL

Scheduled Pinned Locked Moved The Lounge
phpmysqloraclesysadmin
22 Posts 10 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • realJSOPR realJSOP

    I've been trying for two weeks to get MySQL (5.0) and PHP (5.12) to play together on a 2003 Server box, and last night I gave up. I installed Oracle 10g EX, and i'm in a much better mnood about the whole thing.

    "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
    -----
    "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

    A Offline
    A Offline
    Albert Pascual
    wrote on last edited by
    #13

    Never used Oracle, I would like to know if it's better than SQL 2005. As I have been using it, however to deploy one server cost me too much money. Can you create a cluster of server in Oracle? How much is the database per server and how the cluster works? Also how fast is compared to MS SQL 2005 and do I need to change the way I perform queries in C# or ASP.NET 2.0? Al PS Well ... give me all the white papers :-) My eMail control My Blog

    realJSOPR L 2 Replies Last reply
    0
    • realJSOPR realJSOP

      I've been trying for two weeks to get MySQL (5.0) and PHP (5.12) to play together on a 2003 Server box, and last night I gave up. I installed Oracle 10g EX, and i'm in a much better mnood about the whole thing.

      "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
      -----
      "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

      S Offline
      S Offline
      Scott Lee
      wrote on last edited by
      #14

      Not to start a flame war, but is there a compelling reason to run Windows Server 2003 instead of Linux on the box? Setting up a LAMP[^] server in Linux is about as trivial as can be and it doesn't cost a dime.

      realJSOPR 1 Reply Last reply
      0
      • J Jerry Hammond

        I tried MySQL some time back...I gotta say, John, you should give SQL2005 a spin. It is so cool and with the Management Studio you should be up and running in no time. If an idiot like myself can create a database and have it running it less than 20 minutes you should be creating and deploying in no time.

        Asking someone to define CP is like asking someone to define art. To define it is to miss its true nature.

        B Offline
        B Offline
        Blue Bird 0
        wrote on last edited by
        #15

        Jerry Hammond wrote:

        If an idiot like myself can create a database and have it running it less than 20 minutes you should be creating and deploying in no time.

        Exactly, the bigger the idiot, the less time it takes.

        J 1 Reply Last reply
        0
        • S Scott Lee

          Not to start a flame war, but is there a compelling reason to run Windows Server 2003 instead of Linux on the box? Setting up a LAMP[^] server in Linux is about as trivial as can be and it doesn't cost a dime.

          realJSOPR Offline
          realJSOPR Offline
          realJSOP
          wrote on last edited by
          #16

          Because I have to be able to support .NET 2.0. Linux/mono doesn't support 2.0 yet, and won't until near the end of this year (or next year).

          "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
          -----
          "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

          1 Reply Last reply
          0
          • B Blue Bird 0

            Jerry Hammond wrote:

            If an idiot like myself can create a database and have it running it less than 20 minutes you should be creating and deploying in no time.

            Exactly, the bigger the idiot, the less time it takes.

            J Offline
            J Offline
            Jerry Hammond
            wrote on last edited by
            #17

            Blue Bird wrote:

            Exactly, the bigger the idiot, the less time it takes.

            Then you're only a heartbeat away...[snicker]

            Asking someone to define CP is like asking someone to define art. To define it is to miss its true nature.

            1 Reply Last reply
            0
            • A Albert Pascual

              Never used Oracle, I would like to know if it's better than SQL 2005. As I have been using it, however to deploy one server cost me too much money. Can you create a cluster of server in Oracle? How much is the database per server and how the cluster works? Also how fast is compared to MS SQL 2005 and do I need to change the way I perform queries in C# or ASP.NET 2.0? Al PS Well ... give me all the white papers :-) My eMail control My Blog

              realJSOPR Offline
              realJSOPR Offline
              realJSOP
              wrote on last edited by
              #18

              I can't answer any of those questions, so consider google to be your friend.

              "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
              -----
              "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

              1 Reply Last reply
              0
              • A Albert Pascual

                Never used Oracle, I would like to know if it's better than SQL 2005. As I have been using it, however to deploy one server cost me too much money. Can you create a cluster of server in Oracle? How much is the database per server and how the cluster works? Also how fast is compared to MS SQL 2005 and do I need to change the way I perform queries in C# or ASP.NET 2.0? Al PS Well ... give me all the white papers :-) My eMail control My Blog

                L Offline
                L Offline
                Lost User
                wrote on last edited by
                #19

                Read this for an insite into Oracle 10g Express Edition. Oracle Database 10g Express Edition: Not Just for Learners[^] While your there, have a look around, and if you like what you see, register yourself with them for future technical product information etc.

                1 Reply Last reply
                0
                • N Nish Nishant

                  norm.net wrote:

                  Why, what else?

                  Just asked. :-) Recently someone told me that, for anything other than amateur use, stuff like postgres and mysql never really worked out well, and that big companies always used oracle or sql server. Regards, Nish


                  Nish’s thoughts on MFC, C++/CLI and .NET (my blog)
                  Currently working on C++/CLI in Action for Manning Publications.

                  N Offline
                  N Offline
                  NormDroid
                  wrote on last edited by
                  #20

                  Oracle, has the worst interface(s) from installing right down to using, their version of a window to retreive data, constisted of a UI similar to notepad, absolute farce all the money you pay for a product like that, even MS Access beats Oracle. SQL Server 2005, is good, the management studio has a few bugs, but it's so easy to set up and use. Long live SqlServer!!! :cool: Never send a human to do a machine's job Agent Smith

                  realJSOPR 1 Reply Last reply
                  0
                  • N NormDroid

                    Oracle, has the worst interface(s) from installing right down to using, their version of a window to retreive data, constisted of a UI similar to notepad, absolute farce all the money you pay for a product like that, even MS Access beats Oracle. SQL Server 2005, is good, the management studio has a few bugs, but it's so easy to set up and use. Long live SqlServer!!! :cool: Never send a human to do a machine's job Agent Smith

                    realJSOPR Offline
                    realJSOPR Offline
                    realJSOP
                    wrote on last edited by
                    #21

                    We're talking about 10g EX here, not the whole tomoto, so... Installing? All I had to do was provide a root password and it did the rest. That was one of the simplest installs I've ever done. Interfaces - Well, to be honest, I don't use their interfaces to retrieve data. For every db program I've ever written or worked on (using oracle for the last three years), we didn't use any "interfaces" provided by the db backend. We wrote code that called stored procedures that retrieved the data. To create tables and packages, we use PL/SQL. I've never used SQL Server, so I can't comment on its usability or compare it to Oracle.

                    "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                    -----
                    "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

                    N 1 Reply Last reply
                    0
                    • realJSOPR realJSOP

                      We're talking about 10g EX here, not the whole tomoto, so... Installing? All I had to do was provide a root password and it did the rest. That was one of the simplest installs I've ever done. Interfaces - Well, to be honest, I don't use their interfaces to retrieve data. For every db program I've ever written or worked on (using oracle for the last three years), we didn't use any "interfaces" provided by the db backend. We wrote code that called stored procedures that retrieved the data. To create tables and packages, we use PL/SQL. I've never used SQL Server, so I can't comment on its usability or compare it to Oracle.

                      "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                      -----
                      "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

                      N Offline
                      N Offline
                      NormDroid
                      wrote on last edited by
                      #22

                      From my experience, the Oracle installation routine where written in Java and need a degree in rocket science to be able to navigate through the options, this was for Windows NT, are you installing on *nix? I suppose if you get used to doing everything like creating tables using PL/SQL thats fine, but you should try SQL Server even SQL 2000 is a sinch to use. Never send a human to do a machine's job Agent Smith

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups