Edgewall Software
Modify ↓

Opened 15 years ago

Closed 14 years ago

Last modified 14 years ago

#7902 closed enhancement (fixed)

Request ability to load SQLite extensions via sqlite3_load_extension

Reported by: glarkin@… Owned by: Grzegorz Sobański <silk@…>
Priority: normal Milestone: 0.12
Component: general Version: 0.11.2
Severity: normal Keywords: pysqlite extension
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

I would like to write custom reports in my Trac instance (SQLite3-based) with certain contributed SQL functions, such as the ones found here: ​http://www.sqlite.org/contrib.

Can you add support to Trac for loadable SQLite3 extensions, perhaps with a trac.ini directive that lists the extension shared libraries that should be loaded?

Thank you,
Greg Larkin
SourceHosting.net, LLC

Attachments (3)

trac-sqlite-extensions.patch​ (1.7 KB ) - added by Grzegorz Sobański <silk@…> 14 years ago.
implementation
trac-sqlite-extensions.2.patch​ (2.2 KB ) - added by Grzegorz Sobański <silk@…> 14 years ago.
refactored, trac.ini option documented, user config API for lists
trac-sqlite-extensions-trunk.patch​ (2.2 KB ) - added by Grzegorz Sobański <silk@…> 14 years ago.
patch updated to latest trunk

Download all attachments as: .zip

Change History (13)

comment:1 by Remy Blank, 15 years ago

Milestone: → 1.0

comment:2 by Christian Boos, 15 years ago

Note: see pysqlite:r340, pysqlite:r361.

comment:3 by Mitar, 15 years ago

I second that.

comment:4 by Grzegorz Sobański <silk@…>, 14 years ago

Owner: set to Grzegorz Sobański <silk@…>

Hi, I need it to get unicode collation for LIKE operator.

I attach a simple patch.

comment:5 by Grzegorz Sobański <silk@…>, 14 years ago

Owner: changed from Grzegorz Sobański <silk@…> to anonymous
Status: new → assigned

by Grzegorz Sobański <silk@…>, 14 years ago

Attachment: trac-sqlite-extensions.patch​ added

implementation

comment:6 by Christian Boos, 14 years ago

Keywords: pysqlite added; sqlite removed
Milestone: 1.0 → 0.12

Looks good to me, thanks for the patch!

by Grzegorz Sobański <silk@…>, 14 years ago

Attachment: trac-sqlite-extensions.2.patch​ added

refactored, trac.ini option documented, user config API for lists

comment:7 by Christian Boos, 14 years ago

The patch doesn't apply on latest trunk?

by Grzegorz Sobański <silk@…>, 14 years ago

Attachment: trac-sqlite-extensions-trunk.patch​ added

patch updated to latest trunk

comment:8 by Grzegorz Sobański <silk@…>, 14 years ago

I attached a updated patch. It apply to todays trunk.

comment:9 by Christian Boos, 14 years ago

Keywords: pysqlite, extension → pysqlite extension
Resolution: → fixed
Status: assigned → closed

Patch committed in r9086 and some extra clean-ups done in r9087.

Would you mind checking if r9087 didn't break anything for you, as I didn't test extension loading? If something is broken, don't hesitate to reopen.

comment:10 by Christian Boos, 14 years ago

Owner: changed from anonymous to Grzegorz Sobański <silk@…>

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Grzegorz Sobański <silk@…>.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Grzegorz Sobański <silk@…> to the specified user.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.