@@ -320,6 +320,17 @@ <h1>Database</h1>
320320< p > < a class ="reference external " href ="http://www.sqlite.org/ "> SQLite</ a > is a database that is stored in a single
321321file on disk. SQLite is built into Python but is only built for access
322322by a single connection at a time.</ p >
323+ < div class ="section " id ="database-connections-with-python ">
324+ < h2 > Database connections with Python</ h2 >
325+ < p > To work with a relational database using Python, you need to use a code
326+ library. The most common libraries for relational databases are:</ p >
327+ < p > < a class ="reference external " href ="http://initd.org/psycopg/ "> psycopg2</ a > for PostgreSQL</ p >
328+ < p > < a class ="reference external " href ="https://pypi.python.org/pypi/MySQL-python/1.2.4 "> MySQLdb</ a > for MySQL</ p >
329+ < p > < a class ="reference external " href ="http://cx-oracle.sourceforge.net/ "> cx_Oracle</ a > for Oracle</ p >
330+ < p > SQLite support is built into Python 2.7+ and therefore a separate library
331+ is not necessary. Simply "import sqlite3" to begin interfacing with the
332+ single file-based database.</ p >
333+ </ div >
323334< div class ="section " id ="database-third-party-services ">
324335< h2 > Database third-party services</ h2 >
325336< p > Numerous companies run scalable database servers as a hosted service.
@@ -335,16 +346,6 @@ <h2>Database third-party services</h2>
335346be scaled to larger or smaller configurations based on storage and performance
336347needs.</ p >
337348</ div >
338- < div class ="section " id ="database-connections-with-python ">
339- < h2 > Database connections with Python</ h2 >
340- < p > To work with a relational database using Python, you need to use a code
341- library. The most common libraries for relational databases are:</ p >
342- < p > < a class ="reference external " href ="http://initd.org/psycopg/ "> psycopg2</ a > for PostgreSQL</ p >
343- < p > < a class ="reference external " href ="https://pypi.python.org/pypi/MySQL-python/1.2.4 "> MySQLdb</ a > for MySQL</ p >
344- < p > < a class ="reference external " href ="http://cx-oracle.sourceforge.net/ "> cx_Oracle</ a > for Oracle</ p >
345- < p > SQLite support is built into Python 2.7+ and therefore a separate library
346- is not necessary.</ p >
347- </ div >
348349< div class ="section " id ="database-resources ">
349350< h2 > Database resources</ h2 >
350351< p > < a class ="reference external " href ="http://db-engines.com/en/ranking "> DB-Engines</ a > ranks the most popular
0 commit comments