View allAll Photos Tagged postgresql
tried to visualise what Scotland would look like if it was warped by drive times from Edinburgh.
The map is centered on Edinburgh city centre. Angles are preserved, but the distance from the centre is the drive time rather than geographic distance.
Used QGIS (pgRouting Layer plugin), PostgreSQL, PostGIS and pgRouting. Road network is OS Open Data, crown copyright and database rights 2015.
more details on my blog
Generation of shortest paths from one Australian Bureau of Statistics (AHS) Statistical Area level 3 (SA3) centroid in Canberra to all 329 other SA3 centroids on the Australian mainland, across a road network topology derived from OpenStreetMaps and hosted on an AWS Aurora-PostgreSQL server.
Done using the PostgreSQL pg_routing extension function pgr_dijkstra(). Execution completed in 1.3 seconds. Cartographic display in QGIS.
It reminds me our work on indexing arrays in PostgreSQL (elephant is the official logo of PostgreSQL), where I and Teodor used RD-Tree (Russian Doll Tree) data structure to store signatures and fast search.
Yoga people may identify one variant of Vrikshasana.
What do you think about mouse ?
Anastasia is a PostgreSQL developer. I made this picture in Vienna after session day of PGGConf-2015.
The red area shows a cluster of parishes whose combined price paid in house sales transactions were 25% of the total. The orange band represents 50%, and the yellow band 75%. The area in gray represent the remaining 25%. So each colour represents 25% of the total house sales value.
Using a wildfire-fill technique, centred on the City of London. Used parishes as they tend to be quite small and evenly distributed, so keep the overall error down to < 0.1%
Horespower constraints meant I worked with a 10% random sample of house transactions - approx 80,000 sales totalling £19.3Bn. A larger sample would mean fewer 'holes'. I suspect a full sample would paint an even more depressing picture.
Used QGIS, PostgreSQL/PostGIS and shp2pgsql. Custom Python script to do the analysis.
Using data from the Land Registry and parish boundaries from Ordnance Survey, Crown Copyright and database rights 2014.
Inspired by the colour scheme of the public street map installations in Glasgow.
I see the George Square one has a sticker on it to repair the "you are here" finger damage.. it's not just the London Underground maps that develop bald patches :-)
Roads are deliberately left the same colour as the background, so they only appear over areas where they're needed, such as parks. The aim of the map is to highlight green spaces (brownfield sites, constructions sites and car parks show up as brown). The map should also be equally usable for the colour blind.
Rendered in QGIS, using data copyright OpenStreetMap and its contributors.
If you like the colour scheme, help yourself to the QML files here. (Background colour is (129,118,163).
Note that these assume that you bring the data into qgis from a postgresql database, which has been imported using osm2pgsql.
Every so often (and judging from my uploads about once every four years) I get the urge to do stuff with GIS, data analysis and programming... it's sort of my version of knitting!
This is me messing about with GIS, PostGIS and pgRouting (which I've never used before). Having to learn/re-learn a bit of SQL, which will be really useful for future projects I have in mind. Why did I decide to do this with football clubs? No idea, other than I was quite interested in knowing who had the biggest 'catchment area' (geographically, if not by population... that's for another day!)
I couldn't have done this without the incredibly helpful tutorials from anitagraser.com/ - an absolute godsend and many thanks for doing these!!
GONZAGA, Jorge Luiz. Dominando o PostgreSQL. Rio de Janeiro: Ciência Moderna, 2007. xiii, 228 p. ISBN 9788573935592. Inclui Ãndice; il. tab. quad.; 24x16cm.
Palavras-chave: BANCO DE DADOS/Administração; LINGUAGEM DE PROGRAMACAO.
CDU 004.65 / G642d / 2007
My son Sergey visited my office to discuss optimization of PostgreSQL uisng machine learning. He is going Google Deepmind for internship this summer.
We discussed many important topics, see wiki.postgresql.org/wiki/PgCon_2015_Developer_Meeting.
Expect PostgreSQL 9.5 alpha really soon in June, PostgreSQL 9.5 release was scheduled to mid of October.
9.6 development: Five commitfests - July 1, September 1, November 1, January 1, March 1. Feature freeze - mid April, 2016.
Signed version of this picture is here.
PGCon 2011 Developer's meeting group -- Ottawa, Canada.
Back row, from left to right: Robert Haas, Selena Deckelmann, Marko Kreen, KaiGai Kohei, Stephen Frost, Magnus Hagander , Robert Treat, Tom Lane, Heikki Linnakangas, Mark Wong, Josh Berkus, Kevin Grittner, Dimitri Fontaine, Koichi Suzuki, Andrew Dunstan, Fujii Masao, Jeff Davis, Greg Smith, Tatsuo Ishii, Dave Page, Simon Riggs.
Front row: Greg Stark, David Wheeler, David Fetter, Bruce Momjian, Teodor Sigaev.
Developers Meeting, Ottawa, May 18, 2011. On this photo: Alvaro Herrera, Robert Haas, Selena Deckelmann, Marko Kreen, KaiGai Kohey, Stephen Frost, Magnus Hagander, Robert Treat, Tom Lane, Heikki Linnakangas , Mark Wong, Josh Berkus, Dimitri Fontaine, Koichi Suzuki , Andrew Dunstan, Fujii Masao, Jeff Davis, Tatsuo Ishii, Dave Page, Simon Riggs, Greg Stark, David Wheeler, David Fetter, Bruce Momjian, Teodor Sigaev. One man is missing - Oleg Bartunov (making this shot).
Group picture of PostgreSQL developers, Arc the Hotel, Ottawa.
Dave Page, Tatsuo Ishii and me were outside of this shot.
See "ALL SIZES" for bigger picture.
Finding chance alignments of random points - in this case, pubs in Scotland.
A pub ley line has
- at least 8 pubs in a line
- all pubs are within 5 meters of the line.
- the whole line must be at least 10 Km long, to remove short lines of pubs in straight streets... so Rose Street doesn't count :-)
This is only a 10% sample from 2.5 million lines between pubs; there will be other alignments. From 200,000 inter-pub lines, I found 4 ley lines. In case you're wondering, the lines end in Glencoe, Ayr, Perth and Stranraer.
Using data copyright OpenStreetMap and its contributors. Used osm2pgsql, PostgreSQL with postGIS, pgsql2shp and QGIS.
You should read this first before inspecting this graphic.
To ensure that my TAZ geocoder found the correct Traffic Analysis Zone for the address I submitted, I took the resulting ID, 294518, and searched for that in the GIS shapefile within the free and open-source QGIS application.
Yep, that's about the location of 3201 S Halsted!
The United States Census Bureau manages the TAZ boundaries and designations, but I think the local MPOs and DOTs can change them.
Transportation Analysis Zones (the new name for TAZ) are discontinued after the 2011 CTPP data release.
First PostgreSQL conference in Europe was held in Prato, Italy, 2008.
Oleg Bartunov, Simon Riggs, Greg Stark, Magnus Hagander, Dave Page, Jean-Paul Argudo, Guillaume Lelarge.
SILBERSCHATZ, Abraham; KORTH, Henry F.; SUDARSHAN, S.. Sistema de banco de dados. [Database system concepts, 5th ed. (Inglês) ISBN 0072958863]. Tradução de Daniel Vieira, Revisão técnica de Luiz Fernando Pereira de Souza. 5 ed. 3 reimpr. Rio de Janeiro : Elsevier , 2006. xxiii, 781 p. Inclui bibliografia e Ãndice; il. tab. quad.; 28cm. ISBN 8535211071.
Resumo:
A quinta edição do livro é uma referência essencial para aqueles que precisam ter uma boa base teórica e prática em banco de dados. Além dos conceitos fundamentais da área, são apresentados tópicos relacionados, tais como: desenvolvimento para Internet, banco de dados orientados a objetos, XML, data mining, processamento paralelo e distribuÃdo. O livro também inclui vários comentários sobre as mais recentes padronizações de linguagem SQL além de abordar em estudos de casos as caracterÃsticas dos SGBDs mais utilizados atualmente.
Notas de conteúdo:
1. Introdução
2. Modelo relacional
3. SQL
4. SQL avançada
5. Outras linguagens relacionais
6. Projeto de banco de dados e o modelo E-R
7. Projeto de banco de dados relacional
8. Projeto de desenvolvimento de aplicação
9. Bancos de dados baseados em objeto
10. XML
11. Armazenamento e estrutura de arquivos
12. Indexação e hashing
13. Processamento da consulta
14. Otimização da consulta
15. Transações
16. Controle de concorrência
17. Sistema de recuperação
18. Mineração e análise de dados
19. Recuperação de informações
20. Arquiteturas de sistema de banco de dados
21. Bancos de dados paralelos
22. Bancos de dados distribuÃdos
23. Desenvolvimento avançado de aplicações
24. Tipos de dados avançados e novas aplicações
25. Processamento avançado de transações
26. PostgreSQL
27. Oracle
28. IBM DB2 Universal Database
29. Microsoft SQL Server
Palavras-chave:
BANCO DE DADOS/Gerência; BANCO DE DADOS/Sistemas.
CDU 004.65 / S582s / 5 ed. 3 reimpr. / 2006
Now with PostgreSQL and PostGIS goodness. PostGIS improves the query times by 30x. The queries are executed between 0.18 and 3.0 seconds, instead of 10 to 60 seconds with MySQL.
I took this screenshot with LittleSnapper and it didn't capture the red circle that outlined the 150 feet radius.
Data is from 2005-2010.
Database Architechs has a unique expertise designing scalable and high-performing database architecture using the latest technologies
Wellington is quite far away from many other places and thus knowing the correct time where our colleagues are, when we can reach clients or when we can schedule a server outage is a necessity.
With today's new fangled technology viewing predefined time zones is just a mouse click away. But it doesn't look as cool as actual clocks on the wall as in a news room.
Some of the times are not your standard locations, but they are of importance to us in the E-Learning team at Catalyst IT.
Map showing proposal to improve access to Dunbar station.
Map created on QGIS + GRASS + POSTGRESQL - map data openstreetmap ODbL.
Database Architechs has a unique expertise designing scalable and high-performing database architecture using the latest technologies
visualising the size of Scottish islands, by placing them side-by-side.
using a mixture of postgres/postgis, qgis and osm2pgsql.
used a postgis query to align the islands so that their centroids were all in the same place, then offset each successive island 20km east of its predecessor.
used data copyright OpenStreetMap and contributors. Polygons were based on admin_level='6', then split from multipart to singlepart. This made sure that Mull (for example) fragmented into lots of individual Islands so that I could isolate the "mainland" of Mull from the countless other islands just off its coast.
At the PostgreSQL party on 24-th floor of Corinthia Hotel in Prague. I told him about our contrib/ltree extension for tree-like data.
Greg Smith is an author of "PostgreSQL 9.0 High Performance" book and active member of PostgreSQL community.
Anastasia is known as author of Index-only scans support for GiST, which was commited to PostgreSQL 9.5 release. Her current project is a new access method based on LSM-trees.
Heroku.com sponsored boat trip on Vltava river for PostgreSQL European Conference. It was rather cold and dark, but I was able to made some pictures of Prague, thanks to my Nikon D800 and Carl Zeiss Distagon T* 2/28 lens. No tripod was used !
www.clasificadosyanuncios.org/trabajo/tiempo-completo/ana... grupo sms se encuentra en la bsqueda de analistas programadores java ssr y sr. para importante empresa ubicada en la zona de microcentro. .se requiere: .conocimientos avanzados de base de datos. .conocimientos avanzados en programacin segn el lenguaje requerido .conocimientos en prcticas de testing .conocimientos tcnicos segn requerimientos . .lenguaje java: .#9702; struts .#9702; spring .#9702; hibernate .#9702; j2ee (servlets, jsp, jdbc) .#9702; app server: jboss .#9702; base de datos: db2/ postgresql .deseables: .#9702; os-workflow .#9702; drools .#9702; quartz .#9702; jta .#9702; activemq .#9702; servicemix .#9702; programacin sql . .ofrecemos una posicin en relacin de dependencia, proyectos desafiantes, nuevos y con posibilidades de crecimiento profesional. aquellos interesados enviar cv con remuneracin pretendida indicando ref: ap java. . analista programador java ssr y sr. email de contacto en las imagenes
Sergey Koposov, Q3C (indexing of spherical data in PostgreSQL) author in Prague, IAU General Assembly. Can do you speak fast "the Quadrilateralized Spherical Cube" ?
Which is different from PostgreSQL. My score was probably fine (I have a hard time interpreting shit, now), I'm just washed out. It is apparently my M.O. to be depressed on Saturdays.
Yukihiro "Mats" Matsumoto. Honest, wondered why he was around, is a big time PostgreSQL fan, had an interesting talk, and more importantly told us his motivation behind Ruby: "Just For Fun" (stolen liberally from Linus Torbalds :P)
Shane McIntosh gave a very good and visual lightning talk about the supposedly dry topic of "Identifying Hotspots in Software Build Processes" at FOSDEM.
(Shane's Slides on Slideshare)
Identical to this test but with the following differences;
- Disk readahead value raised from 256 (default) to 16384
- vm.dirty_background_ratio value lowered from 5 (default) to 3
- vm.dirty_ratio value raised from 10 (default) to 40
# time sh -c "dd if=/dev/zero of=bigfile bs=8k count=2000000 && sync"
2000000+0 records in
2000000+0 records out
16384000000 bytes (16 GB) copied, 78.1669 s, 210 MB/s
real 1m37.615s
user 0m0.352s
sys 0m27.914s
# time dd if=bigfile of=/dev/null bs=8k
2000000+0 records in
2000000+0 records out
16384000000 bytes (16 GB) copied, 69.4623 s, 236 MB/s
real 1m9.470s
user 0m0.116s
sys 0m10.853s