How to get current year, month, day, etc. in python

Ok, so you have been coding for quite some long hours this week and you suddenly realie you dont even know what day it is. Or even year (yes, it happens). Since you are on the python command line, here’s what you can do:

(ok, so the scenario could be slightly different…still, the method to retrieve the date parameters are relevant anyway)

from datetime importdatetime

currentYear =
currentMonth =
currentDay =
currentHour =
currentMinute =
currentMicrosec =
currentWeekday = # weekday as integer - 0 is monday, 1 is tuesday, etc.

There’s lots of cool datetime calculations, methods and magic to be learned. Check the documentation link below.

Some reference reading:

Python docs: datetime — Basic date and time types
From blog “Programming By A Tool”

Django template to respect plain text field linebreaks

If you have a text field with linebreaks in your nice django admin and your cool template refuses to respect them, use this in your template:

{{ variable|linebreaks }}

this replaces newlines with HTML

<br />

and newlines with blank lines with


Learn tons of great stuff from your trusty Django docs:
Built-in template tags and filters

Remove repeated adjacent characters from string

Given a string like:

we want to output:


here are a few ways to do it in Python:

|Read the Rest of the Entry…

Quickly change a Django user password

So you have this nice django site, you try to access the admin to change some minor thing and you completely forgot (and didnt save somewhere) the password of the only user in the system – so many dont’s in that sentence, but anyway…

Since you are the developer, you can simply do this (assuming you at least know the user’s username):

python changepassword [username]

You will be prompted for a new password, and confirmation, and its done. Then you can go login to your nice admin and smile.

Read more about this and learn new things here:
Using the Django authentication system (opens in a new window)

PostgreSQL – PostGIS versions

Login to your postgresql on some database and go:

To get PostgreSQL version:

SELECT version();

To get versions for PostGIS, GEO, etc.:

SELECT PostGIS_full_version();

How to list and alter table sequences in PostgreSQL

So you screwed up with your ninja manual inserts on some lost and forgotten table. In such a way that when your shiny django backoffice gives you a fullscreen yellow error about duplicate keys. What now? Well, you read and i will show you how to circumvent the system (well, kind of).

|Read the Rest of the Entry…

How to add robots.txt to a Django project

So we had this nice, unfinished project, publicly shared on a public server being indexed like a pig’s behind on google servers. Some searches on google had hits to full length urls to this unfinished project on the test server. Easily stopped using the robots.txt, except that its a Django site and its not as simple as putting the file on the server’s root. Its not that hard either, but you have to know how.

Anyway, here are a few solutions i found:

|Read the Rest of the Entry…

Javascript Functions optional parameters

Ok, you want to create a function to be used several times (well, isnt that the main purpose of them?), but, depending on the call, you can have 1 argument or several. How do you go about doing it? Enter the world of optional parameter functions. Or something like that…after the jump.

Here are three ways:

|Read the Rest of the Entry…

PosgreSQL encoding problems

A very simple problem im sure all postgreSQL users/devs have come across one time or the other:

So you have your shiny PostgreSQL Database in some nice server somehwre and you want to manually make some changes. Say you have tons of records on some table and want to replace a word with a different one. All good, except the database in encoded in utf8 and you have text with accented characters.

Jump to learn.

|Read the Rest of the Entry…

PostgreSQL login basics

Just to keep things organized, i will leave this info here for one more hit on the interwebs.

There are tons of parameters and tips and tricks, but i will just leave the bare basics. After the jump.


|Read the Rest of the Entry…

%d bloggers like this: