I’m glad to report that the database schema has now been designed! I’ve written, tested and optimised the SQL queries and put the whole thing into PHP. I’ve taken care to make sure that the database will be manageable. Once we get up and running, it needs to be able to automatically maintain itself as much as possible. So there are fields in there like negativeVotes etc. which will all be available via the API. There will be the ability to flag suspect numbers and remove and update numbers as they change.
Before launching it on a public page, I’m going to let it settle for a few days, see if I can break it and once that’s done the “Add Number” page will go live so that we can begin to fill up the numbers.
Posted in database on 25/11/2008 06:27 pm |
No Comments
After having been on the message boards at saynoto0870.com these last few days I now realise that it’s imperative to have an open API to the numbers database. There are so many developers on the saynoto0870 message boards who are desperate to use the data to create all sorts of wonderful applications - often offering to do it in their own time for free, and they are all getting flatly ignored by the site admin.
more »
Posted in database, open API on 20/11/2008 07:04 pm |
2 Comments
One of the most important parts of a service that provides free alternatives to premium 0870 and 0845 numbers is the database of numbers and their alternatives. These are not easy to come by.
more »
Posted in database on 31/10/2008 04:16 pm |
No Comments