Lætitia
@l_avrot
Followers
2,482
Following
222
Media
1,694
Statuses
11,839
Postgres women founder, PostgreSQL Europe treasurer, PostgreSQL recognized contributor. Field CTO at EDB. Opinions are my own.
Lyon, France
Joined February 2017
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Father's Day
• 1287487 Tweets
jaehyun
• 837978 Tweets
Daddy
• 665006 Tweets
Eid Mubarak
• 521683 Tweets
GO TO URANUS2324
• 326348 Tweets
Stop Killing Animals
• 320091 Tweets
England
• 280765 Tweets
Dads
• 253991 Tweets
Dudu
• 160690 Tweets
Cruzeiro
• 123060 Tweets
Feliz Día del Padre
• 106658 Tweets
Serbia
• 104760 Tweets
#POLNED
• 80025 Tweets
Netherlands
• 77379 Tweets
Poland
• 75862 Tweets
Denmark
• 51615 Tweets
Kylian
• 50178 Tweets
Eriksen
• 47191 Tweets
Dutch
• 44569 Tweets
Weghorst
• 38903 Tweets
#無職転生
• 32581 Tweets
Slovenia
• 29579 Tweets
Gelsenkirchen
• 21726 Tweets
オランダ
• 20251 Tweets
Holanda
• 19498 Tweets
Depay
• 18911 Tweets
Países Bajos
• 18216 Tweets
Albanians
• 16872 Tweets
イオリの足
• 10774 Tweets
JUANJO EN EL WIZINK
• 10739 Tweets
Sesko
• 10323 Tweets
@_clembell
Et je te dis pas leur gueule quand tu mets fin à la période d'essai après 5 ou 6 mois avec ton préavis de 48 heures calendaires!
5
6
338
@spakhm
I'm not sure 2 days will be enough to *really* know SQL.
After all,
@MarkusWinand
said you're basically lying if you put "SQL" on your resume while not knowing what window functions are...
May I suggest this excellent website to make your SQL better ?
5
8
153
Hello,
This is your kindly reminder that the
@PostgreSQL
project created a "Don't do this" wikipage. Please read it and avoid implemented each and every case!
5
36
106
Some tech: "We've reached the limits of
#PostgreSQL
"
Me: "Let me rephrase. Your bad design data model and badly designed application including several well-known antipatterns do not work as your twisted brain expected."
I'll uphold
@PostgreSQL
with my last breath!
5
23
113
Hello,
I'm very excited, proud and honoured to have been added to the
@PostgreSQL
list of contributors!
It shows the project also rewards non-code contributions and I think it's excellent news!
8
9
89
Hey companies out there,
This is a kindly reminder that "
@PostgreSQL
is free" does not mean all your employees will magically turn into Postgres expert overnight!
You'll still need to spend some money for trainings, advices, design, consultants and even hosting/hardware!
3
24
81
Bonjour
@PIKTURASCHOOL
,
Pourriez- vous faire attention à votre communication s'il vous plaît?
Ma fille est allée vous voir au salon de l'orientation de Strasbourg en disant qu'elle aimait le dessin et les jeux vidéos.
1/x
2
15
71
I'm very delighted to tell you that this was my first week as a field CTO at EDB!
I'm very looking forward to the weeks to come!
8
2
65
I'm proud that my first code patch for
#postgresql
has been pushed into postgresql's git repository!
10
9
65
If you want to learn and practice SQL, just know
#PostgreSQL
is more compilant to the SQL standard.
And you can also try , to learn and practice online.
Are you learning
#SQL
on Oracle Database and looking for FREE instances to practice on?
@thatjeffsmith
shows you how using
Live SQL
Always Free Oracle Autonomous Cloud Database Service
VirtualBox Database Appliance
Oracle Database XE
0
31
105
4
14
62
@CodeKaio
@_clembell
Le préavis est d'une semaine par mois passé quand c'est l'employeur qui met fin à la période d'essai.
Si c'est l'employé, c'est 48h calendaires.
2
1
62
Je viens de me rendre compte qu'il n'est pas obligatoire d'avoir une pub toutes les 2 pages pour faire un magazine!
Merci
@Epsiloon_mag
!
1
5
56
3
5
56
We're pretty excited to tell you that Postgres
@CERN
will be a thing! It will be held at
@CERN_FR
the 17th of January.
You'll be able to visit CERN in the morning and you'll enjoy
@PostgreSQL
conf talks the afternoon!
It's free. Please register here:
0
22
52
In France, we take cheese really seriously...
cervelle de canut, cendré, bouton de culotte, rocamadour, chèvre aux tomates séchées, chèvre sec, étorki, bleu de chèvre (with cherry marmelade), tome de Savoie, Saint Nectaire, comté, bleu de gex, camembert
8
2
50
Just a reminder that the
#Postgres
community is not responsible for
#Amazon
RDS support.
If you're not satisfied with Amazon support answer, maybe it's time to move to a real
#PostgreSQL
database.
1
5
45
I'm very excited about this new project that can help bring psql magic to people!
Take a look here:
3
11
47
How to become very good at troubleshooting in one step:
Read 👏 The 👏 Log 👏 Messages 👏
4
9
43
@DocPepper_FR
Go compétition!!!
Les championnats départements sont pendant les vacances d'automne. Les championnats régionaux pendant les vacances d'hiver et les championnats nationaux pendant les vacances de printemps.
1
1
44
@novallkhan
@tapoueh
At a lot of technical events, people ask me if I'm marketing or sales... Even though I wear a speaker badge, they don't think I might be tech...
1
3
38
I did it!
I delivered 5 conf talks on 5 different topics this month!
8
0
40
Upgrading to the latest version of Postgres is not about getting some new fancy unstable features.
It's about a new stable release with huge performance improvements.
1
8
38
Elle a fait le summer camp girls can code à 13 ans et à codé un microbit et un bot discord. À 14 ans, elle s'est attaqué à advent of code. Et cette année, elle apprend le V!
Arrêtez avec les stéréotypes!
Qu'est ce qui vous fait croire qu'une fille n'aime pas le code?
3/x
3
2
38
This is your kindly reminder that should you encounter performance issue with
@PostgreSQL
due to wrong choices while designing the data model, the best option is to fix the data model, not trying to force the optimizer to choose a path that you think is better.
4
8
34
OH: If you've written down "SQL" into your resume but don't know window functions, you're basically lying.
#pgconfeu
@MarkusWinand
1
10
31
@Dixie3Flatline
@fuzzychef
It means that they'll say to the team "we tried hiring, but couldn't find someone. We guess the only solution is for you to do free overtime to compensate the missing teammate."
2
0
26
Mes slides 'les merveilles méconnues du SQL', conf donnée
@AFUP_lyon
vendredi dernier, sont là :
0
12
31
OH:
- do you want a stress ball?
- no, I don't need it: I use postgres!
#fosdem2020
#PostgreSQL
1
6
31
In this particular US context, there's something I need to share.
I did use abortion. I was a married woman with 2 children and no desire for more children. It happens. Ask your sisters, mothers, and daughters.
No woman should be forced to give birth if they don't want to.
2
0
29
Hey, that's me!
New interview freshly released on the
@avocadogrowth
blog!
Discover the inspiring portrait of Laetitia
@l_avrot
, Field CTO and PostgreSQL contributor emeritus, as well as the founder of Postgres Women.
Dive into her journey and her captivating profession. 🥑
1
2
9
1
4
28
And please, use timestamp with timezone.
✏Never store dates or timestamps as strings in your database! It will eliminate many built-in checks (and keep you awake at night!)!
... Tweet sent after production issues with a 24:59:59 Timestamp... 🙄🤦♀️
#sql
#database
#programming
11
19
167
5
3
33
I just added 25 brand-new tips to .
@samokhvalov
and
@the_hydrobiont
, look at tips
#128
,
#129
,
#148
and
#149
. We discussed them in August.
4
12
30
If you run a virtual conf event with pre-recorded videos, here's FYI:
- it took me 5 waffle batches and 4 full days to record and video edit my pg_waffles talk
- it took me 2 full days to record and video edit my psql talk
On top of preparing the talk and writing the slides
4
7
29
I wrote a blog post with a small proof of concept of using Postgres log to keep a trace of your databases changes
1
10
29
It's been 15 days since my second Pfizer jab, so I am today fully vaccinated! \o/
5
0
27
Hey
@UnitedAirlines
,
This is my name exactly as written on my legal document... What am I supposed to do? Lie to you or ask the French government to change their processes?
4
6
25
I just realized
@PGDayAustria
will be hold at Schöbrunn castle!
I'll be speaking at Sissi's home!
1
4
26
If your company relies on Open Source projects, instead of demanding a fix from the pro bono developers, you might want to invest and pay either your own developers or the community developers to fix it.
If you don't see it, your moral compass is defective.
No, it was not a joke. "Our paying customers need X, when will you fix it?" may not be the best way to introduce yourself to an open source project.
#TodayInOpenSource
421
2K
22K
0
5
29
Dear HR people,
Please read my profile before sending a job offer, then you won't be surprised if I take your Oracle job offer as an insult.
3
1
23
My husband told me he had no idea what autovacuum is but that he had well understood it should be turned on...
I hope my customers will have understood it as well...
#PostgreSQL
2
2
26
Hey, that's me!
***MEET OUR SPEAKERS***
@l_avrot
is Senior Consultant for
@EDBPostgres
and is a recognized
#PostgreSQL
project contributor. In her lecture she will talk about the new features of Postgres 14 and give a few tips to optimize working with “psql”.
0
5
20
1
2
24
Hello sales persons in IT,
This is a kindly reminder that consultants are people, not products that you sell to the customers.
Have a great day
1
0
27
4 hours a day of free time?
Tell me you're a man without telling me you're a man... 🙄
4
2
24
Have you tried writing C code for
#PostgreSQL
while having to deal with a 6 y-o complaining that she doesn't know what to do and that life is boring?
You should, because if you can do this, there's nothing you can't do...
6
3
26
Security officer at the airport: you have a sharp metal star in your bag. What is it?
Me: Yes, I know, it's my captain Marvel wallet!
4
0
25
I'm sooooooooooooo proud to be listed there!
1
1
24
This is big!
We are excited to announce that
#EDB
has acquired
@2ndQuad
, a global
#PostgreSQL
solutions and tools company. Our combined team of experts will drive PostgreSQL
#innovation
and
#growth
everywhere. Continue reading the press release:
#databases
3
35
41
2
6
24
My laptop was stolen. I haven't lost anything valuable (thanks to gitlab and Google drive), my storage was encrypted and I was able to lock down my account remotely...
But I'm still missing my .bash_profile, my .tmux.conf and my .vimrc...
6
2
25
Pgday Paris schedule is released!
Here is the
#sketchnote
I wrote when meeting with
@pg_krol
and
@louisemeta
to build that schedule.
3
6
22
Available in
#PostgreSQL
since the beginning 😀
What's that ?
Transactional DDL ?!?!?!
Find out when and how on my Office Hours session tomorrow.
(and no, there's no hidden DDL triggers etc floating around here)
1
5
27
3
4
25
hello
@kaggle
,
This is 2023. UTF-8 does exist and you should be aware there are languages out there that are not English (shocking news) with characters you don't expect.
Anyhow, this is disrespecting my name and you should do better.
@yournameisvalid
2
6
26
Hi all,
My slides (de-mystifying contributing to PostgreSQL) are available on the FOSDEM page ().
If you attended my talk, you've seen there isn't much text on it, but don't worry: the downloadable deck has text
:-)
1
21
24
It's ok to think you're right, but if you hired an expert and the expert disagrees with you, maybe you should start to listen and reconsider your position?
2
1
22
Go psql!
Of the respondents who use tools to connect PostgreSQL for queries & administration tasks, psql (69.4%), pgAdmin (35.3%), and
@dbeaver_news
(26.2%) were the top three choices.
For more information, see our blog post on PostgreSQL tools, in addition to psql
1
3
13
0
1
24
I had a great time
@pgconfeu
. Bonus point to the
#PostgreSQL
community: nobody asked me if I was sales, marketing or HR.
3
5
24
If I'm entitled to a wedding ring, I think it's only justice that I buy myself a divorce ring!
5
0
24
L'intervenant sur le stand lui a dit qu'il y avait aussi de la programmation et que ça risquait de lui plaire moins.
Ma fille code depuis ses 9 ans. Elle a donné une conférence devant 70 personnes en anglais sur le langage SQL à 12 ans.
2/x
1
1
23
When someone is bragging about having a huge database (several TB) and after asking some questions you find out that they simply failed at defining their data retention policy...
@DBAReactions
3
5
25
I'm very happy to have been selected for
@PostgresOpen
with a new subject: "Meet NULL the UNKNOWN". See you in Florida!
4
4
21
Hello,
Register to
@Postgres_London
to see great talks about
#PostgreSQL
!
I'll explain how awesome psql is!
Register here (it's free):
0
5
22
I'm honoured to have been picked to be a PostgreSQL person of the week
PostgreSQL Person of the Week interview with: Lætitia Avrot (
@l_avrot
)
#PostgreSQL
#PostgresFriends
0
11
23
2
0
23
Hey,
I'm very excited to unveil a tool I wrote during the last past years that helped me with my consultant job.
This week in our
#PostgresFriends
meeting:
@l_avrot
presents: "Pglog: a flexible log analyser"
Wednesday, 21:00 CET
0
5
9
2
3
21
@sjstoelting
@PostgresWomen
@pgconfeu
1- Invite them, instead of waiting for them to apply to the CFP.
2- Discuss with the companies so they send women attending and speaking (More women attending means more women speaking in the following years)
3- Offer free mentoring
4- Provide travel and accommodation money
5
2
22
It's frustrating when you answer a first simple question by DM on a technical slack and you end up with the guy asking personal questions late at night...
It's frustrating because I really do think that this kind of inappropriate behaviour is done by an annoying minority...
4
2
21
@samokhvalov
@ascherbaum
@the_hydrobiont
For your information, I use this tutorial from Digital Ocean to show my students they need to be very careful about any tutorial they can find on the internet regarding postgres...
No, pgdump is not a backup. It's a data export.
4
1
22
Dear HR people,
Yes, it is insulting that you're thinking I would be perfect for your PostgreSQL/MySQL/Mariadb DBA open position.
Please read (and understand) the profiles before approaching people!
Have a nice day,
Lætitia
5
0
20
Thanks to
@holdenkarau
, I was able to customize a dress (with pockets) with
#PostgreSQL
code!
See here:
3
2
20
I meet Bruce Willis at
@pgconfeu
. Did you know he was an active contributor to
#postgresql
? He works at
@crunchydb
and is the main developer of
@pgBackRest
.
2
1
21
I'm also giving kudos to great women in my community:
@shaysler
@apatheticmagpie
@ilanalyze
@DataRenee
@louisemeta
@melanieplageman
@sharpDBA
@HettieDombr
@sheeshee
@Karenhjex
@pg_krol
1
4
17
"I understand this is a problem for you."
0
6
20
@Collabblues
- Ah, t'es ingénieur en informatique? Ça tombe bien j'ai un problème avec Windows..
À. Chaque. Fois
4
1
19