I wrote AsteriDex, but it's open source GPL2 code so... improve away and share your ideas.
astdb is the data base component of the Asterisk toolkit. It now runs under SQLite 3. Any app can use it to store or retrieve information. FreePBX uses it extensively. Many Asterisk components use it as well. What's the issue?? Or is it just curiosity?
I had thought that Asteridex used MySQL. Utter overkill for the number of entries involved, but I figured the reasoning was that MySQL was already there and lots of folks know PHPMyAdmin. There is phpliteadmin, but that's yet another sql manager.
It started as a simple desire to remove the "Your Extension" field. But if I'm going to figure out how the system works I'd might as well aim a bit higher. I figure I'll take a shot at multiple phone numbers for each person/business.
My first thought, which might turn out to be the right way, is to simply add another field to each record (e.g. 'home', 'office', etc.) and put the linkage (read: additional query) into the PHP code.
I was hoping you might have some kind of repository, so I could get a copy of the most recent code, and a place for me to send a branch back once I thought I had something worth doing that with. I was also hoping for a test harness. Something that would just show me what extension and what outside number were to be connected.
To be clear, I'm an asterisk noob. I do OK with PHP and SQL, though. Also, I'm quite aware of what a nightmare cross-browser support can be - and don't claim to be good at that part of things (most of my PHP experience is in intranets).
Thanks!