How to PostgreSQL- Getting started

Getting Started

In this guide, You will learn PostgreSQL through many practical examples. PostgreSQL is a fully featured object-relational database with many enterprise features.

PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system.
It is also highly extensible and allows users to define internal functions in C, C++, Java, Perl, TCL, Python, Ruby, PHP and PL/PgSQL.

PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors. PostgreSQL is free and open source software. Its source code is available under PostgreSQL license.

PostgreSQL Features

  • Easy to install and configure
  • The Web Control Panel
  • Adminer administration frontend for PostgreSQL
  • Webmin modules for configuring PostgreSQL.
  • PostgreSQL is configured to listen on its default port on all interfaces by default, and accept connections from all hosts.
  • PostgreSQL password encryption enabled by default (security).
  • The Postgres user is trusted when connecting over local Unix sockets (convenience).
  • PostGIS support.

Featured companies Apple, Fujitsu, Red Hat, Cisco, Juniper Network, etc. are using built products and solutions using PostgreSQL.

Usage details

No default passwords: For security reasons, there are no default passwords. All passwords are set at system initialization time.

Ignore SSL browser warning: browsers don’t like self-signed SSL certificates, but this is the only kind that can be generated automatically without paying a commercial Certificate Authority.

Support

If you need any support, an active community is available to help. You can always find the answers from the PostgreSQL’s community for the issues that you may have when working with PostgreSQL.

MySQL vs PostgreSQL

 

NameMySQL  XPostgreSQL  X
Database modelRelational DBMS Relational DBMS 
Websitewww.mysql.comwww.postgresql.org
Technical documentationdev.mysql.com/­docwww.postgresql.org/­docs/­manuals
DeveloperOracle PostgreSQL Global Development Group 
Initial release19951989 
LicenseOpen Source Open Source 
Cloud-based nono
Implementation languageC and C++C
Server operating systemsFreeBSD, Linux, OS X, Solaris, WindowsFreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix, Windows
Data schemeyesyes
Typing yesyes
XML support yes
Secondary indexesyesyes
SQL yes yes 
APIs and other access methodsADO.NET, JDBC, ODBCNative C library,Streaming API for large objects, ADO.NET, JDBC, ODBC
Supported programming languagesAda, C, C#,C++, D, Delphi, Eiffel, Erlang, Haskell, Java, JavaScript (Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl
.Net, C, C++, Delphi, Java, Perl, Python, Tcl
Server-side scripts yes user defined functions 
Triggersyesyes
Partitioning methods horizontal partitioning, sharding with MySQL Cluster or MySQL Fabricno, but can be realized using table inheritance 
Replication methods Master-master replication, Master-slave replicationMaster-slave replication 
MapReduce nono
Consistency concepts Immediate ConsistencyImmediate Consistency
Foreign keys yes yes
Transaction concepts ACID ACID
Concurrency yes yes
Durability yesyes
In-memory capabilities yesno
User concepts Users with fine-grained authorization concept fine grained access rights according to SQL-standard

Muhsin Yakkiparamban

Muhsin Yakkiparamban is the co-founder of Lauyou Learning. Muhsin holds Bachelor Degree in Civil Engineering from KMCT Calicut.

You may also like...