Database

Since version 2.4.0 all NetSpeedMonitor data is saved in a SQLite3 database. Please note that NetSpeedMonitor monitors the amount of data transfered by a network interface. This data also includes usual network traffic. NetSpeedMonitor doesn't monitor raw data.

Import / Export traffic

Currently NetSpeedMonitor supports importing and exporting .db and .csv (comma-separated values) files. The format of the .csv files is the same for importing and exporting:

Format:	"Interface",year,month,day,sent(bytes),recv(bytes)
Example:	"Intel PRO/Wireless",2008,1,2,6000,8000

Editing the Database File (SQLite Tables)

If you need to edit the NetSpeedMonitor database, here are the information you need. However, it's not recomannded to edit the database file! Be sure that NetSpeedMonitor is closed. Depending which operating system you are using and which custom settings you made in the configuration, the database file is usually saved in one of the following directories:

Windows Vista / Windows 7:
C:\User\AppData\Roaming\NetSpeedMonitor\data.db

Windows XP / Server 2003:
C:\Documents and Settings\User\Application Data\NetSpeedMonitor\data.db

SQLite Table: interfaces

Column	Description
id	id of network interface
name	name of network interface

SQLite Table: traffic

Column	Description
id	id of network interface, reference to table interfaces
y	year
m	month
d	day
sent	sent bytes
recv	received bytes

Third-party tools for managing SQLite databases

SQLite Database Browser (Open Source)
SQLiteSpy

Use third-party tools at you own risk!

Select your Language
English | Deutsch

Navigation

Last updated on April 3, 2010 01:35 PM