Page 1 of 1

Database structure change from version 1.17

Posted: 04 Mar 2014, 11:16
by IW3HMH
From release 1.17 there will be some changes in database structure:

TxPwr and RxPwr fields will be removed from newly deployed databases, and replaced with TxPwrDecimal and RxPwrDecimal (both fields will store DECIMAL fields). This limitation is due to the limitation in sqlite to REMOVE fields and CHANGE fields data structure (from INT to DECIMAL should be possible, but it's not supported).
They should not be used anymore.

New fields will be added (some are not used yet):

ClubLogQsoUploadDate
ClubLogQsoUploadStatus
HrdlogQsoUploadDate
HrdlogQsoUploadStatus
MyFists
MySotaRef
MyUsacaCounties
MyVuccGrids
AwardSubmitted
AwardGranted
Fists
FistsCc
QrzcomQsoUploadDate
QrzcomQsoUploadStatus
RxPwrDecimal
Skcc
SotaRef
SubMode
TxPwrDecimal
UsacaCounties
VuccGrids
QsoAwards

Re: Database structure change from version 1.17

Posted: 04 Mar 2014, 12:50
by G4POP
I agree that the implementation of the latest changes to ADIF are awful although the new fields are sensible! its just the way it was re-designed that I object to.

However I think you have done a great job being able to incorporate these changes without major disruption to the program, even with the odd SQLite shortcoming.

Re: Database structure change from version 1.17

Posted: 04 Mar 2014, 14:19
by IW3HMH
I will be forced to split the export in 2 different versions, 2.4 and 3.04 to be able to deal with the rest of the world that is working in 2.4
Also import will be made in 2 different formats.
Also using new "mode/submode" system will be a big mess. I will definitely leave ADIF data structure on database to be more flexible and being able to work in a better way keeping the compatibility and the user experience like the one we have right now

Re: Database structure change from version 1.17

Posted: 04 Mar 2014, 14:22
by G4POP
IW3HMH wrote:I will be forced to split the export in 2 different versions, 2.4 and 3.04 to be able to deal with the rest of the world that is working in 2.4 - Also import will be made in 2 different formats.
I have noticed that two or three other developers have done the same, they provided a choice for the user to decide what version of ADIF to import from or export to