Bug 278413 - Provide a UI to change SQLite's pragmas
Summary: Provide a UI to change SQLite's pragmas
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: General (show other bugs)
Version: 3.0.x
Platform: Compiled Sources Linux
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-07-24 19:48 UTC by Dimitrios T Tanis
Modified: 2019-02-18 19:30 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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.