azuredatastudio
msphpsql
Our great sponsors
azuredatastudio | msphpsql | |
---|---|---|
29 | 12 | |
7,431 | 1,762 | |
0.5% | 0.2% | |
9.8 | 6.7 | |
6 days ago | 3 months ago | |
TypeScript | PHP | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
azuredatastudio
msphpsql
-
Microsoft sqlsrv.so Extension for MS SQL - need ODBC ?
Using the Microsoft github area for this, I grabbed the PHP shared library (.so) files for Debian 10. [Was this the right flavour to grab for Synology?]
-
sqlsrv connection in Sail on ARM64?
I found this older post that links to a Github issue.
-
SQL Server Connection Issue after Server IP Address Change, Port Works but Instance Name doesn't
I did find this github issue where someone was unable to connect to SERVER\INSTANCE, closed as expected behavior. A response also said requests from Linux must be made over TCP and not UDP. The linked Microsoft documentation says as much, but is slightly confusing:
-
Setting up Laravel with SQL Server AND Laragon on Windows
Step 1. Download the PHP driver here
- Does anybody have a working Dockerfile for Laravel Sail w/ PHP8.1 and SQLSRV/ODBC drivers?
-
Issue Connecting to Azure SQL with PHP
Maybe follow the example code and put the password into a variable? https://github.com/microsoft/msphpsql/blob/master/sample/pdo_sqlsrv_sample.php
-
How to fetch columns individually from a collection of rows
Just out of curiosity, what was it then? Because if I look at the (pdo)sqlsrv source, LOB's should be possible.
- What extensions are missing from PHP?
-
PDO throws an exception on Apple M1 when connecting to SQL Server Database Container (Unknown processor architecture.)
I think this might be the related open issue: https://github.com/microsoft/msphpsql/issues/1223
-
Do you use PHP? and why?
There is no problem with using MSSQL with PHP it's easily doable and supported. See the Microsoft open source extension: https://github.com/microsoft/msphpsql
What are some alternatives?
vscode-python - Python extension for Visual Studio Code
wasmer-php - ππΈοΈ WebAssembly runtime for PHP
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
docker-php-mssql - Docker images based on the official Docker PHP images with the Microsoft SQL Server Driver already installed
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
scalar_objects - Extension that adds support for method calls on primitive types in PHP
vscode-sqltools - Database management for VSCode
Entware - Ultimate repo for embedded devices
rushstack - Monorepo for tools developed by the Rush Stack community
php-quickstart - This repository contains a simple web application that demonstrates how to quickly connect to and communicate with a MariaDB database using PHP (via mysqli).
repo-templates - Default templates for Microsoft repos across all GitHub organizations: helping providing for collaborative communities, SECURITY.MD, Code of Conduct, and other files...
Phalcon - High performance, full-stack PHP framework delivered as a C extension.