What does HackerNews think of pgloader?

Migrate to PostgreSQL in a single command!

Language: Common Lisp

#11 in Database
#7 in MySQL
#14 in PostgreSQL
Why Lisp? | Nov 2022
Alright, here's my little selection of projects.

If you don't see a project in your field it doesn't mean there is no software or library.

Are they as awesome as the Rust/Go projects? It depends.

Is it an exhaustive list? No.

For a list of companies using CL and more projects, old or current, see the other links.

## Music

- [OpusModus](http://opusmodus.com/) - a comprehensive computer-aided environment for the whole work of music composition. [Proprietary]. - [OM7](https://github.com/openmusic-project/om7) - a new implementation of the OpenMusic visual programming and computer-aided composition environment including a number of improvements on graphical interface, computational mode, and connection to external software libraries. [GPL3][2]. - [ScoreCloud](https://scorecloud.com/) - A web and mobile application to automatically create music notation from music performance or recordings. Built with LispWorks.

## DB tools

- [Pgloader](https://github.com/dimitri/pgloader/) - Migrate to PostgreSQL in a single command!. [PostgreSQL License] - [Pgchart](https://github.com/dimitri/pgcharts) - A self-contained web application that takes as input an SQL query text and outputs its data as a chart. [No License Specified]

## Utils

- [Cepl](https://github.com/cbaggers/cepl) - Code Evaluate Play Loop. [2-clause BSD]. - [Regex-coach](http://weitz.de/regex-coach/) - a graphical application for Windows which can be used to experiment with (Perl-compatible) regular expressions interactively. Freeware.

## Text editors

- [Lem](https://github.com/cxxxr/lem) - Common Lisp editor/IDE with high expansibility. [MIT]. Works for many languages, has a LSP client.

## Math

- [Maxima](https://sourceforge.net/projects/maxima/files/) - Computer Algebra System written in Common Lisp. [GPL2]. - https://github.com/susam/mathb A math pastebin

## Graphics

- [Sketch](https://github.com/vydd/sketch) -A Common Lisp framework for the creation of electronic art, visual design, game prototyping, game making, computer graphics, exploration of human-computer interaction, and more.

## Productivity

- [Grammarly](https://www.grammarly.com/) - Grammar checking. [Proprietary]. - [Deftask](https://deftask.com/) - Painless task management for teams. [Partly Open Source]. - [Ichiran](https://github.com/tshatrov/ichiran) - Linguistic tools for texts in Japanese language. [MIT]. - [Ballish](https://gitlab.com/ralt/ballish - a pretty fast code search tool.

### Window Manager

- [Stumpwm](https://github.com/stumpwm/stumpwm) - The Stump Window Manager.

## Mobile Applications

- [ScoreCloud Express](https://apps.apple.com/us/app/scorecloud-express/id566535238) - An iPhone and iPad application that automatically creates music notation from music performance or recordings.

### Games

Just 2:

- Kandria https://kandria.com/ - [sucle](https://github.com/terminal625/sucle) - A Minecraft clone (voxel game engine). [MIT]. - [Notalone](https://github.com/borodust/notalone) - You wake up nowhere in the night. Hungry zombies around, but your ol' pal "BOOMSTICK" is with you. [GPL3]

My selection comes from https://github.com/azzamsa/awesome-cl-software

Why Lisp? | Nov 2022
Pgloader is written in Common Lisp https://github.com/dimitri/pgloader

StumpWM as well https://github.com/stumpwm/stumpwm

Ask HN: Good Postgres Book(s)? | Aug 2021
The Art of PostgreSQL (https://theartofpostgresql.com) by Dimitri Fontaine, also the author of PGLoader (https://github.com/dimitri/pgloader)
Babelfish: SQL Server-to-Postgres Translation Layer | Dec 2020
Expand Context ↕
pgloader does this (and much much more) in a single command:

https://github.com/dimitri/pgloader

  pgloader \
    mysql://user:password@mysql:3306/database \
    postgresql://postgres:root@localhost:5432/postgres
This is a gem of a tool. Surprised nobody has mentioned it. Supports SQLite and MS-SQL too.

https://pgloader.readthedocs.io/en/latest/ref/mysql.html#
Ora2Pg – Oracle to PostgreSQL database schema converter | Sep 2020
Related: please consider getting your company to support pgloader[0] so we can get a piece of free software for migrating from Oracle into Postgres.

[0] https://github.com/dimitri/pgloader

Ask HN: What's the database you use for your simple website? | Nov 2019
Expand Context ↕
The thought is always start with the simplest capability you can use to meet your requirements -- PG is awesome, but it does require care and feeding by a DBA. Here's a tool to migrate from SQLite to PostgreSQL if and when necessary, but if your schema is reasonably clean it shouldn't be a hardship:

https://github.com/dimitri/pgloader

My suggestion is script what you need to test to check throughput for the number of concurrent conns you think you'll be needing and base decisions on that. FYI - I use Fossil SCM over git. It is awesome.

https://www.fossil-scm.org/home/doc/trunk/www/index.wiki
Engineers Shouldn’t Write ETL | Mar 2016
How do people do ETL these days? Using spark? Some framework?

Personally for smaller projects I've used kiba[1] or transforms in pgloader [2]

[1] http://www.kiba-etl.org/ [2] https://github.com/dimitri/pgloader

Pgloader: A High-speed PostgreSQL Swiss Army Knife, Written in Lisp | Jan 2015
Here's a link to the github repo for the project as well - https://github.com/dimitri/pgloader
Pgloader: A High-speed PostgreSQL Swiss Army Knife, Written in Lisp | Jan 2015
Here's another link to the video while the all static website seems to have some sort of an issue: http://medias.ircam.fr/stream/ext/video/files/2014/05/13/ELS...

Also see the github page for the project at https://github.com/dimitri/pgloader

the main docs at https://github.com/dimitri/pgloader/blob/master/pgloader.1.m...

Check out the USAGE section (it's a quickstart really) at https://github.com/dimitri/pgloader/blob/master/pgloader.1.m...