[personal kdb+] About transaction and error handling in q

Community Support
1

Dear Members,

I was looking for a feature in q, which can provide transaction and
error handling, which are most important in some applications.
Could someone give me hints ( using personal trial version).

Thanks in advance
Vasanth

–
Submitted via Google Groups

2

My $0.02: kdb is not a generic DBMS, although it can execute SQLequivalent queries. It is suitable for mostly static data that onlyaccumulates. It is generally not a good idea to keep updating data inthe past. In terms of transactional behavior, by default kdb is singlethreaded, just make sure each query itself is atomic should be enough.2010/4/23, Vasanth K :> Dear Members,>> I was looking for a feature in q, which can provide transaction and> error handling, which are most important in some applications.> Could someone give me hints ( using personal trial version).>> Thanks in advance> Vasanth>> –>

Submitted via Google Groups

3

I would add that there is a feature in q that allows you to take someaction on errors.https://code.kx.com/trac/wiki/QforMortals/execution_control#Protected-EvaluationOn Apr 23, 10:10 pm, ??? <hewei…> wrote:> My $0.02: kdb is not a generic DBMS, although it can execute SQL> equivalent queries. It is suitable for mostly static data that only> accumulates. It is generally not a good idea to keep updating data in> the past. In terms of transactional behavior, by default kdb is single> threaded, just make sure each query itself is atomic should be enough.>> 2010/4/23, Vasanth K <veenavasa…>:>>>>>> > Dear Members,>> > I was looking for a feature in q, which can provide transaction and> > error handling, which are most important in some applications.> > Could someone give me hints ( using personal trial version).>> > Thanks in advance> > Vasanth>> > –> >

Submitted via Google Groups</veenavasa…></hewei…>