background preloader

PostgreSQL: Welcome

PostgreSQL: Welcome

Related:  J'utilisecartographierVeille Géo-codage / Géolocalisation / PostgreSQLTools

Osm2pgsql Available languages — osm2pgsql is a command-line based program that converts OpenStreetMap data to postGIS-enabled PostgreSQL databases. Such databases are often used to render OSM data visually using Mapnik, as PostgreSQL is one of the most efficient and flexible formats Mapnik can use for querying large amounts of data. For more information on using osm2pgsql to render OpenStreetMap data with Mapnik, see the Mapnik page. Doc d'installation Nominatim This page describes the general installation process for Nominatim. It is assumed that you are familiar with basic system and database administration. There are also more detailed step-by-step instructions for the following operating systems: Nominatim/Installation/CentOS

LabxNow - A Free Online Cloud Lab for Linux Enthusiasts - OSTechNix LabxNow – OS in the Web browser Today, we have a very very interesting news for Linux enthusiasts. Now, you can play with your favourite Virtual machines right from your Web browser itself for absolutely free of cost. You don’t need to buy an expensive VPS or deploy any virtualization platforms on your local server to setup Virtual machines. LabxNow, a free online Research and Development environment, offers pre-configured VMs for free.

OpenNMP From QNAPedia by AdNovea - Nov 2009 Once the installation completed, log to the OpenNMP web interface with your web browser: http: //<your_nmp>:8080/ Default account is: admin/admin They are few additional options for the installer script:--force-defaults use default options for questions asked by the installer during upgrade. --force-reinstall allow to reinstall (from scratch) OpenNMP over a previous version -h --help display this help and exit -V --version output version information and exit Performances The QNAP NMP-1000 is a versatile product which offers already a great number of functionalities. Its very smart implementation has enabled the quick development of this opened source application to get even more from the product.

QGIS OSM Plugin The QGIS OpenStreetMap Plugin is a plugin for the desktop GIS application QGIS. It adds support for OpenStreetMap raw vector data, bringing it in as a layer either from .osm XML file or by direct download from the OpenStreetMap API. It also permits editing and upload back the OSM server.

Doc d'installation Gisgraphy Before install and launch Gisgraphy, you must setup java (you needs JVM >= 1.5), postgres, and postgis. it is not, properly speaking, the installation of Gisgraphy, and if you already havn't Postgres, Postgis and java installed, you must install it first. a tutorial is provided here for linux and here for windows Download a Gisgraphy distribution Fisrt you have to download a distribution here. Download a tar.gz file, if you are on Linux or download a zip file, if you are on windows. Then extract it : tar xvf YOURFILE if you're on linux or double click on the file if your on Windows

13 Free GIS Software Options: Map the World With Open Source GIS Mapping Software - GIS Geography You don’t have to pay a king’s ransom to map the world. This is because you can do it all with free GIS software. The best part is: Global Mapper Powerful Cost Effective User Friendly Overview Global Mapper is an affordable and easy-to-use GIS application that offers access to an unparalleled variety of spatial datasets and provides just the right level of functionality to satisfy both experienced GIS professionals and beginning users. Equally well suited as a standalone spatial data management tool and as an integral component of an enterprise-wide GIS, Global Mapper is a must-have for anyone who works with maps or spatial data.

osm2pgrouting - Import OSM data into pgRouting Database — Open Source Routing Library Important osm2pgrouting currently doesn’t support anymore pgRouting v1.x but requires pgRouting 2.0 or higher. Easily import OpenStreetMap data into a pgRouting database using osm2pgrouting tool. osm2pgrouting was primarily written by Daniel Wendt and is now hosted on the pgRouting project site. Features Uses XML configuration file to select road types and classes to importCreates types and classes tables, which can help to create sophisticated cost functions Documentation de l'application Leaflet API Reference This reference reflects Leaflet 0.7. Docs for 0.6 are available in the source form (see instructions for running docs). Download Your Open Source GIS Tools - Open-source Township GIS This section provides step-by-step instructions on downloading and installing the major GIS tools used in this project. The download instructions are for Windows PCs. Participants all had Windows machines installed and available at their offices for use in this project. The download/installation screens as they appear on a Windows 7 PC were used to illustrate the process. The process is identical on Windows Vista and Windows XP machines, although the appearance of the dialogue boxes may vary with the operating system.

Apache HTTP Server The Apache HTTP Server, colloquially called Apache (/əˈpætʃiː/ ə-PA-chee), is the world's most used web server software. Originally based on the NCSA HTTPd server, development of Apache began in early 1995 after work on the NCSA code stalled. Apache played a key role in the initial growth of the World Wide Web,[5] quickly overtaking NCSA HTTPd as the dominant HTTP server, and has remained most popular since April 1996. In 2009, it became the first web server software to serve more than 100 million websites.[6]

Sneakpeekit Browser sketch sheets for Web Designers Quickly design awesome website wireframes and mockups on our Sneakpeekit Browser©. We provide a large sketch sheets collection with many different canvasses, grids and PSD grid templates. Any sketch sheet is a ready-to-print A4 PDF template. We have included PSD Photoshop grid templates too for quickly converting your sketch in a graphic mockup. Free License: Feel free to download and use our templates for personal projects with attribution back to

Why not MySql? I needed cursors that could maintain state across calls. MySql cursors are maintained on the server and you pass a positional reference for each next page. I'm not explaining it well because its been ages since I tried each one. I started with sqlite3, and it was a locking disaster. Not to be used for multithreaded apps that want to access the database from separate threads. Postgres is faster than I can imagine. I also use its Full Text S-----? indexing for blazing word searchs. I literally get near-realtime responses on key input against a 130,000 row music database, searching a 1000+ byte field that concatenates all the interesting song attribs, all the while with a where clause to exclude known uninteresting songs. Blazing. And the INSTEAD OF views work great, and pgadmin is bug-free and fast, though primitive. by alendar Feb 26

Related:  PostgreSQLdatabase enginesMy Open Source ProjectsinstagramdatabaseSistemas de información en las organizacionesPyBuildingrelational databases & models of cognitionbases de données