add stupid experiment - randomcrap - random crap programs of varying quality
 (HTM) git clone git://git.codemadness.org/randomcrap
 (DIR) Log
 (DIR) Files
 (DIR) Refs
 (DIR) README
 (DIR) LICENSE
       ---
 (DIR) commit 62eb9cd16d2fbc341f6a07be98bae017ed1d3f41
 (DIR) parent c6a6a40c0a956d52d228a61b764693a41e1930e1
 (HTM) Author: Hiltjo Posthuma <hiltjo@codemadness.org>
       Date:   Tue, 19 Sep 2023 20:00:06 +0200
       
       add stupid experiment
       
       Diffstat:
         A sfeedql                             |      20 ++++++++++++++++++++
       
       1 file changed, 20 insertions(+), 0 deletions(-)
       ---
 (DIR) diff --git a/sfeedql b/sfeedql
       @@ -0,0 +1,20 @@
       +#!/bin/sh
       +
       +sqlite3 \
       +':memory:' \
       +'CREATE TABLE items (
       +        timestamp bigint,
       +        title TEXT,
       +        link TEXT,
       +        content TEXT,
       +        content_type varchar(16),
       +        id TEXT,
       +        author TEXT,
       +        enclosure TEXT,
       +        category TEXT);' \
       +'.mode ascii' \
       +'.headers off' \
       +'.separator "\t" "\n"' \
       +'.import /dev/stdin items' \
       +"${1:-SELECT * FROM items LIMIT 10}"
       +