Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 31.751.426 Times

pg/python 1.0

Company: pg/python project
Date Added: December 01, 2013  |  Visits: 336


Report Broken Link
Printer Friendly Version

Product Homepage
Download (19 downloads)

pg/python is an open source project working toward the improvement of Python interfaces to PostgreSQL.<br /><br />Quick start:<br /><br />Fetch and Install pg_proboscis<br /><br />easy_install pg_proboscis<br /><br />Connect to a database with the frontend<br /><br />import as pq<br />Con = pq.Connector(<br />user = 'root',<br />host = 'localhost',<br />port = 5432,<br />ssl = True, # Optional. Only set it to True if you want it.<br />database = 'pgsql',<br />)<br /># This creates a Connection *class*, it still needs to be instantiated.<br />C = Con()<br />C<br /><br /><br /># Let's query the database; your results may vary.<br />Q = C.Query("SELECT * FROM pg_proc WHERE proname = $1")<br />P = Q('byteain')<br />for x in P: print x<br />('byteain'::name, '11'::oid, '1'::int4, '12'::oid, False, False, True, False,<br />'i'::char, '1'::int2, '17'::oid, '2275'::oidvector, None, 'byteain'::text,<br />'-'::bytea, '{=X/pgsql}'::_aclitem)<br />print type(x)<br />(proname name, pronamespace oid, proowner int4, prolang oid, proisagg bool,<br />prosecdef bool, proisstrict bool, proretset bool, provolatile char, pronargs<br />int2, prorettype oid, proargtypes oidvector, proargnames _text, prosrc text,<br />probin bytea, proacl _aclitem,)<br /><br />print repr(x["proname"])<br />'byteain'::name<br />print repr(x[0])<br />'byteain'::name<br /><br />for y in x: print repr(y)<br /><br />'byteain'::name<br />'11'::oid<br />'1'::int4<br />'12'::oid<br />False<br />False<br />True<br />False<br />'i'::char<br />'1'::int2<br />'17'::oid<br />'2275'::oidvector<br />None<br />'byteain'::text<br />'-'::bytea<br />'{=X/pgsql}'::_aclitem<br /><br />print x["proacl"][0]<br />=X/pgsql<br /><br />Please be sure to see the documentation for more details.<br />

Requirements: No special requirements
Platforms: *nix, Linux
Keyword: Bool Byteain False Improvement Interfaces Open Postgresql Print Project Proname Python Repr Source Text True Working
Users rating: 0/10

License: Freeware Size: 31.74 KB
Database Tools  -  The Open For Business Project 3.0.0
The Open For Business Project is an open source enterprise automation software project licensed under the MIT Open Source License. By open source enterprise automation we mean: Open Source ERP, Open Source CRM, Open Source E-Business /...
28.51 MB  
Text Editors  -  Aquarium 1.0
Aquarium is an open source text filtering package written in PHP. It filters nearly all four-letter words, profanities, curses, and pornographic language from any text, while filtering nearly no benign words. It can keep your blog, forum,...
11.26 KB  
Utilities  -  Edhita: Open source text editor 1.0.1
Edhita is Open source text editor for iPad. [Features] * Make(rename) direcotries and files * View files in built-in browser * Download files by HTTP * Input symbols by accessory view * Send files by...
1.1 MB  
Games  -  Open Dice Language 1.5
Open Dice Language project is a language for describing dice rolls. Open Dice Language is a language for describing dice rolls. The language is nearly identical to what you see in most role-playing game texts (e.g., "1d20"). It provides...
501.76 KB  
Programming  -  Otk Tests 1.0
Otk Tests are tests for the Open Tool Kit project. Otk is a portable widget library for making graphical user interfaces for C programs. It emphasizes simplicity for the application programmer without eliminating capability. Based on OpenGL, Otk...
6.14 KB  
Games  -  Open Gaming System 0.1.1
Open Gaming System project is a platform for developing open gaming software. It defines an API and provides a free software implementation of this interface. It is designed to be portable, reusable, and flexible enough for use in any game world...
Simulation Games  -  Open Pinball Simulator 0.0.6b
Open Pinball Simulator project is an pinball simulator. The program is divided into two processes. The main process takes care of interpreting the .table description files and controls the balls movements according to physical laws. It...
102.4 KB  
Simulation Games  -  Open Ski Jumping 0.2.0
Open Ski Jumping project is a ski jumping game. Its a simulation game for the console and/or X11. It contains fairly good graphics, and features like replays and hill records.. ski holidays snowboard resorts resort area skiing snow jump jumping
Libraries  -  Tie::Layers 0.06
SYNOPSIS ##### # Subroutines # use Tie::Layers qw(is_handle config); $yes = is_handle( $file_handle ); ($key, $old_value) = config(%options, $key); ($key, $old_value) = config(%options, $key => $new_value ); #### # Config default...
71.68 KB  
File Utilities  -  McDwiff 1.1
McDwiff... DWF. Mac-style. Open, view, print, and convert Autodesk DWF files with this easy-to-use Mac application.Free for non-commercial use, $39 for commercial license.
87 KB  
Linux Software  -  wpCache® WordPress HTTP Cache 1.9
wpCache® is a high-performance, distributed object, caching system application, generic in nature, but intended for use in speeding up dynamic web applications, by decreasing database load time. wpCache® decreases dramatically the page...
3.51 MB  
Linux Software  -  Polling Autodialer Software 3.4
ICTBroadcast Auto Dialer software has a survey campaign for telephone surveys and polls. This auto dialer software automatically dials a list of numbers and asks them a set of questions that they can respond to, by using their telephone keypad....
488 B  
Linux Software  -  Total Video Converter Mac Free 3.5.5
Total Video Converter Mac Free developed by EffectMatrix Ltd is the official legal version of Total Video Converter which was a globally recognized brand since 2006. Total Video Converter Mac Free is a free but powerful all-in-one video...
17.7 MB  
Linux Software  -  Skeith mod_log_sql Analyzer 2.10beta2
Skeith is a php based front end for analyzing logs for Apache using mod_log_sql.
47.5 KB  
Linux Software  -  SLAX 6.0+
Slax is a modern, portable, small and fast Linux operating system with a modular approach and outstanding design. Despite its small size, Slax provides a wide collection of pre-installed software for daily use, including a well organized graphical...
190 KB  
Business  -  Java SQL Admin Tool for Linux 2.4.3
This is a Java-based Admin-Tool for SQL-Databases via JDBC. It needs to have JDK 1.6 underneath In the beginnings of Java I had my first look at this exciting product. So I decided to learn more about Java. As beeing a developer for...
686.08 KB  
Business  -  DBBalancer 0.4.4
DBBalancer is some sort of middleware that would sit in between of database clients, like C, C++, TCL, Java JDBC, Perl DBI, and a database server. Currently the only server supported is Postgres, but the architecture is open to embrace more...
174.08 KB  
Business  -  Postgres Plus 9.0.4
Postgres Plus is a distribution of PostgreSQL that contains the following additional features integrated in a convenient installation package: Postgres Studio for administration, Procedural Language Debugger, GridSQL Parallel Query, MySQL...
43.06 MB  
Business  -  Insulin Buddy 1.0b
Insulin Buddy is diabetes management software. It allows for quick and painless entry of all diabetes-related data (blood blucose, carbohydrate consumption, insulin doses, etc) and provides a number of reports, charts and data exports to easily...
2.52 MB  
Business  -  Apatar Data Integration 1.12.23
Apatar is an open source Extract, Transform, and Load (ETL) project. Modular architecture delivers: 1. Visual job designer/mapping 2. Connectivity to all major data sources 3. Flexible Deployment Options (GUI, or server engine with JVM, or...
25.94 MB