145 reputation
6
bio website simonecarletti.com
location Rome, Italy
age
visits member for 2 years, 1 month
seen Sep 27 at 18:43

profile for Simone Carletti on Stack Exchange

Hi! My name is Simone Carletti. I'm a passionate programmer and scuba diving instructor.

I work at DNSimple. I'm the author of RoboWhois and RoboDomain.

I have been involved with FOSS (free/open source software) for more than a decade, contributing code and creating libraries.

I'm available for short mentoring sessions.


Sep
26
asked How much should I care about prepared statements for simple queries?
Sep
24
awarded  Autobiographer
May
13
awarded  Critic
May
13
accepted Query improvements without UNION
May
12
comment Query improvements without UNION
Sure, I'm just trying to understand what is the best approach. Considering this is one of the most critical query and those tests where done on a very few records (whereas an user can have thousands of them), I'm taking the time to learn more about writing efficient queries.
May
12
comment Query improvements without UNION
The UNION seems to be the more efficient. Does this surprise you? gist.github.com/weppos/d552d978d604fbecd917
May
12
comment Query improvements without UNION
Yes, when the records had 1 ore more memberships, the same record was returned multiple times.
May
12
comment Query improvements without UNION
According to techonthenet.com/sql/exists.php the EXISTS statement is very inefficient. Does this mean this query is less efficient than UNION?
May
12
asked Query improvements without UNION
Oct
29
awarded  Scholar
Oct
29
awarded  Supporter
Oct
29
accepted Unexpected Seq Scan when doing query against boolean with value NULL
Oct
29
comment Unexpected Seq Scan when doing query against boolean with value NULL
Brilliant answer, thank you Erwin. I'm sad I can't upvote it twice.
Oct
26
awarded  Editor
Oct
26
revised Unexpected Seq Scan when doing query against boolean with value NULL
added 117 characters in body; edited tags
Oct
26
awarded  Student
Oct
26
asked Unexpected Seq Scan when doing query against boolean with value NULL