SQLiteStudio, SQLiteSpy or DBeaver: select load_extension('c:\Users\anton\sqlite\stats. Sqlite> select median(value) from generate_series(1, 99) SQLite command-line interface (CLI, aka ‘sqlite3.exe’ on Windows): sqlite>. Then load it as described below.Įxamples use the stats extension you can specify any other supported extension. How to Install an Extensionįirst, download the extension. Incubator extensions are also available for download. Vote for your favorites! Popular ones will make their way into the main set faster. zorder: map multidimensional data to a single dimension.unionvtab: union similar tables into one.uint: natural string sorting and comparison.stats2 and stats3: additional math statistics functions.spellfix: search a large vocabulary for close matches.pearson: Pearson correlation coefficient between two data sets.isodate: additional date and time functions.decimal, fcmp and ieee754: decimal and floating-point arithmetic.cron: match dates against cron patterns.compress and sqlar: compress / uncompress data.closure: navigate hierarchic tables with parent/child relationships.classifier: binary classifier via logistic regression.cbrt and math2: additional math functions and bit arithmetics.btreeinfo, memstat, recsize and stmt: various database introspection features.bloom: a fast way to tell if a value is already in a table.besttype: convert string value to numeric.I’m gradually refactoring and merging them into the main set: They may be too broad, too narrow, or without a well-thought API. These extensions haven’t yet made their way to the main set. There are precompiled binaries for Windows, Linix and macOS. stats: math statistics - median, percentiles, etc.
0 Comments
Leave a Reply. |