WHONET SQLite data files

Summary

For the past twenty years, WHONET has relied on a simple but robust data file structure called dBASE (also known as DBF files), which has worked well for WHONET users for many years. WHONET and BacLink are now ready to support a newer and more modern data structure called SQLite which offers many advantages over dBASE.

Our new versions of WHONET support both the existing WHONET dBASE files, as well as the new WHONET SQLite files. You can use any combination of the old dBASE and new SQLite files without issue, assuming you do not have one of the compatibility problems referenced above.

Performance comparison

The below table gives examples of the performance improvement using WHONET SQLite data files using one year of data from a 700-bed hospital and over 70,000 samples.

WHONET version comparison
WHONET 5.6 - dBASE WHONET 2019 - dBASE WHONET 2020 - dBASE WHONET 2020 - SQLite
Escherichia coli - % RIS (n=5092) 0:10 0:06 0:18 0:06
Organism summary (n=70798) 0:50 0:30 1:16 0:18
Location summary (n=70798) 5:52 6:30 1:25 0:19
WHO GLASS export (n=70798) Not applicable 2:03 7:30 0:45
EARS-Net export (n=70798) 0:06 0:06 0:22 0:02

BacLink version comparison
BacLink 2 - dBASE BacLink 2019 - dBASE BacLink 2020 - dBASE BacLink 2020 - SQLite
1 year of data (180 MB) Too much data 3:24 13:25 3:13

How to create SQLite data files

How to view SQLite data files