SQLite instead of PostgreSQL for FusionPBX database

[OhSeeGee]

Is it possible to store all of FusionPBX's data in a SQLite database instead of PostgreSQL?

If so, how would I do that? And is FusionPBX going to force use of PostgreSQL in the future?

 

[DigitalDaz]

I think it already has bits in that are postgres only, why do you want sqlite?

 

[OhSeeGee]

1. PostgreSQL is a resource heavy DB, which is being used to hold nothing more than static config data
2. PostgreSQL is yet another DB that needs to be loaded onto a server with multiple VoIP apps. Most open source apps use MySQL - why not use the most popular DB in this space?
3. SQLite is a small footprint DB that is ideally suited to holding simple static data like UI settings

 

[DigitalDaz]

You have the cdrs too. Also, I have seen mysql fail so many times for people though I do like the look of galera myself, I do have a three node cluster running.

 

[OhSeeGee]

Is there a list of FusionPBX tables somewhere? I didn't realize CDR's were there too (not sure why, since these would be FreeSWITCH generated data)