Bedrock VS phpMyAdmin

Also Expensify's Bedrock, which powers their famous "Scaling SQLite to 4M QPS" article:

https://bedrockdb.com/

https://use.expensify.com/blog/scaling-sqlite-to-4m-qps-on-a...

Lots of things don't need failover, but if you do, you can use Bedrock, which is built on sqlite.

At first, I thought Amazon was launching their own SQLite hosted database.

BedrockDB is a SQLite based database with MySQL compatible drivers.

https://bedrockdb.com

Vapor[0] based on Swift. Advantage of this is that you don't have to evaluate multiple frameworks for Swift and suffer paralysis by analysis. All the Swift community is behind one framework.

The next is Actix[1] based on Rust. There are many frameworks in Rust and most of them have not reached 1.0 And which framework will survive becomes a question.

Other not so well-known is Wt[2] based on C++. This actually is created for programmers who are not web developers. The development experience is similar to desktop app development like Qt.

If that is not acceptable then Django[3], based on Python, is the one that will be good for you.

For the front-end I would recommend Flutter[4]. As much as I dislike getting tied to a single company for whom the framework is not their bread-and-butter, I don't see any other viable options to Flutter that will cover all web, mobile and desktop out of the box.

For databases, I would recommend BedrockDB[5], if you are not averse to SQLite. Or FoundationDB[6], if you want NoSQL. But if you are not concerned about horizontal scalability or okay with self-managing database availability, then PostgreSQL[7] is a very good option.

For push notifications, PushPin[8] is a good option.

[0] https://vapor.codes

[1] https://actix.rs

[2] https://webtoolkit.eu

[3] https://www.djangoproject.com

[4] https://flutter.dev

[5] https://bedrockdb.com

[6] https://www.foundationdb.org

[7] https://postgresql.org

[8] https://pushpin.org

Recently I stumbled upon BedrockDB[0] from Expensify. It is based on SQLite and has very interesting idea on HA and distributed DB.

[0] https://bedrockdb.com

This is not SQLite though, also the test is trivial compared to TPC: https://github.com/Expensify/Bedrock/blob/dbarrett_perftest/...

Don’t forget BedrockDB (built on SQLite) that’s used in production at Expensify.

How it scales as well.

https://bedrockdb.com/

https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-q...

Mastering SQL is like engaging in a deep conversation with databases. Sometimes, you might feel like you're "chatting" with data. But don't worry, tools like phpMyAdmin for managing MySQL databases ensure that your data stays put, bidding farewell to the nightmare of "lost data." This phase requires mastering SQL and relational databases like MySQL, using tools like phpMyAdmin for data management and optimization. Tools to consider: phpMyAdmin, MySQL Workbench, Sequel Pro, and other database management tools.

phpMyAdmin is the stalwart of free open-source database managers. It’s been around forever, and it’s just plain good at what it does — providing a graphical interface for fully managing every aspect of MySQL databases. It’s built using PHP and runs in the browser.

now any project on this directory will be auto-linked with subdomain .test, let's download PHPMyAdmin from this link and unzip the file inside the Sites directory and rename the folder to PHPMyAdmin, after that go inside the folder and use this command

phpMyAdmin was born in 1998, written in PHP, and is a classic SQL client. It was the default tool for LAMP and MAMP at that time. phpMyAdmin has grown to become one of the leading tools for managing MySQL and MySQL-like databases (e.g. MariaDB) It has over 200,000 direct downloads per month (and countless other users install it using prepackaged installations or using package managers).

Is a Docker WordPress Environment focused on the development of WordPress plugins and themes, supports WP-CLI, phpMyAdmin, Xdebug and WordPress Coding Standards - WPCS.

You should post this in https://github.com/phpmyadmin/phpmyadmin/issues/ it could be a good thing to add in 6.0

Package: phpmyadmin Version: 4:4.9.5+dfsg1-2 Priority: optional Section: universe/web Origin: Ubuntu Maintainer: Ubuntu Developers [email protected] Original-Maintainer: phpMyAdmin Packaging Team [email protected] Bugs: https://bugs.launchpad.net/ubuntu/+filebug Installed-Size: 27.2 MB Depends: php, php-cli, php-mysql, php-json, php-mbstring, php-xml, debconf (>= 0.5) | debconf-2.0, libjs-sphinxdoc (>= 1.0), sensible-utils, dbconfig-mysql | dbconfig-no-thanks | dbconfig-common (<< 2.0.0), php-phpseclib (>= 2.0), php-common, php-phpmyadmin-sql-parser (>= 4.3.2), php-phpmyadmin-sql-parser (<< 5), php-phpmyadmin-motranslator (>= 5.0), php-phpmyadmin-motranslator (<< 6), php-phpmyadmin-shapefile (>= 2.0), php-phpmyadmin-shapefile (<< 3), php-phpseclib (<< 3), php-google-recaptcha (>= 1.1), php-google-recaptcha (<< 2), php-psr-container (>= 1.0), php-psr-container (<< 2), php-twig (>= 2.9), php-twig (<< 3), php-twig-extensions (>= 1.5.1), php-twig-extensions (<< 1.6), php-symfony-expression-language, libjs-openlayers, ucf (>= 0.28) Recommends: apache2 | lighttpd | httpd, php-curl, php-gd, php-bz2, php-zip, php-tcpdf Suggests: default-mysql-server | virtual-mysql-server, www-browser, php-recode, php-opcache, php-gd2, php-pragmarx-google2fa, php-bacon-qr-code, php-samyoul-u2f-php-server Homepage: https://www.phpmyadmin.net/ Download-Size: 4,426 kB APT-Sources: http://us.archive.ubuntu.com/ubuntu focal/universe amd64 Packages Description: MySQL web administration tool This package allows administering of MySQL or MariaDB with a web interface. . It allows administrators to: - browse through databases and tables; - create, copy, rename, alter and drop databases; - create, copy, rename, alter and drop tables; - perform table maintenance; - add, edit and drop fields; - execute any SQL-statement, even multiple queries; - create, alter and drop indexes; - load text files into tables; - create and read dumps of tables or databases; - export data to SQL, CSV, XML, Word, Excel, PDF and LaTeX formats; - administer multiple servers; - manage MySQL users and privileges; - check server settings and runtime information with configuration hints; - check referential integrity in MyISAM tables; - create complex queries using Query-by-example (QBE), automatically connecting required tables; - create PDF graphics of database layout; - search globally in a database or a subset of it; - transform stored data into any format using a set of predefined functions, such as displaying BLOB-data as image or download-link; - manage InnoDB tables and foreign keys; and is fully internationalized and localized in dozens of languages. ```

I think this is https://github.com/phpmyadmin/phpmyadmin/issues/16851 So you should use the latest 5.2 snapshot: https://www.phpmyadmin.net/downloads/#snapshot_5.2+snapshot

I have been using it for years and while it is a resource hog and it occasionally crashes, I have not found it to be burdensome. You could always set up phpMyAdmin which IMO is sort of antiquated and a true PITA.

Hi! You can use https://docs.phpmyadmin.net/en/latest/config.html#cfg_Order or https://docs.phpmyadmin.net/en/latest/config.html#cfg_TablePrimaryKeyOrder But be aware that the first one needs you to apply https://github.com/phpmyadmin/phpmyadmin/commit/7d4eafd188030307dd8666ed32cf26510466d1bc on your local phpMyAdmin. Or use the latest snapshot from our website on the downloads page: 5.2 snapshot.