Database structure change from version 1.17

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

Database structure change from version 1.17

Post 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
Daniele Pistollato - IW3HMH
User avatar
G4POP
Log4OM Alpha Team
Posts: 10749
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Database structure change from version 1.17

Post 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.
73 Terry G4POP
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Database structure change from version 1.17

Post 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
Daniele Pistollato - IW3HMH
User avatar
G4POP
Log4OM Alpha Team
Posts: 10749
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Database structure change from version 1.17

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