We'd like to announce the release candidate for
HTSQL 2.1, a high-level query language and web
service gateway for relational databases. HTSQL
is specifically designed for analytical inquiries
and targeted to data analysts and web developers.
HTSQL is implemented as a WSGI component, works
with PostgreSQL, MySQL, SQLite and could be used
to embed ad-hoc reporting features into your
Python application.
Homepage: http://htsql.org
Download: http://pypi.python.org/pypi/HTSQL/
Source: http://bitbucket.org/prometheus/htsql
Since 2.0 release, announced in February, we added many
new language features which increase the "query power"
of the language. HTSQL is now able to express quite
sophisticated business inquiries.
The 2.2 release of HTSQL later this year will be
focused on "usability". It'll include improved
configuration, a query editor and formatting options.
Also for this release we've cleaned up the homepage
for HTRAF -- a javascript toolkit for constructing
attractive dashboards and interactive reports. This
toolkit is MIT licensed and implemented as a JQuery
plugin. For more detail, please visit http://htraf.org.
Let's us know if you have any questions!
Clark C. Evans & Kirill Simonov
***********************************************************
HTSQL -- A Query Language for the Accidental Programmer
***********************************************************
HTSQL ("Hyper Text Structured Query Language") is a high-level query
language for relational databases. The target audience for HTSQL is
the accidental programmer -- one who is not a SQL expert, yet needs a
usable, comprehensive query tool for data access and reporting.
HTSQL is also a web service which takes a request via HTTP, translates
it into a SQL query, executes the query against a relational database,
and returns the results in a format requested by the user agent (JSON,
CSV, HTML, etc.).
Use of HTSQL with open source databases (PostgreSQL, MySQL, SQLite) is
royalty free under BSD-style conditions. Use of HTSQL with proprietary
database systems (Oracle, Microsoft SQL) requires a commercial license.
See ``LICENSE`` for details.
For installation instructions, see ``INSTALL``. For list of new
features in this release, see ``NEWS``. HTSQL documentation is in the
``doc`` directory.
http://htsql.org/
The HTSQL homepage
http://htsql.org/doc/introduction.html
Get taste of HTSQL
http://htsql.org/doc/tutorial.html
The HTSQL tutorial
http://bitbucket.org/prometheus/htsql
HTSQL source code
irc://irc.freenode.net#htsql
IRC chat in #htsql on freenode
http://lists.htsql.org/mailman/listinfo/htsql-users
The mailing list for users of HTSQL
HTSQL is copyright by Prometheus Research, LLC. HTSQL is written by
Clark C. Evans <cce(a)clarkevans.com> and Kirill Simonov
<xi(a)resolvent.net>.
Generous support for HTSQL was provided by the Simons Foundation.
This material is also based upon work supported by the National
Science Foundation under Grant #0944460.
Hi Everybody! Standing Cloud has just launched our brand new Python
dev platform. You can deploy it on a dozen cloud providers, scale your
infrastructure from within the GUI and deployments are 'cross-cloud
portable.' We've built features that allow you to sync to a repo (GIT,
SVN) to deploy your code.
We'd love for you to check it out. We're working to build something
useful for the Python community, so your feedback is appreciated. You
can spin up a test drive on any of our supported clouds for free.
Check it out and let us know what you think!
http://www.standingcloud.com/network/python
Best,
Cameron Weiss
The next Cape Town Python Users Group meeting will this Saturday, 2nd
of July, starting at 14:00. We will be using the Events room at the
Bandwidth Barn.
Simon Cross will talk a bit about python's Method Resolution Order.
Maciej Fijałkowski will a lead a hands-on PyPy session.
See http://www.ctpug.org.za/wiki/Meeting20110702 for more details.
--
Neil Muller
drnlmuller(a)gmail.com
I've got a gmail account. Why haven't I become cool?
Hi Everyone,
We have confirmed arrangements for two days of Sprints following PyCon
Au this year. This will be a great opportunity to contribute to the
Python ecosystem under the guidance of experienced developers, so bring
your laptops!
PyCon Australia is Australia's only conference dedicated exclusively to
the Python programming language, and will be held at the Sydney Masonic
Center over the weekend of August 20 and 21. See below for more
information and updates on:
1. Post-Conference Sprints
2. Thanks to our Sponsors
Please pass this message on to those you feel may be interested.
Post-Conference Sprints
=======================
We are taking up the global PyCon tradition of post-conference sprints
this year at PyCon Au.
A Sprint is an opportunity for people to get together and do focussed
development on a project in a fun and welcoming atmosphere. Experienced
developers will be on hand to help newcomers get started, so bring your
laptops and take this opportunity to contribute to the Python ecosystem!
The sprints will be held on the 22nd and 23rd of August at the Sydney
Masonic Center. Sprint leaders and topics so far include:
Nick Coghlan: Python core development
Audrey Roy/Danny Greenfeld: Django and/or Packaginator
Richard Jones: Python Package Index
For more information and updates see:
http://www.pycon-au.org/2011/sprints/
Please register your interest by emailing pycon-reg(a)pycon-au.org.
Thanks to our Sponsors
======================
Thanks once again to the following companies for their continuing
support of Python and for helping to make PyCon Australia 2011 a
reality:
Gold: Google <http://www.google.com.au/>
Gold: ComOps <http://www.comops.com.au/>
Silver: Anchor <http://anchor.com.au/>
Silver: Enthought <http://www.enthought.com/>
Silver: Python Software Foundation <http://www.python.org/psf/>
Silver: WingWare <http://www.wingware.com/>
Silver: Superior Recruitment <http://superiorrecruitment.com.au/>
Thanks also to Linux Australia, who provide the overarching legal and
organisational structure for PyCon Australia.
Ryan Kelly
PyCon Australia 2011
All:
I have recently completed a draft of "Python. Vulnerability descriptions for
the language" for eventual submission to the International Organization for
Standardization (ISO) Information and Communication Technologies (ICT)
committee. This document enumerates the standard ways in which programming
languages are exposed to vulnerabilities, how Python is exposed to each, and
how to avoid each vulnerability.
I am seeking:
. Advice as to the comprehensiveness and completeness of the
vulnerabilities and remedies;
. Comments about the code examples and explanations;
. Additional vulnerabilities;
. Suggestions for improving the readability of the document; and
. Any general suggestions including typos etc.
If you are interested please send me a short email with point of contact
information and your background/interest in the Python language.
Regards,
Kevin Coyne
kevinjcoyne(a)hotmail.com
We will meet Wednesday, July, 13th
starting about 6.30 pm - 6.45 pm
at Room 0.14, Benutzerrechenzentrum (RRZK-B)
University of Cologne, Berrenrather Str. 136, 50937 Köln, Germany
On this month's agenda:
- EuroPython review (Reimar Bauer, ...)
- pylint and Django apps (!django-lint) (Andi Albrecht)
Any presentations, news, book presentations etc. are welcome
on each of our meetings!
At about 8.30 pm we will as usual enjoy the rest of the evening in a
nearby restaurant.
Further information including directions how to get to the location
can be found at:
http://www.pycologne.de
(Sorry, the web-links are in German only.)
Regards,
Andi
Hi All,
Pydev 2.2.0 has been released
Details on Pydev: http://pydev.org
Details on its development: http://pydev.blogspot.com
Release Highlights:
-------------------------------
**Eclipse 3.7**
* Eclipse 3.7 (Indigo) is now supported.
**Break on Exceptions**
* It's now possible to **break on caught exceptions** in the debugger.
* There's an UI to break on caught or uncaught exceptions (menu: Run
> Manage Python Exception Breakpoints).
**Hierarchy view**
* UI improved (now only uses SWT -- access through F4 with the
cursor over a class).
**PyPy**:
* PyDev now supports PyPy (can be configured as a regular Python interpreter).
**Django**
* Django configuration in project properties page (improved UI for
configuration of the django manage.py and django settings module).
* Improved support for debugging Django with autoreload. Details at:
http://pydev.org/manual_adv_remote_debugger.html#django-remote-debugging-wi…
**Code analysis**
* Fixed issue where a resolution of a token did not properly
consider a try..except ImportError (always went for the first match).
* Fixed issue with relative import with wildcards.
* Fixed issue with relative import with alias.
* Fixed issue where binary files would be wrongly parsed (ended up
generating errors in the error log).
**Code completion**
* Improved sorting of proposals (__*__ come at last)
**Others**
* Improved ctrl+1 quick fix with local import.
* Fixed issue running with py.test.
* PyDev test runner working properly with unittest2.
* Fixed compatibility issue with eclipse 3.2.
* No longer sorting libraries when adding interpreter/added option
to select all not in workspace.
* Fixed deadlock in the debugger when dealing with multiple threads.
* Fixed debugger issue (dictionary changing size during thread
creation/removal on python 3.x).
What is PyDev?
---------------------------
PyDev is a plugin that enables users to use Eclipse for Python, Jython
and IronPython development -- making Eclipse a first class Python IDE
-- It comes with many goodies such as code completion, syntax
highlighting, syntax analysis, refactor, debug and many others.
Cheers,
--
Fabio Zadrozny
------------------------------------------------------
Software Developer
Appcelerator
http://appcelerator.com/
Aptana
http://aptana.com/
Pydev - Python Development Environment for Eclipse
http://pydev.orghttp://pydev.blogspot.com
PyCon DE 2011 - Tutorial-Program
================================
The program of tutorials at PyCon DE 2011 is finalized [1].
There are 12 three-hour tutorials covering a wide range of Python topics such
as Python for newbies, web development, algorithms, tests, data analysis,
databases or Cython.
The instructors are all experienced Python developers with profound
knowledge in Python as well as their special domain. They can answer
even challenging questions. The tutorial day is an amazing opportunity to
deepen your Python knowledge.
__
Mike
[1] http://de.pycon.org/2011/schedule/tutorials/
PyCon DE 2011 - Tutorial-Programm
=================================
Das Tutorial-Programm [1] für die PyCon DE 2011 ist veröffentlicht.
Insgesamt 12 drei-stündige Tutorials bieten eine breite Palette von
Python-Themen wie Python für Einsteiger, Web-Entwicklung, Algorithmen, Tests,
Datenanalyse, Datenbanken oder Cython.
Die Referenten sind alle erfahrene Python-Entwickler mit ausgewiesenem,
profunden Wissen in Python und ihrem Spezialgebiet, die auch anspruchsvolle
Fragen beantworten können. Der Tutorial-Tag der PyCon DE bietet eine tolle
Gelegenheit sein Python-Wissen zu erweitern.
Viele Grüße,
Mike
[1] http://de.pycon.org/2011/schedule/tutorials/
PyCon AU gender diversity grants for women in Python
====================================================
PyCon AU is pleased to announce that it will be offering two gender
diversity delegate grants to women who wish to attend PyCon AU in
2011. These grants will *both* cover full registration costs; in
addition, one of the grants will cover up to $AUD500 of travel and
accommodation costs for a woman living outside of the Sydney region to
attend.
These grants aim to reduce the financial barriers to attending PyCon
AU 2011, by subsidising the registration and travel costs of people
from diverse groups, who contribute in important ways to the Python
community.
More information can be found at http://pycon-au.org/2011/grants/
Eligibility
-----------
In order to be eligible for one of the grants, you must be:
* a woman, aged 18 or older
* professional, hobbyist or student interested in, or currently
working in Python-related fields or projects
* planning to attend both days of PyCon AU 2011
In order to be eligible for the travel and accommodation grant, you
must additionally:
* live further than 150 km from the conference venue.
(If you are unsure, please visit
http://maps.google.com.au/maps/place?q=66+Goulburn+St,+Sydney,+NSW+2000
and use the "Get Directions" link in the upper left-hand corner to
calculate the driving distance from your place of residence to the venue.)
More information can be found at http://pycon-au.org/2011/grants/
Award Amount
------------
Both selected grant recipients will receive a free Full registration
to PyCon AU (including a seat at the conference dinner on Saturday
night), worth $198.
In addition, the recipient of the travel and accommodation grant will
be reimbursed up to $500 in travel and accommodation costs.
More information can be found at http://pycon-au.org/2011/grants/
Timeline
--------
Applications for the gender diversity delegates grants are open now,
and will close on **8th of July**. We will notify all successful
recipients of their award by **15th of July** so that you can have
ample time to complete your travel plans.
More information can be found at http://pycon-au.org/2011/grants/
Tim 'mithro' Ansell
PyConAU Organiser