search

Star2Billing / a2billing

A2Billing is a telecom switch and billing system capable of providing and billing a range of telecom products and services to customers such as calling card products, residential and wholesale VoIP termination, DID resale and callback services.
www.asterisk2billing.org
Other
180 stars 175 forks source link

PostgreSQL support #46

Closed starkovv closed 11 years ago

starkovv commented 11 years ago

The last migration for PostgreSQL is UPDATE-a2billing-v1.6.2-to-v1.7.0.sql while fo MySQL it is for version 2.0.

Do you still support PostgreSQL?

areski commented 11 years ago

No, we don't support postgresql since late version, you are welcome to continue the support for it.

ghenry commented 10 years ago

Could we sponsor this? Is Asterisk and postgres as mature for the Realtime side?

areski commented 10 years ago

Asterisk work perfectly over ODBC for realtime, so I guess the DBMS choice is not that important here. I'm a big fan of PostgreSQL, this is part of the bad choice of A2Billing architectures, also A2Billing doesn't use an ORM so it makes porting/supporting an other DB quite painful.

ghenry commented 10 years ago

Thanks Areski. So it's commercially insane to try and move from MySQL to PostgreSQL for this?

areski commented 10 years ago

I think if you have a correct budget to invest that direction. I would recommend to put it, into rewriting a new A2Billing using a proper Web framework/ORM with PostgreSQL. A good base could be CDR-Stats, actually we have a billing module coming soon: https://github.com/star2billing/cdr-stats/tree/develop

ghenry commented 10 years ago

Excellent. If that has a RESTful API, Pg backend or similar, WebHooks, heartbeat balance decrement and FreeSWITCH support I'm interested!

areski commented 10 years ago

CDR-Stats will just provide only Post Billing information, and call reporting at the moment, it does contains a billing engine now which let you configure callplan rates, etc... What i m saying it's a good base to create something great. Trying to fix A2Billing is impossible, it has many architectures/techs issues, so I will not recommend trying to add postgreSQL support to it, this won't fix its biggest problems.