SQLite has pretty limited builtin functions

This page summarizes the projects mentioned and recommended in the original post on /r/sqlite

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • sqlite-plus

    The ultimate set of SQLite extensions

    That's not quite accurate...an extension already exists, sqlean, as pointed out in the article, but the author didn't want to use C, so he wrote his own exension in go.

  • sqlitestudio

    A free, open source, multi-platform SQLite database manager.

    SQLiteStudio (sqlitestudio.pl) is a GUI frontend (Win and Linux) that lets you define functions (such as StdDev) when needed. You might want to give that a try.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • go-sqlite3-stdlib

    A standard library for mattn/go-sqlite3 including best-effort date parsing, url parsing, math/string functions, and stats aggregation functions

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts