Popular Python recipes tagged "sqlite"

Put Peewee ORM data to PDF with xtopdf (Python)

2016-09-29T18:04:57-07:00

Python recipe 580704 by Vasudev Ram (conversion, converter, database, formats, orm, pdf, pdf_generation, peewee, python, python2, sqlite, xtopdf).

This recipe shows how some basics of how to fetch data from database tables managed by the Peewee ORM (a lightweight expressive ORM for Python) and write that data, formatted, to a PDF file. The recipe uses Python, the Peewee ORM and the xtopdf toolkit for PDF creation.

Publish SQLite data to PDF using named tuples (Python)

2015-02-24T22:08:11-08:00

Python recipe 579027 by Vasudev Ram (conversion, pdf, pdfwriter, sql, sqlite, sqlite3, xtopdf).

This recipe shows how to publish SQLite data to PDF, using named tuples from the collections module of Python, the sqlite3 library, and the xtopdf library for PDF generation.

A wxPython GUI To Create Sqlite3 Databases (Python)

2013-09-18T23:05:51-07:00

Python recipe 578665 by toufic zaarour (gui, python, sqlite, wxpython). Revision 2.

A GUI built around wxPython in a way that will allow you to add to this application other forms and functionalities. The main DialogBox is to create,in a fast way, Sqlite3 databases that are used for web or applications development. In order to work properly, save the script in a separate directory.There is also more; each time you create a database a text file named "CreationLog.txt" will be created (for the first time you use the application or if it is not there) and updated, describing when and where was your database created and with what SQL query. I am pleased to receive all the suggestions and improvements on this site or to my e-mail directly if this is convenient to you.

Python DBAPI 2 "qmark" to "named" paramstyle (Python)

2012-12-14T19:39:04-08:00

Python recipe 578380 by Steve Howe (dbapi, named, paramstyle, python, qmark, sqlite, sqlite3).

Allows to use "named"-style params with drivers that support only "qmark"-style, as sqlite3.

Android Gmail: export messages from SQLite database blobs (Python)

2013-03-22T11:45:11-07:00

Python recipe 578106 by ccpizza (android, sqlite). Revision 5.

This script will extract email message bodies from the SQLite database stored in an android phone.

The gmail database is typically located on your phone under the following location:

`\data\data\com.google.android.gm\databases\mailstore.YOURUSERNAME@gmail.com.db`

To use the script, copy the file above from your phone to your machine and rename it to gmail.db.

NOTE: You need a rooted phone in order to get access to the folder above.

sqlite message bus (Python)

2010-01-11T09:36:21-08:00

Python recipe 577001 by André Bjärby (message_bus, sqlite).

Let several (unix) processes communicate via a shared sqlite database.

firefox sqlite files cleaner (Python)

2009-07-18T21:41:13-07:00

Python recipe 576842 by peekaa (firefox, sqlite). Revision 7.

Walks through the all the Firefox profiles in current user account and cleans all *.sqlite files with "vacuum". It makes firefox faster then often. Should work on Linux, too, when properly changed constants.

For: python 2.6 (2.5+sqlite3), FF 3.5

firefox sqlite files cleaner (linux) (Python)

2009-07-15T12:15:20-07:00

Python recipe 576843 by Vince Spicer (firefox, sqlite). Revision 3.

Modified from Recipe 576842 to support linux

Walks through the all the Firefox profiles in current user account and cleans all *.sqlite files with "vacuum". It makes firefox faster then often.

tested on Ubuntu

For: python 2.6 (2.5+sqlite3), FF 3.5

MultiThread support for SQLite access. (Python)

2010-07-20T14:29:35-07:00

Python recipe 526618 by Louis RIVIERE (database, sqlite, threads). Revision 4.

Workaround for the SQLite limitation that prevents multiple threads from sharing a Connection object.