@@ -1547,6 +1547,7 @@ I am testing mainly on Ubuntu and I have the following test setups:
1547
1547
- (Docker) Ubuntu 18.04 with PHP 7.2, MySQL 5.7, PostgreSQL 10.4 (PostGIS 2.4) and SQLite 3.22
1548
1548
- (Docker) Ubuntu 20.04 with PHP 7.4, MySQL 8.0, PostgreSQL 12.15 (PostGIS 3.0) and SQLite 3.31 and SQL Server 2019
1549
1549
- (Docker) Ubuntu 22.04 with PHP 8.1, MySQL 8.0, PostgreSQL 14.2 (PostGIS 3.2) and SQLite 3.37
1550
+ - (Docker) Ubuntu 24.04 with PHP 8.3, MySQL 8.0, PostgreSQL 16.2 (PostGIS 3.4) and SQLite 3.45
1550
1551
1551
1552
This covers not all environments (yet), so please notify me of failing tests and report your environment.
1552
1553
I will try to cover most relevant setups in the "docker" folder of the project.
@@ -1609,10 +1610,10 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1609
1610
[3/4] Starting SQLServer 2017 ... skipped
1610
1611
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1611
1612
------------------------------------------------
1612
- mysql: 120 tests ran in3279 ms, 1 skipped, 0 failed
1613
- pgsql: 120 tests ran in1802 ms, 1 skipped, 0 failed
1613
+ mysql: 120 tests ran in921 ms, 1 skipped, 0 failed
1614
+ pgsql: 120 tests ran in1058 ms, 1 skipped, 0 failed
1614
1615
sqlsrv: skipped, driver not loaded
1615
- sqlite: 120 tests ran in1720 ms, 13 skipped, 0 failed
1616
+ sqlite: 120 tests ran in752 ms, 13 skipped, 0 failed
1616
1617
================================================
1617
1618
Debian 11 (PHP 7.4)
1618
1619
================================================
@@ -1621,10 +1622,10 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1621
1622
[3/4] Starting SQLServer 2017 ... skipped
1622
1623
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1623
1624
------------------------------------------------
1624
- mysql: 120 tests ran in2761 ms, 1 skipped, 0 failed
1625
- pgsql: 120 tests ran in2263 ms, 1 skipped, 0 failed
1625
+ mysql: 120 tests ran in914 ms, 1 skipped, 0 failed
1626
+ pgsql: 120 tests ran in997 ms, 1 skipped, 0 failed
1626
1627
sqlsrv: skipped, driver not loaded
1627
- sqlite: 120 tests ran in1860 ms, 13 skipped, 0 failed
1628
+ sqlite: 120 tests ran in735 ms, 13 skipped, 0 failed
1628
1629
================================================
1629
1630
Debian 12 (PHP 8.2)
1630
1631
================================================
@@ -1633,10 +1634,10 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1633
1634
[3/4] Starting SQLServer 2019 ... skipped
1634
1635
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1635
1636
------------------------------------------------
1636
- mysql: 120 tests ran in3106 ms, 1 skipped, 0 failed
1637
- pgsql: 120 tests ran in1863 ms, 1 skipped, 0 failed
1637
+ mysql: 120 tests ran in1016 ms, 1 skipped, 0 failed
1638
+ pgsql: 120 tests ran in1041 ms, 1 skipped, 0 failed
1638
1639
sqlsrv: skipped, driver not loaded
1639
- sqlite: 120 tests ran in1649 ms, 13 skipped, 0 failed
1640
+ sqlite: 120 tests ran in733 ms, 13 skipped, 0 failed
1640
1641
================================================
1641
1642
RockyLinux 8 (PHP 7.2)
1642
1643
================================================
@@ -1645,10 +1646,10 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1645
1646
[3/4] Starting SQLServer 2017 ... skipped
1646
1647
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1647
1648
------------------------------------------------
1648
- mysql: 120 tests ran in3248 ms, 1 skipped, 0 failed
1649
+ mysql: 120 tests ran in935 ms, 1 skipped, 0 failed
1649
1650
pgsql: skipped, driver not loaded
1650
1651
sqlsrv: skipped, driver not loaded
1651
- sqlite: 120 tests ran in1745 ms, 13 skipped, 0 failed
1652
+ sqlite: 120 tests ran in746 ms, 13 skipped, 0 failed
1652
1653
================================================
1653
1654
RockyLinux 9 (PHP 8.0)
1654
1655
================================================
@@ -1657,10 +1658,10 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1657
1658
[3/4] Starting SQLServer 2017 ... skipped
1658
1659
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1659
1660
------------------------------------------------
1660
- mysql: 120 tests ran in2945 ms, 1 skipped, 0 failed
1661
+ mysql: 120 tests ran in928 ms, 1 skipped, 0 failed
1661
1662
pgsql: skipped, driver not loaded
1662
1663
sqlsrv: skipped, driver not loaded
1663
- sqlite: 120 tests ran in1657 ms, 13 skipped, 0 failed
1664
+ sqlite: 120 tests ran in728 ms, 13 skipped, 0 failed
1664
1665
================================================
1665
1666
Ubuntu 18.04 (PHP 7.2)
1666
1667
================================================
@@ -1669,10 +1670,10 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1669
1670
[3/4] Starting SQLServer 2017 ... skipped
1670
1671
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1671
1672
------------------------------------------------
1672
- mysql: 120 tests ran in4151 ms, 1 skipped, 0 failed
1673
- pgsql: 120 tests ran in1798 ms, 1 skipped, 0 failed
1673
+ mysql: 120 tests ran in1296 ms, 1 skipped, 0 failed
1674
+ pgsql: 120 tests ran in1056 ms, 1 skipped, 0 failed
1674
1675
sqlsrv: skipped, driver not loaded
1675
- sqlite: 120 tests ran in1906 ms, 13 skipped, 0 failed
1676
+ sqlite: 120 tests ran in772 ms, 13 skipped, 0 failed
1676
1677
================================================
1677
1678
Ubuntu 20.04 (PHP 7.4)
1678
1679
================================================
@@ -1681,10 +1682,10 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1681
1682
[3/4] Starting SQLServer 2019 ... done
1682
1683
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1683
1684
------------------------------------------------
1684
- mysql: 120 tests ran in6480 ms, 1 skipped, 0 failed
1685
- pgsql: 120 tests ran in2415 ms, 1 skipped, 0 failed
1686
- sqlsrv: 120 tests ran in14517 ms, 1 skipped, 0 failed
1687
- sqlite: 120 tests ran in1694 ms, 13 skipped, 0 failed
1685
+ mysql: 120 tests ran in1375 ms, 1 skipped, 0 failed
1686
+ pgsql: 120 tests ran in868 ms, 1 skipped, 0 failed
1687
+ sqlsrv: 120 tests ran in5713 ms, 1 skipped, 0 failed
1688
+ sqlite: 120 tests ran in733 ms, 13 skipped, 0 failed
1688
1689
================================================
1689
1690
Ubuntu 22.04 (PHP 8.1)
1690
1691
================================================
@@ -1693,10 +1694,22 @@ To run the docker tests run "build_all.sh" and "run_all.sh" from the docker dire
1693
1694
[3/4] Starting SQLServer 2019 ... skipped
1694
1695
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1695
1696
------------------------------------------------
1696
- mysql: 120 tests ran in5951 ms, 1 skipped, 0 failed
1697
- pgsql: 120 tests ran in1951 ms, 1 skipped, 0 failed
1697
+ mysql: 120 tests ran in1372 ms, 1 skipped, 0 failed
1698
+ pgsql: 120 tests ran in1064 ms, 1 skipped, 0 failed
1698
1699
sqlsrv: skipped, driver not loaded
1699
- sqlite: 120 tests ran in 1923 ms, 13 skipped, 0 failed
1700
+ sqlite: 120 tests ran in 727 ms, 13 skipped, 0 failed
1701
+ ================================================
1702
+ Ubuntu 24.04 (PHP 8.3)
1703
+ ================================================
1704
+ [1/4] Starting MySQL 8. ........ done
1705
+ [2/4] Starting PostgreSQL 16.2 .. done
1706
+ [3/4] Starting SQLServer 2019 ... skipped
1707
+ [4/4] Cloning PHP-CRUD-API v2 ... skipped
1708
+ ------------------------------------------------
1709
+ mysql: 120 tests ran in 1344 ms, 1 skipped, 0 failed
1710
+ pgsql: 120 tests ran in 856 ms, 1 skipped, 0 failed
1711
+ sqlsrv: skipped, driver not loaded
1712
+ sqlite: 120 tests ran in 722 ms, 13 skipped, 0 failed
1700
1713
1701
1714
The above test run (including starting up the databases) takes less than 5 minutes on my slow laptop.
1702
1715
@@ -1718,10 +1731,10 @@ The above test run (including starting up the databases) takes less than 5 minut
1718
1731
[3/4] Starting SQLServer 2017 ... skipped
1719
1732
[4/4] Cloning PHP-CRUD-API v2 ... skipped
1720
1733
------------------------------------------------
1721
- mysql: 120 tests ran in4151 ms, 1 skipped, 0 failed
1722
- pgsql: 120 tests ran in1798 ms, 1 skipped, 0 failed
1734
+ mysql: 120 tests ran in1296 ms, 1 skipped, 0 failed
1735
+ pgsql: 120 tests ran in1056 ms, 1 skipped, 0 failed
1723
1736
sqlsrv: skipped, driver not loaded
1724
- sqlite: 120 tests ran in1906 ms, 13 skipped, 0 failed
1737
+ sqlite: 120 tests ran in772 ms, 13 skipped, 0 failed
1725
1738
root@b7ab9472e08f:/php-crud-api#
1726
1739
1727
1740
As you can see the "run.sh" script gives you access to a prompt in the chosen docker environment.