Jul 27, 2008

The Difference Between Mysql And Postgresql ?

Free Web Hosting, No Ads > General > Hosted Members Area

free web hosting

The Difference Between Mysql And Postgresql ?

ProtoMan
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
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
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
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 smile.gif ?

Reply

farsiscript
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



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : difference, mysql, postgresql

  1. How Do I Find My Mysql Password? [resolved]
    Cannot access my MySQL (5)
  2. 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....
  3. 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.....
  4. What's The Difference Between 64 And 32 Bit?
    Buying a new computer. (9)
    Hey everyone! I'm going to be buying a new laptop in a few months, and I am very confused
    about one thing: AMD manufactures a LOT of 64 bit processors, while Intel almost never does.
    I'm clueless when it comes to processors, and I'm concerned because I haven't really
    been paying attention to processor specs as much as HD and RAM, even though those are the cheapest
    and easiest to switch. Does anyone have any good tips about processors? I'm mainly wondering
    what the difference between 64 bit and 32 bit is, but other than that I also want to know i....
  5. 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). ....
  6. Create Table - Mysql Code - Help
    (1)
    I need your feedback about setting the database issues. Please, review them and correct some entries
    in the code if they got some mistakes. This is the code itself: SQL CREATE TABLE
    `news` ( `id` int(250) NOT NULL auto_increment, `title` varchar(255)
    NOT NULL default '', `text` text NOT NULL, `author` varchar(255) NOT
    NULL default '', `valid` varchar(255) NOT NULL default '',
    `date` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE = ....
  7. Mysql Error
    (3)
    ok i need some more help from the wonderful coders here at Trap. I'm almost done with my CMS
    script, but i'm having a problem with the installer.php file, when it trys to inseret the user
    data into the database i keep getting the following error: CODE mySQL Error: You have an
    error in your SQL syntax; check the manual that corresponds to your MySQL server version for the
    right syntax to use near ';INSERT INTO `members` (`id`, `name`,
    `username`, `password`, `email`, `title`) ' at lin....
  8. Mysql
    Several files in one field. (2)
    Hi guys. I want t know if it is posible to have so many entries for one object in a field in MySQL.
    I know my question may not be clear because I lack in terminology but pliz try and help. What I want
    to do is for axample have a database of my clients with the following fields for every client:
    fname, lname, more than one photos, contrubutions(comments, jokes, testimonials posted) etc. I want
    to have the things like the photos in the same field but they have to be unique so that my php code
    can deal with them individually llike they are coming from different fields.....
  9. 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.......
  10. Best Php And Mysql Editor For Noobs
    anyone any php or mysql editor that is good for noob (6)
    hi there guys, from my previous posting, i am a noob in php and mysql programming. I want to know
    if there are any php and mysql editors which are best for me as a noob. i appreciate your kindness
    ....
  11. Php And Mysql Programming
    anyone knows a code for mysql and php (2)
    hi everyone! I am making a program using php and mysql...I am a noob on this so i need your
    help guys...I want to make a simple program that will some values and then store them on a database
    and then retrieve them...uhmm let me give an example out put of what i need. This is the example
    say..: Enter First Name: Enter Last Name:
    Enter Age: Enter Address: ..those
    are the data needed for input values...my question now is how can I make a database....
  12. Social Vibe, Join & Make A Difference!
    (0)
    CLICK HERE TO JOIN SOCIAL VIBE So i was just browsing through my friend's music
    profile.. and i found she supported this service called social vibe. What social vibe is, is kinda
    like google ads, but the money goes to the charity of your choice of course you earn stuff too..
    you get to feel great inside, and also earn entries for giveaways.. theres ipods, redbulls, xboxs..
    everything, they have some amazing perks /tongue.gif" style="vertical-align:middle" emoid=":P"
    border="0" alt="tongue.gif" /> well! so join through my link.. TO WRITE LOVER O....
  13. Mysql, Php, Apache Downloads And Setup Was A Nightmare
    Mysql, PHP, Apache (9)
    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?....
  14. 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. ....
  15. 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","....
  16. Tools Needed!
    PHP & MySQL (9)
    Hello, everyone! I need some tools for those two things to test PHP scripts coming together with
    database on my laptop, instead checking them on a web-server which takes time.....
  17. Mysql + Php Question
    (5)
    Hi, I am creating a website in php and using a mysql database to store the data. I want to store
    time data in the database. My question is what is the best datatype I should use and how do I read
    the time from the database and format(display) it using php ?....
  18. 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....
  19. 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 ....
  20. Is It Possible To Access The Mysql Remotely?
    (10)
    I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
    in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
    remotely. If that's not possible, are we allowed to run Python scripts on the server?....
  21. Check Referrer To Prevent Linking Yours From Other Sites
    Check referrer with Php and Mysql (8)
    Check Referrer Using Php To Prevent People Linking To Your Downloads From Other Sites Ever
    find that found some people are listing items, images and tuts and linking directly to the download
    url (those that are like my photoshop tutorial.php?id=0), which is a .php to count the number of
    downloads. To prevent this, you can add a piece of code to the download pages that checks which page
    referred them to the download page: if it's my domain, it downloads the file normally, if
    it's not, it will redirect to my home page instead. Important : Not all browser....
  22. Difference Between Love And Crush
    (12)
    As the title says, i wanna see what all of you out there think the difference between a crush and
    true love is i'm 16, and havent seen much of life, but i think i have the general gist of the
    difference. This happens so because of my own relationship with a girl, which hasnt gone well, i
    wrote this story in the topic named Confusing girls, but it didnt work out, and usually for me, if
    it was a crush i would've forgotten a girl in a month or two, but this girl, even though i tried
    to avoid for a 3 months after she said no, and staying away, not even seeing her fa....
  23. Can You Add Images Into A Mysql Database?
    Using Php? (20)
    I'm learning php in class right now, but I'm still not that good at it, what I'm
    wondering is when I write the php so that it can connect with a database, can I at the same time
    have it that it is able to display back images that I choose. Like, I want a search feature, where
    you can search for a keyword, and it will bring back a list of all the possible entries with that
    keyword, but each of these entries will have a photo associated with it. Now, do I put these image
    files directly into the database, or do I write the code to link them from my files to th....
  24. Installing Apache, Mysql, Phpmyadmin Locally
    Solving the "php_mbstring.dll missing" (5)
    Since Trap17's CP provide the individual site's owner with goodies like MySql and
    PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
    on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
    expected that most people considering to make use of a database on their site will want to do most
    of the tedious job of developing and testing on their own local system before sending the wrapped-up
    result on their domain/subdomain. This involves four basic steps (sorry for the compuwi....
  25. Mysql Database Size
    related to the free database space (6)
    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....
  26. Import From Excel File Into Mysql Database
    (7)
    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....
  27. What Is The Main Difference Between Religions?
    (10)
    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....
  28. Learning Mysql
    pls guide (3)
    hello out there, i have already looked through on this tutorial forum.. and still can find any
    topics which related to MySql basic.. i wanna learn about how to create MySql table and its
    concept!! just basic.. i've no knowledge on MySql before nor any other database server
    software.. but i do have littol konwledge on programming,scripting,html basic in concept.. pls dun
    gave me so many links so as i can be blur for none about how to get start!! /laugh.gif'
    border='0' style='vertical-align:middle' alt='laugh.gif' /> i can thou find from Googles sear....
  29. Complete Login System
    With PHP + MYSQL (56)
    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....
  30. Difference Between C, C++ And C#?
    And some other questions. (13)
    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....

    1. Looking for difference, mysql, postgresql

Searching Video's for difference, mysql, postgresql
Similar
How Do I
Find My
Mysql
Password?
[resolved] -
Cannot
access my
MySQL
Please
Explain Me
Mysql - How
do i insert
information
into this
config:
Remote
Access Mysql
What's
The
Difference
Between 64
And 32 Bit?
- Buying a
new
computer.
Advertised
Isp Speed
Versus
Actual Speed
- Why is the
difference?
Create Table
- Mysql Code
- Help
Mysql Error
Mysql -
Several
files in one
field.
Html
Form! -
Using
MySQL?!
Best Php And
Mysql Editor
For Noobs -
anyone any
php or mysql
editor that
is good for
noob
Php And
Mysql
Programming
- anyone
knows a code
for mysql
and php
Social Vibe,
Join &
Make A
Difference&#
33;
Mysql, Php,
Apache
Downloads
And Setup
Was A
Nightmare -
Mysql, PHP,
Apache
Mysql-essent
ial-5.0.51
Installion
Problem -
please help
me.(urgent)
Database
With Mysql++
- getting
mySQL++ to
work with
trap17
Tools
Needed!
- PHP &
MySQL
Mysql + Php
Question
Mysql
Won't
Update
Qupis : Free
Hosting With
Php, Mysql,
Cpanel. (one
Line Text Ad
At Bottom) -
a member of
Xisto
Is It
Possible To
Access The
Mysql
Remotely?
Check
Referrer To
Prevent
Linking
Yours From
Other Sites
- Check
referrer
with Php and
Mysql
Difference
Between Love
And Crush
Can You Add
Images Into
A Mysql
Database? -
Using Php?
Installing
Apache,
Mysql,
Phpmyadmin
Locally -
Solving the
"php_mb
string.dll
missing"
;
Mysql
Database
Size -
related to
the free
database
space
Import From
Excel File
Into Mysql
Database
What Is The
Main
Difference
Between
Religions?
Learning
Mysql - pls
guide
Complete
Login System
- With PHP +
MYSQL
Difference
Between C,
C++ And C#?
- And some
other
questions.
advertisement



The Difference Between Mysql And Postgresql ?



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE