PostgreSQL

2K

Solutions

3

Articles & Videos

1K

Contributors

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

Share tech news, updates, or what's on your mind.

Sign up to Post

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities.

I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL that did not begin with the assumption I couldn't tell a database from a linked list. Now, as I'm getting my feet wet with PostgreSQL, I wanted something similar. Here are some notes and links I have found helpful. Hopefully they will help you as well.

Gabrielle Roth's Introduction to DB's with PostgreSQL gives a fair introduction. This is just the slide show that would accompany the lecture.
The PostgreSQL FAQ's are rich with information ... including the product name's pronunciation!
Ross Laird provides an example project using PostgreSQL that I found helpful for deciphering some login issues.

I'm actually looking for something for experienced DB developers ... a quick list to get going.

Log Into PostgreSQL from the OS Prompt

psql -U UserName

Open in new window

Notice that's a CAPITAL U -- unlike we use in MySql.

But what's the default user name?

No, it's not root. Or ... probably not. It's the name of the OS user under which PostgreSQL was originally configured to run. Usually that's "postgres".
If you attempt to log in using a username that has not been created, you get the error:
psql: FATAL: role "UserName" does not exist

Open in new window

It does say "role" rather than "user". Technically, PostgreSQL has roles
0
NEW Veeam Agent for Microsoft Windows
LVL 1
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!


Best database to use for Maps is PostgreSQL.

This is an open source database. Comes as a package with most Linux OS.

For more info visit the following site:
http://www.postgresql.org/

This requires some add-ons to get the Map functionality.

1. PostGIS
2. pgrouting

1. PostGIS: PostGIS adds support for geographic objects to the PostgreSQL object-relational database.
For more info and downloads visit the following site:
http://postgis.refractions.net/

2. pgrouting: This provides routing functionality to PostGIS / PostgreSQL.
The algorithms that works with this are:
a. Shortest Path Dijkstra -- well known shortest path algorithm with exact result
b. Shortest Path A* -- shortest path algorithm with heuristics
c. Shortest Path Shooting Star -- shortest path algorithm for real road networks (cares about restrictions) with heuristics
d. Traveling Sales Person (TSP)
e. Driving Distance calculation
For more info and downloads visit the following site:
http://pgrouting.postlbs.org/
1

PostgreSQL

2K

Solutions

3

Articles & Videos

1K

Contributors

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

Top Experts In
PostgreSQL
<
Monthly
>