Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: Which shall I?

  1. #1
    Regular Coder
    Join Date
    Aug 2005
    Posts
    279
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Which shall I?

    I'm creating a website that is used for friend connections basically like profile listing stuff. So I studied the Database using Ms Access, do you think I should go with ODBC or MySQL using PHP script? I'm very new to this language by the way.

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,073
    Thanks
    11
    Thanked 98 Times in 96 Posts
    Most here would suggest MySQL , msaccess is OK if you only have a few users, its awful in a multi-(concurrent)-user environment , also ODBC is about the slowest method of retrieving data, the native MySQL functions (and other DB native functions) are far quicker.

    If this is a one-off small project then access is ok, if you want to do more of this sort of work then get stuck into MySQL .. or if you are on a windows platform .NET + SQLServer
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    New Coder
    Join Date
    Jan 2006
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I recommend MySQL. You should also put phpMyAdmin on your server to view the MySQL database online.

  • #4
    Regular Coder Element's Avatar
    Join Date
    Jul 2004
    Location
    Lynnwood, Washington, US
    Posts
    855
    Thanks
    2
    Thanked 2 Times in 2 Posts
    I have expirenced, for some reason, when I had my personal server online, here next to me, that phpMyAdmin wouldn't run on Windows 2003 Possibly it was how I had the system configured, or maybe it just doesn't work on it at all.

    MySQL also is what I would recommend its fast, compliant and easy to use.

  • #5
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    @Element
    So if phpmyadmin didn't work on your server, what did you use to view your mysql? I'm just a bit curious.
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • #6
    Regular Coder Element's Avatar
    Join Date
    Jul 2004
    Location
    Lynnwood, Washington, US
    Posts
    855
    Thanks
    2
    Thanked 2 Times in 2 Posts
    Well I could have used Navicat MySQL for Windows, but I only got halfway done until I went on vacation, and when I got back I didn't use the server for web stuff anymore, because I didn't have any net.

  • #7
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    Ahh okay. I was just wondering the possibly alternatives for handling mysql on windows.
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • #8
    Senior Coder missing-score's Avatar
    Join Date
    Jan 2003
    Location
    UK
    Posts
    2,194
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by _Aerospace_Eng_
    Ahh okay. I was just wondering the possibly alternatives for handling mysql on windows.
    You can log into MySQL admin directly from the commandline, but its a bit annoying to be honest. I believe MySQL.com has a query builder tool but I dont know if it will run queries.

    @Element: Did you check these things with phpMyAdmin:
    • You edited the phpMyAdmin config file
    • mysqld-nt.exe was running in the background when you attempted to use MySQL

    Edit: Not sure if Win 2003 is NTFS or not so it might be a different mysqld...exe file, but I'm quite certain MySQL will work on Win 2003

  • #9
    New Coder
    Join Date
    Dec 2005
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Don't remember any good free alternatives to phpmyadmin, but a very nice commercial one is SQLYog

  • #10
    Senior Coder
    Join Date
    Apr 2005
    Location
    Colorado, United States
    Posts
    1,208
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by missing-score
    You can log into MySQL admin directly from the commandline, but its a bit annoying to be honest. I believe MySQL.com has a query builder tool but I dont know if it will run queries.

    @Element: Did you check these things with phpMyAdmin:
    • You edited the phpMyAdmin config file
    • mysqld-nt.exe was running in the background when you attempted to use MySQL

    Edit: Not sure if Win 2003 is NTFS or not so it might be a different mysqld...exe file, but I'm quite certain MySQL will work on Win 2003
    MySQL does work on Win 2003...I've used it, and I know hosts use it all the time. Win 2003 is by default NTFS, but can be FAT32. mysqld-nt.exe refers to "NT" I believe, as it runs as a service rather than an active window.

    And I'd also recommend MySQL. Large or small it does the job admirably. MS Access I wouldn't trust as far as my desk, let alone on my computer. Nasty MS junk...
    "$question = ( to() ) ? be() : ~be();"

  • #11
    Senior Coder
    Join Date
    Nov 2002
    Location
    North-East, UK
    Posts
    1,265
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would recommend phpMyAdmin, especially if you have a server that doesn't support remote connections.

    Otherwise checkout
    http://www.mysqlfront.de/


    and for major uploads
    http://www.gossamer-threads.com/scripts/mysqlman/
    doesn't have the PHP timeout limit that you may encounter

  • #12
    Regular Coder
    Join Date
    Aug 2004
    Location
    The US of A
    Posts
    767
    Thanks
    1
    Thanked 0 Times in 0 Posts
    There is also another very well supported open-source database option: PostGreSQL. Many consider it as good, if not better, than MySQL. I couldn't tell you from experience since I've only used PostGres since MySQL isn't installed on my server.

    Just thought I'd throw that out there.

  • #13
    Senior Coder
    Join Date
    Apr 2005
    Location
    Colorado, United States
    Posts
    1,208
    Thanks
    0
    Thanked 0 Times in 0 Posts
    MySQL is nearly as good as PostgreSQL in terms of features, but I've read in several places that PostgreSQL isn't as solid or stable as MySQL. I don't know these for a fact, but I remember reading them. As I read them elsewhere, don't take it as fact.
    "$question = ( to() ) ? be() : ~be();"

  • #14
    Regular Coder
    Join Date
    Aug 2004
    Location
    The US of A
    Posts
    767
    Thanks
    1
    Thanked 0 Times in 0 Posts
    They both have their advantages and disadvantages, I'm sure of that. I couldn't exactly tell you since I'm hardly an expert of either one, let alone both. =O>

  • #15
    Senior Coder
    Join Date
    Aug 2003
    Location
    One step ahead of you.
    Posts
    2,815
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by Element
    I have expirenced, for some reason, when I had my personal server online, here next to me, that phpMyAdmin wouldn't run on Windows 2003 Possibly it was how I had the system configured, or maybe it just doesn't work on it at all.
    ... which proves that PHP is OS-indepandant...
    I'm not sure if this was any help, but I hope it didn't make you stupider.

    Experience is something you get just after you really need it.
    PHP Installation Guide Feedback welcome.


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •