Full Web Apps with FastAPI Transcripts
Chapter: Appendix: Modeling data with SQLAlchemy classes
Lecture: Who uses SQLAlchemy?
0:00 When you choose a framework
0:01 whether that's for a database or a web framework
0:03 it's good to know that you're in good company
0:05 and that other companies and products
0:07 have already tested this and looked around and decided
0:11 Yep, SQLAlchemy is a great choice.
0:13 So let's look at some of the popular deployments.
0:17 Dropbox is a user of SQLAlchemy
0:19 and Dropbox is one of the most significant
0:23 Python shops out there.
0:25 Guido van Rossum and some of the other core developers
0:28 work there and almost everything they do is in Python.
0:31 So the fact that they use SQLAlchemy
0:33 that's a very high vote of confidence.
0:36 Uber. Uber uses SQLAlchemy.
0:38 Reddit. Reddit's interesting in that they don't use the ORM
0:43 but in fact they use only the core.
0:45 At least, wow, hey we're using only the core aspect
0:49 of SQLAlchemy, that's pretty cool.
0:52 Firefox, Mozilla, more properly is using SQLAlchemy.
0:57 OpenStack makes heavy use of SQLAlchemy.
1:00 FreshBooks, the accounting software
1:02 based on, you guessed it, SQLAlchemy!
1:04 We've got Hulu, Yelp, TriMet,
1:08 that's the public transit authority
1:10 for all of Portland, Oregon.
1:12 The trains, the buses and things like that
1:15 so they use that as well.
1:16 So here are just a couple of the companies and products
1:18 that use SQLAlchemy.
1:20 There's some really high pressure
1:22 some of these are under.
1:23 You know if it's working for them
1:25 it's going to work well for you, especially Reddit.
1:27 Reddit gets a crazy amount of traffic, so
1:30 pretty interesting that they're all using it
1:32 and we'll see why in a little bit.