Temporarily disable all indexes of a postgresql table
Disable temporarily and reenable table indexes can be useful to speed up a large insert or update query
Reset a PostgreSQL sequence and update column values
A simple way to reset and restart a broken PostgreSQL sequence.
Easy Webmapping with django-leaflet & django-geojson
Django-geojson is a set of tools to manipulate GeoJSON with Django. Django-leaflet allows you to use Leaflet in your Django projects. Together, they made webmapping really easy to play with.
Detect value changes between lines with PostgreSQL
A window function performs a calculation across a set of rows that are related to the current row. Here is an example of utilisation of window functions lag and lead to detect value changes between successive table rows.
An efficient GIT workflow for mid/long term projects
Our full-web CAMM project at Makina Corpus has been going on for nearly two years and is running in production for over 18 months. I think it's my first project without any headache about our codebase and VCS management. So, I'll present our GIT workflow which has proven to be …
Page 1 / 3
»