Re: [Announce] New Sqlbox version

What I've been considering is on a higher level: a way to be able to  
define your own SQL to fetch messages. That would allow you, among  
other niceties, to specify your own SQL, for example with an extra  
column to specify queueing date/time and a WHERE clause to handle it.  
On the other side, people not needing it would use the regular queries  
that perform better under heavy load.

Still no ETA, though... stay tuned :)

Regards,
--
Alejandro Guerrieri
[email protected]



On 30/09/2009, at 13:25, 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
>
>
>
>
>
>
>
>
>