Saleor VS Adminer

At Saleor, where I act as a CTO, we spend a significant part of our engineering effort embracing the different failure states and making sure the unhappy paths are covered as well as the happy ones.

git clone https://github.com/saleor/saleor.git

You can also check our https://github.com/saleor/saleor repository for real-life examples. We performed such operations on Order, OrderLine, and CheckoutLine models.

Recently at Saleor we encountered the challenge of implementing multi-tenancy in Saleor apps. In this blog post, I'll share my experience with access modelling when using DynamoDB for multi-tenant services.

Saleor Core: the high performance, composable, headless commerce API

https://github.com/saleor/saleor

Our community is most active on GitHub - for more questions, you can open discussions: https://github.com/saleor/saleor/discussions

Hi, could you please open a GitHub discussion or issue? Someone from our core team will need to take a look at it. https://github.com/saleor/saleor/discussions

Read more in the changelog: https://github.com/saleor/saleor/releases/tag/3.12.0

Certain complex tasks (analyzing indexes, optimizing queries, performing large-scale exports/imports) are much simpler with a graphical tool than with a command line or REST API. The same is true for analyzing the structure of a complex database with many tables. The user-friendliness of the graphical interface of tools like DBeaver or Adminer is a definite advantage.

To be fair it's the actual releases that are in a single file.

Development evidently happens in the traditional sense with the project in a nicely defined tree.

The build process looks pretty gnarly, but it works! https://github.com/vrana/adminer/blob/master/compile.php

Upload Adminer to your hosting (download it from Adminer’s website).

> browser based

For whatever reason, this is the main limiting factor, because local software can be really good, for example:

DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/

DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/

DbVisualizer - really cool tool that helps you explore messy schemas https://www.dbvis.com/

HeidiSQL - haven't really used this myself but the version graph on the page is cool https://www.heidisql.com/

There's also some solutions that are specific to certain databases, like:

pgAdmin - for PostgreSQL https://www.pgadmin.org/

MySQL Workbench - for MySQL/MariaDB, sometimes a bit buggy but I really like the reverse engineering and forward engineering functionality https://www.mysql.com/products/workbench/

(out of respect for my own sanity, not mentioning SQL Developer, even though it sort of works)

Adminer - one of the somewhat rare web based solutions for the likes of MySQL/MariaDB, actually pleasant to use as long as you use it securely, this I think is a good example of web based DB tools https://www.adminer.org/

Use adminer (or the SQL CLI) to verify tables and database entries. In a dockware default development setup: http://localhost//adminer.php (Server: 127.0.0.1, not localhost; database: shopware; initial login: root:root).

Heh, what a name for a DB explorer ("Adminer - Database management in a single PHP file"; Apache 2 or GPLv2 https://github.com/vrana/adminer/blob/v4.8.1/readme.txt#L7 )

Web Station test using PHP and Adminer via the 'ancient' unsupported pdo_dblib confirmed SQL Server is working, however I need to write code using the sqlsrv extension.