Popular 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.

Using SQLite as an embedded database with C# instantly (Text)

2010-12-15T01:24:06-08:00

Text recipe 577500 by Stephen Akiki (akiscode, csharp, database, embedded, sqlite).

http://akiscode.com/articles/sqlite-csharp.shtml

There are a few libaries that every programmer loves and knows because they either:

Saves you a ton of time coding
Does something that you don't know how to do yourself

Examples include cURL, SQLite, or even the .NET library itself. Many of us have to create CRUD (Create, Read, Update, Delete) projects on a semi-regular routine. SQLite is nice in the fact that it handles all the CRUD-y stuff (bad pun I know) in a simple, small and standalone package. But because SQLite is so nice to use (when compared to say XML), the Gods have cursed SQLite to cause many headaches if you are a new to it on C# to balance the world karma (or something like that). Also note that i'm not going to explain what any of the code does as its pretty self explanatory. Anyway, here is a complete example on how to setup an embedded SQLite database, insert some data into it, and then update a listview with only certain columns from the database:

The Fun Stuff

*NOTE: I've made a demo project that you can download here. It includes the DLLs and everything that i've talked about below. *
Download the setup from these guys and install it.
Start a new Project in Visual C# Studio (I'm using version 2010 Express). Make it a Windows Forms Application. Save it anywhere. For this example, I will save it on the Desktop and call the project "Akiscode-SQLiteTest. At the time I was doing this, the SQLite dll only worked with a program targeted at .NET version 3.5. To learn how to change that go here.
Go to the Solutions Explorer on the top right of your VC setup. Right click references and select "Add Reference". Go to the ".NET" tab and find the entry named "System.Data.SQLite". Not "System.Data.Sql", not "System.Data.SqlXml", NOT "MySql.Data". Just find "System.Data.SQLite". If you can't find it, sort the list by name. If you still can't find it, restart VC and try this process again. Still can't find it? Run the installer and do it all over again. Still not there? Well I can't really help you, hand in your programming badge on the way out.
Once you added "System.Data.SQLite", right click it and select properties. Set "Copy Local" to true.
Ok type at the top "using "using System.Data.SQLite;" without the quotes.
Go back to the form designer. Add a listview component. In the properties window (bottom right) make sure the property view is set to "Details". Then right click on the listview and add columns. For this example I added two called "First Name" and "Last Name"

8.Ok now for some copy and paste coding (my favorite): Double click the form to make a "Form1_Load" function appear and paste the following in it:

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.