changes

• updated surrealdb to v2
• added binary log. this tool parses every object at your keypress and writes it to out.json. the parsing process is logged for debugging.

➜  drugbankdb git:(master) grep '<drug ' /portable/DrugBank.xml | wc -l # rough estimate of number of drugs
16581 

remove one line in the database xml before importing

<drugbank xmlns="http://www.drugbank.ca" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.drugbank.ca http://www.drugbank.ca/docs/drugbank.xsd" version="5.1" exported-on="2024-03-14">

as well as the matching </drugbank> in the end.

This is step-1 which imports the XML as-is into the database.

We can do post-processing later with Deno.

vscode-extension

Name: SurrealQL
Id: surrealdb.surrealql
Description: Official support for the surrealql query language, used by SurrealDB!
Version: 0.2.16
Publisher: SurrealDB
VS Marketplace Link: https://marketplace.visualstudio.com/items?itemName=surrealdb.surrealql

TODO:

• Insert drug interaction as record graph edges.
• Convert types, created as date, average-mass as float