SQLite

Introduction

• sqlite is my favorite database (beginner - intermediate) anthony explains • Anthony Writes Code 📺

General

• SQLite Docs • SQLite 📚
• Installing on macOS:
  • It comes preinstalled (just type sqlite3 in a terminal)
  • How to install SQLite on macOS • Flavio Copes 📖
• Tools:
  • sqlite-utils: a nice way to import data into SQLite for analysis • Julia Evans 📖

Using in production

• Possible to use SQLite as remote DB accessed by multiple clients over a network?

Inbox

• SQL For Beginners using SQLite

• SQLite Tutorial – A Step-by-step SQLite Tutorial

• thenorthbay/doculite • Use SQLite as a Document Database.

• Websites Using SQLite in Production — Podcast and Interviews

• SQLite the only database you will ever need in most cases

• Wesley Aptekar-Cassels | Consider SQLite

• Command Line Shell For SQLite - CLI docs, including how to import CSV to your db

• Practical SQLite Commands That You Don’t Want To Miss - includes how to save an sql query to a file and then execute that query

• Query Language Understood by SQLite - uses diagrams to explain the SQL dialect SQLite understands

• How to Use SQLite with Node.js

• A SQLite Tutorial with Node.js

• Connecting To SQLite Database Using Node.js

• Import a CSV File Into an SQLite Table • SQLite Tutorial 📖

• Better to read/write throughout program? Or read data into memory at startup and then pass the in-memory data around via pure functions?

• SQLite On The Command Line: How To Inspect A DB - SQLite Land

• sqlite: Running SQL Queries from a ‘.sql’ file in NodeJS (SQLite) | by Theo Okafor | Level Up Coding - use fs.readFileSync to load SQL queries from *.sql files

• sqlite: node.js - Backup database - Stack Overflow - when using node sqlite3 library, backup like this: db.backup('backup.db', () => callback())

• sqlite: SQLite3 Editor - Visual Studio Marketplace - vs code extension that’s really great; allows manual edits like a spreadsheet + previewing the result of queries + lots of other tools like importing/exporting as csv and table manipulation

• Querying Data in SQLite Database from Node.js Applications

• sqlite: Many Small Queries Are Efficient In SQLite

• sqlite: Using SQLite with Next.js 13

• sqlite: Using SQLite with Next.js 13

• GitHub - sql-js/sql.js: A javascript library to run SQLite on the web.

• DHH discusses SQLite (and Stoicism) • Describing the benefits of using SQLite in production • Aaron Francis 📺

• High Performance SQLite • SQLite video course • Aaron Francis 🧑‍🎓

• dbcli/litecli - CLI for SQLite Databases with auto-completion and syntax highlighting