Re: [Announce] New Sqlbox version
Alejandro Guerrieri <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Message-ID | <[email protected]> |
Yep, my plan is to add support to those fields, and also the ability to use your custom sql queries without needing to patch the source code :) Regards, -- Alejandro Guerrieri [email protected] On 30/09/2009, at 14:44, sangprabv wrote: > To do SQLBox MySQL quick and dirty schedulling patch you just need to > add datetime type field in the table and edit sqlbox_mysql.h in my > case > it will be: > > #define SQLBOX_MYSQL_SELECT_QUERY "SELECT sql_id, momt, sender, > receiver, udhdata, \ > msgdata, time, smsc_id, service, account, id, sms_type, mclass, mwi, > coding, \ > compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, \ > charset, boxc_id, binfo, priority, custom, insertdate FROM %S WHERE > insertdate < NOW() LIMIT 0,1" > > Do ordinary make clean and make install. Run this SQLBox as a new > daemon, so you will have 2 SQLBox running. Keep in mind that this > scheduling will raise your memory consumption. > > I'm sure Alejandro has better solution. And hopefully the next SQLBox > version will add internal Kannel Msg-ID, Foreign-ID, and compatibility > with Meta-Data. > > > > Willy > > > > > On Wed, 2009-09-30 at 12:25 +0100, Kenny Orisanaiye wrote: >> Hi Alejandro, >> >> Is there any hope of having this scheduling capabilities in the >> SQLBox >> in the nearest future ? >> >> -- >> Kenny >> >> p: +2348034939090 >> e: [email protected] >> w: www.nuObjects.com >> >> Bulk SMS Solutions | Managed Hosting | Enterprise Application >> Development >> >> >> On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri >> <[email protected]> wrote: >> Alex, >> >> The deferred field does get processed and afaik it's passed on >> the SMPP link (as long as the SMSC supports it) so I'd rather >> don't touch it either :) >> >> Regards, >> >> Alejandro >> >> El 18/11/2008, a las 01:54 p.m., Alexander Malysh escribió: >> >> >> >> Hi, >> >> there is deferred filed in kannel Msg struct, that >> could be used for this... >> >> Alejandro Guerrieri schrieb: >> I think that having scheduling capabilities >> would be cool, but I definitely do not agree >> with using the time column, since that column >> is used internally on Kannel and cannot be >> tweaked without disrupting other stuff. >> I think this needs further thinking, though. >> There are performance considerations to take >> into account for example (when you have lots >> of messages queued, adding a condition on the >> select can impact performance if it's not done >> right). >> Regards, >> Alejandro Guerrieri >> El 18/11/2008, a las 12:36 p.m., Ehizogie >> Binitie escribió: >> Hi Alex >> What are your thoughts on converting >> the timestamp on the sqlbox field >> into a basic scheduler. >> >> So messages are delivered if system >> time greater = or > msg time stamp? >> >> Ehi >> >> On Tue, 2008-11-18 at 10:15 -0200, >> Alejandro Guerrieri wrote: >> Ken, >> >> I've used SqlBox to handle >> 200-300K messages per day for >> months with >> no issues using commodity >> hardware (P IV 3.0 Ghz with 1 >> Gig RAM) and >> using the same box for kannel, >> sqlbox and MySQL. The traffic >> was >> unevenly distributed across >> the day, with day hours >> receiving almost >> all traffic. >> >> I think Sqlbox can handle that >> load on decent hardware. >> You'll have to >> take into account other >> factors though, specially on >> the application's >> side, as well as the SMPP >> traffic to your carrier. >> >> Regards, >> >> Alejandro Guerrieri >> >> El 18/11/2008, a las 09:46 >> a.m., Ken Bellars escribió: >> >> Hi Alejandro, >> >> Your contributions are >> highly appreciated. >> >> Am about to use SQLbox >> for a production >> system for delivering >> 5million >> sms/monthly. please >> can SQLbox handle this >> seamlessly? >> >> I anticipate your >> early reply. >> >> On 11/18/08, Alejandro >> Guerrieri >> >> <[email protected]> wrote: >> Hi, >> >> I've just >> commited a new >> SqlBox >> version. >> Changes on >> this version >> are: >> >> - Added >> support for >> the LibSDB >> database >> abstraction >> library. DB >> support is now >> similar to >> Kannel's. >> - Extensive >> code >> reorganization >> to move the >> queries into >> the header >> files and >> allow reusing >> from the >> libsdb module. >> - Added >> examples for >> database >> connections on >> sample conf >> file. >> >> I've also >> started a >> numbering >> schema and I'm >> also tagging >> relevant >> versions. >> >> Cvs version >> 20081103 is >> now tagged as >> rev-0-6-0 and >> represents >> Sqlbox-0.6.0. >> Cvs version >> 20081113 is >> now tagged as >> rev-0-7-0. >> Cvs version >> 20081118 is >> now tagged as >> rev-0.7.1 >> (This is the >> latest >> release). >> >> As usual, you >> can checkout >> latest version >> from CVS, and >> also retrieve >> tagged >> versions as >> follow: >> >> cvs co -r >> rev-0-6-0 (to >> retrieve >> version 0.6.0, >> for example). >> >> You can also >> download this >> and former >> releases from >> here: >> >> http://www.kannel.org/~aguerrieri/ >> >> Regards, >> >> Alejandro >> Guerrieri >> >> >> >> >> >> -- >> Regards, >> Kenny >> >> >> "Whosoever desires >> constant success must >> change his conduct >> with the >> times."-Niccolo >> Machiavelli >> >> >> >> >> >> >> >> >> >> >