As some might noticed already I started migrating all the MySQL specific stuff to more generic queries and started using PDO in order to have support for PostgreSQL and sqlite. I’m not moving away from MySQL as it will be supported also, but since Starfish PBX wants to have a version that will be bundled with hardware we needed to find an alternative to it. I also aim to improve the performance on embedded systems and sqlite will be o good alternative to a heavy database server.
This process may take some time and It’s very boring to code but it’s no use to delay it more. It’s a good chance to go over all the code I wrote so far and fix some of the wrong decisions I made in the past. I’m also adding a database abstraction layer so the interface / backend code to have all the db logic in external functions, this way the code will be easier to maintain.
Something to keep in mind for the next time I code a MySQL powered application: never use camel case naming and always stick to ANSI SQL.
2 October 2009 |
No Comments »
Funny thing it that i didn’t heard about the website before yesterday, and was surprised to find out that I already had some of my open-source history listed there. I’ve posted this project on ohloh and there are a some nice statistics for those who are interested in numbers :
- 65,213 line of code : 38,851 of php, 17,165 of html, 11,350 of javascript …
- Estimated effort : 16 Person Years (wtf?)
- 84 subversion commits (that’s only in the public svn)
- Only 1 developer
You can find out more here : https://www.ohloh.net/p/starfish-pbx
18 September 2009 |
2 Comments »
Since I noticed a lot of people interested in a Freeswitch web interface reathed that another Asterisk one I decided to write some proof of concept code that shows how easely the interface can be ported to use another backend.
It took me some time to get used to how Freeswitch works but looks like a work worth doing. Unfortunately I don’t think I have the skills and the time to work in parallel on both backends. I somebody from the Freeswitch community would like to help on development of the this backend, I would gladly help him take over. In the mean time I’ll try to do my best.
If you’re interested on installing it, you can read this wiki article : http://wiki.starfish-pbx.org/index.php/Installing_From_Source
16 September 2009 |
No Comments »
We had a problem with the webserver as the site was/is currently hosted in my home network
, I haven’t expected this amount of traffic from the first day so at least I had a good news together with the bad one.
I’m expecting now a dedicated server from my hosting company but in the mean time I’ll try to stay live with what I have.
1 September 2009 |
No Comments »
After a lot of development hidden for the public eyes Starfish PBX project goes public.
The software it’s alpha release quality right now but with some help from the open source community I hope to have a stable release as soon as possible. We’re open for contributions from anyone that is interested on the project.
We encourage you to download and test run our current release and wait your feedback on the forum or on our FreeNode IRC channel #starfish-pbx.
31 August 2009 |
No Comments »