Lex Fridman: preference

Transcript context

…Even simpler than that. It turns tables into classes and rows into objects. I actually think SQL is very easy to understand most of it. You can write some SQL golf too, that’s very hard to understand, but SQL at its base and much of the criticism against SQL was it was written for human consumption. It’s actually quite verbose, especially if you’re doing things like inserts over and over again. It’s quite verbose. Insert into table, parentheses, enumerate every column you want to insert, values, parentheses. In every column you want to insert values, parentheses, every value that fits with that column, it gets tedious to write SQL by hand, but it’s actually very humanly readable. ActiveRecord just takes that tediousness away, it makes it possible to combine things in a way that a humanly describable language just doesn’t. It composes things into methods and you can combine these methods and you can build structures around them. I don’t dislike SQL, I just like a lot of things in programming, I try to get rid of them. SQL wasn’t really one of them, it was just a sense of, “I don’t want to write the same thing over and over again.” It was a, “Can we be a little more succinct? Can we match it just slightly better to the object orientation without trying to hide away the fact that we’re persisting these objects into a database?” That’s where I think a lot of ORMs went wrong. They tried to live in the pure world of objects, never to consider that those objects had to be consistent into a SQL database, and then they came up with convoluted way of translating back and forth. ActiveRecord says, “You know what? Just accept it.” This record, this object is not going to get saved into some no-SQL database, it’s going to be saved into SQL database, so just structure the whole thing around that. It’s going to have attributes, those attributes are going to respond to columns in the database. It’s not more complicated than that stuff making it so. Yeah, but I should say, I personally love SQL, because I’m an algorithms person, so I love optimization, I love to know how the databases actually work, so I can match the SQL queries and the design of the tables such that there is optimal… Squeeze the optimal performance out of the table. Okay. Based on the actual way that that table is used. I think that pushes to the point that there is value in understanding SQL. I wonder, because I started looking at ActiveRecord and it looks really awesome. Does that make you lazy? Not you, but a person that rolls in and starts using Rails, you can probably get away with never really learning SQL, right? As long as you want to stay at the entry level of competence. This is actually my overarching mission with Rails, is to lower the barrier of entry so far down that someone can start seeing stuff on their browser without basically understanding anything. They can run Rails, new blog, run a couple of generators. They have a whole system… They don’t understand anything, but it’s an invitation to learn more. Where I get fired up, and this ties back to the AI discussion, is when that’s turned into this meme that programmers no longer have to be competent. “The AI is going to figure it out, the generators is going to figure it out. I don’t need to know SQL, ActiveRecord is going to abstract it away from me.” No, no, no. Dude, hold up. The path here is competence. I’m trying to teach you things. I understand I can’t teach you everything in five minutes. No one who’s ever become good at anything worthwhile could be taught everything in five minutes. If you want to be a fully well-rounded application developer, that takes years, but you can actually become somewhat productive in a few days, you can have fun in a few days. For sure, you’re going to have fun in a few minutes, in a few hours, and over time, I can teach you a little more. ActiveRecord says like, “Yeah, yeah. All right, start here and then, next week, we’ll do a class on SQL.”…

Stored transcript either side of the excerpt. The highlighted words are the published quote; the surrounding text is unedited source, never generated.