Database structure change from version 1.17

Here we will provide support for developers working on integration
Post Reply
User avatar
IW3HMH
Site Admin
Posts: 2200
Joined: 21 Jan 2013, 15:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Database structure change from version 1.17

Post by IW3HMH » 04 Mar 2014, 12:16

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
Daniele Pistollato - IW3HMH

User avatar
G4POP
Moderator
Posts: 5011
Joined: 21 Jan 2013, 15:55
Location: Burnham on Crouch, Essex UK

Re: Database structure change from version 1.17

Post by G4POP » 04 Mar 2014, 13:50

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.
73 Terry G4POP

User avatar
IW3HMH
Site Admin
Posts: 2200
Joined: 21 Jan 2013, 15:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Database structure change from version 1.17

Post by IW3HMH » 04 Mar 2014, 15:19

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
Daniele Pistollato - IW3HMH

User avatar
G4POP
Moderator
Posts: 5011
Joined: 21 Jan 2013, 15:55
Location: Burnham on Crouch, Essex UK

Re: Database structure change from version 1.17

Post by G4POP » 04 Mar 2014, 15:22

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
73 Terry G4POP

Post Reply