Can SQLite be compiled with additional extensions for the next release?

[Andre Garzia]

Hi Folks,

SQLite is very flexible and lots of features can be enabled at compile time. I was wondering if the following extensions could be enabled for the next release:

# FTS5

A new full-text search extension.

more info at: https://www.sqlite.org/fts5.html

# JSON1

Enable JSON features inside SQLite. This is very useful for storing arbitrary documents.

more info: https://www.sqlite.org/json1.html

# SQLAR

SQLite archives are a powerful way of storing binary files inside SQLite much like a virtual file system.

more info: https://www.sqlite.org/sqlar.html

I've checked the compile options used for sqlite3.dll included in Racket 7.5 using "PRAGMA compile_options" and currently it is basically FTS3 and RTREE.

Best

A.

--

http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.

[Joel Dueck]

+1

[Philip McGrath]

I'm also interested in these extensions. I'm not sure if there about potential downsides to statically linking them, though: e.g. IIUC Racket relies on a not-especially-recent system libsqlite3 on Mac OS (but maybe it shouldn't?).

From other mailing list discussions, though, I understand that it's also possible to dynamically link these extensions, and that you can arrange for Racket to use a libsqlite3 you provided: see https://groups.google.com/d/topic/racket-users/Xg2iwevsSu0/discussion and https://groups.google.com/d/topic/racket-users/lOF5FwViZfM/discussion.

-Philip

--
You received this message because you are subscribed to the Google Groups "Racket Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to racket-dev+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/racket-dev/b4a3f1d6-5466-432d-84d6-a457d43bd2c6%40googlegroups.com.

[Stephen De Gabrielle]

I like the idea too but I don’t have the time or resources to take it on.

Maybe platform specific packages would be be better?

Nb the included DLL's are about 2 years old and can be found in 'libs';

https://github.com/racket/libs/tree/master/db-win32-x86_64/db

https://github.com/racket/libs/tree/master/db-win32-i386/db

To view this discussion on the web visit https://groups.google.com/d/msgid/racket-dev/CAH3z3gb6Dx5EOS9AWZvyQzEBQky1P6hR2%2BZ4iwJ44mWrHWsiFA%40mail.gmail.com.

--

----