SQLITE DBEAVER WINDOWS

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.fuzzy: fuzzy string matching and phonetics.fileio: read and write files and catalogs.crypto: cryptographic hashes like MD5 or SHA-256.

These are the most popular functions missing in SQLite: I plan to write in detail about each module in a separate article, but for now - here’s a brief overview. Something like a standard library in Python or Go, only for SQLite.

SQLITE DBEAVER WINDOWS

So I started the sqlean project, which brings the extensions together, neatly packaged into domain modules, documented, tested, and built for Linux, Windows and macOS. As a result, there are a lot of SQLite extensions out there, but they are incomplete, inconsistent and scattered across the internet. Fortunately, the authors provided an extension mechanism, which allows doing almost anything. There are few built-in functions compared to PostgreSQL or Oracle.

It’s a miniature embedded database, perfect for both exploratory data analysis and as a storage for small apps (I’ve blogged about that previously).

Sqlite dbeaver