SQLite instead of PostgreSQL for FusionPBX database

Status
Not open for further replies.

OhSeeGee

New Member
Jan 15, 2022
12
1
3
Wishing I was in Jamaica
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

Administrator
Staff member
Sep 29, 2016
3,038
556
113
I think it already has bits in that are postgres only, why do you want sqlite?
 

OhSeeGee

New Member
Jan 15, 2022
12
1
3
Wishing I was in Jamaica
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

Administrator
Staff member
Sep 29, 2016
3,038
556
113
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.
 
Status
Not open for further replies.