Python and SQLite Development
()
About this ebook
* Setting up Development Environment
* Setting Started - Python and SQLite
* SQLite Shell
* CRUD (Create, Read, Update, Delete) Operations
* Working with Image and Blob Data
* Transaction
* Python, SQLite and Pandas
Agus Kurniawan
Agus Kurniawan is an independent technology consultant, author, and lecturer. He has over 18 years' experience working on various software development projects, including delivering training courses and workshops, and delivering technical writing. He has done a few research activities related to wireless networking, software, and security in multiple universities. Currently, he is pursuing a Ph.D. program in Computer Science in Germany. He has previously written five books for Packt.
Read more from Agus Kurniawan
Smart Internet of Things Projects Rating: 4 out of 5 stars4/5Raspberry Pi LED Blueprints: Design, build, and test LED-based projects using the Raspberry Pi Rating: 0 out of 5 stars0 ratingsGetting Started with Big Data Query using Apache Impala Rating: 0 out of 5 stars0 ratings
Related to Python and SQLite Development
Related ebooks
Learn SQLite in 24 Hours Rating: 0 out of 5 stars0 ratingsPython Projects for Everyone Rating: 0 out of 5 stars0 ratingsMastering Objectoriented Python Rating: 5 out of 5 stars5/5Python 3 Object Oriented Programming Rating: 4 out of 5 stars4/5Python Essentials Rating: 5 out of 5 stars5/5MySQL for Python Rating: 5 out of 5 stars5/5The Ultimate Python Programming Guide For Beginner To Intermediate Rating: 4 out of 5 stars4/5The 1 Page Python Book Rating: 2 out of 5 stars2/5Python Programming: Your Advanced Guide To Learn Python in 7 Days Rating: 0 out of 5 stars0 ratingsUseful Python Rating: 0 out of 5 stars0 ratingsPython Mastery: From Absolute Beginner to Pro Rating: 0 out of 5 stars0 ratingsBasic Core Python Programming: A Complete Reference Book to Master Python with Practical Applications (English Edition) Rating: 0 out of 5 stars0 ratingsMastering Python Programming: A Comprehensive Guide: The IT Collection Rating: 5 out of 5 stars5/5Python In - Depth: Use Python Programming Features, Techniques, and Modules to Solve Everyday Problems Rating: 0 out of 5 stars0 ratingsLearning Flask Framework Rating: 4 out of 5 stars4/5Python for Beginners: An Introduction to Learn Python Programming with Tutorials and Hands-On Examples Rating: 4 out of 5 stars4/5Learn Python in 10 Minutes Rating: 4 out of 5 stars4/5Data Analysis with Python: Introducing NumPy, Pandas, Matplotlib, and Essential Elements of Python Programming (English Edition) Rating: 0 out of 5 stars0 ratingsPython for Beginners: Learn It as Easy as Pie Rating: 0 out of 5 stars0 ratingsPython for Beginners: A Crash Course to Learn Python Programming in 1 Week Rating: 0 out of 5 stars0 ratingsModular Programming with Python Rating: 0 out of 5 stars0 ratingsPython Data Analysis - Second Edition Rating: 0 out of 5 stars0 ratingsPython: Advanced Guide to Programming Code with Python Rating: 0 out of 5 stars0 ratingsLearning Website Development with Django Rating: 0 out of 5 stars0 ratings
Trending on #Booktok
It Ends with Us: A Novel Rating: 4 out of 5 stars4/5Pride and Prejudice Rating: 4 out of 5 stars4/5The Summer I Turned Pretty Rating: 4 out of 5 stars4/5If We Were Villains: A Novel Rating: 4 out of 5 stars4/5Once Upon a Broken Heart Rating: 4 out of 5 stars4/5Crime and Punishment Rating: 4 out of 5 stars4/5Better Than the Movies Rating: 4 out of 5 stars4/5Rich Dad Poor Dad Rating: 4 out of 5 stars4/5The Little Prince: New Translation Version Rating: 5 out of 5 stars5/5Beauty and the Beast Rating: 4 out of 5 stars4/5Finnegans Wake Rating: 4 out of 5 stars4/5Milk and Honey: 10th Anniversary Collector's Edition Rating: 4 out of 5 stars4/5
Related categories
Reviews for Python and SQLite Development
0 ratings0 reviews
Book preview
Python and SQLite Development - Agus Kurniawan
Contact
Preface
This book provides alternative approach to build Python application with SQLite database. This book describes how to work with Python and SQLite and illustrates their use with code examples.
Agus Kurniawan
Depok, January 2021
1. Setting up Development Environment
1.1 Python
Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. In this book, we focus on learning how to develop Python programs to access SQLite database.
To install Python, you can download it for your platform on https://www.python.org/. This book covers for Windows, Mac and Linux.
After installed Python, you can verify it by opening Terminal or Command Prompt for Windows. Type this command.
You should see python and pip versions on Terminal.
For Windows users, you probably get errors while you are running python command. You can configure Python path into Path environment from Control Panel. You can see my Python path configuration in Figure below.
q1-1You probably have Python 3.x so your pip may be pip3. You can type this command