View Issue Details

IDProjectCategoryView StatusLast Update
0010573mantisbtdb schemapublic2019-03-19 12:07
ReporternobswolfAssigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status acknowledgedResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0010573: support SQLite
Description

For small systems it would be nice to have a database backend that does not need any installation.

Please support SQLite for that purpose.

TagsNo tags attached.

Relationships

related to 0019350 new SQLite support patches for mantis 1.2.19 and 1.3.0b1 

Activities

vboctor

vboctor

2009-06-11 03:01

manager   ~0022073

Sounds like a good idea. Anyone willing to provide a patch for this?

AnnoyingTechnology

AnnoyingTechnology

2015-02-05 03:48

reporter   ~0048789

I'd be interested too. An Actual DBMS is a bit overkill for that purpose.
Is mantis running PDO ? If no database specific functions are used it should be fairly simple to enable a PDO driver.

dregad

dregad

2015-02-05 05:48

developer   ~0048791

At the moment our API relies on ADOdb for DB abstraction.

There was a plan to switch to a new DB API based on PDO, but the developer who led that effort has left the team, so at this time I don't know if and when that switch will actually happen.

That being said, ADOdb does offer SQLite drivers, so in theory it should be feasible to implement that.

Should you decide to implement it, feel free to submit a pull request on Github.

AnnoyingTechnology

AnnoyingTechnology

2015-02-05 05:51

reporter   ~0048792

Thanks for the info, I'll probably do that !

dregad

dregad

2015-02-05 06:00

developer   ~0048793

Great, looking forward to your contribution !

Note, if and when you get around to it, please make sure to base your changes on our 'master' branch (i.e. not 1.2.x).

vboctor

vboctor

2015-02-07 13:49

manager   ~0048800

You may want to see the patch submitted at 0019350 to add Sqlite support for 1.2.x and 1.3.x.

Issue History

Date Modified Username Field Change
2009-06-09 03:42 nobswolf New Issue
2009-06-11 03:01 vboctor Note Added: 0022073
2009-06-11 03:01 vboctor Status new => acknowledged
2015-02-05 03:48 AnnoyingTechnology Note Added: 0048789
2015-02-05 05:48 dregad Note Added: 0048791
2015-02-05 05:51 AnnoyingTechnology Note Added: 0048792
2015-02-05 06:00 dregad Note Added: 0048793
2015-02-07 13:48 vboctor Relationship added related to 0019350
2015-02-07 13:49 vboctor Note Added: 0048800
2015-02-07 13:49 vboctor Category customization => db schema