Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

PostgreSQL

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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
2
[Webinar] Lessons on Recovering from Petya
LVL 10
[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

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

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

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
>