25 lines
627 B
Markdown
25 lines
627 B
Markdown
## Work in progress
|
|
|
|
Works pretty well at current. Not 100%, but I'm managing to use the code in other projects just fine. Use at your own risk.
|
|
|
|
## What it does
|
|
|
|
Converts JSON to data in a SQLite database. Makes it way easier to search and manipulate. You are responsible for of course doing the seraches and what not yourself.
|
|
|
|
## Database layout
|
|
|
|
```
|
|
|
|
CREATE TABLE "json_data" (
|
|
"id" INTEGER,
|
|
"key" TEXT,
|
|
"parent_key" INTEGER,
|
|
"type" TEXT,
|
|
"value" TEXT,
|
|
PRIMARY KEY("id")
|
|
);
|
|
```
|
|
|
|
## Notes
|
|
|
|
You need to either use the blank database provide ore create your own off the SQL above. It currently doesn't auto generate it.
|