index

SQLite has few functions compared to other database management systems. SQLite authors see this as a feature rather than a problem, because SQLite has an extension mechanism in place.

• How to install an SQLite extension

Some SQLite Extensions

SQLean

• SQLean : A bundle of curated foundational SQLite extensions. Think of them as the extended standard library for SQLite:
  • crypto: hashing, encoding and decoding data
  • define: user-defined functions and dynamic sql
  • fileio: read and write files
  • fuzzy: fuzzy string matching and phonetics
  • ipaddr: IP address manipulation
  • math: math functions
  • regexp: regular expressions
  • stats: math statistics
  • text: string functions and Unicode
    • Powerful string functions in SQLite
  • time: high-precision date/time
    • High-precision date/time in SQLite
  • uuid: Universally Unique IDentifiers
  • vsv: CSV files as virtual tables

macOS may disable unsigned binaries

Note for macOS users. macOS may disable unsigned binaries and prevent the extension from loading. To resolve this issue, remove the extension from quarantine by running the following command in Terminal (replace /path/to/folder with an actual path to the folder containing the extension):

xattr -d com.apple.quarantine /path/to/folder/stats.dylib

Also note that the “stock” SQLite CLI on macOS does not support extensions. Use the custom build.

See Escaping macOS quarantine for SQLite extensions