fullstackpython.com/sqlite.html at gh-pages · allengaller/fullstackpython.com · GitHub

History

182 lines (180 loc) · 12.5 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

178

179

180

181

182

<!DOCTYPE html>

<head>

<title>SQLite - Full Stack Python</title>

<!--[if lt IE 9]>

<![endif]-->

</head>

<body>

<p class="banner"><a href="https://www.gumroad.com/l/python-deployments" style="color: #fff">Learning Python web development? Check out the just-updated Guide to Deployments book</a>!</p>

</div>

</div> <a href="https://github.com/makaimc/fullstackpython.com"><img style="position: absolute; top: 0; right: 0; border: 0;" src="/theme/img/fork.png" alt="Fork me on GitHub"></a>

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

</div>

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

<h1>SQLite</h1>

<p>SQLite is an open source relational database included with the Python standard

library as of Python 2.5. The pysqlite database driver is also included with

the standard library so that no further external dependencies are required to

access a SQLite database from within Python applications.</p>

<div class="well see-also">SQLite is an implementation of the <a href="/databases.html">relational database</a> concept. Learn more in the <a href="/data.html">data</a> chapter or view the <a href="/table-of-contents.html">table of contents</a> for all topics.</div>

<h3>SQLite resources</h3>

<ul>

<li>

<p><a href="https://pymotw.com/2/sqlite3/">sqlite3 - embedded relational database</a> is an

extensive tutorial showing many of the common create, read, update and delete

operations a developer would want to do with SQLite.</p>

</li>

<li>

<p><a href="http://www.blog.pythonlibrary.org/2012/07/18/python-a-simple-step-by-step-sqlite-tutorial/">A simple step-by-step SQLite tutorial</a>

walks through creating databases as well as inserting, updating, querying and

deleting data.</p>

</li>

<li>

<p><a href="http://charlesleifer.com/blog/my-list-of-python-and-sqlite-resources/">My list of SQLite resources</a>

is a nice roundup of useful tools to use with SQLite and tutorials for

learning more about the database.</p>

</li>

<li>

<p><a href="http://byteacademy.co/index.php/blog/item/124-intro-to-sqlite3-with-python-s-flask">Introduction to SQLite3 with Python's Flask</a>

shows how to write SQL within a Flask application to work with a SQLite

backend.</p>

</li>

<li>

<p><a href="http://charlesleifer.com/blog/extending-sqlite-with-python/">Extending SQLite with Python</a>

uses the Peewee

<a href="/object-relational-mappers-orms.html">object-relational mapper (ORM)</a>

to implement virtual tables and aggregates on top of SQLite.</p>

</li>

<li>

<p><a href="http://flask.pocoo.org/docs/0.10/patterns/sqlite3/">Using SQLite with Flask</a>

explains how Flask code can directly query a SQLite database without an ORM.</p>

</li>

<li>

<p><a href="http://sqlitebrowser.org/">SQLite Browser</a> is an open source graphical user

interface for working with SQLite.</p>

</li>

<li>

<p>The official

<a href="https://docs.python.org/3/library/sqlite3.html">sqlite3 module in the Python stdlib docs</a>

contains a bunch of scenarios with code for how to use the database from

a Python application.</p>

</li>

</ul>

<h3>What do you want to learn next about data?</h3>

<p class="under-btn">Tell me about standard relational databases.</p> </div>

</div>

<p class="under-btn">What're these NoSQL data stores hipster developers keep talking about?</p> </div>

</div>

<p class="under-btn">I want to know about working with data in Python.</p> </div>

</div>

</div><div id="mc_embed_signup">

<h4>Sign up here to receive an email with major updates to this site and Python tutorials delivered to your inbox once a month.</h4>

</div>

</div>

</form>

</div>

<p style="font-size: .8em; margin-top: 10px;">Searching for a complete, step-by-step deployment walkthrough? Learn more about <a href="http://www.deploypython.com/">The Full Stack Python Guide to Deployments book</a>.

</p>

</div>

</div><div class="panel panel-success">

<h3 class="panel-head">Email Updates</h3>

</div>

<h5>Sign up to get a monthly email with Python tutorials and major updates to this site.</h5>

</div>

</form>

</div>

</div> <div class="panel panel-success">

<h3 class="panel-head"><a href="/table-of-contents.html" style="color: #fff;">Chapters</a></h3>

</div>

<a href="/introduction.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>1. Introduction</a><a href="/development-environments.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>2. Development Environments</a><a href="/python-programming-language.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>3. Core Language</a><a href="/web-development.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>4. Web Development</a><a href="/web-frameworks.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>5. Web Frameworks</a><a href="/data.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>6. Data</a> <a href="/sqlite.html" class="list-group-item smaller-item active" style='font-family: "Helvetica Neue",sans-serif;'>» SQLite</a>

<a href="/application-programming-interfaces.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>7. Web APIs</a><a href="/deployment.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>8. Deployment</a><a href="/testing.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>9. Testing</a><a href="/change-log.html" class="list-group-item smaller-item " style='font-family: "Helvetica Neue",sans-serif;'>13. Change Log</a><a href="/table-of-contents.html" class="list-group-item smaller-item" style='font-family: "Helvetica Neue",san-serif;background-color:#22B24C; color: #fff;'>...or <span style="border-bottom: 1px dotted;">view the full table of contents</span>.</a> </div>

</div>

<div class="panel-heading"><h3 class="panel-head">SQLite</h3></div>

Major updates are tweeted via

<a href="https://twitter.com/fullstackpython">@fullstackpython</a>.

<hr/>

Need more detailed tutorials than you see here?

<a href="http://www.deploypython.com/">Learn more about The Full Stack Python Guide to Deployments book.</a>

</div>

</div></div>

<hr/>

</div>

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

2016

</div>

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){

(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),

m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)

})(window,document,'script','//www.google-analytics.com/analytics.js','ga');

ga('create', 'UA-19910497-7', 'auto');

ga('send', 'pageview');

</script>

var trackOutboundLink = function(url) { ga('send', 'event', 'outbound', 'click', url, {'hitCallback': function () { document.location = url; } }); }

</script>

</body>

</html>

fullstackpython.com/sqlite.html at gh-pages · allengaller/fullstackpython.com · GitHub

Expand file tree

Breadcrumbs

sqlite.html

Latest commit

History

Breadcrumbs

sqlite.html

File metadata and controls