bash commandline timestamping using a sqlite database for personal analytics, activity logging and auditing (by csdvrx)

Bash-timestamping-sqlite Alternatives

Similar projects and alternatives to bash-timestamping-sqlite

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better bash-timestamping-sqlite alternative or higher similarity.

bash-timestamping-sqlite reviews and mentions

Posts with mentions or reviews of bash-timestamping-sqlite. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-11-02.
  • Introducing chroot for Android 10, designed for the Nova Air C
    2 projects | | 2 Nov 2022
    It will be inspired by but it will add a theme suited for eink and a proper support for shortcuts or keys like delete/backspace/control delete/control backspace etc. as I'm used to Windows shortcuts and can't do with vim if control-left doesn't jump to the left word but I have to do the traditional esc b that I don't like much :)
  • Bash 5.2
    8 projects | | 27 Sep 2022
    For bash users who are tempted by zsh interactive "fuzzy" completion, here's my take on it: it's directory-aware (offering different suggestions based on your history of commands in that given directory), pure bash code using sqlite to store data:

    The only other dependency is fzy for fuzzy matching.

  • Everything you ever wanted to know about terminals(but were afraid to ask)
    14 projects | | 17 May 2022
    > but i swear to god developers have so completely forgotten how terminals work that i might be one of a handful of people left on earth who actually has the knowledge to, so they all just layer their bullshit on top of ncurses (which should never have survived the '90s) instead and it's maddening.

    Actually, yes it seems to become a dark art.

    However it's the best way to do complex things quickly: I did use some of these tricks like storing and then restoring the cursor position to have the time at which a command stop executing ABOVE the command itself and next to the time it started executing in

    I had to, because I was using MSYS2 and the time to execute a command was a limiting factor in Windows before WSL2.

    14 projects | | 17 May 2022
    It should be a super simple feature to add to your terminal emulator: SCP works with a X,Y position. RCP just "jumps" there.

    If you keep an accounting of how many lines you have displayed since then, you could alter the response to RCP by also doing the appropriate amount of scrolling: it should only take one variable, the deltaY to scroll.

    If you want to test the idea, I think you could even use tmux and send commands to control the scrollback cf a

    I've used similar tricks with RCP/SCP but for simpler things: the only slight difficulty is the deltaY accounting, like when you are executing commands near the bottom of the screen because you must take into account that scolling will happen - but it's essentially similar to your idea.

    So check and make sure you understand both how the __notbottom function works, and why PS0 needs an extra Esc[2a

    Actually, now that I think more about your idea, it would be sweet to keep a SCP/RCP stack with multiple values, where you can push values with each SCP then pop them with RCP, say in sequence, or maybe just access the nth value with a different command that wouldn't pop them? That could be done nicely by augmenting RCP.

    Also you could augment SCP with an optional flag to specify whether the terminal should scroll back upon RCP of this nth entry, and you'd have a great function that would be quite useful (ex: SCP with a jump bool when the return is non 0: you could make a shortcut to jump to the commands that have returned errors)

    There's no reason to stop adding cool features to terminals: we're in a terminal renaissance!

  • Do-nothing scripting: the key to gradual automation
    6 projects | | 2 Nov 2021
    > The problem happens when somebody "updates" that web server in-place.

    Imagine this is 28-nginx : I would jist create another script 29-nginx-update recording the update, even if it: "echo apt-get update; apt-get upgrade nginx ; echo "make sure to fix variable $foo"

    Next time I have to do that, I will integrate that into 28-nginx and remove 29-nginx-update

    > eventually when someone tries the whole checklist from the beginning, they'll find it's now broken; the steps aren't working as expected.

    Maybe I don't understand the issue, but my scripts or text files are simple and meant to be used in sequence. If I hack the scripts, I make sure it still works as expected - and given my natural laziness, I only ever update scripts when deploying to a new server or VM, so I get an immediate feedback if they stop working

    Still, sometimes something may work as expected (ex: above, maybe $foo depends on a context?), but it only means I need to generalize the previous solution - and since the script update only happen in the context of a new deployment, everything is still fresh in my head.

    To help me with that, I also use zfs snapshots at important steps, to be able to "observe" what the files looked like on the other server at a specific time. The snapshots conveniently share the same name (ex [email protected]) so comparing the files to create a scripts can be easily done with diff -Nur using .zfs/snapshot/ cf

    Between that + a sqlite database containing the full history of commands types (including in which directory, and their return code), I rarely have such issues

    Shameless plug for that bash history in sqlite:

  • s/bash/zsh/g
    24 projects | | 20 Oct 2021
    > I believe that using zsh means, for the vast majority of users, using just a small subset of functionality that gives a better UX when compared to Bash.

    What about adding only these functionalities you may care about?

    When I tried zsh, what I liked was the history search. Like youm Everything else "wasn't as simple as I expected".

    So I fixed my bash. Check :

    - stores everything into a sqlite database so 2 separate terminals can access each other history on the go

    - add extras details to the history like when the command started, stopped, which with return code, in which directory,

    - for accessing the history, uses fzy for fuzzy finding,

    - provides 2 separate history search context: either global (ctrl-t) or "this directory only" (ctrl-r), with extra goodies like excluding commands with a non-zero return error code thanks to the extra things saved

    I included a few examples of the SQL queries you can run.

  • A note from our sponsor - InfluxDB | 27 Jan 2023
    InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises. Learn more →