MYSQL, SQLite, PHPMyAdmin, SQL: Do they do the same job?
Hi guys, pretty new to PHP and Databases. just wants to know. I have been using the console (cmd.exe) to make databases and then learnt about MYSQLite and was about to learn and install it, BUT! is it not the same as PHPMyAdmin and MYSQL. just like a text editors (there lots out there but they can give you the same end result). or are they all different and should be used for certain tasks?
just wanted to know as I would prefer to learn a master one database program than learn many.
MySQL is a DBMS (database management system). phpMyAdmin is a PHP web application that provides a web-based front-end to MySQL databases -- it does nothing without MySQL also being installed (along with PHP, of course).
SQLite is a different DBMS, designed to be light-weight and (relatively) easy to bundle as part of an stand-alone application -- i.e., you don't have to install a stand-alone DBMS application. (You do have to install the necessary drivers/extensions for the programming language you are using it with, in most cases.)
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)