ProtoMan
Sep 21 2006, 10:11 AM
| | I found those two in cPanel and they loofed nearly the same as each other but what is the difference ? I tried to go to phpMyAdmin and phpPgAdmin and they are nearly the same too. Do you know that ? Please reply , thanks a lot. |
Reply
jlhaslip
Sep 21 2006, 01:11 PM
SQL is a standardization of Database Procedures. In the 'olde' days, everyone used different commands and features and then there were always problems adapting code, retrieving information, etc from various databases. SQL solves some of these problems. MYSQL and PostGresql are two implementations of SQL by two different groups, both of which are Open Source, although the Mysql is also available as a commercial product. Postgresql is available from Sourceforge, the Open Source site. PHP5 comes packaged with an 'SQL-lite' which doesn't have all the features of these other packages, but is quite effective for smaller applications, ie: a cd library, address book, mailing list, etc.
Reply
beeseven
Sep 22 2006, 12:29 AM
This is another one of those questions that could be answered by going to Wikipedia or, god forbid, the mysql and postgresql websites.
Reply
ProtoMan
Sep 22 2006, 10:30 AM
Thank you guys very much , my friend said that MySQL is more common and PostgreSQL is more advanced , is it true ? And the word My from MySQL means something I own , right  ?
Reply
farsiscript
Sep 23 2006, 04:13 PM
HI I have a question Mysql is better or Postgresql ? i know is very bad question but i want to know ! all developers make php script by mysql database and all panels support mysql mysql or Postgresql is it deferent Database query in Postgresql and mysql
Reply
Similar Topics
Keywords : difference, mysql, postgresql
- Mysql Hacks
(1)
Creating A Php Login System Using Mysql
I need help in creating a login system, what I want is a login system (10) Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login
form. I have a fair bit of experiance in HTML and some javascript too. I have virtually no
experiance in MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a
personalised page for each user and when they login the system transfers the user to their page.
Another thing that the system MUST have is a way of stopping unwanted users entering someones page.
CODE For example lets say I register and my UN is jesse123 and my personalised pages a....
Mysql Database Not Working
(3) well i'm getting an error message(a databass connection warning) for all of the parts of my site
that connects to a mysql database i check my database users pertmissions and i try to do the repair
database thing and it's still not woeking. am i the only person having this or is it an overall
trap17 issue and how do i fix it.....
Budget Freedom V.s. Plan E
What is the difference? (2) Except for the disk space, the bandwidth and the free domain, what is the difference between both?
With Budget Freedom I get more disk space and bandwidth and I get a free domain on top of that for
the same price as the Plan E package? Thanks!....
The Only Reason I Choose Ms Sql Server Rather Than Mysql
(0) The only reason i choose ms sql server rather than mysql is, MS SQL has more security
features!! MySQL is lacking a lot in my opinions - Lack in wide char, like nvarchar, I
developed some application to support chinese letter, and dont know how to build one in mysql - Lack
in t-sql syntax, like query in query is not fully supported - Does not have today SQL features like
BI support (today really required) And compare MS SQL to MySQL, the only reason why mysql is
favourable is - it is free! Dont u guys agree?....
Need Advice On Setting Up Mysql Database.
I have a huge amount of daily data updates to be inserted. (4) First of all, to get the idea of what I am trying to achieve here, please have a look at my
idea thread, entitled Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates . This gives
a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is
specific advice on setting up the mySQL database(s) to implement this idea. There is a useful FAQ
file for how to make use of the map.sql data located on the help.travian.com website, which also
gives an example of the CREATE TABLE instruction that matches the data in the map.sql fi....
Mysql Db Is Down Getting Following Error
(2) My Mysql is Down can I get some help please? Appreciate it. Patrick Domain: patrickcurl.com Error:
phpMyAdmin - Error #2002 - The server is not responding (or the local MySQL server's socket is
not correctly configured)....
It Went Well For A While
MySQL problem back in all its glory. (5) Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
effect. File(include/errors.xml) is not within the allowed path(s):
(/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
fopen(include/errors.xml) : failed to open stream: Operation not permitted in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
incl....
Half Life Vs Counter Strike, Whats The Difference?
(2) Our package just got here last week from China with these really cool CS figures from
www.lducompany.com that I bought for my son. He is only 8 and I am starting to think that the
computer game is a little too violent for him but the toys are kinda cute and harmless. Does anyone
know if these characters have names? You can see them at this page
http://www.liangdianup.com/collectibles_1.htm unless they moved them by the time you read this. I
have heard some people call this game half life, is there a difference? ....
Post Or Get Method
Explains the difference between the two. (4) Ok, I assume you know the basics of forms in html. There are two methods that you can use when
creating a form in HTML. They are post and get, as in: QUOTE or: QUOTE One
thing is that if you don't specify a method, then the Web server assumes that you are using the
GET method. So what's the deal? They do the same thing right? Well, almost. You may have noticed
that the URL looks a lot longer after you submit a form that uses the get method. For example, you
may see something like: QUOTE http://trap17.com/gamer.php?name=god&a...laying....
How Do I Find My Mysql Password? [resolved]
Cannot access my MySQL (5) After all the recent problems, my account has been restored. I have setup my parked domain agin, and
that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
that's all). I had to create a new user for my databases, and created the user with exactly the
same username and password I had before, but some of my web pages do not let me access the pages I
have associated with my databases. Where could i find out what my DB password is? (Although I am as
good as sure I am using the right one). I have tried my old password, the new c....
Please Explain Me Mysql
How do i insert information into this config: (4) Hi, I wanted to try just to test how can i connect my website to another mysql server, but i have no
idea how to insert the other mysql information such as port and host etc.... so here is the config
file please give me an example CODE <?php // mySQL information $server =
'FRESHSQL.COM:3306'; // MySql server $username =
'vasilevich'; // MySql Username $password =
'*******'; // MySql Password $database =
'vasilevich'; // MySql Da....
Remote Access Mysql
(8) Is it possible to directly access my local database from my website? For example, if somebody
submits info on my website, the info they submitted would be transferred to my local database
directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
my database to my subdomain is because it would be difficult to keep the website database and my
local database in sync . . . or is there a way to do that? Thanks for any replies.....
Advertised Isp Speed Versus Actual Speed
Why is the difference? (5) You may want to visit this topic. That topic gave me the this question.
http://www.trap17.com/forums/page-3-t58513-s20.html My ISP advertise 1024/256 Kbit speed and
network details do say 1024. But my actual download speed is 100 kb per second and my upload limit
is 25 kps. So what's a Kbit? QUOTE(ivantoar @ Jun 11 2008, 08:49 AM) 394433 I
run at 768 kbps and I can download at 90kbps (stable). ....
Html Form!
Using MySQL?! (4) Hey, I need your help again! I need some good working tutorial how I can update my SQL through
HTML form. I did use some tutorials online found with the help of google; but they do not work
properly; I mean there are still small mistakes. I need to have a good tutorial to follow. It
should be based on security and more things. It has to be done in proper way.......
Mysql, Php, Apache Downloads And Setup Was A Nightmare
Mysql, PHP, Apache (10) Mysql, PHP, Apache downloads were easy enough. Then came the setup process. This seemed to be an
endless mess of going back and forth trying to get the programs to work together properly. Finaly I
got them working after about 48 hours. There are great tutorials on the setup process, but only one
or two actualy were easy enough for me to understand. I would like to see if I was the only one who
had issues with this setup. Are there easier ways to setup the three?....
Mysql-essential-5.0.51 Installion Problem
please help me.(urgent) (2) Dear friend, please help me. Iam working on php project (matchmaking site). I have downloaded mysql
essensial 5.0.51. When i was installing mysql 5.0.51, i got following error - Error 1901: Error
attempting to read from the source installation database:
c:\windows\installer\527ec6.msi What is solution of this problem ? Iam using
windows xp professional version 2002 (service pack 2). Please post your reply. Iam waiting for your
answer. ....
Database With Mysql++
getting mySQL++ to work with trap17 (7) Hi, I'm trying to build an online game and figured the easiest way to do the server list would
be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my
website and I always get an abnormal program termination; however, it will work with the mySQL on my
own machine. The code is below: CODE #include <iostream> #include <iomanip>
#include <mysql++> #include "pass.h"//holds my password (i program at
school) int main(void) { Connection con("t3jem3_test","....
Mysql Won't Update
(4) Ok, so I'm making some arcade administration software so I don't have to add games the hard
way, well anyway, one of the features I have is that on the homepage is a featured author and as
such I just have it so it updates one line in the mySQL. Well, the page with the form passes on the
varibles fine and the updating page recieves them because I echoed everything, then I build the
query and I even echo the query and it comes out exactly how I want it to, but for some reason, the
database itself won't update even though all the varibles are there. Here's....
Qupis : Free Hosting With Php, Mysql, Cpanel. (one Line Text Ad At Bottom)
a member of Xisto (41) Hello Members, We are proud to introduce a new member to Xisto group of sites.
Qupis : Free Web Hosting 150 MB space, 5000 MB Bandwidth, php,
mysql, CPanel (Latest). Emails, FTP, Addon domains, Parked Domains etc.
http://www.Qupis.com
Feel free to add your reviews and comments about it. -Trap17
Management ....
Quick Question
Is there a limit on the size of the MySQL database? (10) Question's in the title!....
Subquery In Mysql
(5) Is there anyway to make subqueries work in MySQL? I'm pretty certain someone out there knows
how. /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /> Can anyone help?
CODE Select * from ITEMS where ID="Select Max(ID) from ORDERS"; This works
for MSAccess and SQL Server but why not in MySQL? I'll be writing some reports and I've
shifted database from MSAccess to MySQL. Help! Thanks.....
Mysql Database Size
related to the free database space (7) hi all! this is my first post /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> and i have a doubt, how much mysql space i am allowed to use... i mean how
much is available for my free account....
Import From Excel File Into Mysql Database
(11) Has anyone tried using the excel import function that comes with phpmyadmin
http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
to import the data to , there is a link on the bottom left corner which says "insert data from a
text file into the table" - although it says text file it still can be used to import an excel file.
When you click on this link you will be taken to a page where you will be asked for the file name
(the....
What Is The Main Difference Between Religions?
(11) Well, I think that all the religions of the world share a few similar and most important
concepts! There is no religion that would try to convince that doing BAD is acctually good and
vice-versa. I think the main difference is in the word that is used for some sort of divine being
(god, pure good, alah, whatever u name it...) that represents the highest good to all of them. I
think that a mountain is a very good example to explain how these religions are connected: There are
inumerable ways to the top of the mountain and each of this ways is a certain religion but al....
Increment A Mysql Column
how to increment a MySQL column one unit (7) Hi, I have a column in a MySQL table which contains a counter of the views of the object described
by this table. I would like to increment this value by one everytime the object is viewed. Obviously
came into my mind the possibility of retrieving the value of this field, store it in a variable
increment this value by one and perform an UPDATE query again with this new value. My question is if
there is a MySQL option to update the field with its actual value plus an unit increment. I hope you
understand the issue.....
What Is The Difference Between Asp And Php?
How About u ? (4) What is the difference between ASP and PHP? Which language is better? Which is more popular? Which
is more easier to learn? Plz Tell Me More and More information I know PHP is better but i want to
know how you think ! /blink.gif' border='0' style='vertical-align:middle' alt='blink.gif' />
Thanks....
Complete Login System
With PHP + MYSQL (57) Its an complete login sistem made and tested by me and I think itwill be very usefull for people who
are tryn to learn PHP. First, let's make register.php: CODE <?
include("conn.php"); // create a file with all the database connections
if($do_register){ // if the submit button were clicked if((!$name)
|| (!$email) || (!$age) || (!$login) ||
(!$password) || (!$password2)){ print "You can't let
any fields in blank....
Mysql Database Setup : Setting Up Mysql Database
Guide to use MySQL database in your site (6) A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....
Difference Between C, C++ And C#?
And some other questions. (15) What's the difference between C, C++ and C#? What is more closely related to working with
ASP.NET, C++, C#, or VB? Which comiler is best for C++ and/or C#? Are there any benefits in choosing
VB over C++ or C#? Z^ivjo HR....
Looking for difference, mysql, postgresql
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for difference, mysql, postgresql
*MORE FROM TRAP17.COM*
|
advertisement
|
|
