[Announce] New Sqlbox version

View: New views
11 Messages — Rating Filter:   Alert me  

[Announce] New Sqlbox version

by Alejandro Guerrieri-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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



Parent Message unknown Re: [Announce] New Sqlbox version

by Alejandro Guerrieri-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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 <aguerrieri@...> 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



Re: [Announce] New Sqlbox version

by Ehizogie Binitie :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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 <aguerrieri@...> 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
>
>




Re: [Announce] New Sqlbox version

by Alejandro Guerrieri-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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 <aguerrieri@...> 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
>>
>>
>
>



Re: [Announce] New Sqlbox version

by Alexander Malysh :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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 <aguerrieri@...> 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
>>>
>>>
>>
>>
>
>
>



Re: [Announce] New Sqlbox version

by Alejandro Guerrieri-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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 <aguerrieri@...> 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
>>>>
>>>>
>>>
>>>
>
>



Re: [Announce] New Sqlbox version

by Kenny Orisanaiye :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Alejandro,

Is there any hope of having this scheduling capabilities in the SQLBox in the nearest future ?

--
Kenny

p: +2348034939090
e: kenny@...
w: www.nuObjects.com

Bulk SMS Solutions | Managed Hosting | Enterprise Application Development


On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri <aguerrieri@...> 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 <aguerrieri@...> 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










Re: [Announce] New Sqlbox version

by Alejandro Guerrieri-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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



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: kenny@...
w: www.nuObjects.com

Bulk SMS Solutions | Managed Hosting | Enterprise Application Development


On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri <aguerrieri@...> 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 <aguerrieri@...> 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











Re: [Announce] New Sqlbox version

by Willy-21 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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: kenny@...
> w: www.nuObjects.com
>
> Bulk SMS Solutions | Managed Hosting | Enterprise Application
> Development
>
>
> On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri
> <aguerrieri@...> 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
>                                                 <aguerrieri@...> 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
>                                        
>                                        
>                                
>                                
>                
>                
>        
>        
>        
>



Re: [Announce] New Sqlbox version

by Alejandro Guerrieri-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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
aguerrieri@...



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: kenny@...
>> w: www.nuObjects.com
>>
>> Bulk SMS Solutions | Managed Hosting | Enterprise Application
>> Development
>>
>>
>> On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri
>> <aguerrieri@...> 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
>>                                                
>> <aguerrieri@...> 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>



Re: [Announce] New Sqlbox version

by Kenny Orisanaiye :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Alejandro,

This would be fantastic! Can't wait anymore. :)

--
Kenny

e: kenny@...
w: www.nuObjects.com

Bulk SMS Solutions | Managed Hosting | Enterprise Application Development


On Wed, Sep 30, 2009 at 2:06 PM, Alejandro Guerrieri <aguerrieri@...> wrote:
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
aguerrieri@...



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: kenny@...
w: www.nuObjects.com

Bulk SMS Solutions | Managed Hosting | Enterprise Application
Development


On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri
<aguerrieri@...> 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
                                              <aguerrieri@...> 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