#1 2020-07-15 19:59:34

Leslie7
Member
Registered: 2015-06-25
Posts: 184

What is cooking in SQLite's kitchen?

ab,

by looking at the repository comments it seems decimal arithmetic is finally coming. smile
Strangely it is described  as an extension for doing decimal arithmetic on strings - so it seems there is no proper decimal data type. (Or in SQLite's  world "decimal affinity".)

Currently it is built into the shell, but is an optional add-on for the library. It is not included in the amalgamation.
If this remains the case, will this be a part of the mORMot engine?

Last edited by Leslie7 (2020-07-15 20:15:18)

Offline

#2 2020-08-17 16:59:46

Leslie7
Member
Registered: 2015-06-25
Posts: 184

Re: What is cooking in SQLite's kitchen?

v3.33 is out with decimal support. smile Will this be compiled into mORMot's sqlite?

Last edited by Leslie7 (2020-08-17 17:00:01)

Offline

#3 2020-08-17 17:12:55

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 11,568
Website

Re: What is cooking in SQLite's kitchen?

We will wait a few days, because almost everytime there is a #.#.1 revision which fixes some regression, discovered just after the official release.
smile

Note that this "decimal" is not a new SQLite3 type, comparable to the decimal types of other RDBMS - it is just a way to access numbers stored with text columns.
This extension is not part of the amalgmation yet, so I don't think it is a good idea to enable it by default: it will need external c source files, which may not be in synch with the main amalgmation sqlite3.c file.

Offline

#4 2020-08-18 15:21:33

Leslie7
Member
Registered: 2015-06-25
Posts: 184

Re: What is cooking in SQLite's kitchen?

It makes total sense to be cautious with the fresh releases.

Hopefully the end goal is to create a proper  decimal type, but this is a step to the right direction. It is very much needed. I have never understood why was this not a priority for a long time. AFAIK the since cancelled v4 branch had proper decimal support. I assume this made the developers avoid the subject for v3 even longer.

I have no idea  how difficult it is to add the extra source file(s) for mORMot, but it would be a little surprising if the source was not synced.

Last edited by Leslie7 (2020-08-18 21:23:54)

Offline

#5 2020-09-02 07:53:34

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 11,568
Website

Re: What is cooking in SQLite's kitchen?

3.33 has been included.
They didn't include any 3.33.# after-release patch this time!
smile

Check https://synopse.info/fossil/info/0cb9b2f9c3
And don't forget to download the latest .o/.obj files too (no need from github).

Without the decimal functions support yet.

Offline

#6 2020-09-02 13:21:47

Junior/RO
Member
Registered: 2011-05-13
Posts: 176

Re: What is cooking in SQLite's kitchen?

@ab sqlite encryption is gone?

Offline

#7 2020-09-02 17:05:50

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 11,568
Website

Re: What is cooking in SQLite's kitchen?

It is still there.
The https://synopse.info/forum/viewtopic.ph … 327#p32327 new way of encrypting data is working as expected with 3.33.
No change about the encryption. Only XE4-Win64 is not working yet, due to a Delphi linker bug in this version. But seems fine from Delphi 6 to 10.x.

Offline

#8 2020-09-11 05:37:22

Leslie7
Member
Registered: 2015-06-25
Posts: 184

Re: What is cooking in SQLite's kitchen?

ab wrote:

3.33 has been included.
They didn't include any 3.33.# after-release patch this time!
smile

Take an umbrella to scare away the rain. big_smile

Offline

Board footer

Powered by FluxBB