Disable temporarily and reenable table indexes can be useful to speed up a large insert or update query
Posts published by: Florent Lebreton (fle)
A simple way to reset and restart a broken PostgreSQL sequence.
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.
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.
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 …