pg_bulkload
pspg
| pg_bulkload | pspg | |
|---|---|---|
| 4 | 13 | |
| 403 | 2,379 | |
| 2.7% | - | |
| 4.6 | 7.8 | |
| 2 months ago | 7 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.
pg_bulkload
-
Ingesting multiple large .sql files into Postgres database
Did you look at tools like https://github.com/ossc-db/pg_bulkload ?
-
SQLalchemy, postgres, and parallelizing
TLDR I would restrict the use of Python to the data processing and use a dedicated solution for loading the data into Postgres, such as the native COPY on a table without keys/indexes, or pg_bulkload.
- How to import csv to postgresql in a faster way ?
-
MEET A STEERING COMMITTEE MEMBER: TORU SHIMOGAKI OF NTT DATA
Tell us about your career path, interest in green software and your journey to the Green Software Foundation (GSF) As a software engineer, I initially worked on performance improvements and feature additions for PostgreSQL, an open-source software - RDBMS. I am the original developer of a data loading utility called pg_bulkload. After that, I supported the introduction of Apache Hadoop, Apache Spark, and Apache Kafka, which are big data platforms.
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?
pgbouncer - lightweight connection pooler for PostgreSQL
pgquarrel - pgquarrel compares PostgreSQL database schemas (DDL)
psycopg2 - PostgreSQL database adapter for the Python programming language
mandown - man-page inspired Markdown viewer
PipelineDB - High-performance time-series aggregation for PostgreSQL
postgres_lsp - A Language Server for Postgres
citus - Distributed PostgreSQL as an extension
mdviewer - Rendered display of markdown on terminal
Greenplum - Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.
ncda - Ncurses disk usage analyzer
moar - Moar is a pager. It's designed to just do the right thing without any configuration.
ccodoc - ccodoc（鹿威し）simulated（造）in your terminal（庭）