SQLite format 3@  .n  c  m bc %Ytriggerbookmarks_aubookmarksCREATE TRIGGER bookmarks_au AFTER UPDATE ON bookmarks BEGIN INSERT INTO bookmarks_fts (bookmarks_fts, rowid, URL, metadata, tags, "desc") VALUES ('delete', old.id, old.URL, old.metadata, old.tags, old.desc); INSERT INTO bookmarks_fts (rowid, URL, metadata, tags, "desc") VALUES (new.id, new.URL, new.metadata, new.tags, new.desc); ENDm %!triggerbookmarks_aibookmarksCREATE TRIGGER bookmarks_ai AFTER INSERT ON bookmarks BEGIN INSERT INTO bookmarks_fts (rowid, URL, metadata, tags, "desc") VALUES (new.id, new.URL, new.metadata, new.tags, new.desc); END %Striggerbookmarks_adbookmarksCREATE TRIGGER bookmarks_ad AFTER DELETE ON bookmarks BEGIN INSERT INTO bookmarks_fts (bookmarks_fts, rowid, URL, metadata, tags, "desc") VALUES ('delete', old.id, old.URL, old.metadata, old.tags, old.desc); ENDx 55tablebookmarks_fts_configbookmarks_fts_config CREATE TABLE 'bookmarks_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID| 77tablebookmarks_fts_docsizebookmarks_fts_docsizeCREATE TABLE 'bookmarks_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB) //Ctablebookmarks_fts_idxbookmarks_fts_idxCREATE TABLE 'bookmarks_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWIDv11tablebookmarks_fts_databookmarks_fts_dataCREATE TABLE 'bookmarks_fts_data'(id INTEGER PRIMARY KEY, block BLOB)''gtablebookmarks_ftsbookmarks_ftsCREATE VIRTUAL TABLE bookmarks_fts using fts5 ( id, URL, metadata, tags, "desc", flags UNINDEXED, last_update_ts UNINDEXED, content= 'bookmarks', content_rowid= 'id', tokenize= "porter unicode61" ))CtriggerUpdateLastTimebookmarksCREATE TRIGGER [UpdateLastTime] AFTER UPDATE ON bookmarks FOR EACH ROW WHEN NEW.last_update_ts <= OLD.last_update_ts BEGIN update bookmarks set last_update_ts=CURRENT_TIMESTAMP where id = OLD.id; ENDwtablebookmarksbookmarksCREATE TABLE bookmarks ( id INTEGER not null primary key, URL VARCHAR not null unique, metadata VARCHAR not null default '', tags VARCHAR not null default '', desc VARCHAR not null default '', flags INTEGER not null default 0, last_update_ts DATETIME not null default CURRENT_TIMESTAMP )1Eindexsqlite_autoindex_bookmarks_1bookmarksXAA;table__diesel_schema_migrations__diesel_schema_migrationsCREATE TABLE __diesel_schema_migrations ( version VARCHAR(50) PRIMARY KEY NOT NULL, run_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP )SgAindexsqlite_autoindex___diesel_schema_migrations_1__diesel_schema_migrations $)3202212291104552023-12-23 09:27:06 ) 20221229110455 ^ ^*}# 7 N9'3https://www.google.comGoogle,ccc,yyy,Example Entry2023-12-23 09:27:07 =) 3shell::vim +/"## SqlAlchemy" $HOME/dev/s/public/bkmr/bkmr/tests/resources/sample_docu.mdshell open vim,,2023-12-23 09:27:06X y 3$HOME/dev/s/public/bkmr/bkmr/tests/resources/bkmr.pptxpptx,,2023-12-23 09:27:06*  3$HOME/devdev,,2023-12-23 09:27:060) 3/Users/Q187392home,,2023-12-23 09:27:06.-  3http://none/none,,2023-12-23 09:27:06W1'33http://11111/11111bla blub3,aaa,bbb,ccc,nice description a42023-12-23 09:27:06W1'33http://asdf2/asdf2bla blub2,aaa,bbb,ccc,nice description a32023-12-23 09:27:06P-33http://asdf/asdfbla blub,aaa,bbb,nice description a22023-12-23 09:27:06f1G13http://aaaaa/bbbbbTEST: entry for bookmark bbbb,aaa,bbb,nice description a2023-12-23 09:27:06j1G'13http://xxxxx/yyyyyTEST: entry for bookmark xxxx,ccc,xxx,yyy,nice description b2023-12-23 09:27:06 ?Mu`]=shell::vim +/"## SqlAlchemy" $HOME/dev/s/public/bkmr/bkmr/tests/resources/sample_docu.md :y$HOME/dev/s/public/bkmr/bkmr/tests/resources/bkmr.pptx $HOME/dev )/Users/Q187392-http://none/none1http://11111/111111http://asdf2/asdf2-http://asdf/asdf1http://aaaaa/bbbbb1http://xxxxx/yyyyy9 https://www.google.com /  C  0iV]0cccomentrixamplgoogl httpwwwyyi  *iV]0cccomentrixamplgoogl httpwwwyyi  'R011111a234aaaasdf2bbbbbkmr  laub23ookmarkcccomdescriptv ocu entrixamplforgoogl homettpmd niceoneopen pptx  ublic q187392resourc   s ampl  hell  qlalchemi test uservim wwwxxxxxyyiyyi    #  (      2$     ||              version 6 ~ S s 9'3 ,https://www.google.comGoogle,ccc,yyy,Example Entry2023-12-21 18:40:40yB_cS8$p< n3IeOj{};;*F%2F=D¼_;z@r<겓<9E*Ѽ=;:*9)~W<:Q<{<33<":% ;ܙQNH\=K=JڼM <<)~= 0@;ڻmf<7i<#ˊ9'<Б;hg2û;_9;wVSA˺";mA<~:{:%;ܩ<M;GƁXػԿ\<4/f<X8= F>2"jZ"R园r=L;Zuw@|Ek<`Ky<VM 캾m;j;dn=E6<{><Ի+h\<#N: ƅ^># <ǰ5=˺/bq =֠ ;g*uu;-W<W¼`<_2<;M(?vغ <;Lsм@]4:;pq2AWew;GP>l$;_=;—<^<;n;5ɮ:2[ϬkT<'X<k&co;aA;}B*;<9<~-<~< |5"aw45:>&;$| =S!(<"<>LX&7'<<<;H밻 m;NOF9<9y[,<9= ձ<_W< <󆪻S;8;4anH$ :M;=<%1;fܩ/v܋H-\ud;vKq:⻒!ksѻt9K<5+O<)$H6<);rpٻ<&Ʒ͂dE=~-]9<{cd*<;t2\*}<]Hd;nNڼ[^<㚻q~X:CEWShC<*!}<{㼪X;i)JCfM;U< lP<3ᢼSLEm$5<7i;]Iw$A/7R ,( @  Qs؄am;I0<;?7V<] <%;;R; 5BaO;t9<;f˻:ea[u<<:Y:N0Yһk1j=) 3shell::vim +/ =) 3shell::vim +/"## SqlAlchemy" $HOME/dev/s/public/bkmr/bkmr/tests/resources/sample_docu.mdshell open vim,,2023-12-21 18:40:39X y 3$HOME/dev/s/public/bkmr/bkmr/tests/resources/bkmr.pptxpptx,,2023-12-21 18:40:39*  3$HOME/devdev,,2023-12-21 18:40:390) 3/Users/Q187392home,,2023-12-21 18:40:39.-  3http://none/none,,2023-12-21 18:40:39W1'33http://11111/11111bla blub3,aaa,bbb,ccc,nice description a42023-12-21 18:40:39W1'33http://asdf2/asdf2bla blub2,aaa,bbb,ccc,nice description a32023-12-21 18:40:39P-33http://asdf/asdfbla blub,aaa,bbb,nice description a22023-12-21 18:40:39f1G13http://aaaaa/bbbbbTEST: entry for bookmark bbbb,aaa,bbb,nice description a2023-12-21 18:40:39j1G'13http://xxxxx/yyyyyTEST: entry for bookmark xxxx,ccc,xxx,yyy,nice description b2023-12-21 18:40:40