PHP SQL

Open-source PHP projects categorized as SQL

Top 22 PHP SQL Projects

  • countries-states-cities-database

    🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities

    Project mention: countries-states-cities-database VS country-state-city - a user suggested alternative | libhunt.com/r/countries-states-cities-database | 2022-08-29
  • Leantime

    Leantime is a lean project management system for non-project managers. Designed to help you manage your projects from ideation to delivery.

    Project mention: Open source multi tenant project management solutions | /r/selfhosted | 2023-05-28

    I don't know if these are multi-tenant projects but you could certainly explore them: leantime.io and openproject.org.

  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • mysqldump-php

    PHP version of mysqldump cli that comes with MySQL

  • upscheme

    Database migrations and schema updates made easy

  • fluentpdo

    A PHP SQL query builder using PDO

  • lessql

    LessQL: A lightweight and performant PHP ORM alternative

    Project mention: Analytics / Reporting capabilities | /r/grocy | 2023-02-01
  • sql-parser

    A validating SQL lexer and parser with a focus on MySQL dialect. (by phpmyadmin)

    Project mention: Can SQL be used without an RDBMS? | /r/PHP | 2023-02-27

    You can tokenize the query using [sql-parser](https://github.com/phpmyadmin/sql-parser) and then write functions to load, filter, sort, and group data, if you really wanted to.

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  • Vulnerable-Web-Application

    OWASP Vulnerable Web Application Project https://github.com/hummingbirdscyber

  • KLiK-SocialMediaWebsite

    Complete PHP-based Login/Registration system, Profile system, Chat room, Forum system and Blog/Polls/Event Management System.

  • ATK Data

    Data Access PHP Framework for SQL & high-latency databases (by atk4)

  • laravel-showsql

    A Laravel package to output a specific sql to your favourite debugging tool. The supported log output is Laravel Telescope, Laravel Log, Ray, Clockwork, Laravel Debugbar and your browser.

  • singlestoredb-laravel-driver

    The official SingleStore Laravel driver.

    Project mention: Official SingleStoreDB driver for Laravel is now 1.0.0 | /r/laravel | 2022-06-30
  • laravel-purity

    An elegant way to filter and sort queries in Laravel

    Project mention: Elegant way to filter and sort queries in Laravel | news.ycombinator.com | 2023-03-04
  • db

    Yii Database Library (by yiisoft)

    Project mention: 🔥 Yii Database abstraction release | /r/PHP | 2023-04-12
  • client

    PHP client for Tarantool. (by tarantool-php)

  • Gangster-Legends-V2

    A free to use text-based PBBG / MMORPG script

  • Simple MySQLi Class

    :gem: Simple MySQLi Abstraction Layer + Doctrine/DBAL support

  • arca-orm

    Low code , Zero Configuration ORM that creates models, config, database and tables on the fly.

  • Luminosity

    Luminosity – a modern style blogging platform (by cmd05)

  • Random_Scripts

    My Own Creations & Stack Overflow Answers To Questions (by JayRizzo)

    Project mention: Sunday Daily Thread: What's everyone working on this week? | /r/Python | 2022-07-02
  • Fregata

    Fregata - a PHP database migrator

  • sql-order-analyse-tools

    A tool used to check the order of columns in SQL table structure.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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). The latest post mention was on 2023-05-28.

PHP SQL related posts

Index

What are some of the best open-source SQL projects in PHP? This list will help you:

Project Stars
1 countries-states-cities-database 4,955
2 Leantime 2,247
3 mysqldump-php 1,172
4 upscheme 960
5 fluentpdo 908
6 lessql 404
7 sql-parser 391
8 Vulnerable-Web-Application 265
9 KLiK-SocialMediaWebsite 264
10 ATK Data 259
11 laravel-showsql 208
12 singlestoredb-laravel-driver 205
13 laravel-purity 113
14 db 97
15 client 61
16 Gangster-Legends-V2 56
17 Simple MySQLi Class 40
18 arca-orm 28
19 Luminosity 24
20 Random_Scripts 19
21 Fregata 18
22 sql-order-analyse-tools 0
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com