What I’ve learnt after starting to work with Symfony and Postgresql?

About uses PostgreSQL functions and types with Symfony Doctrine.

Transcript

1. What I’ve learnt after starting to work with Symfony and Postgresql?
2. That it is not easy. 2
3. IT COULD BE GREAT END But I need to introduce myself first 3
4. Hello! I am Lena Kirichok Winner at "Youngest IT team player" nomination in every company and PHP developer in free time. Twitter @lena_kirichok Instagram @lakie.dev Telegram @girlintech 4
5. Okay, let’s continue 5
6. In my case: migrate from MySQL to PostgreSQL 1
7. With PostgreSQL • Searching in array • Removed “join tables” • JSON support More https://www.techrepublic.com/article/mysql-vs-postgresql/ 7
8. From this To this
9. Choose package for Doctrine to support PostgreSQL features 2
10. Choose from a BIG amount of suited packages martin-georgiev/postgresql -for-doctrine - Last commit Sep 2018 - Support 6 types - Support many functions opensoft/doctrine-postgr es-types - Last commit Dec 2016 - Support only postgresql types opsway/doctrine-dbal-pos tgresql - Last commit Oct 2018 - Support 3 types - Support many functions 10
11. In config.yml
12. In annotations 12
13. With DQL 13
14. “ And what if the package does not have the function or type I need? 14
15. Create issue You can also contribute Make a PR 15
17. 17 Thanks! Any questions? Twitter @lena_kirichok