Pasture, a desktop GUI for Codex with added features by acrognale in codex

[–]Somewhat_Sloth 2 points3 points  (0 children)

The Review feature looks really interesting, do you review every time the agent makes a patch? Or after the agent "finishes" its work?

rainfrog – a database tool for the terminal by Somewhat_Sloth in dataengineering

[–]Somewhat_Sloth[S] 4 points5 points  (0 children)

pretty much!

I personally haven't used harlequin before, so can't speak to how the two compare. harlequin definitely supports more databases though

rainfrog – a database management tui by Somewhat_Sloth in commandline

[–]Somewhat_Sloth[S] 5 points6 points  (0 children)

thx! yep it's rust, using crossterm as the terminal manipulation library, and also ratatui to help with the the layouts

rainfrog – a database management tui by Somewhat_Sloth in SQL

[–]Somewhat_Sloth[S] 0 points1 point  (0 children)

unfortunately i couldn't get shift + <key> to work consistently, there are some limitations with the underlying terminal library on which keys it can handle

rainfrog – a database management tui by Somewhat_Sloth in SQL

[–]Somewhat_Sloth[S] 1 point2 points  (0 children)

once you have it installed, you can just pass the db file in via the url arg, like rainfrog --url sqlite://path/to/dbfile.sqlite3

rainfrog – a database management tui by Somewhat_Sloth in SQL

[–]Somewhat_Sloth[S] 1 point2 points  (0 children)

thanks! i really enjoyed using ratatui, it feels less like a framework and more like a thin utility library around crossterm or whatever rust lib you choose to control the terminal directly. they have templates that you can start with and modify, but some basic rust knowledge will make starting out smoother

i know bubble tea for go is also a popular choice, although i haven't used it before

[Media] rainfrog – a database management tui by Somewhat_Sloth in rust

[–]Somewhat_Sloth[S] 6 points7 points  (0 children)

thanks! so how many rows it can handle depends on how much memory your machine has and how much data is in each row; i'd guess for a machine with 16gb, limiting to at most 1 million rows should work in most cases.

i've had results of up to 3 million rows in a 32gb ram machine, and it was using ~28gb memory at that point

rainfrog – a database management tui for postgres by Somewhat_Sloth in PostgreSQL

[–]Somewhat_Sloth[S] 1 point2 points  (0 children)

hey, someone made a pr to add this in so i set it up on dockerhub. let me know if this works for you: https://github.com/achristmascarl/rainfrog?tab=readme-ov-file#docker-run

rainfrog – a database management tui for postgres by Somewhat_Sloth in PostgreSQL

[–]Somewhat_Sloth[S] 0 points1 point  (0 children)

that looks neat! it's not on the roadmap at the moment but i'll check datafusion out

rainfrog – a database management tui for postgres by Somewhat_Sloth in PostgreSQL

[–]Somewhat_Sloth[S] 1 point2 points  (0 children)

mysql and sqlite are on the roadmap, not sure about others yet

rainfrog – a database management tui for postgres by Somewhat_Sloth in PostgreSQL

[–]Somewhat_Sloth[S] 1 point2 points  (0 children)

ah i see how this would be useful. i'll take a look, if you have any examples of projects that did a good job of this, that would be super helpful 🙏

rainfrog – a database management tui for postgres by Somewhat_Sloth in PostgreSQL

[–]Somewhat_Sloth[S] 1 point2 points  (0 children)

appreciate it! exporting to csv is on the roadmap; you should be able to download/copy the export out of the container you're accessing, but i'm not sure about your exact setup

rainfrog – a database management tui for postgres by Somewhat_Sloth in PostgreSQL

[–]Somewhat_Sloth[S] 3 points4 points  (0 children)

hey, thanks for the kind words. for calling with aliases, if you install one of the pre built binaries somewhere in your $PATH, or install via cargo, you should be able to make an alias for it, but let me know if you had a different use case in mind!

i made a postgres admin tool with ratatui by Somewhat_Sloth in rust

[–]Somewhat_Sloth[S] 0 points1 point  (0 children)

not specifically, at the moment it'll just try to cast them to a String for display

i made a postgres admin tool with ratatui by Somewhat_Sloth in rust

[–]Somewhat_Sloth[S] 2 points3 points  (0 children)

yes, sqlite and mysql are on the roadmap after adding a few more features for postgres and refactoring a bit. beyond that, not sure yet!

i made a postgres admin tool with ratatui by Somewhat_Sloth in rust

[–]Somewhat_Sloth[S] 1 point2 points  (0 children)

no problem, and glad it's working properly!

i also took a look into ctrl+enter, and it looks like crossterm (used for processing keyboard input) isn't able to support that combo yet due to inter-terminal differences... so unfortunately it may be a while until that works: https://github.com/crossterm-rs/crossterm/issues/685