The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 PHP MySQL Projects
-
Matomo
Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
-
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
-
-
countries-states-cities-database
🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
-
DOLIBARR ERP & CRM
Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
Bolt
Bolt is a simple CMS written in PHP. It is based on Silex and Symfony components, uses Twig and either SQLite, MySQL or PostgreSQL. (by bolt)
-
takeout
Docker-based development-only dependency manager. macOS, Linux, and WSL2-only and installs via PHP's Composer... for now.
-
-
laravel-cross-eloquent-search
Laravel package to search through multiple Eloquent models. Supports sorting, pagination, scoped queries, eager load relationships and searching through single or multiple columns.
-
postfixadmin
PostfixAdmin - web based virtual user administration interface for Postfix mail servers
-
-
eLabFTW
:notebook: eLabFTW is the most popular open source electronic lab notebook for research labs.
-
-
Thelia
Thelia is an open source tool for creating e-business websites and managing online content. Repo containing the new major version (v2)
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
With a serverful approach, you can avoid these drawbacks, and the main challenge lies in selecting the platform that aligns with your requirements. Options may include AWS, Render, DigitalOcean, and others. While VPS is also an option, it's generally not recommended due to the significant setup and maintenance overhead involved (logging, monitoring, CI/CD pipelines, etc.). However, you can make your life easier by leveraging tools like Coolify that help managing your VPS.
In that case, write your own platform and db driver that translates it, doctrine already has tons of work done which can be easily extended : https://github.com/doctrine/dbal/tree/3.6.x/src/Platforms - or simply use PDO directly as it can do raw queries and forget ORMs in general for such usecase.
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.
Project mention: Show HN: DB to map cities to countries and states | news.ycombinator.com | 2024-03-12
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).
If your idea is to make something as lean and "from scratch" as possible, I'd use a simple Query Builder instead of an ORM. Something like medoo or Aura.Sql.
Upvote, because I like the idea of https://github.com/cytopia/devilbox. But, it contains a bit too much for me. Worth a look, though, fellow redditors
Project mention: Need something to host a URL that listens for a POST and then talks back to on-prem SQL. | /r/sysadmin | 2023-05-10For quick dev/arch projects at home, I usually use this: https://github.com/mevdschee/php-crud-api
I found this one, but I don't know what it's worth it? easyappointments.org ( feel free to remove if it breaks the community guidelines )
Excellent! Glad we could get you sorted! Hosting can be scary and it's okay to be afraid to touch things or not understand certain settings or terms. Especially if you're new. The key is to read the documentation. For your forum needs, this can be found at https://mybb.com and https://phpbb.com
+1 for https://www.elabftw.net
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
PHP MySQL related posts
- Shopware dev productivity and plugin validation
- Chyrp Lite – An Ultra-Lightweight Tumblelogging Engine Using PHP and SQLite
- Adminer: Database management in a single PHP file
- Chyrp Lite: An ultra-lightweight blogging engine
- Coolify – Self-Hostable PaaS
- Open-source and self-hostable Heroku/Netlify alternative
- Best Xampp alternative
-
A note from our sponsor - WorkOS
workos.com | 24 Apr 2024
Index
What are some of the best open-source MySQL projects in PHP? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Matomo | 18,999 |
| 2 | coolify | 13,311 |
| 3 | dbal | 9,353 |
| 4 | phpMyAdmin | 7,019 |
| 5 | countries-states-cities-database | 6,451 |
| 6 | Adminer | 6,028 |
| 7 | DOLIBARR ERP & CRM | 4,889 |
| 8 | Medoo | 4,778 |
| 9 | devilbox | 4,319 |
| 10 | Bolt | 4,154 |
| 11 | PHP-CRUD-API | 3,522 |
| 12 | Easy!Appointments | 3,082 |
| 13 | takeout | 1,570 |
| 14 | upscheme | 1,292 |
| 15 | mysqldump-php | 1,223 |
| 16 | MyBB | 1,029 |
| 17 | laravel-cross-eloquent-search | 1,027 |
| 18 | postfixadmin | 979 |
| 19 | fluentpdo | 913 |
| 20 | eLabFTW | 897 |
| 21 | pomf | 878 |
| 22 | Thelia | 831 |
| 23 | onelinerhub | 788 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com