Bug 278413

Summary:	Provide a UI to change SQLite's pragmas
Product:	[Applications] KEXI	Reporter:	Dimitrios T Tanis <dimitrios.tanis>
Component:	General	Assignee:	Kexi Bugs <kexi-bugs>
Status:	CONFIRMED ---
Severity:	wishlist	CC:	adam, inksi, staniek
Priority:	NOR
Version First Reported In:	3.0.x
Target Milestone:	---
Platform:	Compiled Sources
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description Dimitrios T Tanis 2011-07-24 19:48:56 UTC

Version:           3.0.x (Calligra 3.0.x) (using KDE 4.6.0) 
OS:                Linux

Currently there is no way to either view or change pragmas from within Kexi. There could be a page in Kexi's options, Or project option so that the user could change the DB's pragmas.

Reproducible: Didn't try



Expected Results:  
The user should be able to change the DB's pragmas from within Kexi.

Auto vacuum, auto indexing, case sensitive like, foreign keys and almost all of the pragmas would be very usefull to Kexi's power users.

Comment 1 Jarosław Staniek 2011-07-25 19:21:28 UTC

I am accepting the wish for increased flexibility.

Comment 2 Dimitrios T Tanis 2011-07-25 19:29:24 UTC

No rush for this one. Either way changing the pragmas doesn't happen very often, and a power user can easily change then from the SQLite console.
However as you said it would provide increased flexibility in the future to handle pragmas internally.