Bashhub – Bash History in the Cloud(bashhub.com)

    histsql=~/.bash_sqlite3

    sqlite3 "${histsql}" '
        create table if not exists "session" (
            "id" integer not null primary key autoincrement,
            "address" text not null,
            "process" integer not null,
            "tty" text not null,
            "user" text not null,
            "start" timestamp not null default current_timestamp,
            "end" timestamp null
        );

        create table if not exists "command" (
            "session" integer not null,
            "line" integer not null,
            "time" timestamp not null default current_timestamp,
            "pwd" text not null,
            "text" text not null,
            primary key ("session", "line")
        );
    '

    histmac=$(ifconfig | sed -e 's/  *$//; /\(ether\|HWaddr\) / { s/.* //; q; }; d;')
    histtty=$(tty)

    histssn=$(sqlite3 "${histsql}" "
        insert into \"session\" (
            \"address\", \"process\", \"tty\", \"user\"
        ) values (
            '${histmac//\'/''}', '${$//\'/''}',
            '${histtty//\'/''}', '${USER//\'/''}'
        );

        select last_insert_rowid();
    ")

    function histend {
        sqlite3 "${histsql}" "
            update \"session\" set
                \"end\" = current_timestamp
            where
                \"id\" = '${histssn//\'/''}';
        "
    }

    trap histend EXIT

    function histadd {
        local data="$(HISTTIMEFORMAT= history 1)"
        if [[ -z $data ]]; then return; fi

        data="${data#"${data%%[![:space:]]*}"}"
        local line="${data%%' '*}"

        data="${data#*' '}"
        data="${data#"${data%%[![:space:]]*}"}"

        sqlite3 "${histsql}" "
            insert or replace into \"command\" (
                \"session\", \"line\",
                \"pwd\", \"text\"
            ) values (
                '${histssn//\'/''}', '${line//\'/''}',
                '${PWD//\'/''}', '${data//\'/''}'
            );
        "
    }

    trap histadd DEBUG