chinook-database VS pgadmin4

In literally 30 seconds, you can open the blog post, upload a SQLite file, and then query it in the Splitgraph web console (or via HTTP, or via any Postgres client). Authentication is not required.

Here's the 30 second video [0] and end result [1]. If you don't have a SQLite file handy and want to try it yourself, here's a link to the Chinook Database [2].

[0] Video (30 seconds): https://twitter.com/splitgraph/status/1646612048837591040

[1] Repository: https://www.splitgraph.com/miles/chinook-tables/latest/-/tab...

[2] chinook.sqlite: https://github.com/lerocha/chinook-database/blob/e7e6d5f008e...

I’ll be using a Postgres datasource (the famous Chinook database) for my example, using WunderGraph to make it accessible through JSON-RPC to my Next.js frontend.

If you look at a typical SQL query in analytics, it looks something like this (taken from Chinook sample database):

schemacrawler/chinook-database builds on the earlier project. The project has an automatic build using GitHub Actions, which pulls scripts from lerocha/chinook-database, cleans them up, and converts them all to UTF-8 with consistent line-endings. Then are are repacked and redistributed in various ways - as a Java jar file for use in Java programs or in tests with database in Testcontainers. The SQLite database can be directly download from the project site. But probably the best way to use the package it is use the Docker image from schemacrawler/chinook-database to create the Chinook database on a database of your choice, whether the database server is running on a separate host or within a Docker container itself.

https://github.com/lerocha/chinook-database#:~:text=Chinook%20is%20a%20sample%20database,single%20and%20multiple%20database%20servers.

If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

You can install pgAdmin on Windows and connect the GUI Admin/developer tool directly to your PostgreSQL server running in WSL.

With this tool, deciphering the details of PostgreSQL query plans becomes a little more approachable. Just be mindful that using it involves sharing your query and its plan publicly. If privacy is a concern regarding sharing your query and its plan publicly, consider using pgAdmin, an open-source administrative tool for PostgreSQL that you can install on your local machine, which also offers a visualization feature for query plans.

This isn’t meant to be an exhaustive list. There are many other database management software packages out there, including MySQL Workbench, DBeaver, and pgAdmin. We’ve chosen these database tools because they cover the most common database systems and use cases, but if you find they aren’t meeting your needs, be sure to explore further or consider building your own database user interface — it’s easier than you think.

pgAdmin to PostgreSQL is what phpMyAdmin is to MySQL, and it can be used on Linux, Unix, macOS and Windows to manage PostgreSQL. pgAdmin 4, the latest pgAdmin, is a complete rewrite of pgAdmin using Python and Javascript/jQuery.

I've attached my full crash report. Please, HALP! I don't want to keep using DBeaver! crashreport-jont.pdf