1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="generator" content="Docutils 0.3.9: http://docutils.sourceforge.net/" />
<title>PyGreSQL future directions</title>
<link rel="stylesheet" href="docs.css" type="text/css" />
</head>
<body>
<div class="document" id="pygresql-future-directions">
<h1 class="title">PyGreSQL future directions</h1>
<div class="section" id="to-do">
<h1><a name="to-do">To Do</a></h1>
<ul class="simple">
<li>Support PQescapeStringConn and PQescapeByteaConn
(see also <a class="reference" href="http://www.postgresql.org/docs/techdocs.49">http://www.postgresql.org/docs/techdocs.49</a>)</li>
<li>Use PQescapeStringConn in the _quote() function of pg and pgdb.</li>
<li>Support composite primary keys
(see <a class="reference" href="http://mailman.vex.net/pipermail/pygresql/2006-May/001688.html">http://mailman.vex.net/pipermail/pygresql/2006-May/001688.html</a>)</li>
<li>The DB-API module needs docstrings and external documentation.</li>
<li>Create separate unit tests for _pg, pg and pgdb.</li>
<li>The large object and direct access functions need much more attention.</li>
<li>An update query should return the number of rows affected.</li>
<li>The C module needs to be cleaned up and redundant code merged.</li>
<li>The fetch method should use real cursors.</li>
</ul>
</div>
<div class="section" id="proposed-patches">
<h1><a name="proposed-patches">Proposed Patches</a></h1>
<ul class="simple">
<li>Notice handling
(<a class="reference" href="http://mailman.vex.net/pipermail/pygresql/2005-November/001530.html">http://mailman.vex.net/pipermail/pygresql/2005-November/001530.html</a>)</li>
</ul>
</div>
<div class="section" id="wish-list">
<h1><a name="wish-list">Wish List</a></h1>
<ul class="simple">
<li>Make SQLSTATE error codes available.</li>
<li>Make use of PQexecParams() and PQprepare(). This could speed up
executemany() and allow retrieving binary data directly by setting
the resultFormat parameter to one.</li>
<li>Users should be able to register their own types with _pg.</li>
<li>I would like a new method that returns a dictionary
of dictionaries from a SELECT.</li>
<li>Add support for persistent and pooled connections
that can be used in multi-threaded environments (we could simply
(add <a class="reference" href="http://www.webwareforpython.org/DBUtils">http://www.webwareforpython.org/DBUtils</a> to the distribution).</li>
<li>Make PyGreSQL thread-safe on the connection level.</li>
<li>The API documentation could be created with Epydoc.</li>
<li>Write a tutorial for beginners and advanced use.</li>
<li>More and better documented examples.</li>
</ul>
</div>
</div>
</body>
</html>
|
