Rating: 4 out of 5 stars
4/5
Ebook35 pages20 minutes
Python and SQLite Development
Rating: 0 out of 5 stars
()
About this ebook
This book is designed for anyone who wants to learn SQLite database programming Python 3. The book covers database programming for SQLite with the following highlight topics:
* 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
* 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
LanguageEnglish
PublisherLulu.com
Release dateJan 30, 2021
ISBN9781716246029
Author
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 Getting Started with Big Data Query using Apache Impala Rating: 0 out of 5 stars0 ratingsRaspberry Pi LED Blueprints: Design, build, and test LED-based projects using the Raspberry Pi Rating: 0 out of 5 stars0 ratings
Related to Python and SQLite Development
Related ebooks
Mastering Objectoriented Python Rating: 5 out of 5 stars5/5Python 3 Object Oriented Programming Rating: 4 out of 5 stars4/5Learning Flask Framework Rating: 4 out of 5 stars4/5Learn SQLite in 24 Hours Rating: 0 out of 5 stars0 ratingsUseful Python Rating: 0 out of 5 stars0 ratingsLearning Website Development with Django Rating: 0 out of 5 stars0 ratingsThe Ultimate Python Programming Guide For Beginner To Intermediate Rating: 4 out of 5 stars4/5Python Programming: Your Advanced Guide To Learn Python in 7 Days Rating: 0 out of 5 stars0 ratingsMySQL for Python Rating: 5 out of 5 stars5/5Basic Core Python Programming: A Complete Reference Book to Master Python with Practical Applications (English Edition) Rating: 0 out of 5 stars0 ratingsPython In - Depth: Use Python Programming Features, Techniques, and Modules to Solve Everyday Problems Rating: 0 out of 5 stars0 ratingsPython Projects for Everyone Rating: 0 out of 5 stars0 ratingsPython Essentials Rating: 5 out of 5 stars5/5Python Mastery: From Absolute Beginner to Pro Rating: 0 out of 5 stars0 ratingsModular Programming with Python Rating: 0 out of 5 stars0 ratingsPython for Beginners: Learn It as Easy as Pie Rating: 0 out of 5 stars0 ratingsThe 1 Page Python Book Rating: 2 out of 5 stars2/5Python: Advanced Guide to Programming Code with Python Rating: 0 out of 5 stars0 ratingsMastering Python Programming: A Comprehensive Guide: The IT Collection Rating: 5 out of 5 stars5/5Learn Python in 10 Minutes Rating: 4 out of 5 stars4/5Python Machine Learning Illustrated Guide For Beginners & Intermediates:The Future Is Here! Rating: 5 out of 5 stars5/5Python for Beginners: A Crash Course to Learn Python Programming in 1 Week Rating: 0 out of 5 stars0 ratingsPython Data Analysis - Second Edition Rating: 0 out of 5 stars0 ratings
Databases For You
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsData Warehousing: Optimizing Data Storage And Retrieval For Business Success Rating: 0 out of 5 stars0 ratingsStar Schema The Complete Reference Rating: 5 out of 5 stars5/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5COMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsTableau Cookbook – Recipes for Data Visualization Rating: 0 out of 5 stars0 ratingsDeveloping Analytic Talent: Becoming a Data Scientist Rating: 3 out of 5 stars3/5Mastering Blockchain Rating: 4 out of 5 stars4/5Oracle Quick Guides: Part 1 - Oracle Basics: Database and Tools Rating: 0 out of 5 stars0 ratingsPython Projects for Everyone Rating: 0 out of 5 stars0 ratingsAccess 2016 For Dummies Rating: 0 out of 5 stars0 ratingsDark Data: Why What You Don’t Know Matters Rating: 3 out of 5 stars3/5Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data Rating: 0 out of 5 stars0 ratingsThe AI Bible, Making Money with Artificial Intelligence: Real Case Studies and How-To's for Implementation Rating: 4 out of 5 stars4/5PostgreSQL Administration Essentials Rating: 0 out of 5 stars0 ratingsPHP & MySQL Practice It Learn It Rating: 3 out of 5 stars3/5Excel 2021 Rating: 4 out of 5 stars4/5Python for Data Science: A Hands-On Introduction Rating: 0 out of 5 stars0 ratingsOracle SQL and PL/SQL Rating: 5 out of 5 stars5/5Simply SQL: The Fun and Easy Way to Learn Best-Practice SQL Rating: 4 out of 5 stars4/5Use LibreOffice Base: A Beginners Guide Rating: 0 out of 5 stars0 ratingsChessBase Complete: 2019 Supplement Covering ChessBase 13, 14 & 15 Rating: 0 out of 5 stars0 ratingsPractical Data Analysis Rating: 4 out of 5 stars4/5Troubleshooting PostgreSQL Rating: 5 out of 5 stars5/5Behind Every Good Decision: How Anyone Can Use Business Analytics to Turn Data into Profitable Insight Rating: 5 out of 5 stars5/5A concise guide to PHP MySQL and Apache Rating: 4 out of 5 stars4/5Starting Database Administration: Oracle DBA Rating: 3 out of 5 stars3/5
Related podcast episodes
Advantages of Completing Small Python Projects 0% found this document useful#059 - 10 Python clean code tips drawn from code reviews 0% found this document usefulEpisode 19 (Python for Data Science - Python Files - Scripts and Modules) 0% found this document usefulUnraveling Python's Syntax to Its Core With Brett Cannon 100% found this document usefulMeasuring Your Python Learning Progress 100% found this document usefulLearning Python Through Errors 0% found this document usefulImproving the Learning Experience on Real Python 0% found this document usefulTools for Setting Up Python on a New Machine 100% found this document usefulPodcast.__init__ - Introduction 0% found this document usefulGoing Beyond the Basic Stuff With Python and Al Sweigart 0% found this document usefulExploring the Zen of Python & pandas Features for Finance 0% found this document usefulPython Decorators and Writing for Real Python 0% found this document usefulMaking Each Line of Code Efficient & Python In Excel 0% found this document usefulBuilding PDFs in Python with ReportLab 0% found this document useful165: Vote4BSD: This week on BSDNow, we’ve got voting news for you (No not *that* election), a closer look at 0% found this document useful116: Arcing ZFS: This week on BSDNow, we are going to be talking to George Wilson AKA 0% found this document usefulGet You a State Machine for Great Good 0% found this document useful
Reviews for Python and SQLite Development
Rating: 0 out of 5 stars
0 ratings
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
Enjoying the preview?
Page 1 of 1