pgloader
PostgresApp
Our great sponsors
pgloader | PostgresApp | |
---|---|---|
31 | 58 | |
4,996 | 7,081 | |
- | 1.2% | |
3.3 | 9.2 | |
6 days ago | 15 days ago | |
Common Lisp | Makefile | |
GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
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.
pgloader
-
Why Is Common Lisp Not the Most Popular Programming Language?
No, it's difficult to read, and understand. It's a parenthesis circus, example -
https://github.com/dimitri/pgloader/blob/master/src/sources/...
-
We need to talk about parentheses
Examples (for Common Lisp, so not citing Emacs): reddit v1, Google's ITA Software that powers airfare search engines (Kayak, Orbitz…), Postgres' pgloader (http://pgloader.io/), which was re-written from Python to Common Lisp, Opus Modus for music composition, the Maxima CAS, PTC 3D designer CAD software (used by big brands worldwide), Grammarly, Mirai, the 3D editor that designed Gollum's face, the ScoreCloud app that lets you whistle or play an instrument and get the music score,
but also the ACL2 theorem prover, used in the industry since the 90s, NASA's PVS provers and SPIKE scheduler used for Hubble and JWT, many companies in Quantum Computing, companies like SISCOG, who plans the transportation systems of european metropolis' underground since the 80s, Ravenpack who's into big-data analysis for financial services (they might be hiring), Keepit (https://www.keepit.com/), Pocket Change (Japan, https://www.pocket-change.jp/en/), the new Feetr in trading (https://feetr.io/, you can search HN), Airbus, Alstom, Planisware (https://planisware.com),
or also the open-source screenshotbot (https://screenshotbot.io), the Kandria game (https://kandria.com/),
and the companies in https://github.com/azzamsa/awesome-lisp-companies and on LispWorks and Allegro's Success Stories.
https://github.com/tamurashingo/reddit1.0/
https://www.ptc.com/en/products/cad/3d-design
https://apps.apple.com/us/app/scorecloud-express/id566535238
-
Time For Me To Fly… To Render
Initially, I started down the pgloader path, which seemed to be a common approach for the database conversion. However, using my M1-chip MacBook Pro led to some unexpected issues. Instead, I opted to use NMIG to convert MySQL to PostgreSQL. For more information, please check out the “Highlights From the Database Conversion” section below.
-
What language should i learn?
But do what makes you happy. The best PostgreSQL data loader in the world is written in Common Lisp. Now, CL is a fast and ANSI standardized language with multiple implementations, and was used to create Reddit, but it's hard to call it fashionable.
-
Why Lisp?
- [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]
-
What ETL tool you use with Postgres ?
I would warmly recommend https://pgloader.io but, unfortunately, the Oracle support is still in need of a sponsor :-)
- PostgreSQL alternative for Large amounts of data
-
Lenpaste - open source analogue of pastebin.com
By the way, if anything SQLite can be easily migrated to PostgreSQl using pgloader.
-
Could I slim this CSV to SQL code down at all?
If you work with postgres, use pgloader.
PostgresApp
-
Test Driving a Rails API - Part One
A running Rails application needs a database to connect to. You may already have your database of choice installed, but if not, I recommend PostgreSQL, or Postgres for short. On a Mac, probably the easiest way to install it is with Posrgres.app. Another option, the one I prefer, is to use Homebrew. With Homebrew installed, this command will install PostgreSQL version 16 along with libpq:
-
Full Stack Chat App with Socket.io
I was using Postgres.app, but of course, you can download it in any way as long as it works.
-
Building Secure Neon-Infused Web Apps with Auth0, Express, and EJS
There are two ways to connect with the Postgres database which can be in the terminal or using a Postgres GUI client app like DBeaver. But first, download the PostgreSQL installer for macOS or Windows, depending on your OS. The setup and installation come with the psql command, a tool shipped with Postgres that allows you to communicate with Postgres through the command line.
- How do I get sql exactly?
-
SQLite-based databases on the Postgres protocol? Yes we can
And if you're on a Mac, Postgres.app makes it even easier: https://postgresapp.com/
- Postgres Devs: What platform are you using to build postgres?
-
Creating a Telegram Desktop App with PostgreSQL and Next.js 🪄
A great app for managing PostgreSQL databases is Postgres.app.
-
Learn Postgres at the Playground
I love that you did audacious thing.
FYI, if you're MacOS, someone has packaged Postgres into a standard "just works" self contained MacOS app. With a GUI & system tray menu to contro it. It so good that I use it instead of a Docker image for PG. All the psql and pg_restore commands are contained in the .app package and can be called from the terminal.
- Drop your favorite Mac apps!
-
The Complete Modern React Developer 2022
Postgres.app Pgcli Valentina Studio
What are some alternatives?
DBngin - DB Engine
wsl-vpnkit - Provides network connectivity to WSL 2 when blocked by VPN
lisp-xl - Common Lisp Microsoft XLSX (Microsoft Excel) loader for arbitrarily-sized / big-size files
docker-openldap - OpenLDAP container image 🐳🌴
xclip - Command line interface to the X11 clipboard
docker-postgres-upgrade - a PoC for using "pg_upgrade" inside Docker -- learn from it, adapt it for your needs; don't expect it to work as-is!
HomeBrew - 🍺 The missing package manager for macOS (or Linux)
cl-wget - The Non-Interactive Network Downloader: cl-wget is a free software for retrieving files using HTTPS; cl-wget makes mirroring websites easy.
prisma-examples - 🚀 Ready-to-run Prisma example projects
arkade - Open Source Marketplace For Developer Tools
better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.
asdf - Extendable version manager with support for Ruby, Node.js, Elixir, Erlang & more