Microsoft Access Database Connectivity (DSN-Less) (PHP)

2006-08-29T03:08:29-07:00

PHP recipe 163447 by Erick Guanlao (database). Revision 4.

An example of connecting to a Microsoft Access database, executing an SQL query, and displaying the results in HTML using PHP and COM (Windows only).

NOTE: This works with PHP 4.x. I have been unsuccessful with getting this to work with PHP 5.1.6 and Apache 2.0.59 on Windowx XP Professional.

Use generators for fetching large db record sets (Python)

2010-02-10T10:47:53-08:00

Python recipe 137270 by Christopher Prinos (database). Revision 5.

When using the python DB API, it's tempting to always use a cursor's fetchall() method so that you can easily iterate through a result set. For very large result sets though, this could be expensive in terms of memory (and time to wait for the entire result set to come back). You can use fetchmany() instead, but then have to manage looping through the intemediate result sets. Here's a generator that simplifies that for you.

DBF reader and writer (Python)

2009-04-29T07:28:14-07:00

Python recipe 362715 by Raymond Hettinger (database). Revision 7.

Reader iterates over records in Dbase or Xbase files. Writer creates dbf files from Python sequences.

Read tabular data from Excel spreadsheets the fast and easy way (Python)

2005-12-14T20:36:30-08:00

Python recipe 440661 by Nicolas Lehuen (database). Revision 3.

Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC + mxODBC), but the easiest way I've found is this one : provide a file name and a sheet name, and read the data !

Microsoft Access Database Connectivity (PHP)

2002-04-28T10:39:45-07:00

PHP recipe 123709 by Daniel Hendricks (database).

This is an example of how you can pull data from a Microsoft Access database through ADO.

Python Database Interface for MS SQL Server (Python)

2010-06-04T14:31:44-07:00

Python recipe 144183 by Jorge Besada (database). Revision 11.

This DBI implements the Cursor and Connection objects. It is functional: you can create connections, cursors, do fetchone, fetchall, get rowcount, etc. It uses osql or sqlcmd instead of ODBC or ADO. There is a good sized section with examples to get you started.

PHP MySQL Search Class (PHP)

2003-10-28T19:57:45-08:00

PHP recipe 125901 by Stephen Bartholomew (database). Revision 10.

This class can perform a full text search over multiple columns of a MySQL database table, matching entries containing all search terms parsed to it.

Storing binary data in SQLite (Python)

2003-12-13T20:37:16-08:00

Python recipe 252531 by John Barham (database).

This script demonstrates how to store binary data (aka BLOB or BINARY fields) in SQLite using the PySQLite extension.

Extraction and manipulation class for Microsoft Access (Python)

2008-03-01T07:15:52-08:00

Python recipe 528868 by Grant Paton-Simpson (database). Revision 2.

Class for extracting and manipulating data from Microsoft Access - identifying tables, getting recordsets, iterating through the results, counting rows, getting field names, getting index information, deleting indexes, and adding and deleting relationships.

Class for writing content to Excel and formatting it (Python)

2007-09-07T03:08:02-07:00

Python recipe 528870 by Grant Paton-Simpson (database). Revision 4.

Class for creating Excel spreadsheets - esp writing data and formatting them. NB OpenOffice Calc will be easily able to open the outputs too.

Create SQL tables from CSV files (Python)

2010-02-24T13:47:36-08:00

Python recipe 498130 by Matt Keranen (database).

Script generates CREATE TABLE statements based on the width of data present in comma delimited (csv) test files. Setting the correct datatypes (other than VARCHAR), is still a manual adventure.

TODOs:

Eliminate '#N/A', '@NA' from data
Remove commas from numeric data
Check for duplicate column names
Create BCP format file or INSERT statements?

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.

Export Oracle Database to CSV using cx_Oracle (Python)

2010-07-11T19:49:42-07:00

Python recipe 577304 by FB36 (csv, database).

Creates a CSV file for each table in the target Oracle database.

Generate SQL for insertation into table from dictionary object (Python)

2005-11-26T18:28:53-08:00

Python recipe 457661 by Carson Reynolds (database). Revision 2.

This recipe shows you how you might generate SQL code to insert the key-value pairs in a dictionary. The parameter table corresponds to an existing SQL table and dictionary keys correspond to the table's SQL column names. The SQL generated can then be inserted into a database (in this case MySQL) in the manner shown in exampleOfUse().

A higher level struct module (Python)

2006-10-26T14:47:57-07:00

Python recipe 498149 by Brian McErlean (database). Revision 4.

This recipe provides a higher level wrapper around the struct module. It provides a more convenient syntax for defining and using structs, and adds additional features such as: - Allows embedding structures within other structures - Allows defining arrays of items (or other structures) - Class based syntax, allowing access and updates by field name, not position - Extension of structures by inheritance

Reverse engineer MS Access/Jet databases (Python)

2004-09-16T19:24:51-07:00

Python recipe 52267 by Matt Keranen (database). Revision 5.

Reads the structure of a Jet (Microsoft Access .MDB) database file, and creates the SQL DDL necessary to recreate the structure.

Originally written to aid in migrating Jet databases to larger RDBMS systems, through E/R design tools, when the supplied "import" routines missed objects like indexes and FKs.

A first experiment in Python, that became an often used tool.

PyDbLite, a small in-memory database engine (Python)

2011-07-18T19:36:04-07:00

Python recipe 496770 by Pierre Quentel (database). Revision 4.

A small, fast, in-memory database management program

The database object supports the iterator protocol, so that requests can be expressed with list comprehensions or generator expressions instead of SQL. The equivalent of :

cursor.execute("SELECT name FROM table WHERE age=30")
rows = cursor.fetchall()

is :

rows = table(age=30)

The module stores data in a cPickled file. Records are indexed by a unique record identifier, that can be used for direct access. Since operations are processed in memory they are extremely fast, nearly as fast as SQLite in the few tests I made, and MUCH faster than other pure-Python modules such as Gadfly or KirbyBase. An index can be created on a field to even speed up selections

Concurrency control is supported by a version number set for each record

Complete documentation is here

Using Berkeley DB Database (Python)

2003-03-12T01:25:46-08:00

Python recipe 189060 by Farhad Fouladi (database).

Berkeley DB is an open source database. Its most important advantages are its simplicity to use and its performance.

This is an introductory example, that shows how to create a database, add new elements in it (as Key/Value pairs) and finally how to print all content of the database. The example is divided in two independent part.

Using the MySQLdb interface (Python)

2002-05-12T22:36:47-07:00

Python recipe 65235 by Mark Nenadov (database). Revision 5.

A simple example showing how to use the MySQLdb interface to function with your MySQL database.

A Phone Book GUI Built in wxPython Connected To Database Using Data Grid View (Python)

2013-09-29T19:25:23-07:00

Python recipe 578676 by toufic zaarour (database, datagridview, graphical, gui, interface).

this GUI as simple as it is explains some basic but important graphical database interfacing; "Add", "Edit","Delete","Search" and few others along with a data grid view. in order to work create an sqlite3 database as follows:

data table : Phone, column 1 : ID, column 2 : name, column 3 : surname, column 4 : telephone.

save the sqlite3 file as file.db in a folder called Data and place it in the same directory as your python script.

if you want to create the sqlite3 database graphically use my previous post : http://code.activestate.com/recipes/578665-a-wxpython-gui-to-create-sqlite3-databases/

Also there is more: I did not use auto-number for 'id' because I also wanted to include in the code a renumbering script.

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.

note: if you don't like the database table name, and columns name create your own but make sure to change them in the code as well! in the end life is great! remember that!

Most viewed recipes tagged "database"