Code Snippets

SQLite with the sqlite3 Stdlib

Python

Create a table, insert rows, and query with parameterized SQL.

import sqlite3

with sqlite3.connect('app.db') as conn:
    cur = conn.cursor()
    cur.execute('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)')
    cur.executemany('INSERT INTO users (name) VALUES (?)',
                    [('Alice',), ('Bob',), ('Eve',)])
    conn.commit()

    for row in cur.execute('SELECT id, name FROM users ORDER BY name'):
        print(row)
Database Database TagSqlSqlite chris

More in Database

PDO MySQL Connection in PHP Database Connect to MySQL with PDO and run a prepared SELECT. Connect to PostgreSQL in Go Database Open a database/sql handle to Postgres and query rows. ActiveRecord Query Snippet Database Define a model and run a chained where/order query with ActiveRecord. Connect to MySQL with DBI Database Open a DBI handle to MySQL, run a SELECT, and iterate rows.

Random picks

Hash Passwords with bcrypt Cryptography & Hashing Use password_hash and password_verify — never store plaintext. Wrap and Unwrap Errors in Go Utilities Wrap errors with fmt.Errorf %w and inspect with errors.Is / As. Read a File to String in Go File I/O Read an entire file into memory with os.ReadFile. Iterator map/filter/collect Sorting & Data Structures Chain iterator adaptors and collect into a Vec. Error Handling with anyhow Utilities Use anyhow::Result and the `?` operator for ergonomic errors.
Recently added
  • Background Jobs and wait
  • Loop SSH Across Hosts
  • Install a Cron Job from a Script
  • Compress a Directory with tar
  • Find Files Recursively
Categories
  • CLI & System 12
  • Concurrency 11
  • Cryptography & Hashing 8
  • Database 5
  • File I/O 21
  • Networking & HTTP 12
  • Sorting & Data Structures 10
  • Strings & Text 11
  • Utilities 16
  • Web Development 6
Tags
File 21 Io 13 Http 11 Json 8 Cli 8 Regex 8 Hash 7 Sort 7 Recursion 7 Serialization 7 Args 7 Concurrency Tag 6 Digest 6 Capture 6 Get 6 Web 6 Sha256 5 Async 5 Arrays 5 Sql 5 Loops 4 Functional 4 Threads 4 System 4 Encoding 3 Node 3 Errors 2 Server 2 Hashes 2 Find 2 Smtp 2 Walk 2 Glob 2 Routes 2 Curl 2 Email 2 Performance 2 Strings Tag 2 Url 2 Database Tag 2 Mysql 2 Password 1 Waitgroup 1 Promises 1 Portable 1 Requests 1 Optionparser 1 Websocket 1 Orm 1 Pdo 1
Languages
  • Bash 14
  • Go 14
  • JavaScript 14
  • Perl 14
  • PHP 14
  • Python 14
  • Ruby 14
  • Rust 14
© 2026 Code Snippets