1、 Please introduce yourself 、 Personal hobbies and where they come from ？

I am a Lætitia, From France , My hometown is close to Lyon（ Place names ）. It doesn't matter if you can't say my name , Because it's hard to read . If it's easier , You can use it. “joy”. I like French boxing 、 Running and learning . I like listening to rock music and classical music , As long as the music sounds “ Positively ”.

Lætitia Avrot

• Website

• LinkedIn

• Twitter

  3、 When did you start using PostgreSQL, Why use it ？

  
  

I am a 2007 Put into use Postgres, At that time, I was working for IGN（ French National Institute of geography and forest information ） Make a large geographic database . I need to develop an algorithm to make Postgres Can search the name of the city , This sounds like providing a name . But this is very tricky in French , French likes to add silent letters to city names （ This is also true in other words ！）.

We started using PostgreSQL 8.1, There was no stream replication , But we can keep a hot backup through log shipping . We have a BI database , Open reading during the day . Of course , Because there was no hot standby machine at that time , So every night we need to rebuild . We also Heartbeat A project is installed on the cluster , This is very effective for high availability , Even if it is not very good in dealing with data loss ,（ We divide in the brain （split brain） Had a very interesting time ）

5、 Have you studied in University ？ If there is , Is the content related to computers ？ Does your study help you in your current job ？

I study in an engineer school in France ,INSA Lyon（ Place names ）, I think this institute is called a university in another country . I choose to specialize in IT And never regretted choosing it . The most useful skill I learned in college is that I can adapt and learn under any circumstances , But I also learned basic mathematics （ Galois theory and group theory , Relational algebra ） And the database （ Data modeling to the fifth paradigm , basic SQL, basic Oracle Instance management  ）, I also learned several languages with different paradigms , programing language 、 Functional language 、 Functional language 、 Object oriented comes from 、 Process language, etc , I even learned real-time programming . With this diversity , I find that learning a new programming language is no different from learning a foreign language , Besides grammar, it is simpler 、 Limited vocabulary , But if you make a mistake , Machines don't try to guess what you mean .

6、 Have you ever used any other databases ？ Which database do you like best ？

I learned how to become a Postgres DBA, But I soon learned again Oracle、SQL Sever、 Even some DB2（AS400, z/OS and UDB）.2018 year 1 In September, I decided to focus my career entirely on Postgres, Because it's so pleasant to work with it ！

I am for Postgres Wrote several patches , And ask students to test PostgreSQL Tools , such as pg BackRest, Let them use it by reading the document . They are misunderstanding documents and looking for BUG Very creative .

I am for PostgreSQL The project has written some document patches . I also wrote a code patch , With permission PostgreSQL Native support hyperbolic functions . I am working on two other patches . I'm not a developer , It's really difficult to release my code .

9、 Yes PostgreSQL Are there any contributions that don't involve writing code ?

I am a Postgres A member of the women's initiative . Our main goal is to get more women into the database or Postgres The world of . I am a Postgres Funds and Postgres Members of the initiative . I was chosen Postgres A member of the European Board . I am a Postgres Lyon User group Meetup Co organizer of . I worked for a year Postgres Members of the code of conduct committee . I am a Postgres stay 2018 Google Code-In Contest Tutor , And I'm also Google season Docs Tutor , Still Postgres.

As a consultant who only does short-term tasks , It is not allowed to modify anything on the system I am reviewing , I can't say I have one “ Favorite extensions ”. Of course , I suggest my clients use pg_stat_statements To monitor their performance , When they have inflation problems , I suggest using pg_repack or pg_squeeze, But I think we really need to see what the application wants to achieve , To find the best way to achieve it , Whether or not extensions are used . I like “ Interesting extensions ”, such as pg_carbonara, Give Way Postgres Give you the real carbonara formula , perhaps pg_crash, It will kill the process , until Postgres collapse , To test your high availability architecture .

The most annoying thing I can think of is the need to upgrade data when performing major upgrades . There is no such extra step , I think it will be easier for me to convince my customers that they need to upgrade their clusters . Of course , If it can be easily changed , Then it has already been made .

12、 You like PostgreSQL What are the features of the latest version ?

I am right. Postgres Impressive performance improvements for each major release . You may think that we will reach a point where improvement will become impossible , But it is developing 25 Years later , new ( And the old ) The brain still finds new ways to make it better !

13、 Can you describe your PostgreSQL Development toolbox ?

I like command line tools . therefore , I use vim( And a great .vimrc), And only use gcc Compile . I use tmux To share my terminal screen . When I use SQL When inquiring , I divide the screen into two parts . I use vim Open one SQL file , On the other pane is psql, So I can describe the table and test simple queries . But no one does one thing at a time , isn't it? ? This is why most of the time my screen is divided into 4 The reason for the block .

I think to become Postgres The developer of the / Users have no mandatory skills . You can learn anything you need when you need it . What you need is some personal abilities , For example, the willingness to learn 、 Patience and determination .

‍15、 Have you used any git Best practices , To use PostgreSQL More easily ?

I'm not very good at using all git, Fortunately, I didn't submit PostgreSQL Project permissions , So I can't create disaster there !

16、 What have you visited PostgreSQL meeting ? Do you submit a speech ?

I have been to many meetings , I also submitted a lot of speeches . For me, giving a speech at a meeting is the best way to learn new things . Once you are selected , You can't escape . You need to learn everything , Can let you make a good speech at the Conference .

17、 Do you think PostgreSQL Is the entry threshold high ?

Postgres More suitable for command line . For many people , This means changing their habits , It's very difficult . Even though humans are good at adapting . But don't forget that the community also needs help ！

18、 For those who want to start PostgreSQL Developer , What would you recommend? ? Where should they start , How to start ?

Many people start by checking the code . I find it doesn't work for me . then , I started from Dimitri Fontaine I got a good suggestion there ：“ Give Way Postgres More in line with sql”. If you look at it Markus Winand Website , You will find that many functions are not difficult to develop , But these functions are Postgres There is still no .

19、 Do you think PostgreSQL Will it exist for many years in the future ?

Of course , In my submission PostgreSQL With a bright future （ But this is my objective opinion ）. What I can be sure of is , It can't be bought , It will continue to be an open source community .

20、 You will take PostgreSQL Recommended for commercial projects or amateur projects ?

If you take your data seriously , You should use PostgreSQL, If your data is scalable , Then do what you want ！

21、 Are you looking at the hacker's mailing list ? Other lists ?

I try to read the hacker's mailing list , But it's too boring . I have also read some mailing lists :Postgres Women、 Novice 、committers、advocacy, Postgres Europe and Postgres France.

22、 Will you go to other places to play ？

I will go Slack and telegram Wandering . I sometimes go back IRC, But suppose it's not my generation .：-)

23、 Are there any other open source projects that you are involved in or interested in ？

I didn't contribute to other open source projects . Time is not an infinite resource , You need to choose your battle carefully .

• About this website
  This website publishes for those who make PostgreSQL Interviews with people whose projects have become outstanding . If you think there is a lack of interview opportunities , Please send an email to interview(at)postgresql(dot)life.

• PostgresFriends
  # PostgreSQL Friend tag in PostgreSQL Where communities gather .
  

• # SlonikTravels
  #Slonik Travel labels cover #Slonik Travel around the world !
  You can also see 《 Chernick's travels 》.
  

• PostgresPets
  Interview series “PostgreSQL Weekly pets ” It shows the pets that help people achieve today's project .