fullstackpython.github.com/databases.html at gh-pages · wocin/fullstackpython.github.com · GitHub

History

177 lines (170 loc) · 10.1 KB

Raw

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

<!DOCTYPE html>

<title>Full Stack Python</title>

<!--[if lt IE 9]>

<![endif]-->

<style>

html,

body {

font-size: 18px;

color: #222;

background: #fefefe;

}

body {

padding-top: 30px;

}

.footer {

padding: 20px 0 30px 0;

}

a, a:hover {border-bottom: 1px dotted; color: #444;}

a:hover {text-decoration: none; color: #000;}

.logo-title {font-size: 56px; color: #403072; padding-top: 80px;

font-family: "News Cycle", "Arial Narrow Bold", sans-serif;

font-weight: bold; line-height: 30px; margin-left: 5px;}

.logo-title a, .logo-title a:hover {color: #000; text-decoration: none;

border-bottom: none;}

.logo-title a:hover {color: gray;}

.logo-image {vertical-align: top; border: none;}

a.list-group-item.active {background: #444; border: 1px solid #222;}

a.list-group-item.active:hover {background: #444; border: 1px solid #222;}

#sidebar {margin-top: 30px;}

@media (max-width: 600px) {

.logo-header-section {

margin: 20px 32px 0 0;

}

</style>

var _gaq = _gaq || [];

_gaq.push(['_setAccount', 'UA-19910497-7']);

_gaq.push(['_trackPageview']);

(function() {

var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;

ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';

var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);

})();

</script>

</head>

<body>

</a>

<span class="logo-title"><a href="/">Full Stack Python</a></span>

</div>

</div> <div class="row">

<h1>Databases</h1>

<p>A database is an abstraction on top of an operating system's file system to

ease creating, reading, updating, and deleting persistent data. The

database storage abstraction most commonly used in Python web development is

sets of relational tables. Alternative storage abstractions are explained in

the <a class="reference external" href="../no-sql-datastore.html">NoSQL</a> section of this guide.</p>

<p>Relational databases store all data in a series of tables. Interconnections

between the tables are specified as <em>foreign keys</em>.</p>

<p>Databases storage implementations vary in complexity. SQLite, a database

included with Python, creates a single file for all data per database.

Other databases such as Oracle, PostgreSQL, and MySQL have more complicated

persistence schemes while offering additional advanced features that are

useful for web application data storage.</p>

<p><a class="reference external" href="http://www.postgresql.org/">PostgreSQL</a> and

<a class="reference external" href="http://www.mysql.com/">MySQL</a> are two of the most common open source

databases for storing Python web application data.</p>

<p><a class="reference external" href="http://www.sqlite.org/">SQLite</a> is a database that is stored in a single

file on disk. SQLite is built into Python but is only built for access

by a single connection at a time. Therefore is highly recommended to not

<a class="reference external" href="https://docs.djangoproject.com/en/dev/ref/databases/#database-is-locked-errors">run a production web application with SQLite</a>.</p>

<h2>Database connections with Python</h2>

<p>To work with a relational database using Python, you need to use a code

library. The most common libraries for relational databases are:</p>

<p><a class="reference external" href="http://initd.org/psycopg/">psycopg2</a> for PostgreSQL</p>

<p><a class="reference external" href="https://pypi.python.org/pypi/MySQL-python/1.2.4">MySQLdb</a> for MySQL</p>

<p><a class="reference external" href="http://cx-oracle.sourceforge.net/">cx_Oracle</a> for Oracle</p>

<p>SQLite support is built into Python 2.7+ and therefore a separate library

is not necessary. Simply "import sqlite3" to begin interfacing with the

single file-based database.</p>

</div>

<h2>Database third-party services</h2>

<p>Numerous companies run scalable database servers as a hosted service.

Depending on the provider, there can be several advantages to using a

hosted database third-party service:</p>

<li>automated backups and recovery</li>

<li>tightened security configurations</li>

<li>easy vertical scaling</li>

</ol>

<p><a class="reference external" href="http://aws.amazon.com/rds/">Amazon Relational Database Service (RDS)</a>

provides pre-configured MySQL and PostgreSQL instances. The instances can

be scaled to larger or smaller configurations based on storage and performance

needs.</p>

<p><a class="reference external" href="https://developers.google.com/cloud-sql/">Google Cloud SQL</a> is a service

with managed, backed up, replicated, and auto-patched MySQL instances. Cloud

SQL integrates with Google App Engine but can be used independently as well.</p>

</div>

<h2>Database resources</h2>

<p><a class="reference external" href="http://db-engines.com/en/ranking">DB-Engines</a> ranks the most popular

database management systems.</p>

<p><a class="reference external" href="http://postgresweekly.com/">PostgreSQL Weekly</a> is a weekly newsletter of

PostgreSQL content from around the web.</p>

<p><a class="reference external" href="http://dbweekly.com/">DB Weekly</a> is a new (as of Feb 2014) weekly roundup

of general database articles and resources.</p>

<p><a class="reference external" href="http://www.ibm.com/developerworks/library/os-postgresecurity/">Total security in a PostgreSQL database</a>.

There is no such thing as total security but this is a good article anyway.</p>

</div>

<br/>

Next read the

<a href="/wsgi-servers.html">wsgi servers</a> section.

</div>

<a href="/introduction.html" class="list-group-item ">Introduction</a>

<a href="/servers.html" class="list-group-item ">Servers</a>

<a href="/operating-systems.html" class="list-group-item ">Operating Systems</a>

<a href="/web-servers.html" class="list-group-item ">Web Servers</a>

<a href="/platform-as-a-service.html" class="list-group-item ">Platform-as-a-service</a>

<a href="/databases.html" class="list-group-item active">Databases</a>

<a href="/wsgi-servers.html" class="list-group-item ">WSGI Servers</a>

<a href="/web-frameworks.html" class="list-group-item ">Web Frameworks</a>

<a href="/task-queues.html" class="list-group-item ">Task Queues</a>

<a href="/static-content.html" class="list-group-item ">Static Content</a>

<a href="/caching.html" class="list-group-item ">Caching</a>

<a href="/web-browsers.html" class="list-group-item ">Web Browsers</a>

<a href="/web-application-security.html" class="list-group-item ">Web Application Security</a>

<a href="/monitoring.html" class="list-group-item ">Monitoring</a>

<a href="/web-analytics.html" class="list-group-item ">Web Analytics</a>

<a href="/api-integration.html" class="list-group-item ">API Integration</a>

<a href="/source-control.html" class="list-group-item ">Source Control</a>

<a href="/configuration-management.html" class="list-group-item ">Configuration Management</a>

<a href="/dependency-management.html" class="list-group-item ">Application Dependencies</a>

<a href="/no-sql-datastore.html" class="list-group-item ">NoSQL Data Stores</a>

<a href="/about-author.html" class="list-group-item ">About</a>

<a href="/change-log.html" class="list-group-item ">Change Log</a>

</div>

</div></div>

<hr/>

<a href="http://www.mattmakai.com/" class="underline">Matt Makai</a> 2014

</div>

</body>

</html>

fullstackpython.github.com/databases.html at gh-pages · wocin/fullstackpython.github.com · GitHub

Expand file tree

Breadcrumbs

databases.html

Latest commit

History

Breadcrumbs

databases.html

File metadata and controls