NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

This could look like quite a basic question but I can't find a clear answer on the Internet... I was simply wondering what DBMS was used to store OSM data. By entering such a question on Google, you get so many informations on how to extract data and import them into various DBMS, but no basic information (just for curious guys) about the way data are stored. I recently read about NoSQL that was based on Key-Value pairs, which reminded me the way OSM data are tagged. Is OSM on NoSQL? Or PostgreSQL? Or any other DBMS? Many thanks for your answers.

asked 24 Sep '15, 19:55

wiltomap's gravatar image

wiltomap
1115612
accept rate: 0%

edited 24 Sep '15, 20:04

aseerel4c26's gravatar image

aseerel4c26 ♦
32.6k18248554


OSM started out on MySQL but has changed to PostgreSQL (not PostGIS) in 2009 and that's what we still use.

permanent link

answered 24 Sep '15, 20:01

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

edited 24 Sep '15, 20:10

4

Note that PostGIS is often used in derived databases, like rendering and geocoding.

(25 Sep '15, 11:24) Vincent de P... ♦
permanent link

answered 24 Sep '15, 20:07

aseerel4c26's gravatar image

aseerel4c26 ♦
32.6k18248554
accept rate: 18%

edited 24 Sep '15, 20:27

1

Many thanks to the both of you! I'm gonna have a closer look at it.

(24 Sep '15, 20:45) wiltomap
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×123
×118
×113

question asked: 24 Sep '15, 19:55

question was seen: 6,092 times

last updated: 25 Sep '15, 11:24

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum