SQLite Database

8.

Using SQLite with Programming Languages

8.1.

Core Programming Concepts

8.1.1.

Establishing Database Connections

8.1.2.

Connection String Parameters

8.1.3.

Connection Pooling Considerations

8.1.4.

Using Cursor Objects

8.1.5.

Executing SQL Queries

8.1.6.

Parameter Substitution and Prepared Statements

8.1.7.

SQL Injection Prevention

8.1.8.

Fetching Results

8.1.8.1.

Fetching One Row

8.1.8.2.

Fetching Many Rows

8.1.8.3.

Fetching All Rows

8.1.9.

Handling Transactions in Code

8.1.10.

Error Handling and Exception Management

8.1.11.

Resource Management

8.2.

SQLite with Python

8.2.1.

The sqlite3 Standard Library Module

8.2.2.

Connecting to a Database

8.2.3.

Executing Queries and Fetching Results

8.2.4.

Using Context Managers

8.2.5.

Handling Transactions

8.2.6.

Row Factories and Data Types

8.2.7.

Threading Considerations

8.2.8.

Performance Optimization

8.3.

SQLite with Node.js

8.3.1.

The sqlite3 Package

8.3.1.1.

Installation and Setup

8.3.1.2.

Asynchronous API

8.3.1.3.

Basic Usage Patterns

8.3.2.

The better-sqlite3 Package

8.3.2.1.

Synchronous API

8.3.2.2.

Performance Considerations

8.3.2.3.

Advanced Features

8.3.3.

Error Handling in Node.js

8.3.4.

Connection Management

8.4.

SQLite with Java

8.4.1.

JDBC Driver for SQLite

8.4.2.

Establishing Connections

8.4.3.

Executing Statements

8.4.4.

Prepared Statements

8.4.5.

Handling Result Sets

8.4.6.

Transaction Management

8.4.7.

Connection Pooling

8.4.8.

Exception Handling

8.5.

SQLite with C/C++

8.5.1.

8.5.2.

Opening and Closing Databases

8.5.3.

Preparing and Executing Statements

8.5.4.

Binding Parameters

8.5.5.

Retrieving Results

8.5.6.

Managing Memory and Resources

8.5.7.

Error Code Handling

8.5.8.

Multi-Threading Considerations

Previous

7. Database Administration and Optimization

Go to top

Next

9. SQLite Extensions and Advanced Capabilities