Posts
Sqlite with Python
Python 2.5 has a SQLite library. The documentation says it best what this can be used for : SQLite is a C library that provides a lightweight disk-based database that doesn't require a separate server process and allows accessing the database using a nonstandard variant of the SQL query language. Some applications can use SQLite for internal data storage. It's also possible to prototype an application using SQLite and then port the code to a larger database such as PostgreSQL or Oracle.
A one line webserver
Python has a built in webserver, that shows the contents of the directory it’s started in. Here’s how you run it : python -c "from SimpleHTTPServer import test; test()" This is invaluable if you have to copy some files across to another machine. It won’t work across the internet, but on a local network it can’t be beat. Yesterday I had to move a 2.4 Gig ISO file from the laptop PC to my Mac.
Using YAML in Python
YAML, which stands for ‘YAML Ain’t Markup Language’, is basically XML without < and > . This makes it very readable. Additionally, in dynamic languages such as Python, the data in the file will be loaded as a Python data structure. Here’s an example file : http://www.infoworld.com/rss/news.xml: (1970, 1, 1, 1, 0, 0, 3, 1, 0) http://weblog.infoworld.com/udell/rss.xml: (1970, 1, 1, 1, 0, 0, 3, 1, 0) http://weblog.infoworld.com/techwatch/rss.xml: (1970, 1, 1, 1, 0, 0, 3, 1, 0)
Stonehenge
Near Salisbury, in the county of Wiltshire in England, lies Stonehenge.
Detail
Creating PDFs using Python
ReportLab has a library for generating PDFs from Python. The following example will show how a PDF can be created using this library. The PDF will contain a title and a table. The first part of the script imports a few of the reportlab objects and sets up a few variables for stuff like titles. from reportlab.platypus import * from reportlab.rl_config import defaultPageSize import reportlab.lib.colors from reportlab.lib.units import inch PAGE_HEIGHT=defaultPageSize[1] Title = "Bill"