Transactions, Commits and Rollbacks

[Bart Pietercil]

As I said earlier, there are for the moment no transactions and hence no commits or rollbacks in the valentina products.
Journaling has been added to the 5 series as a first step towards transactions.

There is now no way to do rollbacks (except for non production environments, taking a backup)

Transactions are on the planning for Valentina.
Ruslan can  you tell more ?

regards

b.


On 11 Oct 2013, at 17:27, Joseph Morgan <joseph at checkos.com> wrote:

> I also typically use SQL. But I'm switching over to more class based approach for easier to read/write code. Also I believe I can "centralize" all the SQL queries and executes in one place for a more simple way to update code. I will guess that there is a slight performance trade off but for me it would be negligible. Also the SQL is still there if needed. 
> 
> 
>> On Oct 11, 2013, at 10:18 AM, "Johnny & Karen Harris" <johnny at southshore.com> wrote:
>> 
>> Thanks Joseph,
>> 
>> That's reassuring to know. I've not looked at the vtable class yet.
>> I plan to check it out soon. Habit for me is to write SQL queries but
>> I wonder if there are any speed advantages to using the VTable class?
>> I think from a coding point of view it would be faster but I wonder
>> about any gains in query performance.
>> 
>> Regards,
>> Johnny Harris
>> 
>>> I think you're correct about the commits as I haven't needed to use them
>>> at all thus far. I have been using vtable class to add/update records.
>>> 
>>> On Oct 11, 2013, at 8:54 AM, "Johnny & Karen Harris"
>>> <johnny at southshore.com> wrote:
>>> 
>>>>> Hi Everyone,
>>>>> 
>>>>> I’ve been reading the Valentina documentation and I’ve not found
>>>>> any
>>>>> information regarding transactions, commits or rollbacks.
>>>>> 
>>>>> if these don’t exist in Valentina, what in the best practice for
>>>>> ensuring all transactions finish successfully?
>>>>> 
>>>>> If they do, could someone point me in the direction of the
>>>>> documentation?
>>>>> 
>>>>> Best Regards To Everyone,
>>>>> 
>>>>> Johnny Harris_______________________________________________
>>>>> Valentina mailing list
>>>>> Valentina at lists.macserve.net
>>>>> http://lists.macserve.net/mailman/listinfo/valentina
>>>> 
>>>> I found in the documentation that those are reserved words, so I'll
>>>> assume
>>>> that transactions do exist. I'll try it out in some code.
>>>> 
>>>> I guess Valentina will commit all changes automatically unless "BEGIN"
>>>> is
>>>> used?
>>>> 
>>>> Regards,
>>>> 
>>>> Johnny Harris
>>>> 
>>>> 
>>>> _______________________________________________
>>>> Valentina mailing list
>>>> Valentina at lists.macserve.net
>>>> http://lists.macserve.net/mailman/listinfo/valentina
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>>> 
>> 
>> 
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina