HN Who's Hiring Powered By SQLite
Paste who's hiring link to url (
example
) and add some SQL or paste HN's link to a text field below and press "Load HN thread" or load your local db:
CREATE TABLE IF NOT EXISTS stories (id INTEGER PRIMARY KEY ASC, titlefld TEXT, textfld TEXT, byfld TEXT, timefld INTEGER, timeloaded INTEGER ); CREATE TABLE IF NOT EXISTS items ( id INTEGER PRIMARY KEY ASC, parent INTEGER, byfld TEXT, timefld INTEGER, textfld TEXT, typefld TEXT, timeloaded INTEGER, seen INTEGER DEFAULT 0, fldcheckbox INTEGER DEFAULT 0, deleted INTEGER DEFAULT 0); CREATE UNIQUE INDEX IF NOT EXISTS i_id ON items(id); CREATE INDEX IF NOT EXISTS i_timefld ON items(timefld); CREATE INDEX IF NOT EXISTS i_seen ON items(seen); CREATE INDEX IF NOT EXISTS i_deleted ON items(deleted); CREATE VIRTUAL TABLE IF NOT EXISTS searchitems USING fts4(id, textfld);
Exec to list
Exec to table
Load HN thread
SQL History
Save db
Load db
Loaded: 0%
Results will be displayed here