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

Slide 1

Slide 1 text

Slide 2

Slide 2 text

That it is not easy. 2

Slide 3

Slide 3 text

IT COULD BE GREAT END But I need to introduce myself first 3

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

Okay, let’s continue 5

Slide 6

Slide 6 text

In my case: migrate from MySQL to PostgreSQL 1

Slide 7

Slide 7 text

With PostgreSQL ● Searching in array ● Removed “join tables” ● JSON support More https://www.techrepublic.com/article/mysql-vs-postgresql/ 7

Slide 8

Slide 8 text

From this To this

Slide 9

Slide 9 text

Choose package for Doctrine to support PostgreSQL features 2

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

In config.yml

Slide 12

Slide 12 text

In annotations 12

Slide 13

Slide 13 text

With DQL 13

Slide 14

Slide 14 text

“ And what if the package does not have the function or type I need? 14

Slide 15

Slide 15 text

Create issue You can also contribute Make a PR 15

Slide 16

Slide 16 text

Slide 17

Slide 17 text

17 Thanks! Any questions? Twitter @lena_kirichok