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

E96386118efa8eb1305c473ead065006?s=47 Lena Kirichok
December 07, 2018

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

About uses PostgreSQL functions and types with Symfony Doctrine.

E96386118efa8eb1305c473ead065006?s=128

Lena Kirichok

December 07, 2018
Tweet

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

  16. 16

  17. 17 Thanks! Any questions? Twitter @lena_kirichok