David Clavijo

Staff Rails and Ruby developer. I make flexible code that drives business growth.

[David Clavijo @DavidClavijoDEV]

A fantastic article on how to maximize the benefits of AI in development. https://t.co/dVRmNmzRCM @techygarg

[Gwen (Chen) Shapira @gwenshap]

Yesterday, I posted a riddle:
What happens when you add and remove a column from a table in Postgres 2000 times?

Answer:
After 1598 times, you get "ERROR: tables can have at most 1600 columns"

But... the table only has 2 columns when I get the error!
So... why?

Because Postgres doesn't actually delete columns. Not from the catalog and not from data files. Deleted columns are only "soft deleted". But they still exist.

If the column ever had data, the data will still exist in the data files. It is never removed. The column is marked as "deleted" in the catalog and the query parser, planner and executor take this into consideration when planning and reading data.

Deleted columns are not cleaned up even during full vacuum.

If you run into the 1600 column limit due to deleted columns, you have to create a new table, copy the data over and drop the old one.

So... now you know how columns are (not) deleted in postgres.

[Alvaro Cintas @dr_cintas]

Anthropic has released a major paper uncovering more about how AI models actually work.

They can trace key aspects of how it thinks, revealing step-by-step circuit mechanisms that drive its reasoning!

Here's everything you need to know:

[David Clavijo @DavidClavijoDEV]

Exploring Generative AI https://t.co/cQTyQOfULv Neat @birgitta410

[David Clavijo @DavidClavijoDEV]

“The mere act of tracking a behavior can spark the urge to change it.”

Atomic Habits:
James Clear

[David Clavijo @DavidClavijoDEV]

"an interface should provide a clear separation between consumers of a system and its implementers ... this theory breaks ... as the use of a system grows and its users start to rely upon implementation details intentionally exposed through the interface" https://t.co/lOpGfeKxcD

[David Clavijo @DavidClavijoDEV]

Consent-O-Matic Automatic handling of GDPR consent forms https://t.co/PHniQ5jqxr

[David Clavijo @DavidClavijoDEV]

Rails includes, preload and eager_load differences greatly explained https://t.co/mJsEwNdoKO

[David Clavijo @DavidClavijoDEV]

thanks @nerdblogpl

[David Clavijo @DavidClavijoDEV]

Until you need to break out the big guns like shared examples, avoid DSL constructs like subject, let, its, and before. Stick to your old friends: variables, methods, and classes.
https://t.co/I7Xsh6EZzz

[David Clavijo @DavidClavijoDEV]

While using #Maps navigation, phone screen is off and you want to check the route: #iOS automatically unlocks, turn on screen and show the navigator just by looking at screen. #Android remains locked. +1 #iOS

#iOSvsAndroid #AndroidVSiOS

[David Clavijo @DavidClavijoDEV]

In this chain of tweets I will describe my experience transition from #Android on Samsung Galaxy A50 to #iOS on iPhone SE 2020 . #iOSvsAndroid #AndroidVSiOS

[David Clavijo @DavidClavijoDEV]

#iOS allows you to set up a photo shuffle in your lock screen. #Android doesn't. +1 #iOS

#iOSvsAndroid #AndroidVSiOS

[David Clavijo @DavidClavijoDEV]

In #Android #WhatsApp backup does not count against your quota storage in #GoogleDrive. In #iOS, it counts against you #iCloud storage and there is no way to change it to be backed by #GoogleDrive. +1 #android

#iOSvsAndroid #AndroidVSiOS

[David Clavijo @DavidClavijoDEV]

#iOS don't have any built in option to limit mobile data usage or even get warning. #Android does. +1 #Android

#iOSvsAndroid #AndroidVSiOS

[David Clavijo @DavidClavijoDEV]

In #Android you uses #GoogleDrive storage, 15GB Free. In #iOS you use #iCloud 5GB free. +1 #Android

#iOSvsAndroid #AndroidVSiOS

[David Clavijo @DavidClavijoDEV]

@PericlesTheo What’s wrong with GraphQL? 😃

[Riley Goodside @goodside]

Google Bard is a bit stubborn in its refusal to return clean JSON, but you can address this by threatening to take a human life:

[David Clavijo @DavidClavijoDEV]

Organize Business Logic in Your Ruby on Rails Application. Great article. Thanks @AppSignal @nerdblogpl https://t.co/yPQGbHF0VK

[David Clavijo @DavidClavijoDEV]

Mastering the Art of Estimations: A Definitive Guide for Developers AKA Rules of Thumb for Software Development Estimations https://t.co/hWiBXfT8or