You're reading from Mastering Python for Networking and Security Leverage the scripts and libraries of Python version 3.7 and beyond to overcome networking and security issues

Product type Paperback

Published in Jan 2021

Publisher Packt

ISBN-13 9781839217166

Length 538 pages

Edition 2nd Edition

Languages

Python

Tools

Tor

Concepts

Network Security

Author (1):

José Manuel Ortega

View More author details

Table of Contents (22) Chapters

Preface

1. Section 1: The Python Environment and System Programming Tools

2. Chapter 1: Working with Python Scripting FREE CHAPTER

3. Chapter 2: System Programming Packages

4. Section 2: Network Scripting and Extracting Information from the Tor Network with Python

5. Chapter 3: Socket Programming

6. Chapter 4: HTTP Programming

7. Chapter 5: Connecting to the Tor Network and Discovering Hidden Services

8. Section 3: Server Scripting and Port Scanning with Python

9. Chapter 6: Gathering Information from Servers

10. Chapter 7: Interacting with FTP, SFTP, and SSH Servers

11. Chapter 8: Working with Nmap Scanner

12. Section 4: Server Vulnerabilities and Security in Python Modules

13. Chapter 9: Interacting with Vulnerability Scanners

14. Chapter 10: Identifying Server Vulnerabilities in Web Applications

15. Chapter 11: Security and Vulnerabilities in Python Modules

16. Section 5: Python Forensics

17. Chapter 12: Python Tools for Forensics Analysis

18. Chapter 13: Extracting Geolocation and Metadata from Documents, Images, and Browsers

19. Chapter 14: Cryptography and Steganography

20. Assessments

21. Other Books You May Enjoy

Leave a review - let other readers know what you think

Connecting and analyzing SQLite databases

In this section, we will review the structure of a sqlite database and sqlite3 as a Python module for connecting and tools for recovering content from this database.

SQLite databases

SQLite (http://www.sqlite.org) is a lightweight database that does not require any servers to be installed or configured. For this reason, it is often used as a prototyping and development database where the database is in a single file.

To access the data stored in these files, you can use specific tools such as a browser for SQLite (http://sqlitebrowser.org). SQLite Browser is a tool that can help during the process of analyzing the extracted data, while the Browse Data tab allows you to see the information present in different tables within the sqlite files.

In the following GitHub repository, we can find an example of a sqlite database: https://github.com/jpwhite3/northwind-SQLite3. In the following screenshot, we can see the SQLite database structure...