Monkeybreadsoftware SQLite Extension 1.7

Installation   License   Functions   Order a license

Our SQLite Extension gives you:

• Additional mathematical functions like Round or Pow.
• Functions to save blob values in files outside the database.
• Functions to calculate checksums on blob values on the server.
• String functions like SoundEx or accents removing for your text searches.
• Regular Expressions in queries.

Check out function list. If you need something new, send us an email.

Alpha and Beta releases

See also SQLiteFunctionMBS class in MBS Xojo SQL Plugin to define your own functions for SQLite. Calls your Xojo code from the SQL statement to perform a calculation.

Platforms

Our SQLite Extension supports macOS, Windows and Linux. You can use it

• in MBS SQL Plugin with SQLite,
• in Cube SQL 4.0 and newer,
• in Studio Stable Database Server 2.0 and newer,
• in Xojo with the SQLiteDatabase class (needs LoadExtensions property set to true),
• in Real Studio with the REALSQLDatabase class,
• with SQLiteManager
• or any other SQLite application using load_extension.

For Cube SQL, REAL Server and SQLiteManager you install our library into the Plugins folder.
Please note: Cube SQL is the successor of REAL Server.

New in Version 1.7, released 8th August 2024

• Changed EncodeHex, DecodeHex and RemoveAccents functions to pass through NULL values.
• Fixed problem in EncodeHexMBS and DecodeHexMBS returning error.
• Upgraded Linux builds. Now 32+64 and Intel+ARM versions available.

New in Version 1.6, released 5th September 2022

• Rebuild with 64-bit macOS for Apple Silicon and Intel CPUs. Removed macOS 32-bit for that.
• Smaller bug fixes.
• Windows ARM 64-bit support.
• Upgraded to Xcode 13.4.1.
• Upgraded to Visual Studio 2019.

New in Version 1.5, released 19th June 2019

• Minimum macOS is now 10.9.
• Added CreateDirectoryMBS function.
• Improved RemoveAccentsMBS function.
• Windows DLL now code signed.
• Mac Dylib now code signed.

New in Version 1.4, released 24th March 2015

• Added JaroWinklerDistanceMBS and LevenshteinDistanceMBS functions.
• Fixed bug in UUIDFormattedMBS function.
• Added Linux 64-bit version.
• Updated to Xcode 6.2

New in Version 1.3, released 3rd December 2014

• Updated Xojo examples to set LoadExtensions property.
• Added Windows 64bit version.
• Added GeoDistanceMBS function.
• Updated to Xcode 6.1

New in Version 1.2, released 10th July 2013

• Added Xojo support.
• Added NthFieldRevMBS function.
• Added InstrMBS and InstrRevMBS function.

Price and license

A license costs $149 USD per developer. We do not count your server or application installations.

You can order using our Order pages