import sqlite3 class Point(object):    def __init__(self, x, y):        self.x, self.y = x, y     def __repr__(self):        return "(%f;%f)" % (self.x, self.y) def adapt_point(point):    return "%f;%f" % (point.x, point.y) def convert_point(s):    x, y = map(float, s.split(";"))    return Point(x, y) # Register the adaptersqlite3.register_adapter(Point, adapt_point) # Register the convertersqlite3.register_converter("point", convert_point) p = Point(4.0, -3.2) ########################## 1) Using declared typescon = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES)cur = con.cursor()cur.execute("create table test(p point)") cur.execute("insert into test(p) values (?)", (p,))cur.execute("select p from test")print "with declared types:", cur.fetchone()[0]cur.close()con.close() ######################## 1) Using column namescon = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_COLNAMES)cur = con.cursor()cur.execute("create table test(p)") cur.execute("insert into test(p) values (?)", (p,))cur.execute('select p as "p [point]" from test')print "with column names:", cur.fetchone()[0]cur.close()con.close()