https://github.com/nalgeon/sqlite-plus/

Skip to content
 
Sign up Sign up

  * Why GitHub?
    Features -
      + Mobile -
      + Actions -
      + Codespaces -
      + Packages -
      + Security -
      + Code review -
      + Project management -
      + Integrations -
      + GitHub Sponsors -
      + Customer stories-
  * Team
  * Enterprise
  * Explore
      + Explore GitHub -

    Learn and contribute

      + Topics -
      + Collections -
      + Trending -
      + Learning Lab -
      + Open source guides -

    Connect with others

      + The ReadME Project -
      + Events -
      + Community forum -
      + GitHub Education -
      + GitHub Stars program -
  * Marketplace
  * Pricing
    Plans -
      + Compare plans -
      + Contact Sales -
      + Education -

[                    ] [search-key]

  *  
    #
    In this repository All GitHub |
    Jump to |

  * No suggested jump to results

  *  
    #
    In this repository All GitHub |
    Jump to |
  *  
    #
    In this user All GitHub |
    Jump to |
  *  
    #
    In this repository All GitHub |
    Jump to |

Sign in Sign up Sign up
{{ message }}

nalgeon / sqlite-plus

  * Notifications
  * Star 427
  * Fork 8

All the missing SQLite functions

MIT License
427 stars 8 forks
Star
Notifications

  * Code
  * Issues 2
  * Pull requests 0
  * Actions
  * Security
  * Insights

More

  * Code
  * Issues
  * Pull requests
  * Actions
  * Security
  * Insights

main
Switch branches/tags
[                    ]
Branches Tags
Nothing to show
{{ refName }} default View all branches
Nothing to show
{{ refName }} default
View all tags
1 branch 4 tags
Go to file Code
 
Clone
HTTPS GitHub CLI
[https://github.com/n]

Use Git or checkout with SVN using the web URL.

[gh repo clone nalgeo]

Work fast with our official CLI. Learn more.

  * Open with GitHub Desktop
  * Download ZIP

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Go back

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Go back

Launching Xcode

If nothing happens, download Xcode and try again.

Go back

Launching Visual Studio

If nothing happens, download the GitHub extension for Visual Studio
and try again.

Go back

Latest commit

@nalgeon
nalgeon doc: fixes #5
...
cda9880 Apr 2, 2021
doc: fixes #5

Unicode extension overrides NOCASE collation.

cda9880

Git stats

  * 16 commits

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
.github/workflows
fix: segmentation fault in re extension
Mar 31, 2021
docs
doc: fixes #5
Apr 2, 2021
src
fix: segmentation fault in re extension
Mar 31, 2021
.gitignore
feat: stats and vsv extensions
Feb 28, 2021
LICENSE
feat: stats and vsv extensions
Feb 28, 2021
README.md
feat: re extension
Mar 30, 2021
View code
SQLite Plus: all the missing SQLite functions Download Usage

README.md

 SQLite Plus: all the missing SQLite functions

SQLite has very few functions compared to other DBMS. SQLite authors
see this as a feature rather than a bug, because SQLite has extension
mechanism in place.

There are a lot of SQLite extensions out there, but they are
incomplete, inconsistent and scattered across the internet.

SQLite Plus brings them all together, neatly packaged by domain
modules and built for Linux, Windows and macOS.

Here is what we've got right now:

  * re: regular expressions
  * stats: common statistical functions
  * vsv: CSV files as virtual tables
  * unicode: Unicode string functions

 Download

There are precompiled binaries for every OS:

  * *.dll - for Windows
  * *.so - for Linux
  * *.dylib - for macOS

 Usage

CLI usage:

sqlite> .load sqlite3-stats;
sqlite> select median(value) from generate_series(1, 100);

IDE usage:

select load_extension('/path/to/extension/sqlite3-stats');
select median(value) from generate_series(1, 100);

In-app usage:

import sqlite3

connection = sqlite3.connect(":memory:")
connection.enable_load_extension(True)
connection.load_extension("./sqlite3-stats.so")
connection.execute("select median(value) from generate_series(1, 100)")
connection.close()

You can specify any other supported extension instead of
sqlite3-stats.

About

All the missing SQLite functions

Resources

Readme

License

MIT License

Releases 4

 
0.3.1 Latest
Mar 31, 2021
+ 3 releases

Packages 0

No packages published

Contributors 3

  * @nalgeon nalgeon Anton Zhiyanov
  * @aborruso aborruso Andrea Borruso
  * @drjasonharrison drjasonharrison Jason Harrison

Languages

  * C 100.0%

  * (c) 2021 GitHub, Inc.
  * Terms
  * Privacy
  * Security
  * Status
  * Docs

 

  * Contact GitHub
  * Pricing
  * API
  * Training
  * Blog
  * About

You can't perform that action at this time.
You signed in with another tab or window. Reload to refresh your
session. You signed out in another tab or window. Reload to refresh
your session.