sqlite-reverse-string is a SQLite runtime loadable extension that provides a REVERSE_STRING function for reversing strings.

sqlite> .load libsqlite_reverse_string
sqlite> SELECT REVERSE_STRING("abc");
cba

The extension fully supports Unicode.

Why should one wish to reverse strings? The plugin was developed for implementing of a full text search using the excellent FTS extension. As of itself, partial matches in FTS will only work if the match is aligned at the beginning of a string. However, suffix matches can be implemented by adding and searching reversed versions of the original columns.

This extension allows you to do the necessary string processing directly within SQLite.

On Linux, you can simply do make to build the extension and make install to install it. Depending on the details of your installation, you might want to set the PREFIX and CFLAGS variables to reflect the destination SQLite include and installation paths.

make install PREFIX=/usr/local CFGLAGS="-O2 -I/usr/local/include"

The default PREFIX is /usr.

A separate Makefile is provided for OSX users.

The extension should compile fine on Windows. Check the instructions on the SQLite page for details.

This code is available under the conditions of the MIT license. If you use this extension in a project, it would be awesome if you told us about it.