orafce
pspg
| orafce | pspg | |
|---|---|---|
| 2 | 13 | |
| 472 | 2,379 | |
| 2.3% | - | |
| 8.2 | 7.8 | |
| 12 days ago | 14 days ago | |
| C | C | |
| GNU General Public License v3.0 or later | BSD 2-clause "Simplified" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
orafce
-
Business Days
This extension have some functions to work with business days https://github.com/orafce/orafce, search for “bizdays”
-
A new extension in PostgreSQL for Oracle DBMS_JOB compatibility
In that case, there even exist Orafce, a project that provides a lot of compatibility to a lot of Oracle Packages. For example, a lot of date functions, UTL_FILE, DBMS_OUTPUT and a lot more are already [art of this :)
https://github.com/orafce/orafce
pspg
-
Harlequin: SQL IDE for Your Terminal
pspg is a pager intended to be used with SQL command line clients. It was originally created for Postgres (hence the name), but also works with MySQL and others
https://github.com/okbob/pspg
- Pspg: Unix pager designed for work with tables
-
Show HN: Postgres Language Server
> I am regularly surprised how bad the tooling is for SQL/databases.
This. I'd really like to have a working SQL pretty printer/formatter. Psql is great, but lacks autocompletion in several places.
That said, a big shoutout to pspg (https://github.com/okbob/pspg) - an excellent pager for psql (also for general csvs).
- Pspg – Postgres Pager[video]
- PostgreSQL and Tabular Data Pager
- Show HN: Ov – feature rich terminal pager
-
pspg VS ov - a user suggested alternative
2 projects | 25 Jun 2022
-
Charm 0.1: a data-oriented scripting language
Possibly the best pager for tabular data out there is https://github.com/okbob/pspg ; it accepts generic inputs so results can be piped via shell command.
-
how to use pspg
I am trying to use: https://github.com/okbob/pspg
- Pspg – Postgres Pager
What are some alternatives?
plpgsql_check - plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).
pgquarrel - pgquarrel compares PostgreSQL database schemas (DDL)
pgaudit - PostgreSQL Audit Extension
mandown - man-page inspired Markdown viewer
pg_plan_advsr - PostgreSQL extension for automated execution plan tuning
postgres_lsp - A Language Server for Postgres
tds_fdw - A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
mdviewer - Rendered display of markdown on terminal
hypopg - Hypothetical Indexes for PostgreSQL
ncda - Ncurses disk usage analyzer
pg-generate-up-down-series - My attempt at the benchmark!
moar - Moar is a pager. It's designed to just do the right thing without any configuration.