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

    Because Oracle is a much better DB than anything MS might be able to buy from someone else (unless, of course, if they bought Oracle, but then we'd be subjected to more of that "Microsoft Genuine Advantage" crap)... :)

    "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

    -- modified at 16:29 Thursday 11th May, 2006

    M Offline
    M Offline
    Marc Clifton
    wrote on last edited by
    #6

    John Simmons / outlaw programmer wrote:

    Because Oracle is a much better DB

    I'm not trying to bait you, but why? I gave up on Oracle after 7, as they were getting really bloated and embracing Java too much. Marc Pensieve Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson

    realJSOPR 1 Reply Last reply
    0
    • N Nish Nishant

      norm.net wrote:

      Lucky you, I finally gave up on Oracle years ago.

      What do you use now? Sql Server by any chance? 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
      #7

      Why, what else? :) Actually 2005 Standard Edition, had a fews bugs in the .net UI, but altogether is far better and easier to use than Oracle will ever be. Never send a human to do a machine's job Agent Smith -- modified at 11:00 Thursday 11th May, 2006

      N 1 Reply Last reply
      0
      • M Marc Clifton

        John Simmons / outlaw programmer wrote:

        Because Oracle is a much better DB

        I'm not trying to bait you, but why? I gave up on Oracle after 7, as they were getting really bloated and embracing Java too much. Marc Pensieve Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson

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

        A back-end is a back-end (just ask J-Lo). If I can use it from PHP and .NET, it's all good.

        "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

        D 1 Reply 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

          D Offline
          D Offline
          Douglas Troy
          wrote on last edited by
          #9

          John, you should consider looking at Firebird[^]. Once you find an Admin client you like, it really is a fast, solid and tiny DB engine. Just a thought.


          :..::. Douglas H. Troy ::..
          Bad Astronomy |Development Blogging|Viksoe.dk's Site -- modified at 11:01 Thursday 11th May, 2006

          1 Reply Last reply
          0
          • realJSOPR realJSOP

            A back-end is a back-end (just ask J-Lo). If I can use it from PHP and .NET, it's all good.

            "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

            D Offline
            D Offline
            Douglas Troy
            wrote on last edited by
            #10

            John Simmons / outlaw programmer wrote:

            A back-end is a back-end (just ask J-Lo)

            :doh: :laugh:


            :..::. Douglas H. Troy ::..
            Bad Astronomy |Development Blogging|Viksoe.dk's Site

            1 Reply Last reply
            0
            • N NormDroid

              Why, what else? :) Actually 2005 Standard Edition, had a fews bugs in the .net UI, but altogether is far better and easier to use than Oracle will ever be. Never send a human to do a machine's job Agent Smith -- modified at 11:00 Thursday 11th May, 2006

              N Offline
              N Offline
              Nish Nishant
              wrote on last edited by
              #11

              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 1 Reply 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

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

                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 1 Reply 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

                  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