RITdb can be used with a free, open-source application called DB Browser for SQLite. (github)
Install DB Browser for SQLite:
- Depending on your OS, download and install package or run the install command from https://sqlitebrowser.org/dl/
- Associate .ritdb with that application. For Windows, right click on a .ritdb file and choose Open With... > Choose Another App > select Db Browser and enable Always use this app to open .ritdb files.
To Browse RITdb with DB Browser:
- Open .rtidb file with Db Browser for SQLite.
- Choose Browse Data tab.
- Enter target text in any column. (reference RITdb Streaming Datalog for column and entity descriptions and example SQL statements to generate wide tables)
To Export RITdb as CSV:
- Open .rtidb file with Db Browser for SQLite.
- Choose File > Export > Table(s) as CSV file...
- Choose Save with ritdb1 table selected. (See Figure 1)
Load Sample SQL Statements to Generate "Wide" Tables:
- Open .rtidb file with Db Browser for SQLite.
- Choose Execute SQL tab and Open SQL Files, then select any of the examples below.
- Choose any of the newly loaded .sql tabs and choose the play icon (or press F5 Key) to execute the selected SQL.
- The results will appear as a table in the pane directly below with output of the script in the pane below that.
Figure 1: Export as CSV
1.
2.