yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.99k stars 1.07k forks source link

Laravel Integration with YugabyteDB #9330

Open ashetkar opened 3 years ago

ashetkar commented 3 years ago

Jira Link: DB-1440 This issue tracks all the work related to Laravel Integration with YugabyteDB.

Tasks

Done Name Notes GitHub Issue
Test Laravel's quickstart example with YugabyteDB
Run Laravel test suite Reached out in Laravel Forum for steps to run Postgres specific tests
Provide YugabyteDB-specific extension/plugin/etc.
Add test cases
Documentation on Yugabyte site
Blog on Yugabyte site
JohnDotOwl commented 2 years ago

@ashetkar is this still active?

ashetkar commented 2 years ago

Yes. @nchandrappa can provide more details.

nchandrappa commented 2 years ago

@rainbowhat Here is the PR for Laravel example with YugabyteDB - https://github.com/yugabyte/orm-examples/pull/71. The GitHub issue is still active, we do want to introduce native support YBDB in laravel when we create YSQL smart driver for PHP.

If you have knowledge of running Laravel test-suite against YB, please feel free to reach out to us. Thanks

tpetry commented 2 years ago

I am maintaining an enhanced PostgreSQL driver for driver which is adding support for PostgreSQL-specific features to Laravel one by one which are not part of the Laravel core and will never be because 80% of the Laravel community is using MySQL.

I could add support for Yugabyte if it's not too far from my goal for PostgreSQL support. Which parts of Yugabyte are currently incompatible with Laravel and which specific features are missing in your opinion?

To be more specific. In which parts is Yugabyte extending the PostgreSQL SQL feature set? I believe just looking at SQL they are identical (with some parts in YugaByte). Am I wrong?

nchandrappa commented 1 year ago

@tpetry YugabyteDB YSQL provides close compatibility with Postgres dialect. As you're building an enhanced driver, YugabyteDB Smart drivers have an additional load-balancing capability across all the YugabyteDB cluster nodes.

This is something that we want to enable in all the language drivers. Let us know if you want to bring this YugabyteDB feature into the driver.